View: OKL_INSURER_RANKINGS_UV

Product:	OKL - Leasing and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_INSURER_RANKINGS_UV

View Text

SELECT IRK.ROWID ROW_ID
, IRK.ID ID
, IRK.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, DECODE(NVL(IRK.DATE_TO
, NULL)
, NULL
, 'ACTIVE'
, DECODE(SIGN(MONTHS_BETWEEN(IRK.DATE_TO
, SYSDATE))
, 1
, 'ACTIVE'
, 0
, 'ACTIVE'
, 'INACTIVE')) STATUS
, IRK.RANKING_SEQ RANKING_SEQ
, IRK.DATE_FROM DATE_FROM
, IRK.DATE_TO DATE_TO
, IRK.ISU_ID ISU_ID
, INPR.PARTY_NAME
, IRK.IC_CODE IC_CODE
, CONV.TERRITORY_SHORT_NAME COUNTRY
, IRK.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, IRK.ATTRIBUTE1 ATTRIBUTE1
, IRK.ATTRIBUTE2 ATTRIBUTE2
, IRK.ATTRIBUTE3 ATTRIBUTE3
, IRK.ATTRIBUTE4 ATTRIBUTE4
, IRK.ATTRIBUTE5 ATTRIBUTE5
, IRK.ATTRIBUTE6 ATTRIBUTE6
, IRK.ATTRIBUTE7 ATTRIBUTE7
, IRK.ATTRIBUTE8 ATTRIBUTE8
, IRK.ATTRIBUTE9 ATTRIBUTE9
, IRK.ATTRIBUTE10 ATTRIBUTE10
, IRK.ATTRIBUTE11 ATTRIBUTE11
, IRK.ATTRIBUTE12 ATTRIBUTE12
, IRK.ATTRIBUTE13 ATTRIBUTE13
, IRK.ATTRIBUTE14 ATTRIBUTE14
, IRK.ATTRIBUTE15 ATTRIBUTE15
, IRK.CREATED_BY CREATED_BY
, IRK.CREATION_DATE CREATION_DATE
, IRK.LAST_UPDATED_BY LAST_UPDATED_BY
, IRK.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IRK.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_INSURER_RANKINGS IRK
, OKX_INS_PROVIDER_V INPR
, FND_TERRITORIES_TL CONV
WHERE INPR.PARTY_ID = IRK.ISU_ID
AND CONV.LANGUAGE = USERENV('LANG')
AND CONV.TERRITORY_CODE = IRK.IC_CODE

Columns