[Home] [Help]
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
Name |
ALIAS |
ALIAS2 |
RESOURCE_LIST_ID |
RESOURCE_LIST_MEMBER_ID |
RESOURCE_ID |
TRACK_AS_LABOR_FLAG |
PARENT_MEMBER_ID |
RESOURCE_NAME |
MIGRATION_CODE |