[Home] [Help]
View: PA_ADW_CURRENT_TASKS
View Text
SELECT TASK_HISTORY_ID
, TASK_ID
, SERVICE_TYPE_CODE
, CARRYING_OUT_ORGANIZATION_ID
, TOP_TASK_ID
, PROJECT_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ADW_INTERFACE_FLAG
, ADW_NOTIFY_FLAG
FROM PA_TASK_HISTORY PTH
WHERE PTH.ADW_NOTIFY_FLAG = 'Y'
Columns
Name |
TASK_HISTORY_ID |
TASK_ID |
SERVICE_TYPE_CODE |
CARRYING_OUT_ORGANIZATION_ID |
TOP_TASK_ID |
PROJECT_ID |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
REQUEST_ID |
PROGRAM_APPLICATION_ID |
PROGRAM_ID |
PROGRAM_UPDATE_DATE |
ADW_INTERFACE_FLAG |
ADW_NOTIFY_FLAG |