VIEW: APPS.PA_ADW_INTERFACED_TASKS

Source

View Text - Preformatted

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' )

View Text - HTML Formatted

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' )