View: OKL_BPD_BTCH_CONT_SUMRY_UV

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

View Text

SELECT A.ID
, NAME
, BATCH_QTY
, TO_CHAR (BATCH_TOTAL
, '99
, 999
, 999
, 999.99')
, CURRENCY_CODE
, DATE_DEPOSIT
, DATE_GL_REQUESTED
, TRX_STATUS_CODE
, A.IRM_ID
, A.ORG_ID
, A.CURRENCY_CONVERSION_TYPE
, A.CURRENCY_CONVERSION_RATE
, A.CURRENCY_CONVERSION_DATE
FROM OKL_TRX_CSH_BATCH_V A
, OKL_TRX_CSH_RECEIPT_V B
, OKL_TXL_RCPT_APPS_V C
WHERE A.ID = B.BTC_ID
AND B.ID = C.RCT_ID_DETAILS
AND C.KHR_ID IS NOT NULL
AND C.CNR_ID IS NULL
AND B.ID IN (SELECT MIN(ID)
FROM OKL_TRX_CSH_RECEIPT_V
WHERE BTC_ID = A.ID)

Columns