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_BATCH_LINES_UV

Source

View Text - Preformatted


SELECT BTC.ID , BTC.NAME , BTC.TRX_STATUS_CODE , IH.ID , IH.IRM_ID , IL.CNR_ID , CNR.CONSOLIDATED_INVOICE_NUMBER , IH.CURRENCY_CODE , IH.CHECK_NUMBER , IH.DATE_EFFECTIVE , IH.RCPT_STATUS_CODE , IH.AMOUNT , IH.ILE_ID , IL.KHR_ID , CN.CONTRACT_NUMBER , CA.ACCOUNT_NUMBER FROM OKL_TRX_CSH_BATCH_V BTC,OKL_TRX_CSH_RCPT_ALL_B IH,OKL_TXL_RCPT_APPS_ALL_B IL,OKL_CNSLD_AR_HDRS_ALL_B CNR,HZ_CUST_ACCOUNTS CA,OKC_K_HEADERS_B CN WHERE BTC.ID = IH.BTC_ID AND IH.ID = IL.RCT_ID_DETAILS AND IL.CNR_ID = CNR.ID AND CN.ID (+) = IL.KHR_ID AND CNR.IXX_ID = CA.CUST_ACCOUNT_ID

View Text - HTML Formatted

SELECT BTC.ID
, BTC.NAME
, BTC.TRX_STATUS_CODE
, IH.ID
, IH.IRM_ID
, IL.CNR_ID
, CNR.CONSOLIDATED_INVOICE_NUMBER
, IH.CURRENCY_CODE
, IH.CHECK_NUMBER
, IH.DATE_EFFECTIVE
, IH.RCPT_STATUS_CODE
, IH.AMOUNT
, IH.ILE_ID
, IL.KHR_ID
, CN.CONTRACT_NUMBER
, CA.ACCOUNT_NUMBER
FROM OKL_TRX_CSH_BATCH_V BTC
, OKL_TRX_CSH_RCPT_ALL_B IH
, OKL_TXL_RCPT_APPS_ALL_B IL
, OKL_CNSLD_AR_HDRS_ALL_B CNR
, HZ_CUST_ACCOUNTS CA
, OKC_K_HEADERS_B CN
WHERE BTC.ID = IH.BTC_ID
AND IH.ID = IL.RCT_ID_DETAILS
AND IL.CNR_ID = CNR.ID
AND CN.ID (+) = IL.KHR_ID
AND CNR.IXX_ID = CA.CUST_ACCOUNT_ID