Dropship Orders

[gexsfox]

Hi Gurus,

For dropships, in which table sales order number is stored in the purchasing module. The sales order number is in the Shipping Tab on the purchase order, but I cannot locate the table..

Any ideas..

Thks in advance!!

[Ritz]

No idea , but I suggest you raise this in the technical forum

Ritz

[srinivasoracle]

Hi,

OE_DROP_SHIP_SOURCES table is having the information about sales order, PO Requisitions and Purchase Orders. You can map with the below query.

select prh.segment1 req_num, prl.line_num, oeh.order_number, oel.line_number, prl.line_location_id
from oe_drop_ship_sources oed,
po_requisition_headers_all prh,
po_requisition_lines_all prl,
oe_order_headers_all oeh,
oe_order_lines_all oel
where
prh.requisition_header_id = oed.requisition_header_id
and prh.requisition_header_id = prl.requisition_header_id
and prl.requisition_line_id = oed.requisition_line_id
and oeh.header_id = oed.header_id
and oeh.header_id = oel.header_id
and oel.line_id = oed.line_id;

Thanks & Regards,
Srinivasulu Vakati