APPS.POS_WF_PO_ACKNOWLEDGE dependencies on PO_LOOKUP_CODES

Line 170: po_lookup_codes polc

166: poh.acceptance_required_flag, poh.acceptance_due_date, poh.org_id
167: into x_document_num, x_document_type, x_agent_id, x_acceptance_required_flag,
168: x_acceptance_due_date, x_org_id
169: from po_headers_all poh,
170: po_lookup_codes polc
171: where poh.po_header_id = x_document_id
172: and poh.type_lookup_code = polc.lookup_code
173: and polc.lookup_type = 'PO TYPE';
174:

Line 187: po_lookup_codes polc

183: into x_release_num, x_agent_id, x_document_num, x_document_type, x_acceptance_required_flag,
184: x_acceptance_due_date, x_agent_id
185: from po_releases_all por,
186: po_headers_all poh,
187: po_lookup_codes polc
188: where por.po_release_id = x_document_id
189: and por.po_header_id = poh.po_header_id
190: and polc.lookup_type = 'DOCUMENT TYPE'
191: and polc.lookup_code = 'RELEASE';