Product: | PA - Projects |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PA_ADW_INTERFACED_TASKS |
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_INTERFACE_FLAG = 'Y'
AND TASK_HISTORY_ID = (SELECT MAX(TASK_HISTORY_ID)
FROM PA_TASK_HISTORY PTHA
WHERE PTH.TASK_ID = PTHA.TASK_ID
AND PTHA.ADW_INTERFACE_FLAG = 'Y' )