OLD VERSION

CREATE OR REPLACE VIEW MQM19CVIEW_WARM_WITH_NULLS (MAGNET_NAME, A1_INJ_TF, A1_INJ_ML, A1_INJ_B2, A1_INJ_B3, A1_INJ_B4, A1_INJ_B5, A1_INJ_B6, A1_INJ_B7, A1_INJ_B8, A1_INJ_B9, A1_INJ_B10, A1_INJ_B11, A1_INJ_B12, A1_INJ_B13, A1_INJ_B14, A1_INJ_A3, A1_INJ_A4, A1_INJ_A5, A1_INJ_A6, A1_INJ_A7, A1_INJ_A8, A1_INJ_A9, A1_INJ_A10, A1_INJ_A11, A1_INJ_A12, A1_INJ_A13, A1_INJ_A14, A1_EOI_TF, A1_EOI_ML, A1_EOI_B2, A1_EOI_B3, A1_EOI_B4, A1_EOI_B5, A1_EOI_B6, A1_EOI_B7, A1_EOI_B8, A1_EOI_B9, A1_EOI_B10, A1_EOI_B11, A1_EOI_B12, A1_EOI_B13, A1_EOI_B14, A1_EOI_A3, A1_EOI_A4, A1_EOI_A5, A1_EOI_A6, A1_EOI_A7, A1_EOI_A8, A1_EOI_A9, A1_EOI_A10, A1_EOI_A11, A1_EOI_A12, A1_EOI_A13, A1_EOI_A14, A1_NOM_TF, A1_NOM_ML, A1_NOM_B2, A1_NOM_B3, A1_NOM_B4, A1_NOM_B5, A1_NOM_B6, A1_NOM_B7, A1_NOM_B8, A1_NOM_B9, A1_NOM_B10, A1_NOM_B11, A1_NOM_B12, A1_NOM_B13, A1_NOM_B14, A1_NOM_A3, A1_NOM_A4, A1_NOM_A5, A1_NOM_A6, A1_NOM_A7, A1_NOM_A8, A1_NOM_A9, A1_NOM_A10, A1_NOM_A11, A1_NOM_A12, A1_NOM_A13, A1_NOM_A14, A2_INJ_TF, A2_INJ_ML, A2_INJ_B2, A2_INJ_B3, A2_INJ_B4, A2_INJ_B5, A2_INJ_B6, A2_INJ_B7, A2_INJ_B8, A2_INJ_B9, A2_INJ_B10, A2_INJ_B11, A2_INJ_B12, A2_INJ_B13, A2_INJ_B14, A2_INJ_A3, A2_INJ_A4, A2_INJ_A5, A2_INJ_A6, A2_INJ_A7, A2_INJ_A8, A2_INJ_A9, A2_INJ_A10, A2_INJ_A11, A2_INJ_A12, A2_INJ_A13, A2_INJ_A14, A2_EOI_TF, A2_EOI_ML, A2_EOI_B2, A2_EOI_B3, A2_EOI_B4, A2_EOI_B5, A2_EOI_B6, A2_EOI_B7, A2_EOI_B8, A2_EOI_B9, A2_EOI_B10, A2_EOI_B11, A2_EOI_B12, A2_EOI_B13, A2_EOI_B14, A2_EOI_A3, A2_EOI_A4, A2_EOI_A5, A2_EOI_A6, A2_EOI_A7, A2_EOI_A8, A2_EOI_A9, A2_EOI_A10, A2_EOI_A11, A2_EOI_A12, A2_EOI_A13, A2_EOI_A14, A2_NOM_TF, A2_NOM_ML, A2_NOM_B2, A2_NOM_B3, A2_NOM_B4, A2_NOM_B5, A2_NOM_B6, A2_NOM_B7, A2_NOM_B8, A2_NOM_B9, A2_NOM_B10, A2_NOM_B11, A2_NOM_B12, A2_NOM_B13, A2_NOM_B14, A2_NOM_A3, A2_NOM_A4, A2_NOM_A5, A2_NOM_A6, A2_NOM_A7, A2_NOM_A8, A2_NOM_A9, A2_NOM_A10, A2_NOM_A11, A2_NOM_A12, A2_NOM_A13, A2_NOM_A14) AS
select
x.magnet_name as magnet_name,
TRANFCT_A1_CM.transfer_function * (1 + MQCINFO_WC_OFFSET.A1_INJ_B2 / 10000.0) as A1_INJ_TF,
TRANFCT_A1_CM.field_length * 0.997 + MQCINFO_WC_OFFSET.A1_INJ_ML as A1_INJ_ML,
null as A1_INJ_b2,
INTHARM_A1_CM.normal_3 + MQCINFO_WC_OFFSET.A1_INJ_b3 as A1_INJ_b3,
INTHARM_A1_CM.normal_4 + MQCINFO_WC_OFFSET.A1_INJ_b4 as A1_INJ_b4,
INTHARM_A1_CM.normal_5 + MQCINFO_WC_OFFSET.A1_INJ_b5 as A1_INJ_b5,
INTHARM_A1_CM.normal_6 + MQCINFO_WC_OFFSET.A1_INJ_b6 as A1_INJ_b6,
INTHARM_A1_CM.normal_7 + MQCINFO_WC_OFFSET.A1_INJ_b7 as A1_INJ_b7,
INTHARM_A1_CM.normal_8 + MQCINFO_WC_OFFSET.A1_INJ_b8 as A1_INJ_b8,
INTHARM_A1_CM.normal_9 + MQCINFO_WC_OFFSET.A1_INJ_b9 as A1_INJ_b9,
INTHARM_A1_CM.normal_10 + MQCINFO_WC_OFFSET.A1_INJ_b10 as A1_INJ_b10,
INTHARM_A1_CM.normal_11 + MQCINFO_WC_OFFSET.A1_INJ_b11 as A1_INJ_b11,
INTHARM_A1_CM.normal_12 + MQCINFO_WC_OFFSET.A1_INJ_b12 as A1_INJ_b12,
INTHARM_A1_CM.normal_13 + MQCINFO_WC_OFFSET.A1_INJ_b13 as A1_INJ_b13,
INTHARM_A1_CM.normal_14 + MQCINFO_WC_OFFSET.A1_INJ_b14 as A1_INJ_b14,
INTHARM_A1_CM.skew_3 + MQCINFO_WC_OFFSET.A1_INJ_a3 as A1_INJ_a3,
INTHARM_A1_CM.skew_4 + MQCINFO_WC_OFFSET.A1_INJ_a4 as A1_INJ_a4,
INTHARM_A1_CM.skew_5 + MQCINFO_WC_OFFSET.A1_INJ_a5 as A1_INJ_a5,
INTHARM_A1_CM.skew_6 + MQCINFO_WC_OFFSET.A1_INJ_a6 as A1_INJ_a6,
INTHARM_A1_CM.skew_7 + MQCINFO_WC_OFFSET.A1_INJ_a7 as A1_INJ_a7,
INTHARM_A1_CM.skew_8 + MQCINFO_WC_OFFSET.A1_INJ_a8 as A1_INJ_a8,
INTHARM_A1_CM.skew_9 + MQCINFO_WC_OFFSET.A1_INJ_a9 as A1_INJ_a9,
INTHARM_A1_CM.skew_10 + MQCINFO_WC_OFFSET.A1_INJ_a10 as A1_INJ_a10,
INTHARM_A1_CM.skew_11 + MQCINFO_WC_OFFSET.A1_INJ_a11 as A1_INJ_a11,
INTHARM_A1_CM.skew_12 + MQCINFO_WC_OFFSET.A1_INJ_a12 as A1_INJ_a12,
INTHARM_A1_CM.skew_13 + MQCINFO_WC_OFFSET.A1_INJ_a13 as A1_INJ_a13,
INTHARM_A1_CM.skew_14 + MQCINFO_WC_OFFSET.A1_INJ_a14 as A1_INJ_a14,
TRANFCT_A1_CM.transfer_function * (1 + MQCINFO_WC_OFFSET.A1_EOI_B2 / 10000.0) as A1_EOI_TF,
TRANFCT_A1_CM.field_length * 0.997 + MQCINFO_WC_OFFSET.A1_EOI_ML as A1_EOI_ML,
null as A1_EOI_b2,
INTHARM_A1_CM.normal_3 + MQCINFO_WC_OFFSET.A1_EOI_b3 as A1_EOI_b3,
INTHARM_A1_CM.normal_4 + MQCINFO_WC_OFFSET.A1_EOI_b4 as A1_EOI_b4,
INTHARM_A1_CM.normal_5 + MQCINFO_WC_OFFSET.A1_EOI_b5 as A1_EOI_b5,
INTHARM_A1_CM.normal_6 + MQCINFO_WC_OFFSET.A1_EOI_b6 as A1_EOI_b6,
INTHARM_A1_CM.normal_7 + MQCINFO_WC_OFFSET.A1_EOI_b7 as A1_EOI_b7,
INTHARM_A1_CM.normal_8 + MQCINFO_WC_OFFSET.A1_EOI_b8 as A1_EOI_b8,
INTHARM_A1_CM.normal_9 + MQCINFO_WC_OFFSET.A1_EOI_b9 as A1_EOI_b9,
INTHARM_A1_CM.normal_10 + MQCINFO_WC_OFFSET.A1_EOI_b10 as A1_EOI_b10,
INTHARM_A1_CM.normal_11 + MQCINFO_WC_OFFSET.A1_EOI_b11 as A1_EOI_b11,
INTHARM_A1_CM.normal_12 + MQCINFO_WC_OFFSET.A1_EOI_b12 as A1_EOI_b12,
INTHARM_A1_CM.normal_13 + MQCINFO_WC_OFFSET.A1_EOI_b13 as A1_EOI_b13,
INTHARM_A1_CM.normal_14 + MQCINFO_WC_OFFSET.A1_EOI_b14 as A1_EOI_b14,
INTHARM_A1_CM.skew_3 + MQCINFO_WC_OFFSET.A1_EOI_a3 as A1_EOI_a3,
INTHARM_A1_CM.skew_4 + MQCINFO_WC_OFFSET.A1_EOI_a4 as A1_EOI_a4,
INTHARM_A1_CM.skew_5 + MQCINFO_WC_OFFSET.A1_EOI_a5 as A1_EOI_a5,
INTHARM_A1_CM.skew_6 + MQCINFO_WC_OFFSET.A1_EOI_a6 as A1_EOI_a6,
INTHARM_A1_CM.skew_7 + MQCINFO_WC_OFFSET.A1_EOI_a7 as A1_EOI_a7,
INTHARM_A1_CM.skew_8 + MQCINFO_WC_OFFSET.A1_EOI_a8 as A1_EOI_a8,
INTHARM_A1_CM.skew_9 + MQCINFO_WC_OFFSET.A1_EOI_a9 as A1_EOI_a9,
INTHARM_A1_CM.skew_10 + MQCINFO_WC_OFFSET.A1_EOI_a10 as A1_EOI_a10,
INTHARM_A1_CM.skew_11 + MQCINFO_WC_OFFSET.A1_EOI_a11 as A1_EOI_a11,
INTHARM_A1_CM.skew_12 + MQCINFO_WC_OFFSET.A1_EOI_a12 as A1_EOI_a12,
INTHARM_A1_CM.skew_13 + MQCINFO_WC_OFFSET.A1_EOI_a13 as A1_EOI_a13,
INTHARM_A1_CM.skew_14 + MQCINFO_WC_OFFSET.A1_EOI_a14 as A1_EOI_a14,
TRANFCT_A1_CM.transfer_function * (1 + MQCINFO_WC_OFFSET.A1_NOM_B2 / 10000.0) as A1_NOM_TF,
TRANFCT_A1_CM.field_length * 0.997 + MQCINFO_WC_OFFSET.A1_NOM_ML as A1_NOM_ML,
null as A1_NOM_b2,
INTHARM_A1_CM.normal_3 + MQCINFO_WC_OFFSET.A1_NOM_b3 as A1_NOM_b3,
INTHARM_A1_CM.normal_4 + MQCINFO_WC_OFFSET.A1_NOM_b4 as A1_NOM_b4,
INTHARM_A1_CM.normal_5 + MQCINFO_WC_OFFSET.A1_NOM_b5 as A1_NOM_b5,
INTHARM_A1_CM.normal_6 + MQCINFO_WC_OFFSET.A1_NOM_b6 as A1_NOM_b6,
INTHARM_A1_CM.normal_7 + MQCINFO_WC_OFFSET.A1_NOM_b7 as A1_NOM_b7,
INTHARM_A1_CM.normal_8 + MQCINFO_WC_OFFSET.A1_NOM_b8 as A1_NOM_b8,
INTHARM_A1_CM.normal_9 + MQCINFO_WC_OFFSET.A1_NOM_b9 as A1_NOM_b9,
INTHARM_A1_CM.normal_10 + MQCINFO_WC_OFFSET.A1_NOM_b10 as A1_NOM_b10,
INTHARM_A1_CM.normal_11 + MQCINFO_WC_OFFSET.A1_NOM_b11 as A1_NOM_b11,
INTHARM_A1_CM.normal_12 + MQCINFO_WC_OFFSET.A1_NOM_b12 as A1_NOM_b12,
INTHARM_A1_CM.normal_13 + MQCINFO_WC_OFFSET.A1_NOM_b13 as A1_NOM_b13,
INTHARM_A1_CM.normal_14 + MQCINFO_WC_OFFSET.A1_NOM_b14 as A1_NOM_b14,
INTHARM_A1_CM.skew_3 + MQCINFO_WC_OFFSET.A1_NOM_a3 as A1_NOM_a3,
INTHARM_A1_CM.skew_4 + MQCINFO_WC_OFFSET.A1_NOM_a4 as A1_NOM_a4,
INTHARM_A1_CM.skew_5 + MQCINFO_WC_OFFSET.A1_NOM_a5 as A1_NOM_a5,
INTHARM_A1_CM.skew_6 + MQCINFO_WC_OFFSET.A1_NOM_a6 as A1_NOM_a6,
INTHARM_A1_CM.skew_7 + MQCINFO_WC_OFFSET.A1_NOM_a7 as A1_NOM_a7,
INTHARM_A1_CM.skew_8 + MQCINFO_WC_OFFSET.A1_NOM_a8 as A1_NOM_a8,
INTHARM_A1_CM.skew_9 + MQCINFO_WC_OFFSET.A1_NOM_a9 as A1_NOM_a9,
INTHARM_A1_CM.skew_10 + MQCINFO_WC_OFFSET.A1_NOM_a10 as A1_NOM_a10,
INTHARM_A1_CM.skew_11 + MQCINFO_WC_OFFSET.A1_NOM_a11 as A1_NOM_a11,
INTHARM_A1_CM.skew_12 + MQCINFO_WC_OFFSET.A1_NOM_a12 as A1_NOM_a12,
INTHARM_A1_CM.skew_13 + MQCINFO_WC_OFFSET.A1_NOM_a13 as A1_NOM_a13,
INTHARM_A1_CM.skew_14 + MQCINFO_WC_OFFSET.A1_NOM_a14 as A1_NOM_a14,
TRANFCT_A2_CM.transfer_function * (1 + MQCINFO_WC_OFFSET.A2_INJ_B2 / 10000.0) as A2_INJ_TF,
TRANFCT_A2_CM.field_length * 0.997 + MQCINFO_WC_OFFSET.A2_INJ_ML as A2_INJ_ML,
null as A2_INJ_b2,
INTHARM_A2_CM.normal_3 + MQCINFO_WC_OFFSET.A2_INJ_b3 as A2_INJ_b3,
INTHARM_A2_CM.normal_4 + MQCINFO_WC_OFFSET.A2_INJ_b4 as A2_INJ_b4,
INTHARM_A2_CM.normal_5 + MQCINFO_WC_OFFSET.A2_INJ_b5 as A2_INJ_b5,
INTHARM_A2_CM.normal_6 + MQCINFO_WC_OFFSET.A2_INJ_b6 as A2_INJ_b6,
INTHARM_A2_CM.normal_7 + MQCINFO_WC_OFFSET.A2_INJ_b7 as A2_INJ_b7,
INTHARM_A2_CM.normal_8 + MQCINFO_WC_OFFSET.A2_INJ_b8 as A2_INJ_b8,
INTHARM_A2_CM.normal_9 + MQCINFO_WC_OFFSET.A2_INJ_b9 as A2_INJ_b9,
INTHARM_A2_CM.normal_10 + MQCINFO_WC_OFFSET.A2_INJ_b10 as A2_INJ_b10,
INTHARM_A2_CM.normal_11 + MQCINFO_WC_OFFSET.A2_INJ_b11 as A2_INJ_b11,
INTHARM_A2_CM.normal_12 + MQCINFO_WC_OFFSET.A2_INJ_b12 as A2_INJ_b12,
INTHARM_A2_CM.normal_13 + MQCINFO_WC_OFFSET.A2_INJ_b13 as A2_INJ_b13,
INTHARM_A2_CM.normal_14 + MQCINFO_WC_OFFSET.A2_INJ_b14 as A2_INJ_b14,
INTHARM_A2_CM.skew_3 + MQCINFO_WC_OFFSET.A2_INJ_a3 as A2_INJ_a3,
INTHARM_A2_CM.skew_4 + MQCINFO_WC_OFFSET.A2_INJ_a4 as A2_INJ_a4,
INTHARM_A2_CM.skew_5 + MQCINFO_WC_OFFSET.A2_INJ_a5 as A2_INJ_a5,
INTHARM_A2_CM.skew_6 + MQCINFO_WC_OFFSET.A2_INJ_a6 as A2_INJ_a6,
INTHARM_A2_CM.skew_7 + MQCINFO_WC_OFFSET.A2_INJ_a7 as A2_INJ_a7,
INTHARM_A2_CM.skew_8 + MQCINFO_WC_OFFSET.A2_INJ_a8 as A2_INJ_a8,
INTHARM_A2_CM.skew_9 + MQCINFO_WC_OFFSET.A2_INJ_a9 as A2_INJ_a9,
INTHARM_A2_CM.skew_10 + MQCINFO_WC_OFFSET.A2_INJ_a10 as A2_INJ_a10,
INTHARM_A2_CM.skew_11 + MQCINFO_WC_OFFSET.A2_INJ_a11 as A2_INJ_a11,
INTHARM_A2_CM.skew_12 + MQCINFO_WC_OFFSET.A2_INJ_a12 as A2_INJ_a12,
INTHARM_A2_CM.skew_13 + MQCINFO_WC_OFFSET.A2_INJ_a13 as A2_INJ_a13,
INTHARM_A2_CM.skew_14 + MQCINFO_WC_OFFSET.A2_INJ_a14 as A2_INJ_a14,
TRANFCT_A2_CM.transfer_function * (1 + MQCINFO_WC_OFFSET.A2_EOI_B2 / 10000.0) as A2_EOI_TF,
TRANFCT_A2_CM.field_length * 0.997 + MQCINFO_WC_OFFSET.A2_EOI_ML as A2_EOI_ML,
null as A2_EOI_b2,
INTHARM_A2_CM.normal_3 + MQCINFO_WC_OFFSET.A2_EOI_b3 as A2_EOI_b3,
INTHARM_A2_CM.normal_4 + MQCINFO_WC_OFFSET.A2_EOI_b4 as A2_EOI_b4,
INTHARM_A2_CM.normal_5 + MQCINFO_WC_OFFSET.A2_EOI_b5 as A2_EOI_b5,
INTHARM_A2_CM.normal_6 + MQCINFO_WC_OFFSET.A2_EOI_b6 as A2_EOI_b6,
INTHARM_A2_CM.normal_7 + MQCINFO_WC_OFFSET.A2_EOI_b7 as A2_EOI_b7,
INTHARM_A2_CM.normal_8 + MQCINFO_WC_OFFSET.A2_EOI_b8 as A2_EOI_b8,
INTHARM_A2_CM.normal_9 + MQCINFO_WC_OFFSET.A2_EOI_b9 as A2_EOI_b9,
INTHARM_A2_CM.normal_10 + MQCINFO_WC_OFFSET.A2_EOI_b10 as A2_EOI_b10,
INTHARM_A2_CM.normal_11 + MQCINFO_WC_OFFSET.A2_EOI_b11 as A2_EOI_b11,
INTHARM_A2_CM.normal_12 + MQCINFO_WC_OFFSET.A2_EOI_b12 as A2_EOI_b12,
INTHARM_A2_CM.normal_13 + MQCINFO_WC_OFFSET.A2_EOI_b13 as A2_EOI_b13,
INTHARM_A2_CM.normal_14 + MQCINFO_WC_OFFSET.A2_EOI_b14 as A2_EOI_b14,
INTHARM_A2_CM.skew_3 + MQCINFO_WC_OFFSET.A2_EOI_a3 as A2_EOI_a3,
INTHARM_A2_CM.skew_4 + MQCINFO_WC_OFFSET.A2_EOI_a4 as A2_EOI_a4,
INTHARM_A2_CM.skew_5 + MQCINFO_WC_OFFSET.A2_EOI_a5 as A2_EOI_a5,
INTHARM_A2_CM.skew_6 + MQCINFO_WC_OFFSET.A2_EOI_a6 as A2_EOI_a6,
INTHARM_A2_CM.skew_7 + MQCINFO_WC_OFFSET.A2_EOI_a7 as A2_EOI_a7,
INTHARM_A2_CM.skew_8 + MQCINFO_WC_OFFSET.A2_EOI_a8 as A2_EOI_a8,
INTHARM_A2_CM.skew_9 + MQCINFO_WC_OFFSET.A2_EOI_a9 as A2_EOI_a9,
INTHARM_A2_CM.skew_10 + MQCINFO_WC_OFFSET.A2_EOI_a10 as A2_EOI_a10,
INTHARM_A2_CM.skew_11 + MQCINFO_WC_OFFSET.A2_EOI_a11 as A2_EOI_a11,
INTHARM_A2_CM.skew_12 + MQCINFO_WC_OFFSET.A2_EOI_a12 as A2_EOI_a12,
INTHARM_A2_CM.skew_13 + MQCINFO_WC_OFFSET.A2_EOI_a13 as A2_EOI_a13,
INTHARM_A2_CM.skew_14 + MQCINFO_WC_OFFSET.A2_EOI_a14 as A2_EOI_a14,
TRANFCT_A2_CM.transfer_function * (1 + MQCINFO_WC_OFFSET.A2_NOM_B2 / 10000.0) as A2_NOM_TF,
TRANFCT_A2_CM.field_length * 0.997 + MQCINFO_WC_OFFSET.A2_NOM_ML as A2_NOM_ML,
null as A2_NOM_b2,
INTHARM_A2_CM.normal_3 + MQCINFO_WC_OFFSET.A2_NOM_b3 as A2_NOM_b3,
INTHARM_A2_CM.normal_4 + MQCINFO_WC_OFFSET.A2_NOM_b4 as A2_NOM_b4,
INTHARM_A2_CM.normal_5 + MQCINFO_WC_OFFSET.A2_NOM_b5 as A2_NOM_b5,
INTHARM_A2_CM.normal_6 + MQCINFO_WC_OFFSET.A2_NOM_b6 as A2_NOM_b6,
INTHARM_A2_CM.normal_7 + MQCINFO_WC_OFFSET.A2_NOM_b7 as A2_NOM_b7,
INTHARM_A2_CM.normal_8 + MQCINFO_WC_OFFSET.A2_NOM_b8 as A2_NOM_b8,
INTHARM_A2_CM.normal_9 + MQCINFO_WC_OFFSET.A2_NOM_b9 as A2_NOM_b9,
INTHARM_A2_CM.normal_10 + MQCINFO_WC_OFFSET.A2_NOM_b10 as A2_NOM_b10,
INTHARM_A2_CM.normal_11 + MQCINFO_WC_OFFSET.A2_NOM_b11 as A2_NOM_b11,
INTHARM_A2_CM.normal_12 + MQCINFO_WC_OFFSET.A2_NOM_b12 as A2_NOM_b12,
INTHARM_A2_CM.normal_13 + MQCINFO_WC_OFFSET.A2_NOM_b13 as A2_NOM_b13,
INTHARM_A2_CM.normal_14 + MQCINFO_WC_OFFSET.A2_NOM_b14 as A2_NOM_b14,
INTHARM_A2_CM.skew_3 + MQCINFO_WC_OFFSET.A2_NOM_a3 as A2_NOM_a3,
INTHARM_A2_CM.skew_4 + MQCINFO_WC_OFFSET.A2_NOM_a4 as A2_NOM_a4,
INTHARM_A2_CM.skew_5 + MQCINFO_WC_OFFSET.A2_NOM_a5 as A2_NOM_a5,
INTHARM_A2_CM.skew_6 + MQCINFO_WC_OFFSET.A2_NOM_a6 as A2_NOM_a6,
INTHARM_A2_CM.skew_7 + MQCINFO_WC_OFFSET.A2_NOM_a7 as A2_NOM_a7,
INTHARM_A2_CM.skew_8 + MQCINFO_WC_OFFSET.A2_NOM_a8 as A2_NOM_a8,
INTHARM_A2_CM.skew_9 + MQCINFO_WC_OFFSET.A2_NOM_a9 as A2_NOM_a9,
INTHARM_A2_CM.skew_10 + MQCINFO_WC_OFFSET.A2_NOM_a10 as A2_NOM_a10,
INTHARM_A2_CM.skew_11 + MQCINFO_WC_OFFSET.A2_NOM_a11 as A2_NOM_a11,
INTHARM_A2_CM.skew_12 + MQCINFO_WC_OFFSET.A2_NOM_a12 as A2_NOM_a12,
INTHARM_A2_CM.skew_13 + MQCINFO_WC_OFFSET.A2_NOM_a13 as A2_NOM_a13,
INTHARM_A2_CM.skew_14 + MQCINFO_WC_OFFSET.A2_NOM_a14 as A2_NOM_a14
from
mv_all_mqm_names x,
TRANFCT_A1_CM_MTM TRANFCT_A1_CM,
TRANFCT_A2_CM_MTM TRANFCT_A2_CM,
INTHARM_A1_CM_MTM INTHARM_A1_CM,
INTHARM_A2_CM_MTM INTHARM_A2_CM,
MQCINFO mqcinfo_ref_fld,
MQCINFO mqcinfo_wc_offset
where x.magnet_name = TRANFCT_A1_CM.magnet_name(+)
and x.magnet_name = TRANFCT_A2_CM.magnet_name(+)
and x.magnet_name = INTHARM_A1_CM.magnet_name(+)
and x.magnet_name = INTHARM_A2_CM.magnet_name(+)
and 'HCMQM19_WC_OFFSET' = mqcinfo_wc_offset.magnet_name
and 'HCMQM19_REF_FLD' = mqcinfo_ref_fld.magnet_name;

