DBA Data[Home] [Help]

APPS.INV_RCV_INTEGRATION_PVT dependencies on PO_HEADERS

Line 2281: FROM po_line_locations pll, po_headers ph, po_lines pl,

2277: BEGIN
2278: --performace fix. Bug 3444172. Modified the query below.
2279: SELECT DISTINCT pll.ship_to_organization_id
2280: INTO l_rti_rec.to_organization_id
2281: FROM po_line_locations pll, po_headers ph, po_lines pl,
2282: mtl_system_items_kfv msik
2283: WHERE ph.segment1 = l_rti_rec.document_num
2284: AND ((msik.inventory_item_id = l_rti_rec.item_id)
2285: OR (msik.concatenated_segments = l_rti_rec.item_num