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.ICX_CAT_UTIL_PVT dependencies on PO_LINES_ALL

Line 929: FROM po_headers_all ph, po_lines_all pl

925: l_status := 0;
926:
927: SELECT 1
928: INTO l_status
929: FROM po_headers_all ph, po_lines_all pl
930: WHERE pl.po_line_id = p_po_line_id
931: AND ph.po_header_id = pl.po_header_id
932: AND ph.approved_date IS NOT NULL
933: AND ph.authorization_status NOT IN ('REJECTED', 'INCOMPLETE')

Line 972: FROM po_headers_all ph, po_lines_all pl

968: l_status := 0;
969:
970: SELECT 1
971: INTO l_status
972: FROM po_headers_all ph, po_lines_all pl
973: WHERE pl.po_line_id = p_po_line_id
974: AND ph.po_header_id = pl.po_header_id
975: AND ph.status_lookup_code = 'A'
976: AND ph.quotation_class_code = 'CATALOG'