eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKL_BPD_AP_DISB_DTL_LN_UV

Source

View Text - Preformatted


SELECT APINV.INVOICE_ID INVOICE_ID , IA.CONTRACT_NUMBER INVESTOR_AGREEMENT , CNSLD.INVOICE_NUMBER INVOICE_NUMBER , CNSLD.VENDOR_INVOICE_NUMBER VOUCHER_NUMBER , CNSLD.CURRENCY_CODE INVOICE_CURRENCY_CODE , CNSLD.DATE_INVOICED INVOICE_DATE , KHR.CONTRACT_NUMBER LEASE_CONTRACT , STY.NAME STREAM_TYPE , OKL_ACCOUNTING_UTIL.FORMAT_AMOUNT(NVL(TPL.AMOUNT,0), CNSLD.CURRENCY_CODE) INVOICE_AMOUNT FROM OKC_K_HEADERS_B KHR,AP_INVOICES_ALL APINV,OKL_STRM_TYPE_V STY,OKL_TRX_AP_INVOICES_V TAP,OKL_TXL_AP_INV_LNS_V TPL,OKL_STRM_ELEMENTS_V STE,OKL_STREAMS_V STM,OKC_K_HEADERS_B IA,FND_APPLICATION APP,OKL_CNSLD_AP_INVS_ALL CNSLD WHERE APINV.VENDOR_ID = TAP.VENDOR_ID AND CNSLD.VENDOR_INVOICE_NUMBER = APINV.INVOICE_NUM AND TPL.TAP_ID = TAP.ID AND TAP.TRX_STATUS_CODE = 'PROCESSED' AND TPL.SEL_ID = STE.ID AND TPL.STY_ID = STY.ID AND STE.STM_ID = STM.ID AND STM.KHR_ID = KHR.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) AND IA.ID = TPL.KHR_ID

View Text - HTML Formatted

SELECT APINV.INVOICE_ID INVOICE_ID
, IA.CONTRACT_NUMBER INVESTOR_AGREEMENT
, CNSLD.INVOICE_NUMBER INVOICE_NUMBER
, CNSLD.VENDOR_INVOICE_NUMBER VOUCHER_NUMBER
, CNSLD.CURRENCY_CODE INVOICE_CURRENCY_CODE
, CNSLD.DATE_INVOICED INVOICE_DATE
, KHR.CONTRACT_NUMBER LEASE_CONTRACT
, STY.NAME STREAM_TYPE
, OKL_ACCOUNTING_UTIL.FORMAT_AMOUNT(NVL(TPL.AMOUNT
, 0)
, CNSLD.CURRENCY_CODE) INVOICE_AMOUNT
FROM OKC_K_HEADERS_B KHR
, AP_INVOICES_ALL APINV
, OKL_STRM_TYPE_V STY
, OKL_TRX_AP_INVOICES_V TAP
, OKL_TXL_AP_INV_LNS_V TPL
, OKL_STRM_ELEMENTS_V STE
, OKL_STREAMS_V STM
, OKC_K_HEADERS_B IA
, FND_APPLICATION APP
, OKL_CNSLD_AP_INVS_ALL CNSLD
WHERE APINV.VENDOR_ID = TAP.VENDOR_ID
AND CNSLD.VENDOR_INVOICE_NUMBER = APINV.INVOICE_NUM
AND TPL.TAP_ID = TAP.ID
AND TAP.TRX_STATUS_CODE = 'PROCESSED'
AND TPL.SEL_ID = STE.ID
AND TPL.STY_ID = STY.ID
AND STE.STM_ID = STM.ID
AND STM.KHR_ID = KHR.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)
AND IA.ID = TPL.KHR_ID