DBA Data[Home] [Help]

APPS.PO_CATALOG_INDEX_PVT dependencies on PO_HEADERS_ARCHIVE_ALL

Line 813: FROM PO_HEADERS_ARCHIVE_ALL POHA

809: AND POH.po_header_id = GT_REMAINING_HDRS.index_num1 -- index_num1 stores the PO_HEADER_ID
810: AND POL.po_header_id = POH.po_header_id
811: AND ( NOT EXISTS
812: (SELECT 'Headers were archived'
813: FROM PO_HEADERS_ARCHIVE_ALL POHA
814: WHERE POHA.po_header_id = POH.po_header_id)
815: OR
816: EXISTS
817: (SELECT 'Some attribute is modified'

Line 818: FROM PO_HEADERS_ARCHIVE_ALL POHA

814: WHERE POHA.po_header_id = POH.po_header_id)
815: OR
816: EXISTS
817: (SELECT 'Some attribute is modified'
818: FROM PO_HEADERS_ARCHIVE_ALL POHA
819: WHERE POHA.po_header_id = POH.po_header_id
820: AND POHA.latest_external_flag = 'Y'
821: AND (POH.vendor_id <> POHA.vendor_id OR
822: (POH.vendor_id IS NULL AND POHA.vendor_id IS NOT NULL) OR