View: OKL_CNSLD_AR_STRMS_V

Product:	OKL - Lease and Finance Management
Description:	Lowest level transaction included into consolidated bill
Implementation/DBA Data:	APPS.OKL_CNSLD_AR_STRMS_V

View Text

SELECT LSMB.ROWID
, LSMB.ID
, LSMB.OBJECT_VERSION_NUMBER
, LSMT.SFWT_FLAG
, LSMB.LLN_ID
, LSMB.KHR_ID
, LSMB.KLE_ID
, LSMB.STY_ID
, LSMB.AMOUNT
, LSMB.LATE_INT_ASSESS_DATE
, LSMB.LATE_CHARGE_ASSESS_DATE
, LSMB.LATE_CHARGE_ASS_YN
, LSMB.LATE_INT_ASS_YN
, LSMB.TAX_AMOUNT
, LSMB.RECEIVABLES_INVOICE_ID
, LSMB.ATTRIBUTE_CATEGORY
, LSMB.PAY_STATUS_CODE
, LSMB.ATTRIBUTE1
, LSMB.ATTRIBUTE2
, LSMB.ATTRIBUTE3
, LSMB.ATTRIBUTE4
, LSMB.ATTRIBUTE5
, LSMB.ATTRIBUTE6
, LSMB.ATTRIBUTE7
, LSMB.ATTRIBUTE8
, LSMB.ATTRIBUTE9
, LSMB.ATTRIBUTE10
, LSMB.ATTRIBUTE11
, LSMB.ATTRIBUTE12
, LSMB.ATTRIBUTE13
, LSMB.ATTRIBUTE14
, LSMB.ATTRIBUTE15
, LSMB.REQUEST_ID
, LSMB.PROGRAM_APPLICATION_ID
, LSMB.PROGRAM_ID
, LSMB.PROGRAM_UPDATE_DATE
, LSMB.ORG_ID
, LSMB.CREATED_BY
, LSMB.CREATION_DATE
, LSMB.LAST_UPDATED_BY
, LSMB.LAST_UPDATE_DATE
, LSMB.LAST_UPDATE_LOGIN
, LSMB.INVESTOR_DISB_STATUS
, LSMB.INVESTOR_DISB_ERR_MG
, LSMB.SEL_ID
, LSMB.DATE_DISBURSED
FROM OKL_CNSLD_AR_STRMS_B LSMB
, OKL_CNSLD_AR_STRMS_TL LSMT
WHERE LSMB.ID = LSMT.ID
AND LSMT.LANGUAGE = USERENV('LANG')

Columns