[Home] [Help]
View: PA_ALLOC_SRC_TASKS_V
View Text
SELECT PROJECT_ID
, TASK_ID
, TASK_NUMBER
, TASK_NAME
, SERVICE_TYPE_CODE
, CARRYING_OUT_ORGANIZATION_ID
FROM PA_TASKS
WHERE (TASK_ID = TOP_TASK_ID OR PA_TASK_UTILS.CHECK_CHILD_EXISTS(TASK_ID) =0)
Columns
Name |
PROJECT_ID |
TASK_ID |
TASK_NUMBER |
TASK_NAME |
SERVICE_TYPE_CODE |
CARRYING_OUT_ORGANIZATION_ID |