[Home] [Help]
View: PA_TASKS_ALL_V
View Text
SELECT T.PROJECT_ID
, T.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, LPAD(' '
, (NVL(WBS_LEVEL
, 1)-1)*2
, ' ')||T.TASK_NUMBER
, LPAD(' '
, (NVL(WBS_LEVEL
, 1)-1)*2
, ' ')||T.TASK_NAME
, T.PARENT_TASK_ID
, T.TOP_TASK_ID
, PA_TASK_UTILS.SORT_ORDER_TREE_WALK(T.PARENT_TASK_ID
, T.TASK_NUMBER)
FROM PA_TASKS T
Columns
Name |
PROJECT_ID |
TASK_ID |
TASK_NUMBER |
TASK_NAME |
INDENTED_TASK_NUMBER |
INDENTED_TASK_NAME |
PARENT_TASK_ID |
TOP_TASK_ID |
WBS_SORT_ORDER |