VIEW: APPS.OKL_INS_CLASSCATS_UV

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'