DBA Data[Home] [Help]

APPS.PO_CORE_S dependencies on PO_REQUISITION_HEADERS

Line 7028: FROM po_requisition_headers prh, po_lookup_codes plc_sta, po_lookup_codes plc_clo

7024: SELECT plc_sta.displayed_field
7025: , prh.authorization_status
7026: , DECODE(nvl(prh.closed_code,'OPEN'), 'OPEN', NULL, plc_clo.displayed_field)
7027: INTO l_status_code, l_auth_status, l_closed_status
7028: FROM po_requisition_headers prh, po_lookup_codes plc_sta, po_lookup_codes plc_clo
7029: WHERE plc_sta.lookup_code = DECODE(prh.authorization_status,
7030: 'SYSTEM_SAVED', 'INCOMPLETE',
7031: nvl(prh.authorization_status, 'INCOMPLETE')
7032: )