View: PA_FIN_STRUCTURES_LINKS_V

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

View Text

SELECT PPV2.PROJECT_ID
, PPA2.NAME
, PPA2.SEGMENT1
, PPV2.ELEMENT_VERSION_ID
, POR1.RELATIONSHIP_TYPE
, POR1.COMMENTS
, PPV1.PROJECT_ID
, PPA1.NAME
, PPA1.SEGMENT1
, PPV1.PARENT_STRUCTURE_VERSION_ID
, PPV1.ELEMENT_VERSION_ID
, PPE1.PROJ_ELEMENT_ID
, PPE1.ELEMENT_NUMBER
, PPE1.NAME
, POR1.OBJECT_RELATIONSHIP_ID
FROM PA_PROJ_ELEMENT_VERSIONS PPV1
, PA_PROJ_ELEMENTS PPE1
, PA_PROJECTS_ALL PPA1
, PA_PROJ_ELEMENT_VERSIONS PPV2
, PA_PROJECTS_ALL PPA2
, PA_PROJ_ELEMENTS PPE2
, PA_OBJECT_RELATIONSHIPS POR1
, PA_OBJECT_RELATIONSHIPS POR2
WHERE PPV2.ELEMENT_VERSION_ID = POR1.OBJECT_ID_TO1
AND PPV2.OBJECT_TYPE = 'PA_STRUCTURES'
AND POR1.RELATIONSHIP_TYPE = 'LF'
AND POR1.OBJECT_ID_FROM1 = POR2.OBJECT_ID_TO1
AND PPV2.PROJ_ELEMENT_ID = PPE2.PROJ_ELEMENT_ID
AND PPE2.PROJECT_ID = PPA2.PROJECT_ID
AND PPV2.PROJECT_ID = PPA2.PROJECT_ID
AND POR2.OBJECT_ID_FROM1 = PPV1.ELEMENT_VERSION_ID
AND PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_FIN_STRUC_VER_ID(PPV1.PROJECT_ID) = PPV1.PARENT_STRUCTURE_VERSION_ID
AND PPV1.PROJ_ELEMENT_ID = PPE1.PROJ_ELEMENT_ID
AND PPV1.PROJECT_ID = PPA1.PROJECT_ID
AND PPE1.PROJECT_ID = PPA1.PROJECT_ID
AND POR1.OBJECT_TYPE_FROM = 'PA_TASKS'
AND POR1.OBJECT_TYPE_TO = 'PA_STRUCTURES'
AND PPV2.PROJECT_ID = POR1.OBJECT_ID_TO2
AND PPV1.PROJECT_ID = POR1.OBJECT_ID_FROM2

Columns