View: OKL_TRX_CSH_RECEIPT_V

Product:	OKL - Lease and Finance Management
Description:	Individual receipt processed in a batch
Implementation/DBA Data:	APPS.OKL_TRX_CSH_RECEIPT_V

View Text

SELECT RCTB.ROWID ROW_ID
, RCTB.ID ID
, RCTB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, RCTT.SFWT_FLAG SFWT_FLAG
, RCTB.BTC_ID BTC_ID
, RCTB.IBA_ID IBA_ID
, RCTB.ILE_ID ILE_ID
, RCTB.IRM_ID IRM_ID
, RCTB.CHECK_NUMBER CHECK_NUMBER
, RCTB.CURRENCY_CODE CURRENCY_CODE
, RCTB.AMOUNT AMOUNT
, RCTB.GL_DATE GL_DATE
, RCTB.DATE_EFFECTIVE DATE_EFFECTIVE
, RCTB.EXCHANGE_RATE EXCHANGE_RATE
, RCTB.EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, RCTB.EXCHANGE_RATE_DATE EXCHANGE_RATE_DATE
, RCTT.DESCRIPTION DESCRIPTION
, RCTB.RCPT_STATUS_CODE RCPT_STATUS_CODE
, RCTB.RECEIPT_TYPE RECEIPT_TYPE
, RCTB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, RCTB.ATTRIBUTE1 ATTRIBUTE1
, RCTB.ATTRIBUTE2 ATTRIBUTE2
, RCTB.ATTRIBUTE3 ATTRIBUTE3
, RCTB.ATTRIBUTE4 ATTRIBUTE4
, RCTB.ATTRIBUTE5 ATTRIBUTE5
, RCTB.ATTRIBUTE6 ATTRIBUTE6
, RCTB.ATTRIBUTE7 ATTRIBUTE7
, RCTB.ATTRIBUTE8 ATTRIBUTE8
, RCTB.ATTRIBUTE9 ATTRIBUTE9
, RCTB.ATTRIBUTE10 ATTRIBUTE10
, RCTB.ATTRIBUTE11 ATTRIBUTE11
, RCTB.ATTRIBUTE12 ATTRIBUTE12
, RCTB.ATTRIBUTE13 ATTRIBUTE13
, RCTB.ATTRIBUTE14 ATTRIBUTE14
, RCTB.ATTRIBUTE15 ATTRIBUTE15
, RCTB.REQUEST_ID REQUEST_ID
, RCTB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, RCTB.PROGRAM_ID PROGRAM_ID
, RCTB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, RCTB.ORG_ID ORG_ID
, RCTB.CREATED_BY CREATED_BY
, RCTB.CREATION_DATE CREATION_DATE
, RCTB.LAST_UPDATED_BY LAST_UPDATED_BY
, RCTB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RCTB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RCTB.CASH_RECEIPT_ID
, RCTB.FULLY_APPLIED_FLAG
, RCTB.EXPIRED_FLAG
FROM OKL_TRX_CSH_RECEIPT_B RCTB
, OKL_TRX_CSH_RECEIPT_TL RCTT
WHERE RCTB.ID = RCTT.ID
AND RCTT.LANGUAGE = USERENV('LANG')

Columns