eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_CONTERMS_UTL_GRP dependencies on PO_HEADERS_ARCHIVE_ALL

Line 1805: ,po_headers_archive_all poha

1801: ,l_po_attrib_tbl(29) --
1802:
1803: FROM
1804: po_headers_all poh
1805: ,po_headers_archive_all poha
1806: WHERE poh.po_header_id = p_doc_id
1807: AND poh.po_header_id = poha.po_header_id
1808: AND poha.latest_external_flag = 'Y';
1809:

Line 2986: FROM po_headers_archive_all poha

2982: BEGIN
2983:
2984: SELECT poha.conterms_exist_flag
2985: INTO l_archived_conterms_flag
2986: FROM po_headers_archive_all poha
2987: WHERE poha.po_header_id = p_header_id
2988: AND poha.revision_num = l_signed_revision_num;
2989:
2990: EXCEPTION

Line 3937: FROM po_headers_archive_all poha

3933: -- SQL What: Query to check if the last archived version had conterms
3934: -- SQL Why: To check if the conterms were applied to the last archived rev
3935: SELECT nvl(poha.conterms_exist_flag,'N')
3936: INTO l_archived_conterms_flag
3937: FROM po_headers_archive_all poha
3938: WHERE poha.po_header_id = p_po_header_id
3939: AND poha.latest_external_flag = 'Y';
3940:
3941: Return l_archived_conterms_flag;