VIEW: APPS.PA_STRUC_PREDECESSORS_V

Source

View Text - Preformatted

SELECT rel.object_relationship_id, pp2.project_id, pp2.segment1, pp2.name, pe1.proj_element_id, pe1.element_number, pe1.name, pv1.element_version_id, evs.version_number, evs.name, pv2.element_version_id, pe2.element_number, pe2.name, rel.object_id_from1, rel.relationship_type, rel.relationship_subtype, rel.lag_day, rel.imported_lag, rel.priority, rel.pm_product_code, rel.record_version_number from pa_object_relationships rel, pa_projects_all pp2, pa_proj_elements pe1, pa_proj_element_versions pv1, pa_proj_elem_ver_structure evs, pa_proj_elements pe2, pa_proj_element_versions pv2 WHERE rel.object_id_to1 = pv2.element_version_id and pv2.proj_element_id = pe2.proj_element_id and pv2.project_id = pp2.project_id and pv2.parent_structure_version_id = pv1.element_version_id and pv1.element_version_id = evs.element_version_id and pv1.project_id = evs.project_id and pv1.proj_element_id = pe1.proj_element_id and rel.object_type_to = 'PA_TASKS' and rel.object_type_from IN ('PA_TASKS', 'PA_STRUCTURES') and rel.relationship_type = 'D' AND pp2.project_id <> 0 AND pv1.project_id <> 0 union select rel.object_relationship_id, pp1.project_id, pp1.segment1, pp1.name, pe1.proj_element_id, pe1.element_number, pe1.name, pv1.element_version_id, evs.version_number, evs.name, to_number(null), null, null, rel.object_id_from1, rel.relationship_type, rel.relationship_subtype, rel.lag_day, rel.imported_lag, rel.priority, rel.pm_product_code, rel.record_version_number from pa_object_relationships rel, pa_projects_all pp1, pa_proj_elements pe1, pa_proj_element_versions pv1, pa_proj_elem_ver_structure evs where rel.object_id_to1 = pv1.element_version_id and pv1.element_version_id = evs.element_version_id and evs.project_id = pp1.project_id and pv1.proj_element_id = pe1.proj_element_id and pe1.project_id = pp1.project_id and pv1.project_id = pp1.project_id and rel.object_type_to = 'PA_STRUCTURES' and rel.object_type_from IN ('PA_TASKS', 'PA_STRUCTURES') and rel.relationship_type = 'D' AND pp1.project_id <> 0

View Text - HTML Formatted

SELECT REL.OBJECT_RELATIONSHIP_ID
, PP2.PROJECT_ID
, PP2.SEGMENT1
, PP2.NAME
, PE1.PROJ_ELEMENT_ID
, PE1.ELEMENT_NUMBER
, PE1.NAME
, PV1.ELEMENT_VERSION_ID
, EVS.VERSION_NUMBER
, EVS.NAME
, PV2.ELEMENT_VERSION_ID
, PE2.ELEMENT_NUMBER
, PE2.NAME
, REL.OBJECT_ID_FROM1
, REL.RELATIONSHIP_TYPE
, REL.RELATIONSHIP_SUBTYPE
, REL.LAG_DAY
, REL.IMPORTED_LAG
, REL.PRIORITY
, REL.PM_PRODUCT_CODE
, REL.RECORD_VERSION_NUMBER
FROM PA_OBJECT_RELATIONSHIPS REL
, PA_PROJECTS_ALL PP2
, PA_PROJ_ELEMENTS PE1
, PA_PROJ_ELEMENT_VERSIONS PV1
, PA_PROJ_ELEM_VER_STRUCTURE EVS
, PA_PROJ_ELEMENTS PE2
, PA_PROJ_ELEMENT_VERSIONS PV2
WHERE REL.OBJECT_ID_TO1 = PV2.ELEMENT_VERSION_ID
AND PV2.PROJ_ELEMENT_ID = PE2.PROJ_ELEMENT_ID
AND PV2.PROJECT_ID = PP2.PROJECT_ID
AND PV2.PARENT_STRUCTURE_VERSION_ID = PV1.ELEMENT_VERSION_ID
AND PV1.ELEMENT_VERSION_ID = EVS.ELEMENT_VERSION_ID
AND PV1.PROJECT_ID = EVS.PROJECT_ID
AND PV1.PROJ_ELEMENT_ID = PE1.PROJ_ELEMENT_ID
AND REL.OBJECT_TYPE_TO = 'PA_TASKS'
AND REL.OBJECT_TYPE_FROM IN ('PA_TASKS'
, 'PA_STRUCTURES')
AND REL.RELATIONSHIP_TYPE = 'D'
AND PP2.PROJECT_ID <> 0
AND PV1.PROJECT_ID <> 0 UNION SELECT REL.OBJECT_RELATIONSHIP_ID
, PP1.PROJECT_ID
, PP1.SEGMENT1
, PP1.NAME
, PE1.PROJ_ELEMENT_ID
, PE1.ELEMENT_NUMBER
, PE1.NAME
, PV1.ELEMENT_VERSION_ID
, EVS.VERSION_NUMBER
, EVS.NAME
, TO_NUMBER(NULL)
, NULL
, NULL
, REL.OBJECT_ID_FROM1
, REL.RELATIONSHIP_TYPE
, REL.RELATIONSHIP_SUBTYPE
, REL.LAG_DAY
, REL.IMPORTED_LAG
, REL.PRIORITY
, REL.PM_PRODUCT_CODE
, REL.RECORD_VERSION_NUMBER
FROM PA_OBJECT_RELATIONSHIPS REL
, PA_PROJECTS_ALL PP1
, PA_PROJ_ELEMENTS PE1
, PA_PROJ_ELEMENT_VERSIONS PV1
, PA_PROJ_ELEM_VER_STRUCTURE EVS
WHERE REL.OBJECT_ID_TO1 = PV1.ELEMENT_VERSION_ID
AND PV1.ELEMENT_VERSION_ID = EVS.ELEMENT_VERSION_ID
AND EVS.PROJECT_ID = PP1.PROJECT_ID
AND PV1.PROJ_ELEMENT_ID = PE1.PROJ_ELEMENT_ID
AND PE1.PROJECT_ID = PP1.PROJECT_ID
AND PV1.PROJECT_ID = PP1.PROJECT_ID
AND REL.OBJECT_TYPE_TO = 'PA_STRUCTURES'
AND REL.OBJECT_TYPE_FROM IN ('PA_TASKS'
, 'PA_STRUCTURES')
AND REL.RELATIONSHIP_TYPE = 'D'
AND PP1.PROJECT_ID <> 0