VIEW: APPS.OKL_VP_TERMINATION_REASON_UV

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')