[Home] [Help]
View: PA_WP_RESOURCE_LIST_V
Product: | PA - Projects |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT RLAS.PROJECT_ID
, RL.RESOURCE_LIST_ID
, RL.NAME
, RL.START_DATE_ACTIVE
, RL.END_DATE_ACTIVE
, DECODE(RLAS.USED_IN_WP_FLAG
, NULL
, RL.USE_FOR_WP_FLAG
, RLAS.USED_IN_WP_FLAG) WP_USED_FLAG
, RL.BUSINESS_GROUP_ID
FROM PA_RESOURCE_LISTS_ALL_BG RL
, PA_RESOURCE_LIST_ASSIGNMENTS RLAS
WHERE RL.RESOURCE_LIST_ID = RLAS.RESOURCE_LIST_ID
Columns
Name |
PROJECT_ID |
WP_RESOURCE_LIST_ID |
WP_RESOURCE_LIST_NAME |
WP_RESLIST_START_DATE |
WP_RESLIST_END_DATE |
WP_USED_FLAG |
BUSINESS_GROUP_ID |