View: PA_DLV_ASSCN_TASKS_V

Product:	PA - Projects
Description:	PA_DLV_ASSCN_TASKS_V selects all the attributes of a Deliverable
Implementation/DBA Data:	APPS.PA_DLV_ASSCN_TASKS_V

View Text

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'

Columns