View: HR_LOOKUPS

Product:	PER - Human Resources
Description:	HRMS specific view based on FND_LOOKUP_TYPES and FND_LOOKUP_VALUES.
Implementation/DBA Data:	APPS.HR_LOOKUPS

View Text

SELECT DECODE(SUBSTR(FLV.LOOKUP_TYPE
, 1
, 3)
, 'HXT'
, 808
, 800)
, FLV.LOOKUP_TYPE
, FLV.LOOKUP_CODE
, FLV.MEANING
, FLV.LAST_UPDATE_DATE
, FLV.LAST_UPDATED_BY
, FLV.ENABLED_FLAG
, FLV.START_DATE_ACTIVE
, FLV.END_DATE_ACTIVE
, FLV.DESCRIPTION
, FLV.LAST_UPDATE_LOGIN
, FLV.CREATED_BY
, FLV.CREATION_DATE
FROM FND_LOOKUP_VALUES FLV
WHERE FLV.LANGUAGE = USERENV('LANG')
AND FLV.VIEW_APPLICATION_ID = 3
AND FLV.SECURITY_GROUP_ID = DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 55
, 1)
, ' '
, 0
, NULL
, 0
, '0'
, 0
, FND_GLOBAL.LOOKUP_SECURITY_GROUP(FLV.LOOKUP_TYPE
, FLV.VIEW_APPLICATION_ID))
AND DECODE(FLV.TAG
, NULL
, 'Y'
, DECODE(SUBSTR(FLV.TAG
, 1
, 1)
, '+'
, DECODE(SIGN(INSTR(FLV.TAG
, HR_API.GET_LEGISLATION_CONTEXT))
, 1
, 'Y'
, 'N')
, '-'
, DECODE(SIGN(INSTR(FLV.TAG
, HR_API.GET_LEGISLATION_CONTEXT))
, 1
, 'N'
, 'Y')
, 'Y' ) ) = 'Y'

Columns