NEW VERSION

CREATE OR REPLACE VIEW MQM19CVIEW_WARM_WITH_NULLS (MAGNET_NAME, MEASDATE, A1_INJ_TF, A1_INJ_ML, A1_INJ_B2, A1_INJ_B3, A1_INJ_B4, A1_INJ_B5, A1_INJ_B6, A1_INJ_B7, A1_INJ_B8, A1_INJ_B9, A1_INJ_B10, A1_INJ_B11, A1_INJ_B12, A1_INJ_B13, A1_INJ_B14, A1_INJ_A3, A1_INJ_A4, A1_INJ_A5, A1_INJ_A6, A1_INJ_A7, A1_INJ_A8, A1_INJ_A9, A1_INJ_A10, A1_INJ_A11, A1_INJ_A12, A1_INJ_A13, A1_INJ_A14, A1_EOI_TF, A1_EOI_ML, A1_EOI_B2, A1_EOI_B3, A1_EOI_B4, A1_EOI_B5, A1_EOI_B6, A1_EOI_B7, A1_EOI_B8, A1_EOI_B9, A1_EOI_B10, A1_EOI_B11, A1_EOI_B12, A1_EOI_B13, A1_EOI_B14, A1_EOI_A3, A1_EOI_A4, A1_EOI_A5, A1_EOI_A6, A1_EOI_A7, A1_EOI_A8, A1_EOI_A9, A1_EOI_A10, A1_EOI_A11, A1_EOI_A12, A1_EOI_A13, A1_EOI_A14, A1_NOM_TF, A1_NOM_ML, A1_NOM_B2, A1_NOM_B3, A1_NOM_B4, A1_NOM_B5, A1_NOM_B6, A1_NOM_B7, A1_NOM_B8, A1_NOM_B9, A1_NOM_B10, A1_NOM_B11, A1_NOM_B12, A1_NOM_B13, A1_NOM_B14, A1_NOM_A3, A1_NOM_A4, A1_NOM_A5, A1_NOM_A6, A1_NOM_A7, A1_NOM_A8, A1_NOM_A9, A1_NOM_A10, A1_NOM_A11, A1_NOM_A12, A1_NOM_A13, A1_NOM_A14, A2_INJ_TF, A2_INJ_ML, A2_INJ_B2, A2_INJ_B3, A2_INJ_B4, A2_INJ_B5, A2_INJ_B6, A2_INJ_B7, A2_INJ_B8, A2_INJ_B9, A2_INJ_B10, A2_INJ_B11, A2_INJ_B12, A2_INJ_B13, A2_INJ_B14, A2_INJ_A3, A2_INJ_A4, A2_INJ_A5, A2_INJ_A6, A2_INJ_A7, A2_INJ_A8, A2_INJ_A9, A2_INJ_A10, A2_INJ_A11, A2_INJ_A12, A2_INJ_A13, A2_INJ_A14, A2_EOI_TF, A2_EOI_ML, A2_EOI_B2, A2_EOI_B3, A2_EOI_B4, A2_EOI_B5, A2_EOI_B6, A2_EOI_B7, A2_EOI_B8, A2_EOI_B9, A2_EOI_B10, A2_EOI_B11, A2_EOI_B12, A2_EOI_B13, A2_EOI_B14, A2_EOI_A3, A2_EOI_A4, A2_EOI_A5, A2_EOI_A6, A2_EOI_A7, A2_EOI_A8, A2_EOI_A9, A2_EOI_A10, A2_EOI_A11, A2_EOI_A12, A2_EOI_A13, A2_EOI_A14, A2_NOM_TF, A2_NOM_ML, A2_NOM_B2, A2_NOM_B3, A2_NOM_B4, A2_NOM_B5, A2_NOM_B6, A2_NOM_B7, A2_NOM_B8, A2_NOM_B9, A2_NOM_B10, A2_NOM_B11, A2_NOM_B12, A2_NOM_B13, A2_NOM_B14, A2_NOM_A3, A2_NOM_A4, A2_NOM_A5, A2_NOM_A6, A2_NOM_A7, A2_NOM_A8, A2_NOM_A9, A2_NOM_A10, A2_NOM_A11, A2_NOM_A12, A2_NOM_A13, A2_NOM_A14) AS
select
x.magnet_name as magnet_name,
MOST_RECENT_DATE_4(
TRANFCT_A1_CM.login_date,
TRANFCT_A2_CM.login_date,
INTHARM_A1_CM.login_date,
INTHARM_A2_CM.login_date) as measdate,
TRANFCT_A1_CM.transfer_function * (1 + MQCINFO_WC_OFFSET.A1_INJ_B2 / 10000.0) as A1_INJ_TF,
TRANFCT_A1_CM.field_length * 0.997 + MQCINFO_WC_OFFSET.A1_INJ_ML as A1_INJ_ML,
null as A1_INJ_b2,
INTHARM_A1_CM.normal_3 + MQCINFO_WC_OFFSET.A1_INJ_b3 as A1_INJ_b3,
INTHARM_A1_CM.normal_4 + MQCINFO_WC_OFFSET.A1_INJ_b4 as A1_INJ_b4,
INTHARM_A1_CM.normal_5 + MQCINFO_WC_OFFSET.A1_INJ_b5 as A1_INJ_b5,
INTHARM_A1_CM.normal_6 + MQCINFO_WC_OFFSET.A1_INJ_b6 as A1_INJ_b6,
INTHARM_A1_CM.normal_7 + MQCINFO_WC_OFFSET.A1_INJ_b7 as A1_INJ_b7,
INTHARM_A1_CM.normal_8 + MQCINFO_WC_OFFSET.A1_INJ_b8 as A1_INJ_b8,
INTHARM_A1_CM.normal_9 + MQCINFO_WC_OFFSET.A1_INJ_b9 as A1_INJ_b9,
INTHARM_A1_CM.normal_10 + MQCINFO_WC_OFFSET.A1_INJ_b10 as A1_INJ_b10,
INTHARM_A1_CM.normal_11 + MQCINFO_WC_OFFSET.A1_INJ_b11 as A1_INJ_b11,
INTHARM_A1_CM.normal_12 + MQCINFO_WC_OFFSET.A1_INJ_b12 as A1_INJ_b12,
INTHARM_A1_CM.normal_13 + MQCINFO_WC_OFFSET.A1_INJ_b13 as A1_INJ_b13,
INTHARM_A1_CM.normal_14 + MQCINFO_WC_OFFSET.A1_INJ_b14 as A1_INJ_b14,
INTHARM_A1_CM.skew_3 + MQCINFO_WC_OFFSET.A1_INJ_a3 as A1_INJ_a3,
INTHARM_A1_CM.skew_4 + MQCINFO_WC_OFFSET.A1_INJ_a4 as A1_INJ_a4,
INTHARM_A1_CM.skew_5 + MQCINFO_WC_OFFSET.A1_INJ_a5 as A1_INJ_a5,
INTHARM_A1_CM.skew_6 + MQCINFO_WC_OFFSET.A1_INJ_a6 as A1_INJ_a6,
INTHARM_A1_CM.skew_7 + MQCINFO_WC_OFFSET.A1_INJ_a7 as A1_INJ_a7,
INTHARM_A1_CM.skew_8 + MQCINFO_WC_OFFSET.A1_INJ_a8 as A1_INJ_a8,
INTHARM_A1_CM.skew_9 + MQCINFO_WC_OFFSET.A1_INJ_a9 as A1_INJ_a9,
INTHARM_A1_CM.skew_10 + MQCINFO_WC_OFFSET.A1_INJ_a10 as A1_INJ_a10,
INTHARM_A1_CM.skew_11 + MQCINFO_WC_OFFSET.A1_INJ_a11 as A1_INJ_a11,
INTHARM_A1_CM.skew_12 + MQCINFO_WC_OFFSET.A1_INJ_a12 as A1_INJ_a12,
INTHARM_A1_CM.skew_13 + MQCINFO_WC_OFFSET.A1_INJ_a13 as A1_INJ_a13,
INTHARM_A1_CM.skew_14 + MQCINFO_WC_OFFSET.A1_INJ_a14 as A1_INJ_a14,
TRANFCT_A1_CM.transfer_function * (1 + MQCINFO_WC_OFFSET.A1_EOI_B2 / 10000.0) as A1_EOI_TF,
TRANFCT_A1_CM.field_length * 0.997 + MQCINFO_WC_OFFSET.A1_EOI_ML as A1_EOI_ML,
null as A1_EOI_b2,
INTHARM_A1_CM.normal_3 + MQCINFO_WC_OFFSET.A1_EOI_b3 as A1_EOI_b3,
INTHARM_A1_CM.normal_4 + MQCINFO_WC_OFFSET.A1_EOI_b4 as A1_EOI_b4,
INTHARM_A1_CM.normal_5 + MQCINFO_WC_OFFSET.A1_EOI_b5 as A1_EOI_b5,
INTHARM_A1_CM.normal_6 + MQCINFO_WC_OFFSET.A1_EOI_b6 as A1_EOI_b6,
INTHARM_A1_CM.normal_7 + MQCINFO_WC_OFFSET.A1_EOI_b7 as A1_EOI_b7,
INTHARM_A1_CM.normal_8 + MQCINFO_WC_OFFSET.A1_EOI_b8 as A1_EOI_b8,
INTHARM_A1_CM.normal_9 + MQCINFO_WC_OFFSET.A1_EOI_b9 as A1_EOI_b9,
INTHARM_A1_CM.normal_10 + MQCINFO_WC_OFFSET.A1_EOI_b10 as A1_EOI_b10,
INTHARM_A1_CM.normal_11 + MQCINFO_WC_OFFSET.A1_EOI_b11 as A1_EOI_b11,
INTHARM_A1_CM.normal_12 + MQCINFO_WC_OFFSET.A1_EOI_b12 as A1_EOI_b12,
INTHARM_A1_CM.normal_13 + MQCINFO_WC_OFFSET.A1_EOI_b13 as A1_EOI_b13,
INTHARM_A1_CM.normal_14 + MQCINFO_WC_OFFSET.A1_EOI_b14 as A1_EOI_b14,
INTHARM_A1_CM.skew_3 + MQCINFO_WC_OFFSET.A1_EOI_a3 as A1_EOI_a3,
INTHARM_A1_CM.skew_4 + MQCINFO_WC_OFFSET.A1_EOI_a4 as A1_EOI_a4,
INTHARM_A1_CM.skew_5 + MQCINFO_WC_OFFSET.A1_EOI_a5 as A1_EOI_a5,
INTHARM_A1_CM.skew_6 + MQCINFO_WC_OFFSET.A1_EOI_a6 as A1_EOI_a6,
INTHARM_A1_CM.skew_7 + MQCINFO_WC_OFFSET.A1_EOI_a7 as A1_EOI_a7,
INTHARM_A1_CM.skew_8 + MQCINFO_WC_OFFSET.A1_EOI_a8 as A1_EOI_a8,
INTHARM_A1_CM.skew_9 + MQCINFO_WC_OFFSET.A1_EOI_a9 as A1_EOI_a9,
INTHARM_A1_CM.skew_10 + MQCINFO_WC_OFFSET.A1_EOI_a10 as A1_EOI_a10,
INTHARM_A1_CM.skew_11 + MQCINFO_WC_OFFSET.A1_EOI_a11 as A1_EOI_a11,
INTHARM_A1_CM.skew_12 + MQCINFO_WC_OFFSET.A1_EOI_a12 as A1_EOI_a12,
INTHARM_A1_CM.skew_13 + MQCINFO_WC_OFFSET.A1_EOI_a13 as A1_EOI_a13,
INTHARM_A1_CM.skew_14 + MQCINFO_WC_OFFSET.A1_EOI_a14 as A1_EOI_a14,
TRANFCT_A1_CM.transfer_function * (1 + MQCINFO_WC_OFFSET.A1_NOM_B2 / 10000.0) as A1_NOM_TF,
TRANFCT_A1_CM.field_length * 0.997 + MQCINFO_WC_OFFSET.A1_NOM_ML as A1_NOM_ML,
null as A1_NOM_b2,
INTHARM_A1_CM.normal_3 + MQCINFO_WC_OFFSET.A1_NOM_b3 as A1_NOM_b3,
INTHARM_A1_CM.normal_4 + MQCINFO_WC_OFFSET.A1_NOM_b4 as A1_NOM_b4,
INTHARM_A1_CM.normal_5 + MQCINFO_WC_OFFSET.A1_NOM_b5 as A1_NOM_b5,
INTHARM_A1_CM.normal_6 + MQCINFO_WC_OFFSET.A1_NOM_b6 as A1_NOM_b6,
INTHARM_A1_CM.normal_7 + MQCINFO_WC_OFFSET.A1_NOM_b7 as A1_NOM_b7,
INTHARM_A1_CM.normal_8 + MQCINFO_WC_OFFSET.A1_NOM_b8 as A1_NOM_b8,
INTHARM_A1_CM.normal_9 + MQCINFO_WC_OFFSET.A1_NOM_b9 as A1_NOM_b9,
INTHARM_A1_CM.normal_10 + MQCINFO_WC_OFFSET.A1_NOM_b10 as A1_NOM_b10,
INTHARM_A1_CM.normal_11 + MQCINFO_WC_OFFSET.A1_NOM_b11 as A1_NOM_b11,
INTHARM_A1_CM.normal_12 + MQCINFO_WC_OFFSET.A1_NOM_b12 as A1_NOM_b12,
INTHARM_A1_CM.normal_13 + MQCINFO_WC_OFFSET.A1_NOM_b13 as A1_NOM_b13,
INTHARM_A1_CM.normal_14 + MQCINFO_WC_OFFSET.A1_NOM_b14 as A1_NOM_b14,
INTHARM_A1_CM.skew_3 + MQCINFO_WC_OFFSET.A1_NOM_a3 as A1_NOM_a3,
INTHARM_A1_CM.skew_4 + MQCINFO_WC_OFFSET.A1_NOM_a4 as A1_NOM_a4,
INTHARM_A1_CM.skew_5 + MQCINFO_WC_OFFSET.A1_NOM_a5 as A1_NOM_a5,
INTHARM_A1_CM.skew_6 + MQCINFO_WC_OFFSET.A1_NOM_a6 as A1_NOM_a6,
INTHARM_A1_CM.skew_7 + MQCINFO_WC_OFFSET.A1_NOM_a7 as A1_NOM_a7,
INTHARM_A1_CM.skew_8 + MQCINFO_WC_OFFSET.A1_NOM_a8 as A1_NOM_a8,
INTHARM_A1_CM.skew_9 + MQCINFO_WC_OFFSET.A1_NOM_a9 as A1_NOM_a9,
INTHARM_A1_CM.skew_10 + MQCINFO_WC_OFFSET.A1_NOM_a10 as A1_NOM_a10,
INTHARM_A1_CM.skew_11 + MQCINFO_WC_OFFSET.A1_NOM_a11 as A1_NOM_a11,
INTHARM_A1_CM.skew_12 + MQCINFO_WC_OFFSET.A1_NOM_a12 as A1_NOM_a12,
INTHARM_A1_CM.skew_13 + MQCINFO_WC_OFFSET.A1_NOM_a13 as A1_NOM_a13,
INTHARM_A1_CM.skew_14 + MQCINFO_WC_OFFSET.A1_NOM_a14 as A1_NOM_a14,
TRANFCT_A2_CM.transfer_function * (1 + MQCINFO_WC_OFFSET.A2_INJ_B2 / 10000.0) as A2_INJ_TF,
TRANFCT_A2_CM.field_length * 0.997 + MQCINFO_WC_OFFSET.A2_INJ_ML as A2_INJ_ML,
null as A2_INJ_b2,
INTHARM_A2_CM.normal_3 + MQCINFO_WC_OFFSET.A2_INJ_b3 as A2_INJ_b3,
INTHARM_A2_CM.normal_4 + MQCINFO_WC_OFFSET.A2_INJ_b4 as A2_INJ_b4,
INTHARM_A2_CM.normal_5 + MQCINFO_WC_OFFSET.A2_INJ_b5 as A2_INJ_b5,
INTHARM_A2_CM.normal_6 + MQCINFO_WC_OFFSET.A2_INJ_b6 as A2_INJ_b6,
INTHARM_A2_CM.normal_7 + MQCINFO_WC_OFFSET.A2_INJ_b7 as A2_INJ_b7,
INTHARM_A2_CM.normal_8 + MQCINFO_WC_OFFSET.A2_INJ_b8 as A2_INJ_b8,
INTHARM_A2_CM.normal_9 + MQCINFO_WC_OFFSET.A2_INJ_b9 as A2_INJ_b9,
INTHARM_A2_CM.normal_10 + MQCINFO_WC_OFFSET.A2_INJ_b10 as A2_INJ_b10,
INTHARM_A2_CM.normal_11 + MQCINFO_WC_OFFSET.A2_INJ_b11 as A2_INJ_b11,
INTHARM_A2_CM.normal_12 + MQCINFO_WC_OFFSET.A2_INJ_b12 as A2_INJ_b12,
INTHARM_A2_CM.normal_13 + MQCINFO_WC_OFFSET.A2_INJ_b13 as A2_INJ_b13,
INTHARM_A2_CM.normal_14 + MQCINFO_WC_OFFSET.A2_INJ_b14 as A2_INJ_b14,
INTHARM_A2_CM.skew_3 + MQCINFO_WC_OFFSET.A2_INJ_a3 as A2_INJ_a3,
INTHARM_A2_CM.skew_4 + MQCINFO_WC_OFFSET.A2_INJ_a4 as A2_INJ_a4,
INTHARM_A2_CM.skew_5 + MQCINFO_WC_OFFSET.A2_INJ_a5 as A2_INJ_a5,
INTHARM_A2_CM.skew_6 + MQCINFO_WC_OFFSET.A2_INJ_a6 as A2_INJ_a6,
INTHARM_A2_CM.skew_7 + MQCINFO_WC_OFFSET.A2_INJ_a7 as A2_INJ_a7,
INTHARM_A2_CM.skew_8 + MQCINFO_WC_OFFSET.A2_INJ_a8 as A2_INJ_a8,
INTHARM_A2_CM.skew_9 + MQCINFO_WC_OFFSET.A2_INJ_a9 as A2_INJ_a9,
INTHARM_A2_CM.skew_10 + MQCINFO_WC_OFFSET.A2_INJ_a10 as A2_INJ_a10,
INTHARM_A2_CM.skew_11 + MQCINFO_WC_OFFSET.A2_INJ_a11 as A2_INJ_a11,
INTHARM_A2_CM.skew_12 + MQCINFO_WC_OFFSET.A2_INJ_a12 as A2_INJ_a12,
INTHARM_A2_CM.skew_13 + MQCINFO_WC_OFFSET.A2_INJ_a13 as A2_INJ_a13,
INTHARM_A2_CM.skew_14 + MQCINFO_WC_OFFSET.A2_INJ_a14 as A2_INJ_a14,
TRANFCT_A2_CM.transfer_function * (1 + MQCINFO_WC_OFFSET.A2_EOI_B2 / 10000.0) as A2_EOI_TF,
TRANFCT_A2_CM.field_length * 0.997 + MQCINFO_WC_OFFSET.A2_EOI_ML as A2_EOI_ML,
null as A2_EOI_b2,
INTHARM_A2_CM.normal_3 + MQCINFO_WC_OFFSET.A2_EOI_b3 as A2_EOI_b3,
INTHARM_A2_CM.normal_4 + MQCINFO_WC_OFFSET.A2_EOI_b4 as A2_EOI_b4,
INTHARM_A2_CM.normal_5 + MQCINFO_WC_OFFSET.A2_EOI_b5 as A2_EOI_b5,
INTHARM_A2_CM.normal_6 + MQCINFO_WC_OFFSET.A2_EOI_b6 as A2_EOI_b6,
INTHARM_A2_CM.normal_7 + MQCINFO_WC_OFFSET.A2_EOI_b7 as A2_EOI_b7,
INTHARM_A2_CM.normal_8 + MQCINFO_WC_OFFSET.A2_EOI_b8 as A2_EOI_b8,
INTHARM_A2_CM.normal_9 + MQCINFO_WC_OFFSET.A2_EOI_b9 as A2_EOI_b9,
INTHARM_A2_CM.normal_10 + MQCINFO_WC_OFFSET.A2_EOI_b10 as A2_EOI_b10,
INTHARM_A2_CM.normal_11 + MQCINFO_WC_OFFSET.A2_EOI_b11 as A2_EOI_b11,
INTHARM_A2_CM.normal_12 + MQCINFO_WC_OFFSET.A2_EOI_b12 as A2_EOI_b12,
INTHARM_A2_CM.normal_13 + MQCINFO_WC_OFFSET.A2_EOI_b13 as A2_EOI_b13,
INTHARM_A2_CM.normal_14 + MQCINFO_WC_OFFSET.A2_EOI_b14 as A2_EOI_b14,
INTHARM_A2_CM.skew_3 + MQCINFO_WC_OFFSET.A2_EOI_a3 as A2_EOI_a3,
INTHARM_A2_CM.skew_4 + MQCINFO_WC_OFFSET.A2_EOI_a4 as A2_EOI_a4,
INTHARM_A2_CM.skew_5 + MQCINFO_WC_OFFSET.A2_EOI_a5 as A2_EOI_a5,
INTHARM_A2_CM.skew_6 + MQCINFO_WC_OFFSET.A2_EOI_a6 as A2_EOI_a6,
INTHARM_A2_CM.skew_7 + MQCINFO_WC_OFFSET.A2_EOI_a7 as A2_EOI_a7,
INTHARM_A2_CM.skew_8 + MQCINFO_WC_OFFSET.A2_EOI_a8 as A2_EOI_a8,
INTHARM_A2_CM.skew_9 + MQCINFO_WC_OFFSET.A2_EOI_a9 as A2_EOI_a9,
INTHARM_A2_CM.skew_10 + MQCINFO_WC_OFFSET.A2_EOI_a10 as A2_EOI_a10,
INTHARM_A2_CM.skew_11 + MQCINFO_WC_OFFSET.A2_EOI_a11 as A2_EOI_a11,
INTHARM_A2_CM.skew_12 + MQCINFO_WC_OFFSET.A2_EOI_a12 as A2_EOI_a12,
INTHARM_A2_CM.skew_13 + MQCINFO_WC_OFFSET.A2_EOI_a13 as A2_EOI_a13,
INTHARM_A2_CM.skew_14 + MQCINFO_WC_OFFSET.A2_EOI_a14 as A2_EOI_a14,
TRANFCT_A2_CM.transfer_function * (1 + MQCINFO_WC_OFFSET.A2_NOM_B2 / 10000.0) as A2_NOM_TF,
TRANFCT_A2_CM.field_length * 0.997 + MQCINFO_WC_OFFSET.A2_NOM_ML as A2_NOM_ML,
null as A2_NOM_b2,
INTHARM_A2_CM.normal_3 + MQCINFO_WC_OFFSET.A2_NOM_b3 as A2_NOM_b3,
INTHARM_A2_CM.normal_4 + MQCINFO_WC_OFFSET.A2_NOM_b4 as A2_NOM_b4,
INTHARM_A2_CM.normal_5 + MQCINFO_WC_OFFSET.A2_NOM_b5 as A2_NOM_b5,
INTHARM_A2_CM.normal_6 + MQCINFO_WC_OFFSET.A2_NOM_b6 as A2_NOM_b6,
INTHARM_A2_CM.normal_7 + MQCINFO_WC_OFFSET.A2_NOM_b7 as A2_NOM_b7,
INTHARM_A2_CM.normal_8 + MQCINFO_WC_OFFSET.A2_NOM_b8 as A2_NOM_b8,
INTHARM_A2_CM.normal_9 + MQCINFO_WC_OFFSET.A2_NOM_b9 as A2_NOM_b9,
INTHARM_A2_CM.normal_10 + MQCINFO_WC_OFFSET.A2_NOM_b10 as A2_NOM_b10,
INTHARM_A2_CM.normal_11 + MQCINFO_WC_OFFSET.A2_NOM_b11 as A2_NOM_b11,
INTHARM_A2_CM.normal_12 + MQCINFO_WC_OFFSET.A2_NOM_b12 as A2_NOM_b12,
INTHARM_A2_CM.normal_13 + MQCINFO_WC_OFFSET.A2_NOM_b13 as A2_NOM_b13,
INTHARM_A2_CM.normal_14 + MQCINFO_WC_OFFSET.A2_NOM_b14 as A2_NOM_b14,
INTHARM_A2_CM.skew_3 + MQCINFO_WC_OFFSET.A2_NOM_a3 as A2_NOM_a3,
INTHARM_A2_CM.skew_4 + MQCINFO_WC_OFFSET.A2_NOM_a4 as A2_NOM_a4,
INTHARM_A2_CM.skew_5 + MQCINFO_WC_OFFSET.A2_NOM_a5 as A2_NOM_a5,
INTHARM_A2_CM.skew_6 + MQCINFO_WC_OFFSET.A2_NOM_a6 as A2_NOM_a6,
INTHARM_A2_CM.skew_7 + MQCINFO_WC_OFFSET.A2_NOM_a7 as A2_NOM_a7,
INTHARM_A2_CM.skew_8 + MQCINFO_WC_OFFSET.A2_NOM_a8 as A2_NOM_a8,
INTHARM_A2_CM.skew_9 + MQCINFO_WC_OFFSET.A2_NOM_a9 as A2_NOM_a9,
INTHARM_A2_CM.skew_10 + MQCINFO_WC_OFFSET.A2_NOM_a10 as A2_NOM_a10,
INTHARM_A2_CM.skew_11 + MQCINFO_WC_OFFSET.A2_NOM_a11 as A2_NOM_a11,
INTHARM_A2_CM.skew_12 + MQCINFO_WC_OFFSET.A2_NOM_a12 as A2_NOM_a12,
INTHARM_A2_CM.skew_13 + MQCINFO_WC_OFFSET.A2_NOM_a13 as A2_NOM_a13,
INTHARM_A2_CM.skew_14 + MQCINFO_WC_OFFSET.A2_NOM_a14 as A2_NOM_a14
from
mv_all_mqm_names x,
TRANFCT_A1_CM_MTM TRANFCT_A1_CM,
TRANFCT_A2_CM_MTM TRANFCT_A2_CM,
INTHARM_A1_CM_MTM INTHARM_A1_CM,
INTHARM_A2_CM_MTM INTHARM_A2_CM,
MQCINFO mqcinfo_ref_fld,
MQCINFO mqcinfo_wc_offset
where x.magnet_name = TRANFCT_A1_CM.magnet_name(+)
and x.magnet_name = TRANFCT_A2_CM.magnet_name(+)
and x.magnet_name = INTHARM_A1_CM.magnet_name(+)
and x.magnet_name = INTHARM_A2_CM.magnet_name(+)
and 'HCMQM19_WC_OFFSET' = mqcinfo_wc_offset.magnet_name
and 'HCMQM19_REF_FLD' = mqcinfo_ref_fld.magnet_name;