VIEW: APPS.PA_STRUCTURES_LINKS_V

Source

View Text - Preformatted

SELECT /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ 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 ,por1.record_version_number ,NVL(pfxat.labor_hours,0) + NVL(pfxat.equipment_hours,0) planned_effort ,ppe2.baseline_start_date ,ppe2.baseline_finish_date ,sch.scheduled_start_date ,sch.scheduled_finish_date ,pa_project_parties_utils.GET_PROJECT_MANAGER(ppv2.project_id) ,pa_project_parties_utils.GET_PROJECT_MANAGER_NAME(ppv2.project_id) FROM pa_proj_element_versions ppv1 ,pa_proj_elem_ver_structure ppevs1 ,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 ,pa_proj_elem_ver_schedule sch ,pji_fm_xbs_accum_tmp1 pfxat WHERE ppv2.element_version_id = por1.object_id_to1 AND ppv2.object_type = 'PA_STRUCTURES' AND por1.relationship_type in ( 'LW', '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 por2.object_id_from1 = ppv1.element_version_id AND ppevs1.element_version_id = ppv1.parent_structure_version_id AND ppevs1.project_id = ppv1.project_id AND ppv1.proj_element_id = ppe1.proj_element_id AND ppe1.project_id = ppa1.project_id AND ppv2.project_id = ppa2.project_id AND sch.element_version_id (+) = ppv2.element_version_id AND pfxat.project_id (+)= ppv2.project_id AND pfxat.project_element_id (+)=ppv2.proj_element_id AND pfxat.struct_version_id (+)=ppv2.element_version_id AND pfxat.calendar_type(+) = 'A' AND pfxat.plan_version_id(+) > 0 AND pfxat.txn_currency_code(+) is null And por1.object_type_from = 'PA_TASKS' And por1.object_type_to = 'PA_STRUCTURES' And ppe2.object_type = 'PA_STRUCTURES'

View Text - HTML Formatted

SELECT /*+ INDEX(PJI_FM_XBS_ACCUM_TMP1 PJI_FM_XBS_ACCUM_TMP1_N1)*/ 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
, POR1.RECORD_VERSION_NUMBER
, NVL(PFXAT.LABOR_HOURS
, 0) + NVL(PFXAT.EQUIPMENT_HOURS
, 0) PLANNED_EFFORT
, PPE2.BASELINE_START_DATE
, PPE2.BASELINE_FINISH_DATE
, SCH.SCHEDULED_START_DATE
, SCH.SCHEDULED_FINISH_DATE
, PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER(PPV2.PROJECT_ID)
, PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER_NAME(PPV2.PROJECT_ID)
FROM PA_PROJ_ELEMENT_VERSIONS PPV1
, PA_PROJ_ELEM_VER_STRUCTURE PPEVS1
, 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
, PA_PROJ_ELEM_VER_SCHEDULE SCH
, PJI_FM_XBS_ACCUM_TMP1 PFXAT
WHERE PPV2.ELEMENT_VERSION_ID = POR1.OBJECT_ID_TO1
AND PPV2.OBJECT_TYPE = 'PA_STRUCTURES'
AND POR1.RELATIONSHIP_TYPE IN ( 'LW'
, '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 POR2.OBJECT_ID_FROM1 = PPV1.ELEMENT_VERSION_ID
AND PPEVS1.ELEMENT_VERSION_ID = PPV1.PARENT_STRUCTURE_VERSION_ID
AND PPEVS1.PROJECT_ID = PPV1.PROJECT_ID
AND PPV1.PROJ_ELEMENT_ID = PPE1.PROJ_ELEMENT_ID
AND PPE1.PROJECT_ID = PPA1.PROJECT_ID
AND PPV2.PROJECT_ID = PPA2.PROJECT_ID
AND SCH.ELEMENT_VERSION_ID (+) = PPV2.ELEMENT_VERSION_ID
AND PFXAT.PROJECT_ID (+)= PPV2.PROJECT_ID
AND PFXAT.PROJECT_ELEMENT_ID (+)=PPV2.PROJ_ELEMENT_ID
AND PFXAT.STRUCT_VERSION_ID (+)=PPV2.ELEMENT_VERSION_ID
AND PFXAT.CALENDAR_TYPE(+) = 'A'
AND PFXAT.PLAN_VERSION_ID(+) > 0
AND PFXAT.TXN_CURRENCY_CODE(+) IS NULL
AND POR1.OBJECT_TYPE_FROM = 'PA_TASKS'
AND POR1.OBJECT_TYPE_TO = 'PA_STRUCTURES'
AND PPE2.OBJECT_TYPE = 'PA_STRUCTURES'