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!!
Dropship Orders
-
- Posts: 9
- Joined: Mon May 21, 2007 4:43 am
- Location: India
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
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
Who is online
Users browsing this forum: No registered users and 15 guests