View: PA_DEPENDENCIES_V

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

View Text

SELECT PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_DEPEND_DISP_TYPE'
, 'PRE')
, PPA.PROJECT_ID
, PPA.SEGMENT1
, PPA.NAME
, PPE.ELEMENT_NUMBER
, PPE.NAME
, PPE.PROJ_ELEMENT_ID
, PEV.ELEMENT_VERSION_ID
, PPE2.PROJ_ELEMENT_ID
, PEV3.ELEMENT_VERSION_ID
, PPE2.PROJECT_ID
, REL.COMMENTS
, REL.LAG_DAY
, SCH.SCHEDULED_START_DATE
, SCH.SCHEDULED_FINISH_DATE
, SCH.ACTUAL_START_DATE
, SCH.ACTUAL_FINISH_DATE
, PPE.MANAGER_PERSON_ID
, PAPF.FULL_NAME
, PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_OBJECT_DEPENDENCY_TYPES'
, REL.RELATIONSHIP_SUBTYPE)
, REL.RELATIONSHIP_SUBTYPE
, 'PRE'
, REL.OBJECT_RELATIONSHIP_ID
, REL.RECORD_VERSION_NUMBER
, PEV.PARENT_STRUCTURE_VERSION_ID
FROM PA_PROJECTS_ALL PPA
, PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PEV
, PA_OBJECT_RELATIONSHIPS REL
, PA_PROJ_ELEMENTS PPE2
, PA_PROJ_ELEMENT_VERSIONS PEV3
, PA_PROJ_ELEM_VER_SCHEDULE SCH
, PER_ALL_PEOPLE_F PAPF
WHERE NVL(REL.STATUS_CODE
, 'PUBLISHED') = 'PUBLISHED'
AND REL.RELATIONSHIP_TYPE = 'D'
AND REL.OBJECT_ID_TO1 = PEV.ELEMENT_VERSION_ID
AND REL.OBJECT_TYPE_TO = 'PA_TASKS'
AND REL.OBJECT_ID_FROM1 = PEV3.ELEMENT_VERSION_ID
AND REL.OBJECT_TYPE_FROM = 'PA_TASKS'
AND PEV3.PROJ_ELEMENT_ID = PPE2.PROJ_ELEMENT_ID
AND PEV3.PROJECT_ID = PPE2.PROJECT_ID
AND PEV.PROJ_ELEMENT_ID = PPE.PROJ_ELEMENT_ID
AND PEV.PROJECT_ID = PPE.PROJECT_ID
AND SCH.PROJECT_ID = PEV.PROJECT_ID
AND SCH.ELEMENT_VERSION_ID = PEV.ELEMENT_VERSION_ID
AND PEV.PROJECT_ID = PPA.PROJECT_ID
AND PPE.MANAGER_PERSON_ID = PAPF.PERSON_ID(+)
AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE(+)
AND PAPF.EFFECTIVE_END_DATE (+)
AND PEV.ELEMENT_VERSION_ID IN ( SELECT MAX(PEV2.ELEMENT_VERSION_ID)
FROM PA_PROJ_ELEMENT_VERSIONS PEV2
WHERE PEV2.PROJECT_ID = PEV.PROJECT_ID
AND PEV2.PROJ_ELEMENT_ID = PEV.PROJ_ELEMENT_ID) UNION SELECT PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_DEPEND_DISP_TYPE'
, 'PRE')
, PPA.PROJECT_ID
, PPA.SEGMENT1
, PPA.NAME
, PPE.ELEMENT_NUMBER
, PPE.NAME
, PPE.PROJ_ELEMENT_ID
, PEV.ELEMENT_VERSION_ID
, PPE2.PROJ_ELEMENT_ID
, PEV3.ELEMENT_VERSION_ID
, PPE2.PROJECT_ID
, REL.COMMENTS
, REL.LAG_DAY
, SCH.SCHEDULED_START_DATE
, SCH.SCHEDULED_FINISH_DATE
, SCH.ACTUAL_START_DATE
, SCH.ACTUAL_FINISH_DATE
, PPE.MANAGER_PERSON_ID
, PAPF.FULL_NAME
, PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_OBJECT_DEPENDENCY_TYPES'
, REL.RELATIONSHIP_SUBTYPE)
, REL.RELATIONSHIP_SUBTYPE
, 'PRE'
, REL.OBJECT_RELATIONSHIP_ID
, REL.RECORD_VERSION_NUMBER
, PEV.PARENT_STRUCTURE_VERSION_ID
FROM PA_PROJECTS_ALL PPA
, PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PEV
, PA_OBJECT_RELATIONSHIPS REL
, PA_PROJ_ELEMENTS PPE2
, PA_PROJ_ELEMENT_VERSIONS PEV3
, PA_PROJ_ELEM_VER_SCHEDULE SCH
, PER_ALL_PEOPLE_F PAPF
WHERE NVL(REL.STATUS_CODE
, 'INTRA') = 'INTRA'
AND REL.RELATIONSHIP_TYPE = 'D'
AND REL.OBJECT_ID_TO1 = PEV.ELEMENT_VERSION_ID
AND REL.OBJECT_TYPE_TO = 'PA_TASKS'
AND REL.OBJECT_ID_FROM1 = PEV3.ELEMENT_VERSION_ID
AND REL.OBJECT_TYPE_FROM = 'PA_TASKS'
AND PEV3.PROJ_ELEMENT_ID = PPE2.PROJ_ELEMENT_ID
AND PEV3.PROJECT_ID = PPE2.PROJECT_ID
AND PEV.PROJ_ELEMENT_ID = PPE.PROJ_ELEMENT_ID
AND PEV.PROJECT_ID = PPE.PROJECT_ID
AND SCH.PROJECT_ID = PEV.PROJECT_ID
AND SCH.ELEMENT_VERSION_ID = PEV.ELEMENT_VERSION_ID
AND PEV.PROJECT_ID = PPA.PROJECT_ID
AND PPE.MANAGER_PERSON_ID = PAPF.PERSON_ID(+)
AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE(+)
AND PAPF.EFFECTIVE_END_DATE (+) UNION SELECT PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_DEPEND_DISP_TYPE'
, 'PRE')
, PPA.PROJECT_ID
, PPA.SEGMENT1
, PPA.NAME
, PPE.ELEMENT_NUMBER
, PPE.NAME
, PPE.PROJ_ELEMENT_ID
, PEV.ELEMENT_VERSION_ID
, PPE2.PROJ_ELEMENT_ID
, PEV3.ELEMENT_VERSION_ID
, PPE2.PROJECT_ID
, REL.COMMENTS
, REL.LAG_DAY
, SCH.SCHEDULED_START_DATE
, SCH.SCHEDULED_FINISH_DATE
, SCH.ACTUAL_START_DATE
, SCH.ACTUAL_FINISH_DATE
, PPE.MANAGER_PERSON_ID
, PAPF.FULL_NAME
, PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_OBJECT_DEPENDENCY_TYPES'
, REL.RELATIONSHIP_SUBTYPE)
, REL.RELATIONSHIP_SUBTYPE
, 'PRE'
, REL.OBJECT_RELATIONSHIP_ID
, REL.RECORD_VERSION_NUMBER
, PEV.PARENT_STRUCTURE_VERSION_ID
FROM PA_PROJECTS_ALL PPA
, PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PEV
, PA_OBJECT_RELATIONSHIPS REL
, PA_PROJ_ELEMENTS PPE2
, PA_PROJ_ELEMENT_VERSIONS PEV3
, PA_PROJ_ELEM_VER_SCHEDULE SCH
, PER_ALL_PEOPLE_F PAPF
WHERE REL.STATUS_CODE = 'UNPUBLISHED'
AND REL.RELATIONSHIP_TYPE = 'D'
AND REL.OBJECT_ID_TO1 = PEV.ELEMENT_VERSION_ID
AND REL.OBJECT_TYPE_TO = 'PA_TASKS'
AND REL.OBJECT_ID_FROM1 = PEV3.ELEMENT_VERSION_ID
AND REL.OBJECT_TYPE_FROM = 'PA_TASKS'
AND PEV3.PROJ_ELEMENT_ID = PPE2.PROJ_ELEMENT_ID
AND PEV3.PROJECT_ID = PPE2.PROJECT_ID
AND PEV.PROJ_ELEMENT_ID = PPE.PROJ_ELEMENT_ID
AND PEV.PROJECT_ID = PPE.PROJECT_ID
AND SCH.PROJECT_ID = PEV.PROJECT_ID
AND SCH.ELEMENT_VERSION_ID = PEV.ELEMENT_VERSION_ID
AND PEV.PROJECT_ID = PPA.PROJECT_ID
AND PPE.MANAGER_PERSON_ID = PAPF.PERSON_ID(+)
AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE(+)
AND PAPF.EFFECTIVE_END_DATE (+)
AND PPE.PROJ_ELEMENT_ID NOT IN ( SELECT PEV2.PROJ_ELEMENT_ID
FROM PA_PROJ_ELEMENT_VERSIONS PEV2
, PA_OBJECT_RELATIONSHIPS REL2
WHERE PEV2.PROJECT_ID = PEV.PROJECT_ID
AND PEV2.PROJ_ELEMENT_ID = PEV.PROJ_ELEMENT_ID
AND PEV2.ELEMENT_VERSION_ID = REL2.OBJECT_ID_TO1
AND REL2.RELATIONSHIP_TYPE = 'D'
AND REL2.STATUS_CODE = 'PUBLISHED' ) UNION SELECT PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_DEPEND_DISP_TYPE'
, 'SUC')
, PPA.PROJECT_ID
, PPA.SEGMENT1
, PPA.NAME
, PPE.ELEMENT_NUMBER
, PPE.NAME
, PPE.PROJ_ELEMENT_ID
, PEV.ELEMENT_VERSION_ID
, PPE2.PROJ_ELEMENT_ID
, PEV3.ELEMENT_VERSION_ID
, PPE2.PROJECT_ID
, REL.COMMENTS
, REL.LAG_DAY
, SCH.SCHEDULED_START_DATE
, SCH.SCHEDULED_FINISH_DATE
, SCH.ACTUAL_START_DATE
, SCH.ACTUAL_FINISH_DATE
, PPE.MANAGER_PERSON_ID
, PAPF.FULL_NAME
, PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_OBJECT_DEPENDENCY_TYPES'
, REL.RELATIONSHIP_SUBTYPE)
, REL.RELATIONSHIP_SUBTYPE
, 'SUC'
, REL.OBJECT_RELATIONSHIP_ID
, REL.RECORD_VERSION_NUMBER
, PEV.PARENT_STRUCTURE_VERSION_ID
FROM PA_PROJECTS_ALL PPA
, PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PEV
, PA_OBJECT_RELATIONSHIPS REL
, PA_PROJ_ELEMENTS PPE2
, PA_PROJ_ELEMENT_VERSIONS PEV3
, PA_PROJ_ELEM_VER_SCHEDULE SCH
, PER_ALL_PEOPLE_F PAPF
WHERE NVL(REL.STATUS_CODE
, 'PUBLISHED') = 'PUBLISHED'
AND REL.RELATIONSHIP_TYPE = 'D'
AND REL.OBJECT_ID_FROM1 = PEV.ELEMENT_VERSION_ID
AND REL.OBJECT_TYPE_FROM = 'PA_TASKS'
AND REL.OBJECT_ID_TO1 = PEV3.ELEMENT_VERSION_ID
AND REL.OBJECT_TYPE_TO = 'PA_TASKS'
AND PEV3.PROJ_ELEMENT_ID = PPE2.PROJ_ELEMENT_ID
AND PEV3.PROJECT_ID = PPE2.PROJECT_ID
AND PEV.PROJ_ELEMENT_ID = PPE.PROJ_ELEMENT_ID
AND PEV.PROJECT_ID = PPE.PROJECT_ID
AND SCH.PROJECT_ID = PEV.PROJECT_ID
AND SCH.ELEMENT_VERSION_ID = PEV.ELEMENT_VERSION_ID
AND PPE.MANAGER_PERSON_ID = PAPF.PERSON_ID(+)
AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE(+)
AND PAPF.EFFECTIVE_END_DATE (+)
AND PEV.PROJECT_ID = PPA.PROJECT_ID
AND PEV.ELEMENT_VERSION_ID IN ( SELECT MAX(PEV2.ELEMENT_VERSION_ID)
FROM PA_PROJ_ELEMENT_VERSIONS PEV2
WHERE PEV2.PROJECT_ID = PEV.PROJECT_ID
AND PEV2.PROJ_ELEMENT_ID = PEV.PROJ_ELEMENT_ID) UNION SELECT PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_DEPEND_DISP_TYPE'
, 'SUC')
, PPA.PROJECT_ID
, PPA.SEGMENT1
, PPA.NAME
, PPE.ELEMENT_NUMBER
, PPE.NAME
, PPE.PROJ_ELEMENT_ID
, PEV.ELEMENT_VERSION_ID
, PPE2.PROJ_ELEMENT_ID
, PEV3.ELEMENT_VERSION_ID
, PPE2.PROJECT_ID
, REL.COMMENTS
, REL.LAG_DAY
, SCH.SCHEDULED_START_DATE
, SCH.SCHEDULED_FINISH_DATE
, SCH.ACTUAL_START_DATE
, SCH.ACTUAL_FINISH_DATE
, PPE.MANAGER_PERSON_ID
, PAPF.FULL_NAME
, PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_OBJECT_DEPENDENCY_TYPES'
, REL.RELATIONSHIP_SUBTYPE)
, REL.RELATIONSHIP_SUBTYPE
, 'SUC'
, REL.OBJECT_RELATIONSHIP_ID
, REL.RECORD_VERSION_NUMBER
, PEV.PARENT_STRUCTURE_VERSION_ID
FROM PA_PROJECTS_ALL PPA
, PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PEV
, PA_OBJECT_RELATIONSHIPS REL
, PA_PROJ_ELEMENTS PPE2
, PA_PROJ_ELEMENT_VERSIONS PEV3
, PA_PROJ_ELEM_VER_SCHEDULE SCH
, PER_ALL_PEOPLE_F PAPF
WHERE NVL(REL.STATUS_CODE
, 'INTRA') = 'INTRA'
AND REL.RELATIONSHIP_TYPE = 'D'
AND REL.OBJECT_ID_FROM1 = PEV.ELEMENT_VERSION_ID
AND REL.OBJECT_TYPE_FROM = 'PA_TASKS'
AND REL.OBJECT_ID_TO1 = PEV3.ELEMENT_VERSION_ID
AND REL.OBJECT_TYPE_TO = 'PA_TASKS'
AND PEV3.PROJ_ELEMENT_ID = PPE2.PROJ_ELEMENT_ID
AND PEV3.PROJECT_ID = PPE2.PROJECT_ID
AND PEV.PROJ_ELEMENT_ID = PPE.PROJ_ELEMENT_ID
AND PEV.PROJECT_ID = PPE.PROJECT_ID
AND SCH.PROJECT_ID = PEV.PROJECT_ID
AND SCH.ELEMENT_VERSION_ID = PEV.ELEMENT_VERSION_ID
AND PPE.MANAGER_PERSON_ID = PAPF.PERSON_ID(+)
AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE(+)
AND PAPF.EFFECTIVE_END_DATE (+)
AND PEV.PROJECT_ID = PPA.PROJECT_ID UNION SELECT PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_DEPEND_DISP_TYPE'
, 'SUC')
, PPA.PROJECT_ID
, PPA.SEGMENT1
, PPA.NAME
, PPE.ELEMENT_NUMBER
, PPE.NAME
, PPE.PROJ_ELEMENT_ID
, PEV.ELEMENT_VERSION_ID
, PPE2.PROJ_ELEMENT_ID
, PEV3.ELEMENT_VERSION_ID
, PPE2.PROJECT_ID
, REL.COMMENTS
, REL.LAG_DAY
, SCH.SCHEDULED_START_DATE
, SCH.SCHEDULED_FINISH_DATE
, SCH.ACTUAL_START_DATE
, SCH.ACTUAL_FINISH_DATE
, PPE.MANAGER_PERSON_ID
, PAPF.FULL_NAME
, PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_OBJECT_DEPENDENCY_TYPES'
, REL.RELATIONSHIP_SUBTYPE)
, REL.RELATIONSHIP_SUBTYPE
, 'SUC'
, REL.OBJECT_RELATIONSHIP_ID
, REL.RECORD_VERSION_NUMBER
, PEV.PARENT_STRUCTURE_VERSION_ID
FROM PA_PROJECTS_ALL PPA
, PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PEV
, PA_OBJECT_RELATIONSHIPS REL
, PA_PROJ_ELEMENTS PPE2
, PA_PROJ_ELEMENT_VERSIONS PEV3
, PA_PROJ_ELEM_VER_SCHEDULE SCH
, PER_ALL_PEOPLE_F PAPF
WHERE REL.STATUS_CODE = 'UNPUBLISHED'
AND REL.RELATIONSHIP_TYPE = 'D'
AND REL.OBJECT_ID_FROM1 = PEV.ELEMENT_VERSION_ID
AND REL.OBJECT_TYPE_FROM = 'PA_TASKS'
AND REL.OBJECT_ID_TO1 = PEV3.ELEMENT_VERSION_ID
AND REL.OBJECT_TYPE_TO = 'PA_TASKS'
AND PEV3.PROJ_ELEMENT_ID = PPE2.PROJ_ELEMENT_ID
AND PEV3.PROJECT_ID = PPE2.PROJECT_ID
AND PEV.PROJ_ELEMENT_ID = PPE.PROJ_ELEMENT_ID
AND PEV.PROJECT_ID = PPE.PROJECT_ID
AND SCH.PROJECT_ID = PEV.PROJECT_ID
AND SCH.ELEMENT_VERSION_ID = PEV.ELEMENT_VERSION_ID
AND PEV.PROJECT_ID = PPA.PROJECT_ID
AND PPE.MANAGER_PERSON_ID = PAPF.PERSON_ID(+)
AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE(+)
AND PAPF.EFFECTIVE_END_DATE (+)
AND PPE.PROJ_ELEMENT_ID NOT IN ( SELECT PEV2.PROJ_ELEMENT_ID
FROM PA_PROJ_ELEMENT_VERSIONS PEV2
, PA_OBJECT_RELATIONSHIPS REL2
WHERE PEV2.PROJECT_ID = PEV.PROJECT_ID
AND PEV2.PROJ_ELEMENT_ID = PEV.PROJ_ELEMENT_ID
AND PEV2.ELEMENT_VERSION_ID = REL2.OBJECT_ID_FROM1
AND REL2.RELATIONSHIP_TYPE = 'D'
AND REL2.STATUS_CODE = 'PUBLISHED' )

Columns