[Home] [Help]
View: PA_ADW_LOWEST_TASKS_B_V
View Text
SELECT LT.TASK_ID
, LT.TOP_TASK_ID
, LT.TASK_NUMBER
, LT.TASK_NAME
, LT.DESCRIPTION
, LT.CARRYING_OUT_ORGANIZATION_ID
, LT.SERVICE_TYPE_CODE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, LT.ADW_NOTIFY_FLAG
FROM PA_TASKS LT
, PA_ADW_TOP_TASKS_B_V TT
WHERE LT.TOP_TASK_ID = TT.TOP_TASK_ID
AND NOT EXISTS ( SELECT 'YES'
FROM PA_TASKS PTC
WHERE PTC.PARENT_TASK_ID = LT.TASK_ID )
Columns
Name |
TASK_ID |
TOP_TASK_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 |