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