View: OKL_BPD_BATCH_LINES_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_BPD_BATCH_LINES_UV

View Text

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

Columns