DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTNOTIF_PVT dependencies on PO_LOOKUP_CODES

Line 225: order_type po_lookup_codes.displayed_field%TYPE,

221: sugg_supplier po_requisition_lines.suggested_vendor_name%TYPE,
222: sugg_site po_requisition_lines.suggested_vendor_location%TYPE,
223: txn_curr_code po_requisition_lines.currency_code%TYPE,
224: curr_unit_price po_requisition_lines.currency_unit_price%TYPE,
225: order_type po_lookup_codes.displayed_field%TYPE,
226: source_type_code po_requisition_lines.source_type_code%TYPE,
227: line_location_id po_requisition_lines.line_location_id%TYPE,
228: cancel_flag po_requisition_lines.cancel_flag%TYPE
229: );

Line 272: l_document_subtype po_lookup_codes.displayed_field%TYPE;

268: l_item_key wf_items.item_key%TYPE;
269:
270: l_document_id po_requisition_headers.requisition_header_id%TYPE;
271: l_org_id po_requisition_headers.org_id%TYPE;
272: l_document_subtype po_lookup_codes.displayed_field%TYPE;
273: l_document_type po_lookup_codes.displayed_field%TYPE;
274: l_document_number po_requisition_headers.segment1%TYPE;
275: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
276: l_change_request_group_id number;

Line 273: l_document_type po_lookup_codes.displayed_field%TYPE;

269:
270: l_document_id po_requisition_headers.requisition_header_id%TYPE;
271: l_org_id po_requisition_headers.org_id%TYPE;
272: l_document_subtype po_lookup_codes.displayed_field%TYPE;
273: l_document_type po_lookup_codes.displayed_field%TYPE;
274: l_document_number po_requisition_headers.segment1%TYPE;
275: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
276: l_change_request_group_id number;
277:

Line 450: l_document_subtype po_lookup_codes.displayed_field%TYPE;

446: l_change_request_group_id number;
447:
448: l_document_id po_requisition_headers.requisition_header_id%TYPE;
449: l_org_id po_requisition_headers.org_id%TYPE;
450: l_document_subtype po_lookup_codes.displayed_field%TYPE;
451: l_document_type po_lookup_codes.displayed_field%TYPE;
452: l_document_number po_requisition_headers.segment1%TYPE;
453: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
454:

Line 451: l_document_type po_lookup_codes.displayed_field%TYPE;

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

Line 683: PO_LOOKUP_CODES PLC

679: hr_locations_all hrt,
680: per_all_people_f per,
681: mtl_units_of_measure muom,
682: org_organization_definitions org,
683: PO_LOOKUP_CODES PLC
684: WHERE rql.requisition_header_id = v_document_id
685: AND NVL(rql.modified_by_agent_flag, 'N') = 'N'
686: AND hrt.location_id (+) = rql.deliver_to_location_id
687: AND rql.item_id = msi.inventory_item_id(+)

Line 1194: PO_LOOKUP_CODES PLC

1190: hr_locations_all hrt,
1191: per_all_people_f per,
1192: mtl_units_of_measure muom,
1193: org_organization_definitions org,
1194: PO_LOOKUP_CODES PLC
1195: WHERE rql.requisition_header_id = v_document_id
1196: AND NVL(rql.modified_by_agent_flag, 'N') = 'N'
1197: AND hrt.location_id (+) = rql.deliver_to_location_id
1198: AND rql.item_id = msi.inventory_item_id(+)

Line 1658: po_lookup_codes polc

1654: poh.NOTE,
1655: poh.OBJECT_REVISION_NUM
1656: from po_action_history poh,
1657: per_people_f per,
1658: po_lookup_codes polc
1659: where OBJECT_TYPE_CODE = v_object_type
1660: and poh.action_code = polc.lookup_code
1661: and POLC.LOOKUP_TYPE IN ('APPROVER ACTIONS','CONTROL ACTIONS')
1662: and per.person_id = poh.employee_id