[Home] [Help]
View: AMW_TEMPLATE_TASKS_V
View Text
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'
Columns
Name |
AUDIT_PROJECT_ID |
PROJECT_ID |
TASK_ID |
TASK_NUMBER |
TASK_NAME |
DESCRIPTION |
TOP_TASK_ID |
LEVEL_ID |
PARENT_TASK_ID |
TASK_MANAGER_PERSON_ID |
START_DATE |
COMPLETION_DATE |
SOURCE_CODE |