DBA Data[Home] [Help]

APPS.PO_POAPPROVAL_INIT1 dependencies on PO_REQUISITION_LINES_ALL

Line 1280: po_requisition_lines_all PRL,

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

Line 1678: po_requisition_lines_all PRL

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