VIEW: APPS.PA_DELIVERABLES_V

Source

View Text - Preformatted

SELECT PPE.ELEMENT_NUMBER ,PPE.NAME ,PPE.PM_SOURCE_REFERENCE ,PPE.DESCRIPTION ,PPE.OBJECT_TYPE ,PPE.PROJ_ELEMENT_ID ,PPE.PROJECT_ID ,PPE.STATUS_CODE ,PPS.PROJECT_SYSTEM_STATUS_CODE ,PPF.PERSON_ID ,PPE.TYPE_ID ,PPE.PROGRESS_WEIGHT ,PPE.RECORD_VERSION_NUMBER ,PPV.ELEMENT_VERSION_ID ,PPV.RECORD_VERSION_NUMBER ,PSC.SCHEDULED_FINISH_DATE ,PSC.ACTUAL_FINISH_DATE ,PPF.FULL_NAME ,PPS.PROJECT_STATUS_NAME ,PPR.PROGRESS_STATUS_CODE ,STA.PROJECT_STATUS_NAME ,PPC.PROGRESS_COMMENT ,PPC.DESCRIPTION ,PPR.COMPLETED_PERCENTAGE ,PPC.PERCENT_COMPLETE_ID ,PPR.AS_OF_DATE ,PTT.TASK_TYPE ,PPA.NAME ,PPA.SEGMENT1 ,PPA.TEMPLATE_FLAG ,PPE.ATTRIBUTE_CATEGORY ,PPE.ATTRIBUTE1 ,PPE.ATTRIBUTE2 ,PPE.ATTRIBUTE3 ,PPE.ATTRIBUTE4 ,PPE.ATTRIBUTE5 ,PPE.ATTRIBUTE6 ,PPE.ATTRIBUTE7 ,PPE.ATTRIBUTE8 ,PPE.ATTRIBUTE9 ,PPE.ATTRIBUTE10 ,PPE.ATTRIBUTE11 ,PPE.ATTRIBUTE12 ,PPE.ATTRIBUTE13 ,PPE.ATTRIBUTE14 ,PPE.ATTRIBUTE15 FROM PA_PROJ_ELEMENTS PPE ,PA_PROJ_ELEMENT_VERSIONS PPV ,PA_PROJ_ELEM_VER_SCHEDULE PSC ,PA_PROJECT_STATUSES PPS ,PA_TASK_TYPES PTT ,PA_PERCENT_COMPLETES PPC ,PA_PROGRESS_ROLLUP PPR ,PER_ALL_PEOPLE_F PPF ,PA_PROJECT_STATUSES STA ,PA_PROJECTS_ALL PPA WHERE PPE.OBJECT_TYPE = 'PA_DELIVERABLES' AND PPE.PROJ_ELEMENT_ID = PPV.PROJ_ELEMENT_ID AND PPE.PROJECT_ID=PPV.PROJECT_ID AND PPE.PROJECT_ID = PSC.PROJECT_ID AND PPE.PROJECT_ID = PPA.PROJECT_ID AND PPV.ELEMENT_VERSION_ID = PSC.ELEMENT_VERSION_ID AND PTT.TASK_TYPE_ID = PPE.TYPE_ID AND PPE.STATUS_CODE = PPS.PROJECT_STATUS_CODE(+) AND PPE.MANAGER_PERSON_ID = PPF.PERSON_ID(+) AND SYSDATE BETWEEN PPF.EFFECTIVE_START_DATE(+) AND PPF.EFFECTIVE_END_DATE(+) AND PPE.PROJECT_ID = PPR.PROJECT_ID(+) AND PPE.PROJ_ELEMENT_ID = PPR.OBJECT_ID(+) AND PPR.OBJECT_ID = PPC.OBJECT_ID (+) AND PPR.PROGRESS_STATUS_CODE = STA.PROJECT_STATUS_CODE(+) AND PPR.PROJECT_ID = PPC.PROJECT_ID(+) AND PPC.DATE_COMPUTED(+) = PPR.AS_OF_DATE AND PPR.structure_type = PPC.structure_type (+) AND PPR.structure_type(+) = 'WORKPLAN' AND PPR.current_flag(+) = 'Y' AND PPC.current_flag(+) = 'Y' AND PPC.PUBLISHED_FLAG(+) = 'Y'

