VIEW: APPS.OKL_SPEC_LOSS_PROVISION_UV

Source

View Text - Preformatted

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.representation_type = 'PRIMARY' 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')

View Text - HTML Formatted

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.REPRESENTATION_TYPE = 'PRIMARY'
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')