View: OKL_AGR_SOURCES_FND_UV

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

View Text

SELECT FLV.LOOKUP_TYPE
, FLV.LOOKUP_CODE
, FLV.MEANING
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 FLT.APPLICATION_ID = 540
AND FLV.VIEW_APPLICATION_ID = 0
AND ENABLED_FLAG = 'Y' AND NVL(START_DATE_ACTIVE
, SYSDATE) <= SYSDATE AND NVL(END_DATE_ACTIVE
, SYSDATE) >= SYSDATE

Columns