Product: | PA - Projects |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PA_TASKS_PUBLISHING_V |
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