SELECT lookup_code as ID , meaning as VALUE from fnd_lookup_values WHERE lookup_type = 'EAM_REQUEST_TYPE' and language = userenv('LANG') and VIEW_APPLICATION_ID = 700 and SECURITY_GROUP_ID = fnd_global.lookup_security_group( LOOKUP_TYPE, VIEW_APPLICATION_ID)
SELECT LOOKUP_CODE AS ID
, MEANING AS VALUE
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'EAM_REQUEST_TYPE'
AND LANGUAGE = USERENV('LANG')
AND VIEW_APPLICATION_ID = 700
AND SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP( LOOKUP_TYPE
, VIEW_APPLICATION_ID)
|
|
|