View: OKL_SPEC_LOSS_PROVISION_UV

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

View Text

SELECT CHR.ID CONTRACT_ID
, CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, CHR.SCS_CODE SCS_CODE
, STY.ID STY_ID
, STYTL.NAME STREAM_TYPE_NAME
, TRY.NAME
, TRX.AMOUNT RESERVE_AMOUNT
, CHR.CURRENCY_CODE CURRENCY_CODE
, TRX.TAX_DEDUCTIBLE_LOCAL TAX_DEDUCTIBLE_LOCAL
, TRX.TAX_DEDUCTIBLE_CORPORATE TAX_DEDUCTIBLE_CORPORATE
, TRX.DESCRIPTION DESCRIPTION
, 'N' REVERSE_TOTAL_RESERVE
, TRX.DATE_TRANSACTION_OCCURRED PROVISION_DATE
, CHR.ORG_ID
FROM OKC_K_HEADERS_B CHR
, OKL_K_HEADERS KHR
, OKL_TRX_CONTRACTS_ALL TRX
, OKL_TXL_CNTRCT_LNS_ALL TXL
, OKL_STRM_TYPE_B STY
, OKL_STRM_TYPE_TL STYTL
, OKL_TRX_TYPES_TL TRY
WHERE CHR.ID = KHR.ID
AND KHR.ID = TRX.KHR_ID
AND TRX.TCN_TYPE IN ('PSP'
, 'PGL')
AND TRX.TSU_CODE = 'PROCESSED'
AND TRX.TRY_ID = TRY.ID
AND TRY.LANGUAGE = USERENV ('LANG')
AND TRX.ID = TXL.TCN_ID
AND TXL.STY_ID = STY.ID
AND STY.ID = STYTL.ID
AND STYTL.LANGUAGE = USERENV ('LANG')

Columns