VIEW: APPS.PA_ADW_LOWEST_TASKS_B_V

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )