DBA Data[Home] [Help]

APPS.PO_CLOSEOUT_PVT dependencies on PO_LOOKUP_CODES

Line 2244: po_lookup_codes plc1,

2240: PO_DOCUMENT_TOTALS_PVT.getAmountOrdered('HEADER',po_header_id,'TRANSACTION',revision_num,-1) totAmt,
2241: currency_code
2242: FROM po_headers ph,
2243: po_doc_style_headers pdsh,
2244: po_lookup_codes plc1,
2245: po_lookup_codes plc2,
2246: po_vendors pv
2247: WHERE clm_award_administrator = l_admin_id
2248: AND authorization_status = 'APPROVED'

Line 2245: po_lookup_codes plc2,

2241: currency_code
2242: FROM po_headers ph,
2243: po_doc_style_headers pdsh,
2244: po_lookup_codes plc1,
2245: po_lookup_codes plc2,
2246: po_vendors pv
2247: WHERE clm_award_administrator = l_admin_id
2248: AND authorization_status = 'APPROVED'
2249: AND Nvl(clm_closeout_status, 'OPEN') = 'OPEN'