View: OKL_VP_TERMINATION_REASON_UV

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

View Text

SELECT FLV.LOOKUP_CODE TRN_CODE
, FLV.MEANING TERMINATION_REASON
FROM FND_LOOKUP_TYPES FLT
, FND_LOOKUP_VALUES FLV
WHERE FLV.LOOKUP_TYPE = FLT.LOOKUP_TYPE
AND FLV.SECURITY_GROUP_ID = FLT.SECURITY_GROUP_ID
AND FLV.VIEW_APPLICATION_ID = FLT.VIEW_APPLICATION_ID
AND FLV.LANGUAGE = USERENV('LANG')
AND FLV.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(FLV.LOOKUP_TYPE
, FLV.VIEW_APPLICATION_ID)
AND ENABLED_FLAG = 'Y'
AND NVL(START_DATE_ACTIVE
, SYSDATE) <= SYSDATE
AND NVL(END_DATE_ACTIVE
, SYSDATE) >= SYSDATE
AND FLT.LOOKUP_TYPE = 'OKC_TERMINATION_REASON'
AND FLV.LOOKUP_CODE IN ('DEF'
, 'MUA'
, 'OOB'
, 'EOT'
, 'CTY'
, 'OBS'
, 'REF')

Columns