[Home] [Help]
View: PA_RESOURCE_LIST_MEMBERS_V
Product: | PA - Projects |
Description: | View of all resource members, including resource aliases and sort order columns. |
Implementation/DBA Data: |
APPS.PA_RESOURCE_LIST_MEMBERS_V
|
View Text
SELECT LPAD(' '
, 2*(RLM1.MEMBER_LEVEL-1))||RLM1.ALIAS ALIAS
, RLM1.RESOURCE_LIST_ID
, RLM1.RESOURCE_LIST_MEMBER_ID
, RLM1.RESOURCE_ID
, RLM1.TRACK_AS_LABOR_FLAG
, RLM1.PARENT_MEMBER_ID
, DECODE(RLM1.PARENT_MEMBER_ID
, NULL
, RLM1.SORT_ORDER
, RLM2.SORT_ORDER)
, DECODE(RLM1.PARENT_MEMBER_ID
, NULL
, 0
, RLM1.SORT_ORDER)
, RLM1.MIGRATION_CODE
FROM PA_RESOURCE_LIST_MEMBERS RLM1
, PA_RESOURCE_LIST_MEMBERS RLM2
WHERE NVL(RLM1.PARENT_MEMBER_ID
, RLM1.RESOURCE_LIST_MEMBER_ID) = RLM2.RESOURCE_LIST_MEMBER_ID
Columns
Name |
ALIAS |
RESOURCE_LIST_ID |
RESOURCE_LIST_MEMBER_ID |
RESOURCE_ID |
TRACK_AS_LABOR_FLAG |
PARENT_MEMBER_ID |
PARENT_SORT_ORDER |
SORT_ORDER |
MIGRATION_CODE |