VIEW: APPS.OKL_BPD_AP_DISBURS_SMRY_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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