[Home] [Help]
2154: select cs.incident_number incident_number, cit.name name, udf.object_version_number,
2155: mtl.concatenated_segments item, csi.serial_number, ue.mel_cdl_type_code,
2156: cs.expected_resolution_date, seq.ata_code, arc.repair_time,
2157: apn.name node_name, aph.name class_name, cs.summary, ciu.name repair_category,
2158: (select visit_number from ahl_visit_tasks_b tsk, ahl_visits_b vst where
2159: vst.visit_id = tsk.visit_id and tsk.unit_effectivity_id =
2160: ue.unit_effectivity_id and rownum < 2) visit_number
2161: from cs_incidents_all_vl cs, cs_incident_types_vl cit,
2162: ahl_unit_effectivities_b ue, ahl_unit_deferrals_b udf,