View: OKL_INS_CLASSCATS_UV

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

View Text

SELECT A.ID ID
, DECODE(SIGN(A.DATE_TO-TRUNC(SYSDATE))
, NULL
, 'Y'
, 1
, 'Y'
, 0
, 'Y'
, 'N') ACTIVE_FLAG
, A.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, A.IAC_CODE IAC_CODE
, C.MEANING INSURANCE_CLASS
, A.IAY_ID IAY_ID
, B.NAME ASSET_CATEGORY
, A.DATE_FROM DATE_FROM
, A.DATE_TO DATE_TO
FROM OKL_INS_CLASS_CATS A
, OKX_ASST_CATGRS_V B
, FND_LOOKUPS C
WHERE A.IAY_ID = B.ID1
AND A.IAC_CODE = C.LOOKUP_CODE
AND C.LOOKUP_TYPE = 'OKL_INSURANCE_ASSET_CLASS'

Columns