VIEW: APPS.PA_RESOURCE_GROUPS_VALID_V

Source

View Text - Preformatted

SELECT RESOURCE_TYPE_CODE , NAME , RESOURCE_TYPE_ID , 'Y' , START_DATE_ACTIVE , END_DATE_ACTIVE FROM PA_RESOURCE_TYPES WHERE GROUP_FLAG = 'Y' UNION ALL SELECT LOOKUP_CODE, MEANING, 0, 'N', START_DATE_ACTIVE, END_DATE_ACTIVE FROM fnd_lookup_values WHERE LOOKUP_TYPE ='RESOURCE_GROUP_NONE' AND lookup_code = 'NONE' AND view_application_id = 275 AND language = userenv('LANG')

View Text - HTML Formatted

SELECT RESOURCE_TYPE_CODE
, NAME
, RESOURCE_TYPE_ID
, 'Y'
, START_DATE_ACTIVE
, END_DATE_ACTIVE
FROM PA_RESOURCE_TYPES
WHERE GROUP_FLAG = 'Y' UNION ALL SELECT LOOKUP_CODE
, MEANING
, 0
, 'N'
, START_DATE_ACTIVE
, END_DATE_ACTIVE
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE ='RESOURCE_GROUP_NONE'
AND LOOKUP_CODE = 'NONE'
AND VIEW_APPLICATION_ID = 275
AND LANGUAGE = USERENV('LANG')