VIEW: APPS.HR_LOOKUPS

Source

View Text - Preformatted

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.lookup_type,flv.security_group_id) in (SELECT lt.lookup_type,MAX (lt.security_group_id) from fnd_lookup_types lt where lt.view_application_id = 3 and lt.security_group_id in (0, to_number(decode(substrb(userenv('CLIENT_INFO'),55,1), ' ', '0', null, '0', substrb(userenv('CLIENT_INFO'),55,10)))) group by lt.lookup_type ) 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'

View Text - HTML Formatted

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.LOOKUP_TYPE
, FLV.SECURITY_GROUP_ID) IN (SELECT LT.LOOKUP_TYPE
, MAX (LT.SECURITY_GROUP_ID)
FROM FND_LOOKUP_TYPES LT
WHERE LT.VIEW_APPLICATION_ID = 3
AND LT.SECURITY_GROUP_ID IN (0
, TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 55
, 1)
, ' '
, '0'
, NULL
, '0'
, SUBSTRB(USERENV('CLIENT_INFO')
, 55
, 10)))) GROUP BY LT.LOOKUP_TYPE )
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'