VIEW: APPS.HXT_ALL_TASKS_V

Source

View Text - Preformatted

SELECT t.task_id ,t.project_id ,t.task_name ,t.task_number ,t.start_date ,t.completion_date FROM pa_tasks t ,pa_projects_all p WHERE p.project_id = t.project_id AND nvl (p.cbs_enable_flag ,'N') = 'N' UNION SELECT at.alt_task_id ,t.project_id ,t.task_name || ' - ' || pre.cost_code task_name ,t.task_number || ' - ' || pre.cost_code task_number ,t.start_date ,t.completion_date FROM pa_tasks t ,pa_alternate_tasks at ,pa_rbs_elements pre ,pa_projects_all p WHERE at.proj_element_id = t.task_id AND pre.rbs_element_id = at.cbs_element_id AND p.project_id = t.project_id AND nvl (p.cbs_enable_flag ,'N') = 'Y'

View Text - HTML Formatted

SELECT T.TASK_ID
, T.PROJECT_ID
, T.TASK_NAME
, T.TASK_NUMBER
, T.START_DATE
, T.COMPLETION_DATE
FROM PA_TASKS T
, PA_PROJECTS_ALL P
WHERE P.PROJECT_ID = T.PROJECT_ID
AND NVL (P.CBS_ENABLE_FLAG
, 'N') = 'N' UNION SELECT AT.ALT_TASK_ID
, T.PROJECT_ID
, T.TASK_NAME || ' - ' || PRE.COST_CODE TASK_NAME
, T.TASK_NUMBER || ' - ' || PRE.COST_CODE TASK_NUMBER
, T.START_DATE
, T.COMPLETION_DATE
FROM PA_TASKS T
, PA_ALTERNATE_TASKS AT
, PA_RBS_ELEMENTS PRE
, PA_PROJECTS_ALL P
WHERE AT.PROJ_ELEMENT_ID = T.TASK_ID
AND PRE.RBS_ELEMENT_ID = AT.CBS_ELEMENT_ID
AND P.PROJECT_ID = T.PROJECT_ID
AND NVL (P.CBS_ENABLE_FLAG
, 'N') = 'Y'