View: OKL_INS_RATES_UV

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

View Text

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'

Columns