DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_DOC dependencies on PO_LOOKUP_CODES

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

4879: itemkey => itemkey,
4880: aname => 'AGENT_ID');
4881:
4882:
4883: /* Get the displayed value from po_lookup_codes so it will be translated
4884: * This will return either 'Standard PO' or 'Release'
4885: */
4886: --
4887: if (x_doc_type_to_create = 'STANDARD') then

Line 4893: from po_lookup_codes

4889: else --releases
4890:
4891: select displayed_field
4892: into x_doc_type_created_disp
4893: from po_lookup_codes
4894: where lookup_type = 'NOTIFICATION TYPE'
4895: and lookup_code = x_doc_type_to_create;
4896: end if;
4897: --

Line 5976: po_lookup_codes ty,

5972: l_org_id,
5973: l_preparer_id,
5974: doc_subtype
5975: from po_requisition_headers hd,
5976: po_lookup_codes ty,
5977: po_lookup_codes st
5978: where hd.requisition_header_id = p_req_header_id
5979: and ty.lookup_type = 'DOCUMENT TYPE'
5980: and ty.lookup_code = 'REQUISITION'

Line 5977: po_lookup_codes st

5973: l_preparer_id,
5974: doc_subtype
5975: from po_requisition_headers hd,
5976: po_lookup_codes ty,
5977: po_lookup_codes st
5978: where hd.requisition_header_id = p_req_header_id
5979: and ty.lookup_type = 'DOCUMENT TYPE'
5980: and ty.lookup_code = 'REQUISITION'
5981: and st.lookup_type = 'REQUISITION TYPE'