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_PO_NOTIFICATION dependencies on PO_LOOKUP_CODES

Line 982: TYPE displayed_field_tbl_type IS TABLE OF PO_LOOKUP_CODES.displayed_field%TYPE;

978: -- from history_csr cursor.
979: --
980: TYPE sequence_num_tbl_type IS TABLE OF PO_ACTION_HISTORY.sequence_num%TYPE;
981: TYPE full_name_tbl_type IS TABLE OF PER_ALL_PEOPLE_F.full_name%TYPE;
982: TYPE displayed_field_tbl_type IS TABLE OF PO_LOOKUP_CODES.displayed_field%TYPE;
983: TYPE action_date_tbl_type IS TABLE OF PO_ACTION_HISTORY.action_date%TYPE;
984: TYPE note_tbl_type IS TABLE OF PO_ACTION_HISTORY.note%TYPE;
985: TYPE object_revision_num_tbl_type IS TABLE OF PO_ACTION_HISTORY.object_revision_num%TYPE;
986: TYPE employee_id_tbl_type IS TABLE OF PO_ACTION_HISTORY.employee_id%TYPE;

Line 1013: po_lookup_codes polc

1009: poh.employee_id, /* bug 2788683 */
1010: poh.created_by /* bug 2788683 */
1011: from po_action_history poh,
1012: per_all_people_f per, -- Bug 3404451
1013: po_lookup_codes polc
1014: where OBJECT_TYPE_CODE = v_doc_type_code
1015: and poh.action_code = polc.lookup_code
1016: and POLC.LOOKUP_TYPE IN ('APPROVER ACTIONS','CONTROL ACTIONS')
1017: and per.person_id(+) = poh.employee_id /* bug 2788683 */