DBA Data[Home] [Help]

APPS.ICX_CAT_UTIL_PVT dependencies on PO_HEADERS_ARCHIVE_ALL

Line 961: FROM po_headers_archive_all ph, po_lines_archive_all pl

957: where po_line_id=p_po_line_id;
958:
959: SELECT 1
960: INTO l_status
961: FROM po_headers_archive_all ph, po_lines_archive_all pl
962: WHERE pl.po_line_id = p_po_line_id
963: AND ph.LATEST_EXTERNAL_FLAG = 'Y'
964: AND pl.REVISION_NUM = l_revision
965: AND ph.po_header_id = pl.po_header_id