[Home] [Help]
View: PA_ADW_TOP_TASKS_B_V
View Text
SELECT PTT.TOP_TASK_ID
, PTT.PROJECT_ID
, PTT.TASK_NUMBER
, PTT.TASK_NAME
, PTT.DESCRIPTION
, PTT.CARRYING_OUT_ORGANIZATION_ID
, PTT.SERVICE_TYPE_CODE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, PTT.ADW_NOTIFY_FLAG
FROM PA_TASKS PTT
, PA_ADW_PROJECTS_B_V PP
WHERE PTT.PROJECT_ID = PP.PROJECT_ID
AND PTT.TOP_TASK_ID = PTT.TASK_ID
Columns
Name |
TOP_TASK_ID |
PROJECT_ID |
TASK_NUMBER |
TASK_NAME |
DESCRIPTION |
CARRYING_OUT_ORGANIZATION_ID |
SERVICE_TYPE_CODE |
USER_COL1 |
USER_COL2 |
USER_COL3 |
USER_COL4 |
USER_COL5 |
USER_COL6 |
USER_COL7 |
USER_COL8 |
USER_COL9 |
USER_COL10 |
ADW_NOTIFY_FLAG |