View: PA_BUDGET_RES_ALL_V

Product:	PA - Projects
Description:	PA_BUDGET_RES_ALL_V returns all enabled resource list members, including unclassified resource list members, for a given resource list.
Implementation/DBA Data:	APPS.PA_BUDGET_RES_ALL_V

View Text

SELECT LPAD(' '
, 2*(LEVEL-1))||ALIAS ALIAS
, ALIAS ALIAS2
, RESOURCE_LIST_ID
, RESOURCE_LIST_MEMBER_ID
, RESOURCE_ID
, TRACK_AS_LABOR_FLAG
, NVL(PARENT_MEMBER_ID
, 0)
, SUBSTR(PA_RESOURCES_PKG.GET_RESOURCE_NAME(RESOURCE_ID
, RESOURCE_TYPE_ID)
, 1
, 30) RESOURCE_NAME
, MIGRATION_CODE
FROM PA_RESOURCE_LIST_MEMBERS
WHERE ENABLED_FLAG = 'Y'
AND DECODE(RESOURCE_TYPE_CODE
, 'UNCLASSIFIED'
, 'Y'
, DISPLAY_FLAG) = 'Y'
AND NVL(MIGRATION_CODE
, '-99') <> 'N' START WITH PARENT_MEMBER_ID IS NULL CONNECT BY PRIOR RESOURCE_LIST_MEMBER_ID = PARENT_MEMBER_ID

Columns