View: PA_RESOURCE_GROUPS_VALID_V

Product:	PA - Projects
Description:	This view displays all the valid resource types which you can group a Resource List by
Implementation/DBA Data:	APPS.PA_RESOURCE_GROUPS_VALID_V

View Text

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')

Columns