VIEW: APPS.FII_PA_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' )