DBA Data[Home] [Help]

APPS.POS_CHANGE_PROM_DATES dependencies on PO_LOOKUP_CODES

Line 178: po_lookup_codes polc,

174: x_org_id,
175: x_document_num,
176: x_agent_id
177: from po_releases_all por,
178: po_lookup_codes polc,
179: po_headers_all poh
180: where po_release_id = x_po_release_id
181: and por.po_header_id=poh.po_header_id
182: and por.release_type = polc.lookup_code

Line 192: po_lookup_codes polc

188:
189: select poh.segment1, poh.agent_id, poh.type_lookup_code, polc.displayed_field, poh.org_id
190: into x_document_num, x_agent_id, x_document_subtype, x_document_type, x_org_id
191: from po_headers_all poh,
192: po_lookup_codes polc
193: where
194: poh.po_header_id = x_document_id
195: and poh.type_lookup_code = polc.lookup_code
196: and polc.lookup_type = 'PO TYPE';