VIEW: APPS.PA_DLV_ASSCN_TASKS_V

Source

View Text - Preformatted

SELECT PPE.ELEMENT_NUMBER ,PPE.NAME ,PPE.OBJECT_TYPE ,PPE.PROJ_ELEMENT_ID ,PPE.PROJECT_ID ,PPE.STATUS_CODE ,PPE.MANAGER_PERSON_ID ,PPE.RECORD_VERSION_NUMBER ,PPV.ELEMENT_VERSION_ID ,PPV.PARENT_STRUCTURE_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 ,PPR.COMPLETED_PERCENTAGE ,PPR.PERCENT_COMPLETE_ID ,POR.OBJECT_TYPE_FROM ,POR.OBJECT_TYPE_TO ,POR.RELATIONSHIP_TYPE ,POR.RELATIONSHIP_SUBTYPE ,POR.OBJECT_ID_FROM1 ,POR.OBJECT_ID_TO1 ,POR.OBJECT_ID_FROM2 ,POR.OBJECT_ID_TO2 ,POR.WEIGHTING_PERCENTAGE ,POR.OBJECT_RELATIONSHIP_ID ,POR.RECORD_VERSION_NUMBER FROM PA_PROJ_ELEMENTS PPE ,PA_PROJ_ELEMENT_VERSIONS PPV ,PA_PROJ_ELEM_VER_SCHEDULE PSC ,PA_PROJECT_STATUSES PPS ,PA_PERCENT_COMPLETES PPC ,PA_PROGRESS_ROLLUP PPR ,PER_ALL_PEOPLE_F PPF ,PA_OBJECT_RELATIONSHIPS POR ,PA_PROJECT_STATUSES STA WHERE PPE.OBJECT_TYPE = 'PA_DELIVERABLES' AND PPE.PROJ_ELEMENT_ID = PPV.PROJ_ELEMENT_ID AND PPV.PROJECT_ID = PSC.PROJECT_ID AND PPV.ELEMENT_VERSION_ID = PSC.ELEMENT_VERSION_ID AND PPE.STATUS_CODE = PPS.PROJECT_STATUS_CODE(+) AND PPR.PROGRESS_STATUS_CODE = STA.PROJECT_STATUS_CODE(+) AND PPE.MANAGER_PERSON_ID = PPF.PERSON_ID(+) AND PPE.PROJECT_ID = PPR.PROJECT_ID(+) AND PPE.PROJ_ELEMENT_ID = PPR.OBJECT_ID(+) AND PPE.OBJECT_TYPE = PPR.OBJECT_TYPE(+) AND PPC.DATE_COMPUTED(+) = PPR.AS_OF_DATE AND PPR.PROJECT_ID = PPC.PROJECT_ID(+) AND PPR.OBJECT_ID = PPC.OBJECT_ID(+) AND PPR.OBJECT_TYPE = PPC.OBJECT_TYPE(+) AND PPC.PERCENT_COMPLETE_ID (+) = PPR.PERCENT_COMPLETE_ID AND SYSDATE BETWEEN PPF.EFFECTIVE_START_DATE(+) AND PPF.EFFECTIVE_END_DATE(+) AND POR.RELATIONSHIP_TYPE='A' AND POR.RELATIONSHIP_SUBTYPE='TASK_TO_DELIVERABLE' AND POR.OBJECT_ID_TO2=PPV.PROJ_ELEMENT_ID AND POR.OBJECT_ID_TO1=PPV.ELEMENT_VERSION_ID AND PPR.structure_type(+) = 'WORKPLAN' AND PPR.structure_type = PPC.STRUCTURE_TYPE(+) AND PPR.current_flag(+) = 'Y'

View Text - HTML Formatted

SELECT PPE.ELEMENT_NUMBER
, PPE.NAME
, PPE.OBJECT_TYPE
, PPE.PROJ_ELEMENT_ID
, PPE.PROJECT_ID
, PPE.STATUS_CODE
, PPE.MANAGER_PERSON_ID
, PPE.RECORD_VERSION_NUMBER
, PPV.ELEMENT_VERSION_ID
, PPV.PARENT_STRUCTURE_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
, PPR.COMPLETED_PERCENTAGE
, PPR.PERCENT_COMPLETE_ID
, POR.OBJECT_TYPE_FROM
, POR.OBJECT_TYPE_TO
, POR.RELATIONSHIP_TYPE
, POR.RELATIONSHIP_SUBTYPE
, POR.OBJECT_ID_FROM1
, POR.OBJECT_ID_TO1
, POR.OBJECT_ID_FROM2
, POR.OBJECT_ID_TO2
, POR.WEIGHTING_PERCENTAGE
, POR.OBJECT_RELATIONSHIP_ID
, POR.RECORD_VERSION_NUMBER
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPV
, PA_PROJ_ELEM_VER_SCHEDULE PSC
, PA_PROJECT_STATUSES PPS
, PA_PERCENT_COMPLETES PPC
, PA_PROGRESS_ROLLUP PPR
, PER_ALL_PEOPLE_F PPF
, PA_OBJECT_RELATIONSHIPS POR
, PA_PROJECT_STATUSES STA
WHERE PPE.OBJECT_TYPE = 'PA_DELIVERABLES'
AND PPE.PROJ_ELEMENT_ID = PPV.PROJ_ELEMENT_ID
AND PPV.PROJECT_ID = PSC.PROJECT_ID
AND PPV.ELEMENT_VERSION_ID = PSC.ELEMENT_VERSION_ID
AND PPE.STATUS_CODE = PPS.PROJECT_STATUS_CODE(+)
AND PPR.PROGRESS_STATUS_CODE = STA.PROJECT_STATUS_CODE(+)
AND PPE.MANAGER_PERSON_ID = PPF.PERSON_ID(+)
AND PPE.PROJECT_ID = PPR.PROJECT_ID(+)
AND PPE.PROJ_ELEMENT_ID = PPR.OBJECT_ID(+)
AND PPE.OBJECT_TYPE = PPR.OBJECT_TYPE(+)
AND PPC.DATE_COMPUTED(+) = PPR.AS_OF_DATE
AND PPR.PROJECT_ID = PPC.PROJECT_ID(+)
AND PPR.OBJECT_ID = PPC.OBJECT_ID(+)
AND PPR.OBJECT_TYPE = PPC.OBJECT_TYPE(+)
AND PPC.PERCENT_COMPLETE_ID (+) = PPR.PERCENT_COMPLETE_ID
AND SYSDATE BETWEEN PPF.EFFECTIVE_START_DATE(+)
AND PPF.EFFECTIVE_END_DATE(+)
AND POR.RELATIONSHIP_TYPE='A'
AND POR.RELATIONSHIP_SUBTYPE='TASK_TO_DELIVERABLE'
AND POR.OBJECT_ID_TO2=PPV.PROJ_ELEMENT_ID
AND POR.OBJECT_ID_TO1=PPV.ELEMENT_VERSION_ID
AND PPR.STRUCTURE_TYPE(+) = 'WORKPLAN'
AND PPR.STRUCTURE_TYPE = PPC.STRUCTURE_TYPE(+)
AND PPR.CURRENT_FLAG(+) = 'Y'