View: PA_STRUC_PARENT_LINKS_V

Product:	PA - Projects
Description:	PA_STRUC_PARENT_LINKS_V selects the parent object information of a link. - For future use
Implementation/DBA Data:	APPS.PA_STRUC_PARENT_LINKS_V

View Text

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

Columns