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_WF_REQ_NOTIFICATION dependencies on PO_APPROVAL_LIST_HEADERS

Line 2167: po_approval_list_headers pah

2163: SELECT pal.SEQUENCE_NUM,per.FULL_NAME,null,null,null,null,
2164: NULL, NULL, NULL /* bug 2788683*/
2165: FROM per_all_people_f per, -- Bug 3404451
2166: po_approval_list_lines pal,
2167: po_approval_list_headers pah
2168: WHERE pah.document_id = v_document_id
2169: and pah.document_type = v_object_type
2170: and pah.latest_revision = 'Y'
2171: and pal.APPROVAL_LIST_HEADER_ID = pah.APPROVAL_LIST_HEADER_ID

Line 2182: po_approval_list_headers pah

2178: CURSOR count_rows(v_document_id NUMBER, v_object_type VARCHAR2) IS
2179: SELECT count(*)
2180: FROM per_all_people_f per,
2181: po_approval_list_lines pal,
2182: po_approval_list_headers pah
2183: WHERE pah.document_id = v_document_id
2184: and pah.document_type = v_object_type
2185: and pah.latest_revision = 'Y'
2186: and pal.APPROVAL_LIST_HEADER_ID = pah.APPROVAL_LIST_HEADER_ID