DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_DOC dependencies on PO_LOOKUP_CODES

Line 5221: /* Get the displayed value from po_lookup_codes so it will be translated

5217: itemkey => itemkey,
5218: aname => 'AGENT_ID');
5219:
5220:
5221: /* Get the displayed value from po_lookup_codes so it will be translated
5222: * This will return either 'Standard PO' or 'Release'
5223: */
5224: --
5225: if (x_doc_type_to_create = 'STANDARD') then

Line 5231: from po_lookup_codes

5227: else --releases
5228:
5229: select displayed_field
5230: into x_doc_type_created_disp
5231: from po_lookup_codes
5232: where lookup_type = 'NOTIFICATION TYPE'
5233: and lookup_code = x_doc_type_to_create;
5234: end if;
5235: --

Line 6398: po_lookup_codes ty,

6394: l_org_id,
6395: l_preparer_id,
6396: doc_subtype
6397: from po_requisition_headers hd,
6398: po_lookup_codes ty,
6399: po_lookup_codes st
6400: where hd.requisition_header_id = p_req_header_id
6401: and ty.lookup_type = 'DOCUMENT TYPE'
6402: and ty.lookup_code = 'REQUISITION'

Line 6399: po_lookup_codes st

6395: l_preparer_id,
6396: doc_subtype
6397: from po_requisition_headers hd,
6398: po_lookup_codes ty,
6399: po_lookup_codes st
6400: where hd.requisition_header_id = p_req_header_id
6401: and ty.lookup_type = 'DOCUMENT TYPE'
6402: and ty.lookup_code = 'REQUISITION'
6403: and st.lookup_type = 'REQUISITION TYPE'