[Home] [Help]
View: PA_QRY_RESOURCE_LISTS_V
Product: | PA - Projects |
Description: | This view displays all the valid Resource Lists that have been defined |
Implementation/DBA Data: |
APPS.PA_QRY_RESOURCE_LISTS_V
|
View Text
SELECT RL.NAME
, RL.RESOURCE_LIST_ID
, RG.RESOURCE_GROUP
, RG.RESOURCE_GROUP_NAME
, RL.GROUP_RESOURCE_TYPE_ID
, RL.DESCRIPTION
, RL.START_DATE_ACTIVE
, RL.END_DATE_ACTIVE
, RL.CONTROL_FLAG
FROM PA_RESOURCE_LISTS RL
, PA_RESOURCE_GROUPS_VALID_V RG
WHERE NVL(RL.UNCATEGORIZED_FLAG
, 'N') <> 'Y'
AND RL.GROUP_RESOURCE_TYPE_ID = RG.GROUP_RESOURCE_TYPE_ID
Columns
Name |
RESOURCE_LIST_NAME |
RESOURCE_LIST_ID |
GROUPED_BY_RESOURCE_TYPE |
GROUPED_BY_RESOURCE_TYPE_NAME |
GROUPED_BY_RESOURCE_TYPE_ID |
DESCRIPTION |
START_DATE |
END_DATE |
RESOURCE_CONTROL_FLAG |