DBA Data[Home] [Help]

APPS.PO_POAPPROVAL_INIT1 dependencies on PO_REQUISITION_LINES_ALL

Line 1512: po_requisition_lines_all PRL,

1508: FROM po_lines POL,
1509: po_line_locations PLL,
1510: -- For Shared Procurement, the destination OU may be different from
1511: -- the Purchasing OU:
1512: po_requisition_lines_all PRL,
1513: po_headers POH
1514: WHERE POL.po_line_id = p_po_line_id
1515: AND POL.po_line_id = PLL.po_line_id -- JOIN
1516: AND PLL.line_location_id = PRL.line_location_id (+) -- JOIN

Line 1929: po_requisition_lines_all PRL

1925: l_req_header_id
1926: FROM po_lines POL,
1927: po_headers POH,
1928: po_line_locations PLL,
1929: po_requisition_lines_all PRL
1930: WHERE POL.po_line_id = p_po_line_id
1931: AND POL.po_header_id = POH.po_header_id -- JOIN
1932: AND POL.po_line_id = PLL.po_line_id -- JOIN
1933: AND PLL.line_location_id = PRL.line_location_id (+); -- JOIN