Product: | PA - Projects |
---|---|
Description: | PA_DELIVERABLES_V selects all the attributes of a Deliverable. |
Implementation/DBA Data: | APPS.PA_DELIVERABLES_V |
SELECT
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'