View: PA_ADW_LOWEST_TASKS_B_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_ADW_LOWEST_TASKS_B_V

View Text

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 )

Columns