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 359: TYPE CONTRACT_TYPE_tbl_type is table of po_lookup_codes.DESCRIPTION%TYPE;

355: TYPE shipment_type_tbl_type IS TABLE OF PO_LINE_LOCATIONS.shipment_type%TYPE;
356: /* CLM Changes Start */
357: TYPE clm_option_num_tbl_type IS TABLE OF PO_LINES.CLM_OPTION_NUM%TYPE;
358: TYPE CLM_BASE_LINE_NUM_tbl_type IS TABLE OF po_lines.LINE_NUM_DISPLAY%TYPE;
359: TYPE CONTRACT_TYPE_tbl_type is table of po_lookup_codes.DESCRIPTION%TYPE;
360: TYPE LINE_NUM_DISPLAY_tbl_type is table of po_lines.line_num_display%type;
361: /* CLM changes End */
362:
363: l_line_num_tbl line_num_tbl_type;

Line 424: po_lookup_codes lkp1,

420: ,lkp1.description
421: ,pol.LINE_NUM_DISPLAY
422: FROM po_lines_all pol, --CLM Apprvl
423: po_lines_all po2, -- CLM Apprvl
424: po_lookup_codes lkp1,
425: mtl_system_items_kfv msi,
426: mtl_units_of_measure muom, -- bug 2401933.add
427: financials_system_parameters fsp
428: WHERE pol.po_header_id = v_document_id

Line 491: po_lookup_codes lkp1,

487: ,lkp1.description
488: ,pol.LINE_NUM_DISPLAY
489: FROM po_lines_draft_all pol, --CLM Apprvl
490: po_lines_draft_all po2, -- CLM Apprvl
491: po_lookup_codes lkp1,
492: mtl_system_items_kfv msi,
493: mtl_units_of_measure muom, -- bug 2401933.add
494: financials_system_parameters fsp
495: WHERE pol.po_header_id = v_document_id

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

1241: -- from history_csr cursor.
1242: --
1243: TYPE sequence_num_tbl_type IS TABLE OF PO_ACTION_HISTORY.sequence_num%TYPE;
1244: TYPE full_name_tbl_type IS TABLE OF PER_ALL_PEOPLE_F.full_name%TYPE;
1245: TYPE displayed_field_tbl_type IS TABLE OF PO_LOOKUP_CODES.displayed_field%TYPE;
1246: TYPE action_date_tbl_type IS TABLE OF PO_ACTION_HISTORY.action_date%TYPE;
1247: TYPE note_tbl_type IS TABLE OF PO_ACTION_HISTORY.note%TYPE;
1248: TYPE object_revision_num_tbl_type IS TABLE OF PO_ACTION_HISTORY.object_revision_num%TYPE;
1249: TYPE employee_id_tbl_type IS TABLE OF PO_ACTION_HISTORY.employee_id%TYPE;

Line 1277: po_lookup_codes polc

1273: poh.employee_id, /* bug 2788683 */
1274: poh.created_by /* bug 2788683 */
1275: from po_action_history poh,
1276: per_all_people_f per, -- Bug 3404451
1277: po_lookup_codes polc
1278: where OBJECT_TYPE_CODE = v_doc_type_code
1279: and poh.object_sub_type_code = v_doc_sub_type_code
1280: and poh.action_code = polc.lookup_code
1281: and POLC.LOOKUP_TYPE IN ('APPROVER ACTIONS','CONTROL ACTIONS')