Page 1 of 1
Dropship Orders
Posted: Wed Jan 23, 2008 1:06 am
by 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!!
Posted: Tue Jan 29, 2008 5:17 am
by Ritz
No idea , but I suggest you raise this in the technical forum
Ritz
Posted: Tue Jan 29, 2008 4:38 pm
by 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