View Text - HTML Formatted

SELECT PPE.ELEMENT_NUMBER
, PPE.NAME
, PPE.PM_SOURCE_REFERENCE
, PPE.DESCRIPTION
, PPE.OBJECT_TYPE
, PPE.PROJ_ELEMENT_ID
, PPE.PROJECT_ID
, PPE.STATUS_CODE
, PPS.PROJECT_SYSTEM_STATUS_CODE
, PPF.PERSON_ID
, PPE.TYPE_ID
, PPE.PROGRESS_WEIGHT
, PPE.RECORD_VERSION_NUMBER
, PPV.ELEMENT_VERSION_ID
, PPV.RECORD_VERSION_NUMBER
, PSC.SCHEDULED_FINISH_DATE
, PSC.ACTUAL_FINISH_DATE
, PPF.FULL_NAME
, PPS.PROJECT_STATUS_NAME
, PPR.PROGRESS_STATUS_CODE
, STA.PROJECT_STATUS_NAME
, PPC.PROGRESS_COMMENT
, PPC.DESCRIPTION
, PPR.COMPLETED_PERCENTAGE
, PPC.PERCENT_COMPLETE_ID
, PPR.AS_OF_DATE
, PTT.TASK_TYPE
, PPA.NAME
, PPA.SEGMENT1
, PPA.TEMPLATE_FLAG
, PPE.ATTRIBUTE_CATEGORY
, PPE.ATTRIBUTE1
, PPE.ATTRIBUTE2
, PPE.ATTRIBUTE3
, PPE.ATTRIBUTE4
, PPE.ATTRIBUTE5
, PPE.ATTRIBUTE6
, PPE.ATTRIBUTE7
, PPE.ATTRIBUTE8
, PPE.ATTRIBUTE9
, PPE.ATTRIBUTE10
, PPE.ATTRIBUTE11
, PPE.ATTRIBUTE12
, PPE.ATTRIBUTE13
, PPE.ATTRIBUTE14
, PPE.ATTRIBUTE15
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPV
, PA_PROJ_ELEM_VER_SCHEDULE PSC
, PA_PROJECT_STATUSES PPS
, PA_TASK_TYPES PTT
, PA_PERCENT_COMPLETES PPC
, PA_PROGRESS_ROLLUP PPR
, PER_ALL_PEOPLE_F PPF
, PA_PROJECT_STATUSES STA
, PA_PROJECTS_ALL PPA
WHERE PPE.OBJECT_TYPE = 'PA_DELIVERABLES'
AND PPE.PROJ_ELEMENT_ID = PPV.PROJ_ELEMENT_ID
AND PPE.PROJECT_ID=PPV.PROJECT_ID
AND PPE.PROJECT_ID = PSC.PROJECT_ID
AND PPE.PROJECT_ID = PPA.PROJECT_ID
AND PPV.ELEMENT_VERSION_ID = PSC.ELEMENT_VERSION_ID
AND PTT.TASK_TYPE_ID = PPE.TYPE_ID
AND PPE.STATUS_CODE = PPS.PROJECT_STATUS_CODE(+)
AND PPE.MANAGER_PERSON_ID = PPF.PERSON_ID(+)
AND SYSDATE BETWEEN PPF.EFFECTIVE_START_DATE(+)
AND PPF.EFFECTIVE_END_DATE(+)
AND PPE.PROJECT_ID = PPR.PROJECT_ID(+)
AND PPE.PROJ_ELEMENT_ID = PPR.OBJECT_ID(+)
AND PPR.OBJECT_ID = PPC.OBJECT_ID (+)
AND PPR.PROGRESS_STATUS_CODE = STA.PROJECT_STATUS_CODE(+)
AND PPR.PROJECT_ID = PPC.PROJECT_ID(+)
AND PPC.DATE_COMPUTED(+) = PPR.AS_OF_DATE
AND PPR.STRUCTURE_TYPE = PPC.STRUCTURE_TYPE (+)
AND PPR.STRUCTURE_TYPE(+) = 'WORKPLAN'
AND PPR.CURRENT_FLAG(+) = 'Y'
AND PPC.CURRENT_FLAG(+) = 'Y'
AND PPC.PUBLISHED_FLAG(+) = 'Y'