APPS.PO_CATALOG_INDEX_PVT dependencies on PO_LINES_ARCHIVE_ALL

Line 917: FROM PO_LINES_ARCHIVE_ALL POLA

913: /* Bug 5559492: As part of this ECO, we are not checking if any specific list
914: of columns have changed. We always call the IP's rebuild_index API.
915: AND ( NOT EXISTS
916: (SELECT 'Lines were archived'
917: FROM PO_LINES_ARCHIVE_ALL POLA
918: WHERE POLA.po_line_id = POL.po_line_id)
919: OR
920: EXISTS
921: (SELECT 'Some attribute is modified'

Line 922: FROM PO_LINES_ARCHIVE_ALL POLA

918: WHERE POLA.po_line_id = POL.po_line_id)
919: OR
920: EXISTS
921: (SELECT 'Some attribute is modified'
922: FROM PO_LINES_ARCHIVE_ALL POLA
923: WHERE POLA.po_line_id = POL.po_line_id
924: AND POLA.latest_external_flag = 'Y'
925: AND (POL.ip_category_id <> POLA.ip_category_id OR
926: (POL.ip_category_id IS NULL AND POLA.ip_category_id IS NOT NULL) OR

Line 1516: FROM PO_LINES_ARCHIVE_ALL POLA

1512: AND INPUT_HDRS.key = l_key /* Bug 6942699 - Added the condition to improve performance */
1513: AND POL.po_header_id = POH.po_header_id
1514: AND (NOT EXISTS
1515: (SELECT 'Lines were archived'
1516: FROM PO_LINES_ARCHIVE_ALL POLA
1517: WHERE POLA.po_line_id = POL.po_line_id)
1518: OR EXISTS
1519: (SELECT 'Item description has been modified'
1520: FROM PO_LINES_ARCHIVE_ALL POLA

Line 1520: FROM PO_LINES_ARCHIVE_ALL POLA

1516: FROM PO_LINES_ARCHIVE_ALL POLA
1517: WHERE POLA.po_line_id = POL.po_line_id)
1518: OR EXISTS
1519: (SELECT 'Item description has been modified'
1520: FROM PO_LINES_ARCHIVE_ALL POLA
1521: WHERE POLA.po_line_id = POL.po_line_id
1522: AND POLA.latest_external_flag = 'Y'
1523: AND (POL.item_description <> POLA.item_description OR
1524: (POL.item_description IS NULL AND POLA.item_description IS NOT NULL) OR