DBA Data[Home] [Help]

APPS.PO_CLOSEOUT_PVT dependencies on PO_DOC_STYLE_HEADERS

Line 2195: po_doc_style_headers pdsh

2191:
2192: CURSOR clmAwardAdmins IS
2193: SELECT DISTINCT clm_award_administrator
2194: FROM po_headers ph,
2195: po_doc_style_headers pdsh
2196: WHERE clm_award_administrator IS NOT NULL
2197: AND authorization_status = 'APPROVED'
2198: AND Nvl(clm_closeout_status, 'OPEN') = 'OPEN'
2199: AND ph.style_id = pdsh.style_id

Line 2243: po_doc_style_headers pdsh,

2239: PLC2.DISPLAYED_FIELD status, pv.vendor_name supplier,
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