VIEW: APPS.PA_STRUC_PARENT_LINKS_V

Source

View Text - Preformatted

SELECT rel2.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.proj_element_id, pv2.element_version_id, pe2.element_number, pe2.name, rel2.object_id_to1, pe2.object_type, rel.relationship_type, rel.relationship_subtype, rel.lag_day, rel.imported_lag, rel.priority, rel.pm_product_code, rel2.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, pa_object_relationships rel2 WHERE rel.object_id_from1 = 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.relationship_type = 'S' and rel.object_type_from = 'PA_TASKS' and rel.object_type_to = 'PA_TASKS' and rel.object_id_to1 = rel2.object_id_from1 and rel2.relationship_type = 'L' and rel2.object_type_from = 'PA_TASKS' and rel2.object_type_to IN ('PA_TASKS', 'PA_STRUCTURES') AND pp2.project_id <> 0 AND pv1.project_id <> 0 union select rel2.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), to_number(null), null, null, rel2.object_id_to1, pv1.object_type, rel.relationship_type, rel.relationship_subtype, rel.lag_day, rel.imported_lag, rel.priority, rel.pm_product_code, rel2.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, pa_object_relationships rel2 where rel.object_id_from1 = 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.relationship_type = 'S' and rel.object_type_from = 'PA_STRUCTURES' and rel.object_type_to = 'PA_TASKS' and rel.object_id_to1 = rel2.object_id_from1 and rel2.relationship_type = 'L' and rel2.object_type_from = 'PA_TASKS' and rel2.object_type_to IN ('PA_TASKS', 'PA_STRUCTURES') AND pp1.project_id <> 0

View Text - HTML Formatted

SELECT REL2.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.PROJ_ELEMENT_ID
, PV2.ELEMENT_VERSION_ID
, PE2.ELEMENT_NUMBER
, PE2.NAME
, REL2.OBJECT_ID_TO1
, PE2.OBJECT_TYPE
, REL.RELATIONSHIP_TYPE
, REL.RELATIONSHIP_SUBTYPE
, REL.LAG_DAY
, REL.IMPORTED_LAG
, REL.PRIORITY
, REL.PM_PRODUCT_CODE
, REL2.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
, PA_OBJECT_RELATIONSHIPS REL2
WHERE REL.OBJECT_ID_FROM1 = 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.RELATIONSHIP_TYPE = 'S'
AND REL.OBJECT_TYPE_FROM = 'PA_TASKS'
AND REL.OBJECT_TYPE_TO = 'PA_TASKS'
AND REL.OBJECT_ID_TO1 = REL2.OBJECT_ID_FROM1
AND REL2.RELATIONSHIP_TYPE = 'L'
AND REL2.OBJECT_TYPE_FROM = 'PA_TASKS'
AND REL2.OBJECT_TYPE_TO IN ('PA_TASKS'
, 'PA_STRUCTURES')
AND PP2.PROJECT_ID <> 0
AND PV1.PROJECT_ID <> 0 UNION SELECT REL2.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)
, TO_NUMBER(NULL)
, NULL
, NULL
, REL2.OBJECT_ID_TO1
, PV1.OBJECT_TYPE
, REL.RELATIONSHIP_TYPE
, REL.RELATIONSHIP_SUBTYPE
, REL.LAG_DAY
, REL.IMPORTED_LAG
, REL.PRIORITY
, REL.PM_PRODUCT_CODE
, REL2.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
, PA_OBJECT_RELATIONSHIPS REL2
WHERE REL.OBJECT_ID_FROM1 = 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.RELATIONSHIP_TYPE = 'S'
AND REL.OBJECT_TYPE_FROM = 'PA_STRUCTURES'
AND REL.OBJECT_TYPE_TO = 'PA_TASKS'
AND REL.OBJECT_ID_TO1 = REL2.OBJECT_ID_FROM1
AND REL2.RELATIONSHIP_TYPE = 'L'
AND REL2.OBJECT_TYPE_FROM = 'PA_TASKS'
AND REL2.OBJECT_TYPE_TO IN ('PA_TASKS'
, 'PA_STRUCTURES')
AND PP1.PROJECT_ID <> 0