VIEW: APPS.HXC_BASE_PA_ONLINE_TASKS_V

Source

View Text - Preformatted

SELECT t.task_number ,t.task_name ,t.task_id ,t.billable_flag ,t.project_id ,t.start_date ,t.completion_date ,t.chargeable_flag ,t.task_number || '-' || t.task_name task_details 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 t.task_number || ' - ' || pre.cost_code task_number ,t.task_name || ' - ' || pre.cost_code task_name ,at.alt_task_id ,t.billable_flag ,t.project_id ,t.start_date ,t.completion_date ,t.chargeable_flag ,t.task_number || ' - ' || pre.cost_code || '-' || t.task_name || '-' || pre.cost_code task_details 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_NUMBER
, T.TASK_NAME
, T.TASK_ID
, T.BILLABLE_FLAG
, T.PROJECT_ID
, T.START_DATE
, T.COMPLETION_DATE
, T.CHARGEABLE_FLAG
, T.TASK_NUMBER || '-' || T.TASK_NAME TASK_DETAILS
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 T.TASK_NUMBER || ' - ' || PRE.COST_CODE TASK_NUMBER
, T.TASK_NAME || ' - ' || PRE.COST_CODE TASK_NAME
, AT.ALT_TASK_ID
, T.BILLABLE_FLAG
, T.PROJECT_ID
, T.START_DATE
, T.COMPLETION_DATE
, T.CHARGEABLE_FLAG
, T.TASK_NUMBER || ' - ' || PRE.COST_CODE || '-' || T.TASK_NAME || '-' || PRE.COST_CODE TASK_DETAILS
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'