VIEW: APPS.OKL_BPD_BTCH_CONT_SUMRY_UV

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)