VIEW: APPS.OKL_GEN_LOSS_PROVISION_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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