APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 1721: FROM PO_LINE_LOCATIONS_ALL POL,

1717: , POL.retainage_withheld_amount
1718: , POL.retainage_released_amount
1719: --
1720: , POL.outsourced_assembly --
1721: FROM PO_LINE_LOCATIONS_ALL POL,
1722: PO_LINE_LOCATIONS_ARCHIVE_ALL POLA
1723: WHERE ((p_document_type = 'RELEASE' AND
1724: POL.po_release_id = p_document_id) OR
1725: (p_document_type <> 'RELEASE' AND -- Bug 3210749

Line 2497: FROM PO_LINE_LOCATIONS_ALL

2493: FROM PO_PRICE_DIFFERENTIALS POR,
2494: PO_PRICE_DIFFERENTIALS_ARCHIVE PORA
2495: WHERE ((p_entity_type = 'PRICE BREAK' AND
2496: POR.entity_id IN (SELECT line_location_id
2497: FROM PO_LINE_LOCATIONS_ALL
2498: WHERE po_header_id = p_document_id)) OR
2499: (p_entity_type IN ('PO LINE', 'BLANKET LINE') AND
2500: POR.entity_id IN (SELECT po_line_id
2501: FROM PO_LINES_ALL

Line 2541: FROM PO_LINE_LOCATIONS_ALL

2537: UPDATE PO_PRICE_DIFFERENTIALS_ARCHIVE POR1
2538: SET latest_external_flag = 'N'
2539: WHERE ((p_entity_type = 'PRICE BREAK' AND
2540: entity_id IN (SELECT line_location_id
2541: FROM PO_LINE_LOCATIONS_ALL
2542: WHERE po_header_id = p_document_id)) OR
2543: (p_entity_type IN ('PO LINE', 'BLANKET LINE') AND
2544: entity_id IN (SELECT po_line_id
2545: FROM PO_LINES_ALL