78: cs_incidents_all_b i,
79: cs_incident_types_b t,
80: csi_item_instances cii1,
81: csi_item_instances cii2,
82: mtl_parameters mp1,
83: mtl_parameters mp2
84: WHERE a.rowid between c_start_rowid and c_end_rowid
85: AND a.incident_id = i.incident_id
86: AND i.incident_type_id = t.incident_type_id
79: cs_incident_types_b t,
80: csi_item_instances cii1,
81: csi_item_instances cii2,
82: mtl_parameters mp1,
83: mtl_parameters mp2
84: WHERE a.rowid between c_start_rowid and c_end_rowid
85: AND a.incident_id = i.incident_id
86: AND i.incident_type_id = t.incident_type_id
87: AND a.item_serial_number = cii1.serial_number (+)