[Home] [Help]
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
Name |
RESOURCE_LIST_NAME |
RESOURCE_LIST_ID |
RESOURCE_GROUP_ALIAS |
RESOURCE_GROUP_MEMBER_ID |
SORT_ORDER |
ENABLED_FLAG |