DBA Data[Home] [Help]

APPS.PO_REQS_SV2 dependencies on PO_LOOKUP_CODES

Line 24: from PO_LOOKUP_CODES polc, PO_REQUISITION_HEADERS_ALL porh

20: -- WF change by Iali. 07/24/97 - modified 10/01/97
21:
22: select distinct polc.DISPLAYED_FIELD, porh.AUTHORIZATION_STATUS
23: INTO X_req_header_auth_status_dsp, X_req_header_auth_status
24: from PO_LOOKUP_CODES polc, PO_REQUISITION_HEADERS_ALL porh
25: where
26: porh.authorization_status = polc.LOOKUP_CODE
27: and polc.LOOKUP_TYPE = 'AUTHORIZATION STATUS'
28: and porh.requisition_header_id = X_req_header_id;