1276: FROM po_lines POL,
1277: po_line_locations PLL,
1278: -- For Shared Procurement, the destination OU may be different from
1279: -- the Purchasing OU:
1280: po_requisition_lines_all PRL,
1281: po_headers POH
1282: WHERE POL.po_line_id = p_po_line_id
1283: AND POL.po_line_id = PLL.po_line_id -- JOIN
1284: AND PLL.line_location_id = PRL.line_location_id (+) -- JOIN
1674: l_req_header_id
1675: FROM po_lines POL,
1676: po_headers POH,
1677: po_line_locations PLL,
1678: po_requisition_lines_all PRL
1679: WHERE POL.po_line_id = p_po_line_id
1680: AND POL.po_header_id = POH.po_header_id -- JOIN
1681: AND POL.po_line_id = PLL.po_line_id -- JOIN
1682: AND PLL.line_location_id = PRL.line_location_id (+); -- JOIN