VIEW: APPS.AMW_TEMPLATE_TASKS_V

Source

View Text - Preformatted

SELECT null, task.project_id, task.task_id, task.task_number, task.task_name, task.description, task.top_task_id, task.wbs_level, task.parent_task_id, task.task_manager_person_id, task.start_date, task.completion_date, 'PA' from pa_tasks task, pa_projects_all proj, pa_project_types_all pa_typ where task.project_id = proj.project_id and proj.template_flag = 'Y' and proj.project_type = pa_typ.project_type and pa_typ.project_type_id in (select distinct amw_typ.project_type_id from amw_work_types_b amw_typ, amw_work_categories_b amw_cat where amw_typ.category_id = amw_cat.category_id and amw_cat.category_code = 'ENGAGEMENT' and amw_typ.project_type_id is not null) UNION select tb.audit_project_id, ap.project_id, tb.task_id, tb.task_number, tl.task_name, tl.description, tb.top_task_id, tb.level_id, tb.parent_task_id, tb.task_manager_person_id, tb.start_date, tb.completion_date, 'ICM' from amw_audit_projects ap, amw_audit_tasks_b tb, amw_audit_tasks_tl tl where tb.audit_project_id = ap.audit_project_id and tl.task_id = tb.task_id and tl.language = userenv('LANG') and ap.project_id is null and ap.template_flag = 'Y'

View Text - HTML Formatted

SELECT NULL
, TASK.PROJECT_ID
, TASK.TASK_ID
, TASK.TASK_NUMBER
, TASK.TASK_NAME
, TASK.DESCRIPTION
, TASK.TOP_TASK_ID
, TASK.WBS_LEVEL
, TASK.PARENT_TASK_ID
, TASK.TASK_MANAGER_PERSON_ID
, TASK.START_DATE
, TASK.COMPLETION_DATE
, 'PA'
FROM PA_TASKS TASK
, PA_PROJECTS_ALL PROJ
, PA_PROJECT_TYPES_ALL PA_TYP
WHERE TASK.PROJECT_ID = PROJ.PROJECT_ID
AND PROJ.TEMPLATE_FLAG = 'Y'
AND PROJ.PROJECT_TYPE = PA_TYP.PROJECT_TYPE
AND PA_TYP.PROJECT_TYPE_ID IN (SELECT DISTINCT AMW_TYP.PROJECT_TYPE_ID
FROM AMW_WORK_TYPES_B AMW_TYP
, AMW_WORK_CATEGORIES_B AMW_CAT
WHERE AMW_TYP.CATEGORY_ID = AMW_CAT.CATEGORY_ID
AND AMW_CAT.CATEGORY_CODE = 'ENGAGEMENT'
AND AMW_TYP.PROJECT_TYPE_ID IS NOT NULL) UNION SELECT TB.AUDIT_PROJECT_ID
, AP.PROJECT_ID
, TB.TASK_ID
, TB.TASK_NUMBER
, TL.TASK_NAME
, TL.DESCRIPTION
, TB.TOP_TASK_ID
, TB.LEVEL_ID
, TB.PARENT_TASK_ID
, TB.TASK_MANAGER_PERSON_ID
, TB.START_DATE
, TB.COMPLETION_DATE
, 'ICM'
FROM AMW_AUDIT_PROJECTS AP
, AMW_AUDIT_TASKS_B TB
, AMW_AUDIT_TASKS_TL TL
WHERE TB.AUDIT_PROJECT_ID = AP.AUDIT_PROJECT_ID
AND TL.TASK_ID = TB.TASK_ID
AND TL.LANGUAGE = USERENV('LANG')
AND AP.PROJECT_ID IS NULL
AND AP.TEMPLATE_FLAG = 'Y'