View: PA_BACK_PROJ_TASK_PROG_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_BACK_PROJ_TASK_PROG_V

View Text

SELECT PPA.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PPA.LONG_NAME
, DECODE( PPE.OBJECT_TYPE
, 'PA_STRUCTURES'
, PPVS.NAME
, NULL)
, DECODE( PPE.OBJECT_TYPE
, 'PA_STRUCTURES'
, TO_CHAR(PPVS.VERSION_NUMBER )
, NULL )
, PPE.PROJ_ELEMENT_ID
, PPEV2.PROJ_ELEMENT_ID
, PPE.PROJ_ELEMENT_ID
, POR.OBJECT_ID_FROM1
, PPEV.ELEMENT_VERSION_ID
, PPE.OBJECT_TYPE
, PST.STRUCTURE_TYPE
, DECODE( PPE.OBJECT_TYPE
, 'PA_TASKS'
, PPE.NAME
, NULL)
, DECODE( PPE.OBJECT_TYPE
, 'PA_TASKS'
, PPE.ELEMENT_NUMBER
, NULL )
, PPEV.WBS_NUMBER
, PPEV.WBS_LEVEL
, PPEV.DISPLAY_SEQUENCE
, PPE.MANAGER_PERSON_ID
, ''
, PPVSCH.MILESTONE_FLAG
, PPVSCH.CRITICAL_FLAG
, DECODE( PPE.OBJECT_TYPE
, 'PA_STRUCTURES'
, 'Y'
, 'PA_TASKS'
, PA_PROJ_ELEMENTS_UTILS.IS_SUMMARY_TASK_OR_STRUCTURE(PPEV.ELEMENT_VERSION_ID))
, PTT.INITIAL_STATUS_CODE
, PPS.PROJECT_STATUS_NAME
, PPS.PROJECT_SYSTEM_STATUS_CODE
, PPVSCH.PLANNED_EFFORT
, PPVSCH.WQ_PLANNED_QUANTITY
, PPE.WQ_ITEM_CODE
, ''
, PPE.WQ_UOM_CODE
, ''
, TO_DATE(NULL) AS_OF_DATE
, TO_NUMBER(NULL) PERCENT_COMPLETE_ID
, TO_NUMBER(NULL) COMPLETED_PERCENTAGE
, NULL PROJECT_STATUS_CODE
, NULL PROJECT_STATUS_NAME
, NULL PROJECT_SYSTEM_STATUS_CODE
, NULL STATUS_ICON_IND
, NULL STATUS_ICON_ACTIVE_IND
, PPVSCH.SCHEDULED_START_DATE
, PPVSCH.SCHEDULED_FINISH_DATE
, TO_DATE(NULL) ACTUAL_START_DATE
, TO_DATE(NULL) ACTUAL_FINISH_DATE
, TO_DATE(NULL) ESTIMATED_START_DATE
, TO_DATE(NULL) ESTIMATED_FINISH_DATE
, TO_NUMBER(NULL) INCREMENTAL_WORK_QUANTITY
, TO_NUMBER(NULL) CUMULATIVE_WORK_QUANTITY
, TO_NUMBER(NULL) BASE_PERCENT_COMPLETE
, TO_NUMBER(NULL) EFF_ROLLUP_PERCENT_COMP
, TO_NUMBER(NULL) ESTIMATED_REMAINING_EFFORT
, TO_NUMBER(NULL) PUBLISHED_BY_PARTY_ID
, NULL PARTY_NAME
, NULL PROGRESS_COMMENT
, NULL DESCRIPTION
, TO_DATE(NULL) LAST_UPDATE_DATE
, NULL PUBLISHED_FLAG
, NULL CURRENT_FLAG
, TO_NUMBER(NULL) RECORD_VERSION_NUMBER
, NULL BASE_PROGRESS_STATUS_CODE
, NULL BASE_PROGRESS_STATUS_NAME
, DECODE(PPE.OBJECT_TYPE
, 'PA_STRUCTURES'
, PPPA.WQ_ENABLE_FLAG
, DECODE(PTT.WQ_ENABLE_FLAG
, 'Y'
, DECODE(PPPA.WQ_ENABLE_FLAG
, 'Y'
, 'Y'
, 'N')
, 'N'))
, DECODE(PPE.OBJECT_TYPE
, 'PA_STRUCTURES'
, PPPA.REMAIN_EFFORT_ENABLE_FLAG
, DECODE(PTT.REMAIN_EFFORT_ENABLE_FLAG
, 'Y'
, DECODE(PPPA.REMAIN_EFFORT_ENABLE_FLAG
, 'Y'
, 'Y'
, 'N')
, 'N'))
, PPE.LAST_UPDATE_DATE
, PPVSCH.LAST_UPDATE_DATE
, DECODE(PPE.OBJECT_TYPE
, 'PA_STRUCTURES'
, PPPA.PERCENT_COMP_ENABLE_FLAG
, DECODE(PTT.PERCENT_COMP_ENABLE_FLAG
, 'Y'
, DECODE(PPPA.PERCENT_COMP_ENABLE_FLAG
, 'Y'
, 'Y'
, 'N')
, 'N'))
, NULL EFF_ROLLUP_PROG_STAT_CODE
, NULL EFF_ROLLUP_PROG_STAT_NAME
, NULL EFF_ROLLUP_STATUS_ICON_IND
, PPE.PROGRESS_OUTDATED_FLAG
, PTT.BASE_PERCENT_COMP_DERIV_CODE
, PPE.BASELINE_START_DATE
, PPE.BASELINE_FINISH_DATE
, DECODE(PPE.OBJECT_TYPE
, 'PA_TASKS'
, PTT.PROG_ENTRY_ENABLE_FLAG
, 'Y')
, PTT.PROG_ENTRY_REQ_FLAG
FROM PA_PROJECTS_ALL PPA
, PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPEV
, PA_PROJ_ELEMENT_VERSIONS PPEV2
, PA_PROJ_ELEM_VER_STRUCTURE PPVS
, PA_PROJ_ELEM_VER_SCHEDULE PPVSCH
, PA_STRUCTURE_TYPES PST
, PA_PROJ_STRUCTURE_TYPES PPST
, PA_TASK_TYPES PTT
, PA_PROJ_PROGRESS_ATTR PPPA
, PA_PROJECT_STATUSES PPS
, PA_OBJECT_RELATIONSHIPS POR
WHERE PPA.PROJECT_ID = PPE.PROJECT_ID
AND PPE.LINK_TASK_FLAG <> 'Y'
AND PPE.PROJ_ELEMENT_ID = PPEV.PROJ_ELEMENT_ID
AND PPEV.PARENT_STRUCTURE_VERSION_ID = PPVS.ELEMENT_VERSION_ID
AND PPEV.PROJECT_ID = PPVS.PROJECT_ID
AND PPVS.LATEST_EFF_PUBLISHED_FLAG = 'Y'
AND PPA.PROJECT_ID = PPVSCH.PROJECT_ID
AND PPVSCH.ELEMENT_VERSION_ID = PPEV.ELEMENT_VERSION_ID
AND PPE.TYPE_ID = PTT.TASK_TYPE_ID(+)
AND PPVS.PROJECT_ID = PPPA.PROJECT_ID(+)
AND PPVS.PROJ_ELEMENT_ID = PPPA.OBJECT_ID(+)
AND PST.STRUCTURE_TYPE_ID = PPST.STRUCTURE_TYPE_ID
AND PPST.PROJ_ELEMENT_ID = PPVS.PROJ_ELEMENT_ID
AND PST.STRUCTURE_TYPE_CLASS_CODE = 'WORKPLAN'
AND NVL(PTT.INITIAL_STATUS_CODE
, 'X') = PPS.PROJECT_STATUS_CODE(+)
AND PPEV.ELEMENT_VERSION_ID = POR.OBJECT_ID_TO1(+)
AND POR.OBJECT_TYPE_TO(+) = 'PA_TASKS'
AND POR.OBJECT_ID_FROM1 = PPEV2.ELEMENT_VERSION_ID(+)
AND POR.RELATIONSHIP_TYPE (+) = 'S' UNION ALL SELECT PPA.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PPA.LONG_NAME
, DECODE( PPE.OBJECT_TYPE
, 'PA_STRUCTURES'
, PPVS.NAME
, NULL)
, DECODE( PPE.OBJECT_TYPE
, 'PA_STRUCTURES'
, TO_CHAR(PPVS.VERSION_NUMBER )
, NULL )
, PPE.PROJ_ELEMENT_ID
, PPEV2.PROJ_ELEMENT_ID
, PPE.PROJ_ELEMENT_ID
, POR.OBJECT_ID_FROM1
, PPEV.ELEMENT_VERSION_ID
, PPE.OBJECT_TYPE
, PST.STRUCTURE_TYPE
, DECODE( PPE.OBJECT_TYPE
, 'PA_TASKS'
, PPE.NAME
, NULL)
, DECODE( PPE.OBJECT_TYPE
, 'PA_TASKS'
, PPE.ELEMENT_NUMBER
, NULL )
, PPEV.WBS_NUMBER
, PPEV.WBS_LEVEL
, PPEV.DISPLAY_SEQUENCE
, PPE.MANAGER_PERSON_ID
, ''
, PPVSCH.MILESTONE_FLAG
, PPVSCH.CRITICAL_FLAG
, DECODE( PPE.OBJECT_TYPE
, 'PA_STRUCTURES'
, 'Y'
, 'PA_TASKS'
, PA_PROJ_ELEMENTS_UTILS.IS_SUMMARY_TASK_OR_STRUCTURE(PPEV.ELEMENT_VERSION_ID))
, PPE.STATUS_CODE
, PPS3.PROJECT_STATUS_NAME
, PPS3.PROJECT_SYSTEM_STATUS_CODE
, PPVSCH.PLANNED_EFFORT
, PPVSCH.WQ_PLANNED_QUANTITY
, PPE.WQ_ITEM_CODE
, PL1.MEANING
, PPE.WQ_UOM_CODE
, PL2.MEANING
, PPR.AS_OF_DATE
, PPC.PERCENT_COMPLETE_ID
, NVL(PPR.COMPLETED_PERCENTAGE
, PPR.EFF_ROLLUP_PERCENT_COMP)
, PPS.PROJECT_STATUS_CODE
, PPS.PROJECT_STATUS_NAME
, PPS.PROJECT_SYSTEM_STATUS_CODE
, PPS.STATUS_ICON_IND
, PPS.STATUS_ICON_ACTIVE_IND
, PPVSCH.SCHEDULED_START_DATE
, PPVSCH.SCHEDULED_FINISH_DATE
, PPR.ACTUAL_START_DATE
, PPR.ACTUAL_FINISH_DATE
, PPR.ESTIMATED_START_DATE
, PPR.ESTIMATED_FINISH_DATE
, PPR.INCREMENTAL_WORK_QUANTITY
, PPR.CUMULATIVE_WORK_QUANTITY
, PPR.BASE_PERCENT_COMPLETE
, PPR.EFF_ROLLUP_PERCENT_COMP
, PPR.ESTIMATED_REMAINING_EFFORT
, PPC.PUBLISHED_BY_PARTY_ID
, NULL
, PPC.PROGRESS_COMMENT
, PPC.DESCRIPTION
, PPC.LAST_UPDATE_DATE
, PPC.PUBLISHED_FLAG
, PPC.CURRENT_FLAG
, PPC.RECORD_VERSION_NUMBER
, PPR.BASE_PROGRESS_STATUS_CODE
, PPS1.PROJECT_STATUS_NAME
, DECODE(PPE.OBJECT_TYPE
, 'PA_STRUCTURES'
, PPPA.WQ_ENABLE_FLAG
, DECODE(PTT.WQ_ENABLE_FLAG
, 'Y'
, DECODE(PPPA.WQ_ENABLE_FLAG
, 'Y'
, 'Y'
, 'N')
, 'N'))
, DECODE(PPE.OBJECT_TYPE
, 'PA_STRUCTURES'
, PPPA.REMAIN_EFFORT_ENABLE_FLAG
, DECODE(PTT.REMAIN_EFFORT_ENABLE_FLAG
, 'Y'
, DECODE(PPPA.REMAIN_EFFORT_ENABLE_FLAG
, 'Y'
, 'Y'
, 'N')
, 'N'))
, PPE.LAST_UPDATE_DATE
, PPVSCH.LAST_UPDATE_DATE
, DECODE(PPE.OBJECT_TYPE
, 'PA_STRUCTURES'
, PPPA.PERCENT_COMP_ENABLE_FLAG
, DECODE(PTT.PERCENT_COMP_ENABLE_FLAG
, 'Y'
, DECODE(PPPA.PERCENT_COMP_ENABLE_FLAG
, 'Y'
, 'Y'
, 'N')
, 'N'))
, PPR.EFF_ROLLUP_PROG_STAT_CODE
, PPS2.PROJECT_STATUS_NAME
, PPS2.STATUS_ICON_IND
, PPE.PROGRESS_OUTDATED_FLAG
, PTT.BASE_PERCENT_COMP_DERIV_CODE
, PPE.BASELINE_START_DATE
, PPE.BASELINE_FINISH_DATE
, DECODE(PPE.OBJECT_TYPE
, 'PA_TASKS'
, PTT.PROG_ENTRY_ENABLE_FLAG
, 'Y')
, PTT.PROG_ENTRY_REQ_FLAG
FROM PA_PROJECTS_ALL PPA
, PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPEV
, PA_PROJ_ELEMENT_VERSIONS PPEV2
, PA_PROJ_ELEM_VER_STRUCTURE PPVS
, PA_PROJ_ELEM_VER_SCHEDULE PPVSCH
, PA_STRUCTURE_TYPES PST
, PA_PROJ_STRUCTURE_TYPES PPST
, PA_TASK_TYPES PTT
, PA_PROJ_PROGRESS_ATTR PPPA
, PA_OBJECT_RELATIONSHIPS POR
, PA_PERCENT_COMPLETES PPC
, PA_PROGRESS_ROLLUP PPR
, PA_PROJECT_STATUSES PPS
, PA_PROJECT_STATUSES PPS1
, PA_PROJECT_STATUSES PPS2
, PA_PROJECT_STATUSES PPS3
, PA_LOOKUPS PL1
, PA_LOOKUPS PL2
WHERE PPA.PROJECT_ID = PPE.PROJECT_ID
AND PPE.LINK_TASK_FLAG <> 'Y'
AND PPE.PROJ_ELEMENT_ID = PPEV.PROJ_ELEMENT_ID
AND PPEV.PARENT_STRUCTURE_VERSION_ID = PPVS.ELEMENT_VERSION_ID
AND PPEV.PROJECT_ID = PPVS.PROJECT_ID
AND PPVS.LATEST_EFF_PUBLISHED_FLAG = 'Y'
AND PPA.PROJECT_ID = PPVSCH.PROJECT_ID
AND PPVSCH.ELEMENT_VERSION_ID = PPEV.ELEMENT_VERSION_ID
AND PPE.TYPE_ID = PTT.TASK_TYPE_ID(+)
AND PPVS.PROJECT_ID = PPPA.PROJECT_ID(+)
AND PPVS.PROJ_ELEMENT_ID = PPPA.OBJECT_ID(+)
AND PST.STRUCTURE_TYPE_ID = PPST.STRUCTURE_TYPE_ID
AND PPST.PROJ_ELEMENT_ID = PPVS.PROJ_ELEMENT_ID
AND PST.STRUCTURE_TYPE_CLASS_CODE = 'WORKPLAN'
AND NVL(PPE.STATUS_CODE
, 'X') = PPS3.PROJECT_STATUS_CODE(+)
AND PPEV.ELEMENT_VERSION_ID = POR.OBJECT_ID_TO1(+)
AND POR.OBJECT_TYPE_TO(+) = 'PA_TASKS'
AND POR.OBJECT_ID_FROM1 = PPEV2.ELEMENT_VERSION_ID(+)
AND POR.RELATIONSHIP_TYPE (+) = 'S'
AND PPE.PROJECT_ID = PPR.PROJECT_ID
AND PPE.PROJ_ELEMENT_ID = PPR.OBJECT_ID
AND PPE.OBJECT_TYPE = PPR.OBJECT_TYPE
AND PPR.PROJECT_ID = PPC.PROJECT_ID
AND PPR.OBJECT_ID = PPC.OBJECT_ID
AND PPR.OBJECT_TYPE = PPC.OBJECT_TYPE
AND PPC.PUBLISHED_FLAG = 'Y'
AND PPR.PERCENT_COMPLETE_ID = PPC.PERCENT_COMPLETE_ID
AND PPS.PROJECT_STATUS_CODE (+)= PPC.PROGRESS_STATUS_CODE
AND PPS1.PROJECT_STATUS_CODE (+)= PPR.BASE_PROGRESS_STATUS_CODE
AND PPS2.PROJECT_STATUS_CODE (+)= PPR.EFF_ROLLUP_PROG_STAT_CODE
AND PL1.LOOKUP_TYPE(+) = 'PA_WQ_WORK_ITEMS'
AND PPE.WQ_ITEM_CODE = PL1.LOOKUP_CODE(+)
AND PL2.LOOKUP_TYPE(+) = 'UNIT'
AND PPE.WQ_UOM_CODE = PL2.LOOKUP_CODE(+)

Columns