View: PA_BUDGET_RESOURCES_V

Product:	PA - Projects
Description:	10Sc Only
Implementation/DBA Data:	APPS.PA_BUDGET_RESOURCES_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 DISPLAY_FLAG = 'Y'
AND ENABLED_FLAG = 'Y' START WITH PARENT_MEMBER_ID IS NULL CONNECT BY PRIOR RESOURCE_LIST_MEMBER_ID = PARENT_MEMBER_ID

Columns