[Home] [Help]
View: PA_TASKS_LOV_V
View Text
SELECT P.ORG_ID
, T.TASK_NUMBER
, LPAD (' '
, (NVL(WBS_LEVEL
, 1)-1)*3
, ' ')||T.TASK_NAME TASK_NAME
, T.TASK_ID
, T.PROJECT_ID
FROM PA_TASKS T
, PA_PROJECTS P
WHERE P.PROJECT_ID = T.PROJECT_ID
Columns
Name |
ORG_ID |
TASK_NUMBER |
TASK_NAME |
TASK_ID |
PROJECT_ID |