VIEW: APPS.OKL_INS_RATES_UV

Source

View Text - Preformatted

SELECT INRV.ROWID ROW_ID, INRV.ID ID, INRV.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, DECODE(NVL(INRV.DATE_TO,NULL),NULL,'ACTIVE',DECODE(SIGN(MONTHS_BETWEEN(INRV.DATE_TO,SYSDATE)),1,'ACTIVE',0,'ACTIVE','INACTIVE')) STATUS, INRV.IC_ID IC_ID, IPTT.INVENTORY_ORG_ID INVENTORY_ORG_ID, FIFC.MEANING INSURANCE_FACTOR, CONV.TERRITORY_SHORT_NAME COUNTRY , INRV.IPT_ID IPT_ID, IPTT.NAME PRODUCT, INRV.IAC_CODE IAC_CODE, LOKU.MEANING INSURANCE_CLASS, INRV.COVERAGE_MAX COVERAGE_MAX, INRV.DEDUCTIBLE DEDUCTIBLE, INRV.FACTOR_RANGE_START FACTOR_RANGE_START, INRV.INSURED_RATE INSURED_RATE, INRV.FACTOR_RANGE_END FACTOR_RANGE_END, INRV.DATE_FROM DATE_FROM, INRV.DATE_TO DATE_TO, INRV.INSURER_RATE INSURER_RATE, INRV.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, INRV.ATTRIBUTE1 ATTRIBUTE1, INRV.ATTRIBUTE2 ATTRIBUTE2, INRV.ATTRIBUTE3 ATTRIBUTE3, INRV.ATTRIBUTE4 ATTRIBUTE4, INRV.ATTRIBUTE5 ATTRIBUTE5, INRV.ATTRIBUTE6 ATTRIBUTE6, INRV.ATTRIBUTE7 ATTRIBUTE7, INRV.ATTRIBUTE8 ATTRIBUTE8, INRV.ATTRIBUTE9 ATTRIBUTE9, INRV.ATTRIBUTE10 ATTRIBUTE10, INRV.ATTRIBUTE11 ATTRIBUTE11, INRV.ATTRIBUTE12 ATTRIBUTE12, INRV.ATTRIBUTE13 ATTRIBUTE13, INRV.ATTRIBUTE14 ATTRIBUTE14, INRV.ATTRIBUTE15 ATTRIBUTE15, INRV.CREATED_BY CREATED_BY, INRV.CREATION_DATE CREATION_DATE, INRV.LAST_UPDATED_BY LAST_UPDATED_BY, INRV.LAST_UPDATE_DATE LAST_UPDATE_DATE, INRV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM OKL_INS_PRODUCTS_UV IPTT,FND_LOOKUPS FIFC,OKL_INS_RATES INRV,FND_TERRITORIES_TL CONV,FND_LOOKUPS LOKU WHERE LOKU.LOOKUP_CODE = INRV.IAC_CODE AND LOKU.LOOKUP_TYPE = 'OKL_INSURANCE_ASSET_CLASS' AND CONV.LANGUAGE = USERENV('LANG') AND CONV.TERRITORY_CODE = INRV.IC_ID AND IPTT.ID = INRV.IPT_ID AND IPTT.FACTOR_CODE = FIFC.LOOKUP_CODE AND FIFC.LOOKUP_TYPE = 'OKL_INSURANCE_FACTOR'

View Text - HTML Formatted

SELECT INRV.ROWID ROW_ID
, INRV.ID ID
, INRV.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, DECODE(NVL(INRV.DATE_TO
, NULL)
, NULL
, 'ACTIVE'
, DECODE(SIGN(MONTHS_BETWEEN(INRV.DATE_TO
, SYSDATE))
, 1
, 'ACTIVE'
, 0
, 'ACTIVE'
, 'INACTIVE')) STATUS
, INRV.IC_ID IC_ID
, IPTT.INVENTORY_ORG_ID INVENTORY_ORG_ID
, FIFC.MEANING INSURANCE_FACTOR
, CONV.TERRITORY_SHORT_NAME COUNTRY
, INRV.IPT_ID IPT_ID
, IPTT.NAME PRODUCT
, INRV.IAC_CODE IAC_CODE
, LOKU.MEANING INSURANCE_CLASS
, INRV.COVERAGE_MAX COVERAGE_MAX
, INRV.DEDUCTIBLE DEDUCTIBLE
, INRV.FACTOR_RANGE_START FACTOR_RANGE_START
, INRV.INSURED_RATE INSURED_RATE
, INRV.FACTOR_RANGE_END FACTOR_RANGE_END
, INRV.DATE_FROM DATE_FROM
, INRV.DATE_TO DATE_TO
, INRV.INSURER_RATE INSURER_RATE
, INRV.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, INRV.ATTRIBUTE1 ATTRIBUTE1
, INRV.ATTRIBUTE2 ATTRIBUTE2
, INRV.ATTRIBUTE3 ATTRIBUTE3
, INRV.ATTRIBUTE4 ATTRIBUTE4
, INRV.ATTRIBUTE5 ATTRIBUTE5
, INRV.ATTRIBUTE6 ATTRIBUTE6
, INRV.ATTRIBUTE7 ATTRIBUTE7
, INRV.ATTRIBUTE8 ATTRIBUTE8
, INRV.ATTRIBUTE9 ATTRIBUTE9
, INRV.ATTRIBUTE10 ATTRIBUTE10
, INRV.ATTRIBUTE11 ATTRIBUTE11
, INRV.ATTRIBUTE12 ATTRIBUTE12
, INRV.ATTRIBUTE13 ATTRIBUTE13
, INRV.ATTRIBUTE14 ATTRIBUTE14
, INRV.ATTRIBUTE15 ATTRIBUTE15
, INRV.CREATED_BY CREATED_BY
, INRV.CREATION_DATE CREATION_DATE
, INRV.LAST_UPDATED_BY LAST_UPDATED_BY
, INRV.LAST_UPDATE_DATE LAST_UPDATE_DATE
, INRV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_INS_PRODUCTS_UV IPTT
, FND_LOOKUPS FIFC
, OKL_INS_RATES INRV
, FND_TERRITORIES_TL CONV
, FND_LOOKUPS LOKU
WHERE LOKU.LOOKUP_CODE = INRV.IAC_CODE
AND LOKU.LOOKUP_TYPE = 'OKL_INSURANCE_ASSET_CLASS'
AND CONV.LANGUAGE = USERENV('LANG')
AND CONV.TERRITORY_CODE = INRV.IC_ID
AND IPTT.ID = INRV.IPT_ID
AND IPTT.FACTOR_CODE = FIFC.LOOKUP_CODE
AND FIFC.LOOKUP_TYPE = 'OKL_INSURANCE_FACTOR'