View: OKL_INS_EXCLUSIONS_UV

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

View Text

SELECT IENB.ID ID
, IENB.ROWID ROW_ID
, IENB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, IENT.SFWT_FLAG SFWT_FLAG
, IENB.COUNTRY_ID COUNTRY_ID
, OCOV.NAME COUNTRY
, OACV.NAME COLL_NAME
, IENB.COLL_CODE COLL_CODE
, IENB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, IENB.ATTRIBUTE1 ATTRIBUTE1
, IENB.ATTRIBUTE2 ATTRIBUTE2
, IENB.ATTRIBUTE3 ATTRIBUTE3
, IENB.ATTRIBUTE4 ATTRIBUTE4
, IENB.ATTRIBUTE5 ATTRIBUTE5
, IENB.ATTRIBUTE6 ATTRIBUTE6
, IENB.ATTRIBUTE7 ATTRIBUTE7
, IENB.ATTRIBUTE8 ATTRIBUTE8
, IENB.ATTRIBUTE9 ATTRIBUTE9
, IENB.ATTRIBUTE10 ATTRIBUTE10
, IENB.ATTRIBUTE11 ATTRIBUTE11
, IENB.ATTRIBUTE12 ATTRIBUTE12
, IENB.ATTRIBUTE13 ATTRIBUTE13
, IENB.ATTRIBUTE14 ATTRIBUTE14
, IENB.ATTRIBUTE15 ATTRIBUTE15
, IENB.DATE_FROM DATE_FROM
, IENB.SIC_CODE SIC_CODE
, IENB.DATE_TO DATE_TO
, IENT.COMMENTS COMMENTS
, IENB.CREATED_BY CREATED_BY
, IENB.CREATION_DATE CREATION_DATE
, IENB.LAST_UPDATED_BY LAST_UPDATED_BY
, IENB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IENB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DECODE(NVL(IENB.DATE_TO
, NULL)
, NULL
, 'ACTIVE'
, DECODE(SIGN(MONTHS_BETWEEN(IENB.DATE_TO
, SYSDATE))
, 1
, 'ACTIVE'
, 0
, 'ACTIVE'
, 'INACCTIVE')) STATUS
FROM OKL_INS_EXCLUSIONS_B IENB
, OKL_INS_EXCLUSIONS_TL IENT
, OKX_COUNTRIES_V OCOV
, OKX_ASST_CATGRS_V OACV
WHERE IENB.ID = IENT.ID
AND IENT.LANGUAGE = USERENV('LANG')
AND IENB.COUNTRY_ID = OCOV.ID1
AND IENB.COLL_CODE = OACV.ID1

Columns