APPS.INV_RCV_INTEGRATION_PVT dependencies on PO_HEADERS

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

2306: BEGIN
2307: --performace fix. Bug 3444172. Modified the query below.
2308: SELECT DISTINCT pll.ship_to_organization_id
2309: INTO l_rti_rec.to_organization_id
2310: FROM po_line_locations pll, po_headers ph, po_lines pl,
2311: mtl_system_items_kfv msik
2312: WHERE ph.segment1 = l_rti_rec.document_num
2313: AND ((msik.inventory_item_id = l_rti_rec.item_id)
2314: OR (msik.concatenated_segments = l_rti_rec.item_num