View: OKL_GEN_LOSS_PROVISION_UV

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

View Text

SELECT DISTINCT (CHR.ID) CONTRACT_ID
, CHR.CONTRACT_NUMBER
, STY.ID STY_ID
, STYTL.NAME
, TRX.DATE_TRANSACTION_OCCURRED
, TRX.TAX_DEDUCTIBLE_LOCAL
, TRX.TAX_DEDUCTIBLE_CORPORATE
, TRX.DESCRIPTION
, AR.BUCKET_NAME
, TRX.AMOUNT
FROM OKC_K_HEADERS_B CHR
, OKL_TRX_CONTRACTS_ALL TRX
, OKL_TXL_CNTRCT_LNS_ALL TXL
, OKL_STRM_TYPE_B STY
, OKL_STRM_TYPE_TL STYTL
, AR_AGING_BUCKET_LINES_B ARL
, AR_AGING_BUCKETS AR
, OKL_BUCKETS BKT
WHERE CHR.ID = TRX.KHR_ID
AND TRX.TCN_TYPE = 'PGL'
AND TRX.TSU_CODE = 'ENTERED'
AND TXL.STY_ID = STY.ID
AND STY.ID = STYTL.ID
AND STYTL.LANGUAGE = USERENV('LANG')
AND TRX.ID = TXL.TCN_ID
AND TXL.BKT_ID = BKT.ID
AND BKT.IBC_ID = ARL.AGING_BUCKET_LINE_ID
AND ARL.AGING_BUCKET_ID = AR.AGING_BUCKET_ID

Columns