View: PA_RESOURCE_LIST_GROUPS_V

Product:	PA - Projects
Description:	All the resource groups that have been defined in a resource list
Implementation/DBA Data:	APPS.PA_RESOURCE_LIST_GROUPS_V

View Text

SELECT RL.NAME
, RL.RESOURCE_LIST_ID
, RLM.ALIAS
, RLM.RESOURCE_LIST_MEMBER_ID
, RLM.SORT_ORDER
, RLM.ENABLED_FLAG
FROM PA_RESOURCE_LISTS RL
, PA_RESOURCE_LIST_MEMBERS RLM
WHERE RL.GROUP_RESOURCE_TYPE_ID <> 0
AND RL.RESOURCE_LIST_ID = RLM.RESOURCE_LIST_ID
AND NVL(RLM.MIGRATION_CODE
, '-99') <> 'N'
AND RLM.PARENT_MEMBER_ID IS NULL
AND RLM.DISPLAY_FLAG = 'Y'

Columns