DBA Data[Home] [Help]

APPS.PO_WF_DOCUMENT dependencies on PO_LOOKUP_CODES

Line 39: l_document_subtype po_lookup_codes.displayed_field%TYPE;

35: l_item_key wf_items.item_key%TYPE;
36:
37: l_document_id po_requisition_headers.requisition_header_id%TYPE;
38: l_org_id po_requisition_headers.org_id%TYPE;
39: l_document_subtype po_lookup_codes.displayed_field%TYPE;
40: l_document_type po_lookup_codes.displayed_field%TYPE;
41: l_document_number po_requisition_headers.segment1%TYPE;
42: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
43: l_total_amount VARCHAR2(30);

Line 40: l_document_type po_lookup_codes.displayed_field%TYPE;

36:
37: l_document_id po_requisition_headers.requisition_header_id%TYPE;
38: l_org_id po_requisition_headers.org_id%TYPE;
39: l_document_subtype po_lookup_codes.displayed_field%TYPE;
40: l_document_type po_lookup_codes.displayed_field%TYPE;
41: l_document_number po_requisition_headers.segment1%TYPE;
42: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
43: l_total_amount VARCHAR2(30);
44: l_header_msg VARCHAR2(200);

Line 254: l_document_subtype po_lookup_codes.displayed_field%TYPE;

250: l_item_key wf_items.item_key%TYPE;
251:
252: l_document_id po_requisition_headers.requisition_header_id%TYPE;
253: l_org_id po_requisition_headers.org_id%TYPE;
254: l_document_subtype po_lookup_codes.displayed_field%TYPE;
255: l_document_type po_lookup_codes.displayed_field%TYPE;
256: l_document_number po_requisition_headers.segment1%TYPE;
257: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
258: l_total_amount VARCHAR2(30);

Line 255: l_document_type po_lookup_codes.displayed_field%TYPE;

251:
252: l_document_id po_requisition_headers.requisition_header_id%TYPE;
253: l_org_id po_requisition_headers.org_id%TYPE;
254: l_document_subtype po_lookup_codes.displayed_field%TYPE;
255: l_document_type po_lookup_codes.displayed_field%TYPE;
256: l_document_number po_requisition_headers.segment1%TYPE;
257: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
258: l_total_amount VARCHAR2(30);
259: l_header_msg VARCHAR2(200);

Line 459: l_document_subtype po_lookup_codes.displayed_field%TYPE;

455: l_item_key wf_items.item_key%TYPE;
456:
457: l_document_id po_requisition_headers.requisition_header_id%TYPE;
458: l_org_id po_requisition_headers.org_id%TYPE;
459: l_document_subtype po_lookup_codes.displayed_field%TYPE;
460: l_document_type po_lookup_codes.displayed_field%TYPE;
461: l_document_number po_requisition_headers.segment1%TYPE;
462: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
463: l_total_amount VARCHAR2(30);

Line 460: l_document_type po_lookup_codes.displayed_field%TYPE;

456:
457: l_document_id po_requisition_headers.requisition_header_id%TYPE;
458: l_org_id po_requisition_headers.org_id%TYPE;
459: l_document_subtype po_lookup_codes.displayed_field%TYPE;
460: l_document_type po_lookup_codes.displayed_field%TYPE;
461: l_document_number po_requisition_headers.segment1%TYPE;
462: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
463: l_total_amount VARCHAR2(30);
464: l_header_msg VARCHAR2(200);

Line 664: l_document_subtype po_lookup_codes.displayed_field%TYPE;

660: l_item_key wf_items.item_key%TYPE;
661:
662: l_document_id po_requisition_headers.requisition_header_id%TYPE;
663: l_org_id po_requisition_headers.org_id%TYPE;
664: l_document_subtype po_lookup_codes.displayed_field%TYPE;
665: l_document_type po_lookup_codes.displayed_field%TYPE;
666: l_document_number po_requisition_headers.segment1%TYPE;
667: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
668: l_total_amount VARCHAR2(30);

Line 665: l_document_type po_lookup_codes.displayed_field%TYPE;

661:
662: l_document_id po_requisition_headers.requisition_header_id%TYPE;
663: l_org_id po_requisition_headers.org_id%TYPE;
664: l_document_subtype po_lookup_codes.displayed_field%TYPE;
665: l_document_type po_lookup_codes.displayed_field%TYPE;
666: l_document_number po_requisition_headers.segment1%TYPE;
667: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
668: l_total_amount VARCHAR2(30);
669: l_header_msg VARCHAR2(200);

Line 1043: po_lookup_codes polc

1039: poh.NOTE,
1040: poh.OBJECT_REVISION_NUM
1041: from po_action_history poh,
1042: per_people_f per,
1043: po_lookup_codes polc
1044: where OBJECT_TYPE_CODE = v_object_type
1045: and poh.action_code = polc.lookup_code
1046: and POLC.LOOKUP_TYPE IN ('APPROVER ACTIONS','CONTROL ACTIONS')
1047: and per.person_id = poh.employee_id