APPS.PO_CATALOG_INDEX_PVT dependencies on PO_LINES_ARCHIVE_ALL

Line 927: FROM PO_LINES_ARCHIVE_ALL POLA

923: /* Bug 5559492: As part of this ECO, we are not checking if any specific list
924: of columns have changed. We always call the IP's rebuild_index API.*/
925: AND ( NOT EXISTS
926: (SELECT 'Lines were archived'
927: FROM PO_LINES_ARCHIVE_ALL POLA
928: WHERE POLA.po_line_id = POL.po_line_id)
929: OR
930: EXISTS
931: (

Line 1032: FROM PO_LINES_ARCHIVE_ALL POLA

1028: update date of po lines with extracted ip record for already extracted
1029: records */
1030: AND ( NOT EXISTS
1031: (SELECT 'Lines were archived'
1032: FROM PO_LINES_ARCHIVE_ALL POLA
1033: WHERE POLA.po_line_id = POL.po_line_id)
1034: OR
1035: EXISTS
1036: (

Line 1138: FROM PO_LINES_ARCHIVE_ALL POLA

1134: update date of po lines with extracted ip record for already extracted
1135: records */
1136: AND ( NOT EXISTS
1137: (SELECT 'Lines were archived'
1138: FROM PO_LINES_ARCHIVE_ALL POLA
1139: WHERE POLA.po_line_id = POL.po_line_id)
1140: OR
1141: EXISTS
1142: (

Line 1554: FROM PO_LINES_ARCHIVE_ALL POLA

1550: AND INPUT_HDRS.key = l_key -- Bug 6942699 - Added the condition to improve performance
1551: AND POL.po_header_id = POH.po_header_id
1552: AND (NOT EXISTS
1553: (SELECT 'Lines were archived'
1554: FROM PO_LINES_ARCHIVE_ALL POLA
1555: WHERE POLA.po_line_id = POL.po_line_id)
1556: OR EXISTS
1557: (SELECT 'Item description has been modified'
1558: FROM PO_LINES_ARCHIVE_ALL POLA

Line 1558: FROM PO_LINES_ARCHIVE_ALL POLA

1554: FROM PO_LINES_ARCHIVE_ALL POLA
1555: WHERE POLA.po_line_id = POL.po_line_id)
1556: OR EXISTS
1557: (SELECT 'Item description has been modified'
1558: FROM PO_LINES_ARCHIVE_ALL POLA
1559: WHERE POLA.po_line_id = POL.po_line_id
1560: AND POLA.latest_external_flag = 'Y'
1561: AND (POL.item_description <> POLA.item_description OR
1562: (POL.item_description IS NULL AND POLA.item_description IS NOT NULL) OR