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_LOOKUP_CODES

Line 206: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;

202: l_item_key wf_items.item_key%TYPE;
203:
204: l_document_id po_requisition_headers.requisition_header_id%TYPE;
205: l_org_id po_requisition_headers.org_id%TYPE;
206: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
207: l_document_type po_lookup_codes.displayed_field%TYPE;
208: l_document_number po_requisition_headers.segment1%TYPE;
209: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
210: l_total_amount VARCHAR2(30);

Line 207: l_document_type po_lookup_codes.displayed_field%TYPE;

203:
204: l_document_id po_requisition_headers.requisition_header_id%TYPE;
205: l_org_id po_requisition_headers.org_id%TYPE;
206: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
207: l_document_type po_lookup_codes.displayed_field%TYPE;
208: l_document_number po_requisition_headers.segment1%TYPE;
209: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
210: l_total_amount VARCHAR2(30);
211: l_header_msg VARCHAR2(2225);

Line 451: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;

447: l_item_key wf_items.item_key%TYPE;
448:
449: l_document_id po_requisition_headers.requisition_header_id%TYPE;
450: l_org_id po_requisition_headers.org_id%TYPE;
451: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
452: l_document_type po_lookup_codes.displayed_field%TYPE;
453: l_document_number po_requisition_headers.segment1%TYPE;
454: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
455: l_total_amount VARCHAR2(30);

Line 452: l_document_type po_lookup_codes.displayed_field%TYPE;

448:
449: l_document_id po_requisition_headers.requisition_header_id%TYPE;
450: l_org_id po_requisition_headers.org_id%TYPE;
451: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
452: l_document_type po_lookup_codes.displayed_field%TYPE;
453: l_document_number po_requisition_headers.segment1%TYPE;
454: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
455: l_total_amount VARCHAR2(30);
456: l_header_msg VARCHAR2(200);

Line 721: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;

717: l_item_key wf_items.item_key%TYPE;
718:
719: l_document_id po_requisition_headers.requisition_header_id%TYPE;
720: l_org_id po_requisition_headers.org_id%TYPE;
721: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
722: l_document_type po_lookup_codes.displayed_field%TYPE;
723: l_document_number po_requisition_headers.segment1%TYPE;
724: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
725: l_total_amount VARCHAR2(30);

Line 722: l_document_type po_lookup_codes.displayed_field%TYPE;

718:
719: l_document_id po_requisition_headers.requisition_header_id%TYPE;
720: l_org_id po_requisition_headers.org_id%TYPE;
721: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
722: l_document_type po_lookup_codes.displayed_field%TYPE;
723: l_document_number po_requisition_headers.segment1%TYPE;
724: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
725: l_total_amount VARCHAR2(30);
726: l_header_msg VARCHAR2(200);

Line 946: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;

942: l_item_key wf_items.item_key%TYPE;
943:
944: l_document_id po_requisition_headers.requisition_header_id%TYPE;
945: l_org_id po_requisition_headers.org_id%TYPE;
946: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
947: l_document_type po_lookup_codes.displayed_field%TYPE;
948: l_document_number po_requisition_headers.segment1%TYPE;
949: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
950: l_total_amount VARCHAR2(30);

Line 947: l_document_type po_lookup_codes.displayed_field%TYPE;

943:
944: l_document_id po_requisition_headers.requisition_header_id%TYPE;
945: l_org_id po_requisition_headers.org_id%TYPE;
946: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
947: l_document_type po_lookup_codes.displayed_field%TYPE;
948: l_document_number po_requisition_headers.segment1%TYPE;
949: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
950: l_total_amount VARCHAR2(30);
951: l_header_msg VARCHAR2(200);

Line 1917: po_lookup_codes polc

1913: poh.created_by, /* bug 2788683 */
1914: poh.action_code /* bug 3090563 */
1915: from po_action_history poh,
1916: per_all_people_f per, -- Bug 3404451
1917: po_lookup_codes polc
1918: where OBJECT_TYPE_CODE = v_object_type
1919: and nvl(poh.action_code, 'PENDING') = polc.lookup_code
1920: and POLC.LOOKUP_TYPE = 'APPR_HIST_ACTIONS'
1921: and per.person_id(+) = poh.employee_id /* bug 2788683 */

Line 2289: po_lookup_codes polc

2285: poh.employee_id, /* bug 2788683 */
2286: poh.created_by /* bug 2788683 */
2287: from po_action_history poh,
2288: per_all_people_f per, -- Bug 3404451
2289: po_lookup_codes polc
2290: where OBJECT_TYPE_CODE = v_object_type
2291: and poh.action_code = polc.lookup_code
2292: and POLC.LOOKUP_TYPE IN ('APPROVER ACTIONS','CONTROL ACTIONS')
2293: and per.person_id(+) = poh.employee_id /* bug 2788683 */

Line 2925: from po_lookup_codes

2921: l_doc_subtype_disp varchar2(80);
2922:
2923: cursor c_doc_subtype(p_doc_subtype varchar2) is
2924: select DISPLAYED_FIELD
2925: from po_lookup_codes
2926: where lookup_type='REQUISITION TYPE'
2927: and lookup_code = p_doc_subtype;
2928:
2929: begin

Line 2948: from po_lookup_codes

2944: l_doc_type_disp varchar2(80);
2945:
2946: cursor c_doc_type(p_doc_type varchar2) is
2947: select DISPLAYED_FIELD
2948: from po_lookup_codes
2949: where lookup_type='DOCUMENT TYPE'
2950: and lookup_code = p_doc_type;
2951:
2952: begin