VIEW: APPS.PA_TASKS_PUBLISHING_V

Source

View Text - Preformatted

SELECT ppe.element_number ,ppe.name ,ppv.element_version_id ,ppe.proj_element_id ,ppe.project_id ,ppv.parent_structure_version_id ,ppv.display_sequence ,ppvsch.milestone_flag ,TO_CHAR(null) ,ppvsch.critical_flag ,TO_CHAR(null) ,TO_CHAR(null) ,TO_CHAR(null) ,ppvsch.scheduled_start_date ,ppvsch.scheduled_finish_date ,PA_PROJ_ELEMENTS_UTILS.GET_PREV_SCH_START_DATE(ppv.element_version_id, ppv.parent_structure_version_id) ,PA_PROJ_ELEMENTS_UTILS.GET_PREV_SCH_FINISH_DATE(ppv.element_version_id, ppv.parent_structure_version_id) ,ppvsch.scheduled_start_date - PA_PROJ_ELEMENTS_UTILS.GET_PREV_SCH_START_DATE(ppv.element_version_id, ppv.parent_structure_version_id) ,ppvsch.scheduled_finish_date - PA_PROJ_ELEMENTS_UTILS.GET_PREV_SCH_FINISH_DATE(ppv.element_version_id, ppv.parent_structure_version_id) ,ppe.manager_person_id ,papf.FULL_NAME ,ppv.wbs_level ,ppv.wbs_number ,TO_CHAR(null) ,TO_NUMBER(null) ,TO_CHAR(null) ,ppe.priority_code ,TO_CHAR(null) ,ppe.carrying_out_organization_id ,TO_CHAR(null) ,TO_NUMBER(null) ,TO_CHAR(null) FROM pa_proj_elements ppe ,pa_proj_element_versions ppv ,pa_proj_elem_ver_schedule ppvsch ,per_all_people_f papf WHERE ppe.proj_element_id = ppv.proj_element_id AND ppe.project_id = ppv.project_id AND ppv.element_version_id = ppvsch.element_version_id (+) AND ppv.project_id = ppvsch.project_id (+) AND ppe.manager_person_id = papf.person_id(+) AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+) AND ppe.object_type = 'PA_TASKS' AND ppe.link_task_flag <> 'Y' AND ppe.project_id <> 0

View Text - HTML Formatted

SELECT PPE.ELEMENT_NUMBER
, PPE.NAME
, PPV.ELEMENT_VERSION_ID
, PPE.PROJ_ELEMENT_ID
, PPE.PROJECT_ID
, PPV.PARENT_STRUCTURE_VERSION_ID
, PPV.DISPLAY_SEQUENCE
, PPVSCH.MILESTONE_FLAG
, TO_CHAR(NULL)
, PPVSCH.CRITICAL_FLAG
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, PPVSCH.SCHEDULED_START_DATE
, PPVSCH.SCHEDULED_FINISH_DATE
, PA_PROJ_ELEMENTS_UTILS.GET_PREV_SCH_START_DATE(PPV.ELEMENT_VERSION_ID
, PPV.PARENT_STRUCTURE_VERSION_ID)
, PA_PROJ_ELEMENTS_UTILS.GET_PREV_SCH_FINISH_DATE(PPV.ELEMENT_VERSION_ID
, PPV.PARENT_STRUCTURE_VERSION_ID)
, PPVSCH.SCHEDULED_START_DATE - PA_PROJ_ELEMENTS_UTILS.GET_PREV_SCH_START_DATE(PPV.ELEMENT_VERSION_ID
, PPV.PARENT_STRUCTURE_VERSION_ID)
, PPVSCH.SCHEDULED_FINISH_DATE - PA_PROJ_ELEMENTS_UTILS.GET_PREV_SCH_FINISH_DATE(PPV.ELEMENT_VERSION_ID
, PPV.PARENT_STRUCTURE_VERSION_ID)
, PPE.MANAGER_PERSON_ID
, PAPF.FULL_NAME
, PPV.WBS_LEVEL
, PPV.WBS_NUMBER
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, PPE.PRIORITY_CODE
, TO_CHAR(NULL)
, PPE.CARRYING_OUT_ORGANIZATION_ID
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPV
, PA_PROJ_ELEM_VER_SCHEDULE PPVSCH
, PER_ALL_PEOPLE_F PAPF
WHERE PPE.PROJ_ELEMENT_ID = PPV.PROJ_ELEMENT_ID
AND PPE.PROJECT_ID = PPV.PROJECT_ID
AND PPV.ELEMENT_VERSION_ID = PPVSCH.ELEMENT_VERSION_ID (+)
AND PPV.PROJECT_ID = PPVSCH.PROJECT_ID (+)
AND PPE.MANAGER_PERSON_ID = PAPF.PERSON_ID(+)
AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE(+)
AND PAPF.EFFECTIVE_END_DATE (+)
AND PPE.OBJECT_TYPE = 'PA_TASKS'
AND PPE.LINK_TASK_FLAG <> 'Y'
AND PPE.PROJECT_ID <> 0