View: OKL_BPD_AP_DISBURS_SMRY_UV

Product:	OKL - Lease and Finance Management
Description:	AP Disbursements Summary
Implementation/DBA Data:	APPS.OKL_BPD_AP_DISBURS_SMRY_UV

View Text

SELECT APINV.INVOICE_ID INVOICE_ID
, IA.CONTRACT_NUMBER INVESTOR_AGREEMENT
, POV.VENDOR_NAME INVESTOR_NAME
, CNSLD.VENDOR_INVOICE_NUMBER INVOICE_NUMBER
, CNSLD.CURRENCY_CODE INVOICE_CURRENCY_CODE
, CNSLD.DATE_INVOICED INVOICE_DATE
, APINV.ORG_ID
, OKL_ACCOUNTING_UTIL.FORMAT_AMOUNT(NVL(SUM(TPL.AMOUNT)
, 0)
, CNSLD.CURRENCY_CODE) INVESTOR_AMOUNT
, OKL_ACCOUNTING_UTIL.FORMAT_AMOUNT(NVL(SUM(CNSLD.AMOUNT)
, 0)
, CNSLD.CURRENCY_CODE) TOTAL_TRANSACTION_AMOUNT
, IA.SCS_CODE SCS_CODE
FROM FND_APPLICATION APP
, OKL_CNSLD_AP_INVS_ALL CNSLD
, PO_VENDORS POV
, OKC_K_HEADERS_B IA
, AP_INVOICES_ALL APINV
, OKL_TXL_AP_INV_LNS_V TPL
, OKL_STRM_TYPE_V STY
, OKL_TRX_AP_INVOICES_V TAP
WHERE APINV.VENDOR_ID = POV.VENDOR_ID
AND CNSLD.VENDOR_INVOICE_NUMBER = APINV.INVOICE_NUM
AND TPL.STY_ID = STY.ID
AND TPL.TAP_ID = TAP.ID
AND TAP.TRX_STATUS_CODE = 'PROCESSED'
AND TPL.KHR_ID = IA.ID
AND TAP.VENDOR_ID = POV.VENDOR_ID
AND TPL.CNSLD_AP_INV_ID = CNSLD.CNSLD_AP_INV_ID
AND APINV.APPLICATION_ID = APP.APPLICATION_ID
AND APP.APPLICATION_SHORT_NAME = 'OKL'
AND APINV.PRODUCT_TABLE = 'OKL_CNSLD_AP_INVS_ALL'
AND CNSLD.CNSLD_AP_INV_ID = TO_NUMBER(APINV.REFERENCE_KEY1) GROUP BY APINV.INVOICE_ID
, IA.CONTRACT_NUMBER
, POV.VENDOR_NAME
, CNSLD.VENDOR_INVOICE_NUMBER
, CNSLD.CURRENCY_CODE
, CNSLD.DATE_INVOICED
, APINV.ORG_ID
, IA.SCS_CODE ORDER BY 1
, 2
, 3
, 4
, 5
, 6

Columns