OLD VERSION

CREATE OR REPLACE VIEW MQCVIEW (MAGNET_NAME, A1_INJ_TF, A1_INJ_ML, A1_INJ_FD, 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_FD, 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_EOR_TF, A1_EOR_ML, A1_EOR_FD, A1_EOR_B2, A1_EOR_B3, A1_EOR_B4, A1_EOR_B5, A1_EOR_B6, A1_EOR_B7, A1_EOR_B8, A1_EOR_B9, A1_EOR_B10, A1_EOR_B11, A1_EOR_B12, A1_EOR_B13, A1_EOR_B14, A1_EOR_A3, A1_EOR_A4, A1_EOR_A5, A1_EOR_A6, A1_EOR_A7, A1_EOR_A8, A1_EOR_A9, A1_EOR_A10, A1_EOR_A11, A1_EOR_A12, A1_EOR_A13, A1_EOR_A14, A1_NOM_TF, A1_NOM_ML, A1_NOM_FD, 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_FD, 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_FD, 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_EOR_TF, A2_EOR_ML, A2_EOR_FD, A2_EOR_B2, A2_EOR_B3, A2_EOR_B4, A2_EOR_B5, A2_EOR_B6, A2_EOR_B7, A2_EOR_B8, A2_EOR_B9, A2_EOR_B10, A2_EOR_B11, A2_EOR_B12, A2_EOR_B13, A2_EOR_B14, A2_EOR_A3, A2_EOR_A4, A2_EOR_A5, A2_EOR_A6, A2_EOR_A7, A2_EOR_A8, A2_EOR_A9, A2_EOR_A10, A2_EOR_A11, A2_EOR_A12, A2_EOR_A13, A2_EOR_A14, A2_NOM_TF, A2_NOM_ML, A2_NOM_FD, 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
mqcview_wn.magnet_name as magnet_name,
nvl(mqcview_wn.A1_INJ_TF,0.0) as   A1_INJ_TF,
nvl(mqcview_wn.A1_INJ_ML,0.0) as   A1_INJ_ML,
nvl(mqcview_wn.A1_INJ_FD,0.0) as   A1_INJ_FD,
nvl(mqcview_wn.A1_INJ_b2,0.0) as   A1_INJ_b2,
nvl(mqcview_wn.A1_INJ_b3,0.0) as   A1_INJ_b3,
nvl(mqcview_wn.A1_INJ_b4,0.0) as   A1_INJ_b4,
nvl(mqcview_wn.A1_INJ_b5,0.0) as   A1_INJ_b5,
nvl(mqcview_wn.A1_INJ_b6,0.0) as   A1_INJ_b6,
nvl(mqcview_wn.A1_INJ_b7,0.0) as   A1_INJ_b7,
nvl(mqcview_wn.A1_INJ_b8,0.0) as   A1_INJ_b8,
nvl(mqcview_wn.A1_INJ_b9,0.0) as   A1_INJ_b9,
nvl(mqcview_wn.A1_INJ_b10,0.0) as  A1_INJ_b10,
nvl(mqcview_wn.A1_INJ_b11,0.0) as  A1_INJ_b11,
nvl(mqcview_wn.A1_INJ_b12,0.0) as  A1_INJ_b12,
nvl(mqcview_wn.A1_INJ_b13,0.0) as  A1_INJ_b13,
nvl(mqcview_wn.A1_INJ_b14,0.0) as  A1_INJ_b14,
nvl(mqcview_wn.A1_INJ_a3,0.0) as   A1_INJ_a3,
nvl(mqcview_wn.A1_INJ_a4,0.0) as   A1_INJ_a4,
nvl(mqcview_wn.A1_INJ_a5,0.0) as   A1_INJ_a5,
nvl(mqcview_wn.A1_INJ_a6,0.0) as   A1_INJ_a6,
nvl(mqcview_wn.A1_INJ_a7,0.0) as   A1_INJ_a7,
nvl(mqcview_wn.A1_INJ_a8,0.0) as   A1_INJ_a8,
nvl(mqcview_wn.A1_INJ_a9,0.0) as   A1_INJ_a9,
nvl(mqcview_wn.A1_INJ_a10,0.0) as  A1_INJ_a10,
nvl(mqcview_wn.A1_INJ_a11,0.0) as  A1_INJ_a11,
nvl(mqcview_wn.A1_INJ_a12,0.0) as  A1_INJ_a12,
nvl(mqcview_wn.A1_INJ_a13,0.0) as  A1_INJ_a13,
nvl(mqcview_wn.A1_INJ_a14,0.0) as  A1_INJ_a14,
nvl(mqcview_wn.A1_EOI_TF,0.0) as   A1_EOI_TF,
nvl(mqcview_wn.A1_EOI_ML,0.0) as   A1_EOI_ML,
nvl(mqcview_wn.A1_EOI_FD,0.0) as   A1_EOI_FD,
nvl(mqcview_wn.A1_EOI_b2,0.0) as   A1_EOI_b2,
nvl(mqcview_wn.A1_EOI_b3,0.0) as   A1_EOI_b3,
nvl(mqcview_wn.A1_EOI_b4,0.0) as   A1_EOI_b4,
nvl(mqcview_wn.A1_EOI_b5,0.0) as   A1_EOI_b5,
nvl(mqcview_wn.A1_EOI_b6,0.0) as   A1_EOI_b6,
nvl(mqcview_wn.A1_EOI_b7,0.0) as   A1_EOI_b7,
nvl(mqcview_wn.A1_EOI_b8,0.0) as   A1_EOI_b8,
nvl(mqcview_wn.A1_EOI_b9,0.0) as   A1_EOI_b9,
nvl(mqcview_wn.A1_EOI_b10,0.0) as  A1_EOI_b10,
nvl(mqcview_wn.A1_EOI_b11,0.0) as  A1_EOI_b11,
nvl(mqcview_wn.A1_EOI_b12,0.0) as  A1_EOI_b12,
nvl(mqcview_wn.A1_EOI_b13,0.0) as  A1_EOI_b13,
nvl(mqcview_wn.A1_EOI_b14,0.0) as  A1_EOI_b14,
nvl(mqcview_wn.A1_EOI_a3,0.0) as   A1_EOI_a3,
nvl(mqcview_wn.A1_EOI_a4,0.0) as   A1_EOI_a4,
nvl(mqcview_wn.A1_EOI_a5,0.0) as   A1_EOI_a5,
nvl(mqcview_wn.A1_EOI_a6,0.0) as   A1_EOI_a6,
nvl(mqcview_wn.A1_EOI_a7,0.0) as   A1_EOI_a7,
nvl(mqcview_wn.A1_EOI_a8,0.0) as   A1_EOI_a8,
nvl(mqcview_wn.A1_EOI_a9,0.0) as   A1_EOI_a9,
nvl(mqcview_wn.A1_EOI_a10,0.0) as  A1_EOI_a10,
nvl(mqcview_wn.A1_EOI_a11,0.0) as  A1_EOI_a11,
nvl(mqcview_wn.A1_EOI_a12,0.0) as  A1_EOI_a12,
nvl(mqcview_wn.A1_EOI_a13,0.0) as  A1_EOI_a13,
nvl(mqcview_wn.A1_EOI_a14,0.0) as  A1_EOI_a14,
nvl(mqcview_wn.A1_EOR_TF, 0.0) as A1_EOR_TF,
nvl(mqcview_wn.A1_EOR_ML,0.0) as   A1_EOR_ML,
nvl(mqcview_wn.A1_EOR_FD,0.0) as   A1_EOR_FD,
nvl(mqcview_wn.A1_EOR_b2,0.0) as   A1_EOR_b2,
nvl(mqcview_wn.A1_EOR_b3,0.0) as   A1_EOR_b3,
nvl(mqcview_wn.A1_EOR_b4,0.0) as   A1_EOR_b4,
nvl(mqcview_wn.A1_EOR_b5,0.0) as   A1_EOR_b5,
nvl(mqcview_wn.A1_EOR_b6,0.0) as   A1_EOR_b6,
nvl(mqcview_wn.A1_EOR_b7,0.0) as   A1_EOR_b7,
nvl(mqcview_wn.A1_EOR_b8,0.0) as   A1_EOR_b8,
nvl(mqcview_wn.A1_EOR_b9,0.0) as   A1_EOR_b9,
nvl(mqcview_wn.A1_EOR_b10,0.0) as  A1_EOR_b10,
nvl(mqcview_wn.A1_EOR_b11,0.0) as  A1_EOR_b11,
nvl(mqcview_wn.A1_EOR_b12,0.0) as  A1_EOR_b12,
nvl(mqcview_wn.A1_EOR_b13,0.0) as  A1_EOR_b13,
nvl(mqcview_wn.A1_EOR_b14,0.0) as  A1_EOR_b14,
nvl(mqcview_wn.A1_EOR_a3,0.0) as   A1_EOR_a3,
nvl(mqcview_wn.A1_EOR_a4,0.0) as   A1_EOR_a4,
nvl(mqcview_wn.A1_EOR_a5,0.0) as   A1_EOR_a5,
nvl(mqcview_wn.A1_EOR_a6,0.0) as   A1_EOR_a6,
nvl(mqcview_wn.A1_EOR_a7,0.0) as   A1_EOR_a7,
nvl(mqcview_wn.A1_EOR_a8,0.0) as   A1_EOR_a8,
nvl(mqcview_wn.A1_EOR_a9,0.0) as   A1_EOR_a9,
nvl(mqcview_wn.A1_EOR_a10,0.0) as  A1_EOR_a10,
nvl(mqcview_wn.A1_EOR_a11,0.0) as  A1_EOR_a11,
nvl(mqcview_wn.A1_EOR_a12,0.0) as  A1_EOR_a12,
nvl(mqcview_wn.A1_EOR_a13,0.0) as  A1_EOR_a13,
nvl(mqcview_wn.A1_EOR_a14,0.0) as  A1_EOR_a14,
nvl(mqcview_wn.A1_NOM_TF,0.0) as   A1_NOM_TF,
nvl(mqcview_wn.A1_NOM_ML,0.0) as   A1_NOM_ML,
nvl(mqcview_wn.A1_NOM_FD,0.0) as   A1_NOM_FD,
nvl(mqcview_wn.A1_NOM_b2,0.0) as   A1_NOM_b2,
nvl(mqcview_wn.A1_NOM_b3,0.0) as   A1_NOM_b3,
nvl(mqcview_wn.A1_NOM_b4,0.0) as   A1_NOM_b4,
nvl(mqcview_wn.A1_NOM_b5,0.0) as   A1_NOM_b5,
nvl(mqcview_wn.A1_NOM_b6,0.0) as   A1_NOM_b6,
nvl(mqcview_wn.A1_NOM_b7,0.0) as   A1_NOM_b7,
nvl(mqcview_wn.A1_NOM_b8,0.0) as   A1_NOM_b8,
nvl(mqcview_wn.A1_NOM_b9,0.0) as   A1_NOM_b9,
nvl(mqcview_wn.A1_NOM_b10,0.0) as  A1_NOM_b10,
nvl(mqcview_wn.A1_NOM_b11,0.0) as  A1_NOM_b11,
nvl(mqcview_wn.A1_NOM_b12,0.0) as  A1_NOM_b12,
nvl(mqcview_wn.A1_NOM_b13,0.0) as  A1_NOM_b13,
nvl(mqcview_wn.A1_NOM_b14,0.0) as  A1_NOM_b14,
nvl(mqcview_wn.A1_NOM_a3,0.0) as   A1_NOM_a3,
nvl(mqcview_wn.A1_NOM_a4,0.0) as   A1_NOM_a4,
nvl(mqcview_wn.A1_NOM_a5,0.0) as   A1_NOM_a5,
nvl(mqcview_wn.A1_NOM_a6,0.0) as   A1_NOM_a6,
nvl(mqcview_wn.A1_NOM_a7,0.0) as   A1_NOM_a7,
nvl(mqcview_wn.A1_NOM_a8,0.0) as   A1_NOM_a8,
nvl(mqcview_wn.A1_NOM_a9,0.0) as   A1_NOM_a9,
nvl(mqcview_wn.A1_NOM_a10,0.0) as  A1_NOM_a10,
nvl(mqcview_wn.A1_NOM_a11,0.0) as  A1_NOM_a11,
nvl(mqcview_wn.A1_NOM_a12,0.0) as  A1_NOM_a12,
nvl(mqcview_wn.A1_NOM_a13,0.0) as  A1_NOM_a13,
nvl(mqcview_wn.A1_NOM_a14,0.0) as  A1_NOM_a14,
nvl(mqcview_wn.A2_INJ_TF,0.0) as   A2_INJ_TF,
nvl(mqcview_wn.A2_INJ_ML,0.0) as   A2_INJ_ML,
nvl(mqcview_wn.A2_INJ_FD,0.0) as   A2_INJ_FD,
nvl(mqcview_wn.A2_INJ_b2,0.0) as   A2_INJ_b2,
nvl(mqcview_wn.A2_INJ_b3,0.0) as   A2_INJ_b3,
nvl(mqcview_wn.A2_INJ_b4,0.0) as   A2_INJ_b4,
nvl(mqcview_wn.A2_INJ_b5,0.0) as   A2_INJ_b5,
nvl(mqcview_wn.A2_INJ_b6,0.0) as   A2_INJ_b6,
nvl(mqcview_wn.A2_INJ_b7,0.0) as   A2_INJ_b7,
nvl(mqcview_wn.A2_INJ_b8,0.0) as   A2_INJ_b8,
nvl(mqcview_wn.A2_INJ_b9,0.0) as   A2_INJ_b9,
nvl(mqcview_wn.A2_INJ_b10,0.0) as  A2_INJ_b10,
nvl(mqcview_wn.A2_INJ_b11,0.0) as  A2_INJ_b11,
nvl(mqcview_wn.A2_INJ_b12,0.0) as  A2_INJ_b12,
nvl(mqcview_wn.A2_INJ_b13,0.0) as  A2_INJ_b13,
nvl(mqcview_wn.A2_INJ_b14,0.0) as  A2_INJ_b14,
nvl(mqcview_wn.A2_INJ_a3,0.0) as   A2_INJ_a3,
nvl(mqcview_wn.A2_INJ_a4,0.0) as   A2_INJ_a4,
nvl(mqcview_wn.A2_INJ_a5,0.0) as   A2_INJ_a5,
nvl(mqcview_wn.A2_INJ_a6,0.0) as   A2_INJ_a6,
nvl(mqcview_wn.A2_INJ_a7,0.0) as   A2_INJ_a7,
nvl(mqcview_wn.A2_INJ_a8,0.0) as   A2_INJ_a8,
nvl(mqcview_wn.A2_INJ_a9,0.0) as   A2_INJ_a9,
nvl(mqcview_wn.A2_INJ_a10,0.0) as  A2_INJ_a10,
nvl(mqcview_wn.A2_INJ_a11,0.0) as  A2_INJ_a11,
nvl(mqcview_wn.A2_INJ_a12,0.0) as  A2_INJ_a12,
nvl(mqcview_wn.A2_INJ_a13,0.0) as  A2_INJ_a13,
nvl(mqcview_wn.A2_INJ_a14,0.0) as  A2_INJ_a14,
nvl(mqcview_wn.A2_EOI_TF,0.0) as   A2_EOI_TF,
nvl(mqcview_wn.A2_EOI_ML,0.0) as   A2_EOI_ML,
nvl(mqcview_wn.A2_EOI_FD,0.0) as   A2_EOI_FD,
nvl(mqcview_wn.A2_EOI_b2,0.0) as   A2_EOI_b2,
nvl(mqcview_wn.A2_EOI_b3,0.0) as   A2_EOI_b3,
nvl(mqcview_wn.A2_EOI_b4,0.0) as   A2_EOI_b4,
nvl(mqcview_wn.A2_EOI_b5,0.0) as   A2_EOI_b5,
nvl(mqcview_wn.A2_EOI_b6,0.0) as   A2_EOI_b6,
nvl(mqcview_wn.A2_EOI_b7,0.0) as   A2_EOI_b7,
nvl(mqcview_wn.A2_EOI_b8,0.0) as   A2_EOI_b8,
nvl(mqcview_wn.A2_EOI_b9,0.0) as   A2_EOI_b9,
nvl(mqcview_wn.A2_EOI_b10,0.0) as  A2_EOI_b10,
nvl(mqcview_wn.A2_EOI_b11,0.0) as  A2_EOI_b11,
nvl(mqcview_wn.A2_EOI_b12,0.0) as  A2_EOI_b12,
nvl(mqcview_wn.A2_EOI_b13,0.0) as  A2_EOI_b13,
nvl(mqcview_wn.A2_EOI_b14,0.0) as  A2_EOI_b14,
nvl(mqcview_wn.A2_EOI_a3,0.0) as   A2_EOI_a3,
nvl(mqcview_wn.A2_EOI_a4,0.0) as   A2_EOI_a4,
nvl(mqcview_wn.A2_EOI_a5,0.0) as   A2_EOI_a5,
nvl(mqcview_wn.A2_EOI_a6,0.0) as   A2_EOI_a6,
nvl(mqcview_wn.A2_EOI_a7,0.0) as   A2_EOI_a7,
nvl(mqcview_wn.A2_EOI_a8,0.0) as   A2_EOI_a8,
nvl(mqcview_wn.A2_EOI_a9,0.0) as   A2_EOI_a9,
nvl(mqcview_wn.A2_EOI_a10,0.0) as  A2_EOI_a10,
nvl(mqcview_wn.A2_EOI_a11,0.0) as  A2_EOI_a11,
nvl(mqcview_wn.A2_EOI_a12,0.0) as  A2_EOI_a12,
nvl(mqcview_wn.A2_EOI_a13,0.0) as  A2_EOI_a13,
nvl(mqcview_wn.A2_EOI_a14,0.0) as  A2_EOI_a14,
nvl(mqcview_wn.A2_EOR_TF, 0.0) as A2_EOR_TF,
nvl(mqcview_wn.A2_EOR_ML,0.0) as   A2_EOR_ML,
nvl(mqcview_wn.A2_EOR_FD,0.0) as   A2_EOR_FD,
nvl(mqcview_wn.A2_EOR_b2,0.0) as   A2_EOR_b2,
nvl(mqcview_wn.A2_EOR_b3,0.0) as   A2_EOR_b3,
nvl(mqcview_wn.A2_EOR_b4,0.0) as   A2_EOR_b4,
nvl(mqcview_wn.A2_EOR_b5,0.0) as   A2_EOR_b5,
nvl(mqcview_wn.A2_EOR_b6,0.0) as   A2_EOR_b6,
nvl(mqcview_wn.A2_EOR_b7,0.0) as   A2_EOR_b7,
nvl(mqcview_wn.A2_EOR_b8,0.0) as   A2_EOR_b8,
nvl(mqcview_wn.A2_EOR_b9,0.0) as   A2_EOR_b9,
nvl(mqcview_wn.A2_EOR_b10,0.0) as  A2_EOR_b10,
nvl(mqcview_wn.A2_EOR_b11,0.0) as  A2_EOR_b11,
nvl(mqcview_wn.A2_EOR_b12,0.0) as  A2_EOR_b12,
nvl(mqcview_wn.A2_EOR_b13,0.0) as  A2_EOR_b13,
nvl(mqcview_wn.A2_EOR_b14,0.0) as  A2_EOR_b14,
nvl(mqcview_wn.A2_EOR_a3,0.0) as   A2_EOR_a3,
nvl(mqcview_wn.A2_EOR_a4,0.0) as   A2_EOR_a4,
nvl(mqcview_wn.A2_EOR_a5,0.0) as   A2_EOR_a5,
nvl(mqcview_wn.A2_EOR_a6,0.0) as   A2_EOR_a6,
nvl(mqcview_wn.A2_EOR_a7,0.0) as   A2_EOR_a7,
nvl(mqcview_wn.A2_EOR_a8,0.0) as   A2_EOR_a8,
nvl(mqcview_wn.A2_EOR_a9,0.0) as   A2_EOR_a9,
nvl(mqcview_wn.A2_EOR_a10,0.0) as  A2_EOR_a10,
nvl(mqcview_wn.A2_EOR_a11,0.0) as  A2_EOR_a11,
nvl(mqcview_wn.A2_EOR_a12,0.0) as  A2_EOR_a12,
nvl(mqcview_wn.A2_EOR_a13,0.0) as  A2_EOR_a13,
nvl(mqcview_wn.A2_EOR_a14,0.0) as  A2_EOR_a14,
nvl(mqcview_wn.A2_NOM_TF,0.0) as   A2_NOM_TF,
nvl(mqcview_wn.A2_NOM_ML,0.0) as   A2_NOM_ML,
nvl(mqcview_wn.A2_NOM_FD,0.0) as   A2_NOM_FD,
nvl(mqcview_wn.A2_NOM_b2,0.0) as   A2_NOM_b2,
nvl(mqcview_wn.A2_NOM_b3,0.0) as   A2_NOM_b3,
nvl(mqcview_wn.A2_NOM_b4,0.0) as   A2_NOM_b4,
nvl(mqcview_wn.A2_NOM_b5,0.0) as   A2_NOM_b5,
nvl(mqcview_wn.A2_NOM_b6,0.0) as   A2_NOM_b6,
nvl(mqcview_wn.A2_NOM_b7,0.0) as   A2_NOM_b7,
nvl(mqcview_wn.A2_NOM_b8,0.0) as   A2_NOM_b8,
nvl(mqcview_wn.A2_NOM_b9,0.0) as   A2_NOM_b9,
nvl(mqcview_wn.A2_NOM_b10,0.0) as  A2_NOM_b10,
nvl(mqcview_wn.A2_NOM_b11,0.0) as  A2_NOM_b11,
nvl(mqcview_wn.A2_NOM_b12,0.0) as  A2_NOM_b12,
nvl(mqcview_wn.A2_NOM_b13,0.0) as  A2_NOM_b13,
nvl(mqcview_wn.A2_NOM_b14,0.0) as  A2_NOM_b14,
nvl(mqcview_wn.A2_NOM_a3,0.0) as   A2_NOM_a3,
nvl(mqcview_wn.A2_NOM_a4,0.0) as   A2_NOM_a4,
nvl(mqcview_wn.A2_NOM_a5,0.0) as   A2_NOM_a5,
nvl(mqcview_wn.A2_NOM_a6,0.0) as   A2_NOM_a6,
nvl(mqcview_wn.A2_NOM_a7,0.0) as   A2_NOM_a7,
nvl(mqcview_wn.A2_NOM_a8,0.0) as   A2_NOM_a8,
nvl(mqcview_wn.A2_NOM_a9,0.0) as   A2_NOM_a9,
nvl(mqcview_wn.A2_NOM_a10,0.0) as  A2_NOM_a10,
nvl(mqcview_wn.A2_NOM_a11,0.0) as  A2_NOM_a11,
nvl(mqcview_wn.A2_NOM_a12,0.0) as  A2_NOM_a12,
nvl(mqcview_wn.A2_NOM_a13,0.0) as  A2_NOM_a13,
nvl(mqcview_wn.A2_NOM_a14,0.0) as  A2_NOM_a14
from "MAGMEASADM".MQCVIEW_WITH_NULLS mqcview_wn;

NEW VERSION

CREATE OR REPLACE VIEW MQCVIEW_V2 (MAGNET_NAME, MEASDATE,
A1_INJ_TF, A1_INJ_ML, A1_INJ_FD, 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_FD, 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_EOR_TF, A1_EOR_ML, A1_EOR_FD, A1_EOR_B2,
A1_EOR_B3, A1_EOR_B4, A1_EOR_B5, A1_EOR_B6, A1_EOR_B7, A1_EOR_B8, A1_EOR_B9, A1_EOR_B10, A1_EOR_B11, A1_EOR_B12, A1_EOR_B13, A1_EOR_B14,
A1_EOR_A3, A1_EOR_A4, A1_EOR_A5, A1_EOR_A6, A1_EOR_A7, A1_EOR_A8, A1_EOR_A9, A1_EOR_A10, A1_EOR_A11, A1_EOR_A12, A1_EOR_A13, A1_EOR_A14,
A1_NOM_TF, A1_NOM_ML, A1_NOM_FD, 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_FD, 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_FD, 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_EOR_TF, A2_EOR_ML, A2_EOR_FD, A2_EOR_B2,
A2_EOR_B3, A2_EOR_B4, A2_EOR_B5, A2_EOR_B6, A2_EOR_B7, A2_EOR_B8, A2_EOR_B9, A2_EOR_B10, A2_EOR_B11, A2_EOR_B12, A2_EOR_B13, A2_EOR_B14,
A2_EOR_A3, A2_EOR_A4, A2_EOR_A5, A2_EOR_A6, A2_EOR_A7, A2_EOR_A8, A2_EOR_A9, A2_EOR_A10, A2_EOR_A11, A2_EOR_A12, A2_EOR_A13, A2_EOR_A14,
A2_NOM_TF, A2_NOM_ML, A2_NOM_FD, 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
mqcview_wn.magnet_name as magnet_name,
mqcview_wn.MEASDATE           as   MEASDATE,
nvl(mqcview_wn.A1_INJ_TF,0.0) as   A1_INJ_TF,
nvl(mqcview_wn.A1_INJ_ML,0.0) as   A1_INJ_ML,
nvl(mqcview_wn.A1_INJ_FD,0.0) as   A1_INJ_FD,
nvl(mqcview_wn.A1_INJ_b2,0.0) as   A1_INJ_b2,
nvl(mqcview_wn.A1_INJ_b3,0.0) as   A1_INJ_b3,
nvl(mqcview_wn.A1_INJ_b4,0.0) as   A1_INJ_b4,
nvl(mqcview_wn.A1_INJ_b5,0.0) as   A1_INJ_b5,
nvl(mqcview_wn.A1_INJ_b6,0.0) as   A1_INJ_b6,
nvl(mqcview_wn.A1_INJ_b7,0.0) as   A1_INJ_b7,
nvl(mqcview_wn.A1_INJ_b8,0.0) as   A1_INJ_b8,
nvl(mqcview_wn.A1_INJ_b9,0.0) as   A1_INJ_b9,
nvl(mqcview_wn.A1_INJ_b10,0.0) as  A1_INJ_b10,
nvl(mqcview_wn.A1_INJ_b11,0.0) as  A1_INJ_b11,
nvl(mqcview_wn.A1_INJ_b12,0.0) as  A1_INJ_b12,
nvl(mqcview_wn.A1_INJ_b13,0.0) as  A1_INJ_b13,
nvl(mqcview_wn.A1_INJ_b14,0.0) as  A1_INJ_b14,
nvl(mqcview_wn.A1_INJ_a3,0.0) as   A1_INJ_a3,
nvl(mqcview_wn.A1_INJ_a4,0.0) as   A1_INJ_a4,
nvl(mqcview_wn.A1_INJ_a5,0.0) as   A1_INJ_a5,
nvl(mqcview_wn.A1_INJ_a6,0.0) as   A1_INJ_a6,
nvl(mqcview_wn.A1_INJ_a7,0.0) as   A1_INJ_a7,
nvl(mqcview_wn.A1_INJ_a8,0.0) as   A1_INJ_a8,
nvl(mqcview_wn.A1_INJ_a9,0.0) as   A1_INJ_a9,
nvl(mqcview_wn.A1_INJ_a10,0.0) as  A1_INJ_a10,
nvl(mqcview_wn.A1_INJ_a11,0.0) as  A1_INJ_a11,
nvl(mqcview_wn.A1_INJ_a12,0.0) as  A1_INJ_a12,
nvl(mqcview_wn.A1_INJ_a13,0.0) as  A1_INJ_a13,
nvl(mqcview_wn.A1_INJ_a14,0.0) as  A1_INJ_a14,
nvl(mqcview_wn.A1_EOI_TF,0.0) as   A1_EOI_TF,
nvl(mqcview_wn.A1_EOI_ML,0.0) as   A1_EOI_ML,
nvl(mqcview_wn.A1_EOI_FD,0.0) as   A1_EOI_FD,
nvl(mqcview_wn.A1_EOI_b2,0.0) as   A1_EOI_b2,
nvl(mqcview_wn.A1_EOI_b3,0.0) as   A1_EOI_b3,
nvl(mqcview_wn.A1_EOI_b4,0.0) as   A1_EOI_b4,
nvl(mqcview_wn.A1_EOI_b5,0.0) as   A1_EOI_b5,
nvl(mqcview_wn.A1_EOI_b6,0.0) as   A1_EOI_b6,
nvl(mqcview_wn.A1_EOI_b7,0.0) as   A1_EOI_b7,
nvl(mqcview_wn.A1_EOI_b8,0.0) as   A1_EOI_b8,
nvl(mqcview_wn.A1_EOI_b9,0.0) as   A1_EOI_b9,
nvl(mqcview_wn.A1_EOI_b10,0.0) as  A1_EOI_b10,
nvl(mqcview_wn.A1_EOI_b11,0.0) as  A1_EOI_b11,
nvl(mqcview_wn.A1_EOI_b12,0.0) as  A1_EOI_b12,
nvl(mqcview_wn.A1_EOI_b13,0.0) as  A1_EOI_b13,
nvl(mqcview_wn.A1_EOI_b14,0.0) as  A1_EOI_b14,
nvl(mqcview_wn.A1_EOI_a3,0.0) as   A1_EOI_a3,
nvl(mqcview_wn.A1_EOI_a4,0.0) as   A1_EOI_a4,
nvl(mqcview_wn.A1_EOI_a5,0.0) as   A1_EOI_a5,
nvl(mqcview_wn.A1_EOI_a6,0.0) as   A1_EOI_a6,
nvl(mqcview_wn.A1_EOI_a7,0.0) as   A1_EOI_a7,
nvl(mqcview_wn.A1_EOI_a8,0.0) as   A1_EOI_a8,
nvl(mqcview_wn.A1_EOI_a9,0.0) as   A1_EOI_a9,
nvl(mqcview_wn.A1_EOI_a10,0.0) as  A1_EOI_a10,
nvl(mqcview_wn.A1_EOI_a11,0.0) as  A1_EOI_a11,
nvl(mqcview_wn.A1_EOI_a12,0.0) as  A1_EOI_a12,
nvl(mqcview_wn.A1_EOI_a13,0.0) as  A1_EOI_a13,
nvl(mqcview_wn.A1_EOI_a14,0.0) as  A1_EOI_a14,
nvl(mqcview_wn.A1_EOR_TF, 0.0) as A1_EOR_TF,
nvl(mqcview_wn.A1_EOR_ML,0.0) as   A1_EOR_ML,
nvl(mqcview_wn.A1_EOR_FD,0.0) as   A1_EOR_FD,
nvl(mqcview_wn.A1_EOR_b2,0.0) as   A1_EOR_b2,
nvl(mqcview_wn.A1_EOR_b3,0.0) as   A1_EOR_b3,
nvl(mqcview_wn.A1_EOR_b4,0.0) as   A1_EOR_b4,
nvl(mqcview_wn.A1_EOR_b5,0.0) as   A1_EOR_b5,
nvl(mqcview_wn.A1_EOR_b6,0.0) as   A1_EOR_b6,
nvl(mqcview_wn.A1_EOR_b7,0.0) as   A1_EOR_b7,
nvl(mqcview_wn.A1_EOR_b8,0.0) as   A1_EOR_b8,
nvl(mqcview_wn.A1_EOR_b9,0.0) as   A1_EOR_b9,
nvl(mqcview_wn.A1_EOR_b10,0.0) as  A1_EOR_b10,
nvl(mqcview_wn.A1_EOR_b11,0.0) as  A1_EOR_b11,
nvl(mqcview_wn.A1_EOR_b12,0.0) as  A1_EOR_b12,
nvl(mqcview_wn.A1_EOR_b13,0.0) as  A1_EOR_b13,
nvl(mqcview_wn.A1_EOR_b14,0.0) as  A1_EOR_b14,
nvl(mqcview_wn.A1_EOR_a3,0.0) as   A1_EOR_a3,
nvl(mqcview_wn.A1_EOR_a4,0.0) as   A1_EOR_a4,
nvl(mqcview_wn.A1_EOR_a5,0.0) as   A1_EOR_a5,
nvl(mqcview_wn.A1_EOR_a6,0.0) as   A1_EOR_a6,
nvl(mqcview_wn.A1_EOR_a7,0.0) as   A1_EOR_a7,
nvl(mqcview_wn.A1_EOR_a8,0.0) as   A1_EOR_a8,
nvl(mqcview_wn.A1_EOR_a9,0.0) as   A1_EOR_a9,
nvl(mqcview_wn.A1_EOR_a10,0.0) as  A1_EOR_a10,
nvl(mqcview_wn.A1_EOR_a11,0.0) as  A1_EOR_a11,
nvl(mqcview_wn.A1_EOR_a12,0.0) as  A1_EOR_a12,
nvl(mqcview_wn.A1_EOR_a13,0.0) as  A1_EOR_a13,
nvl(mqcview_wn.A1_EOR_a14,0.0) as  A1_EOR_a14,
nvl(mqcview_wn.A1_NOM_TF,0.0) as   A1_NOM_TF,
nvl(mqcview_wn.A1_NOM_ML,0.0) as   A1_NOM_ML,
nvl(mqcview_wn.A1_NOM_FD,0.0) as   A1_NOM_FD,
nvl(mqcview_wn.A1_NOM_b2,0.0) as   A1_NOM_b2,
nvl(mqcview_wn.A1_NOM_b3,0.0) as   A1_NOM_b3,
nvl(mqcview_wn.A1_NOM_b4,0.0) as   A1_NOM_b4,
nvl(mqcview_wn.A1_NOM_b5,0.0) as   A1_NOM_b5,
nvl(mqcview_wn.A1_NOM_b6,0.0) as   A1_NOM_b6,
nvl(mqcview_wn.A1_NOM_b7,0.0) as   A1_NOM_b7,
nvl(mqcview_wn.A1_NOM_b8,0.0) as   A1_NOM_b8,
nvl(mqcview_wn.A1_NOM_b9,0.0) as   A1_NOM_b9,
nvl(mqcview_wn.A1_NOM_b10,0.0) as  A1_NOM_b10,
nvl(mqcview_wn.A1_NOM_b11,0.0) as  A1_NOM_b11,
nvl(mqcview_wn.A1_NOM_b12,0.0) as  A1_NOM_b12,
nvl(mqcview_wn.A1_NOM_b13,0.0) as  A1_NOM_b13,
nvl(mqcview_wn.A1_NOM_b14,0.0) as  A1_NOM_b14,
nvl(mqcview_wn.A1_NOM_a3,0.0) as   A1_NOM_a3,
nvl(mqcview_wn.A1_NOM_a4,0.0) as   A1_NOM_a4,
nvl(mqcview_wn.A1_NOM_a5,0.0) as   A1_NOM_a5,
nvl(mqcview_wn.A1_NOM_a6,0.0) as   A1_NOM_a6,
nvl(mqcview_wn.A1_NOM_a7,0.0) as   A1_NOM_a7,
nvl(mqcview_wn.A1_NOM_a8,0.0) as   A1_NOM_a8,
nvl(mqcview_wn.A1_NOM_a9,0.0) as   A1_NOM_a9,
nvl(mqcview_wn.A1_NOM_a10,0.0) as  A1_NOM_a10,
nvl(mqcview_wn.A1_NOM_a11,0.0) as  A1_NOM_a11,
nvl(mqcview_wn.A1_NOM_a12,0.0) as  A1_NOM_a12,
nvl(mqcview_wn.A1_NOM_a13,0.0) as  A1_NOM_a13,
nvl(mqcview_wn.A1_NOM_a14,0.0) as  A1_NOM_a14,
nvl(mqcview_wn.A2_INJ_TF,0.0) as   A2_INJ_TF,
nvl(mqcview_wn.A2_INJ_ML,0.0) as   A2_INJ_ML,
nvl(mqcview_wn.A2_INJ_FD,0.0) as   A2_INJ_FD,
nvl(mqcview_wn.A2_INJ_b2,0.0) as   A2_INJ_b2,
nvl(mqcview_wn.A2_INJ_b3,0.0) as   A2_INJ_b3,
nvl(mqcview_wn.A2_INJ_b4,0.0) as   A2_INJ_b4,
nvl(mqcview_wn.A2_INJ_b5,0.0) as   A2_INJ_b5,
nvl(mqcview_wn.A2_INJ_b6,0.0) as   A2_INJ_b6,
nvl(mqcview_wn.A2_INJ_b7,0.0) as   A2_INJ_b7,
nvl(mqcview_wn.A2_INJ_b8,0.0) as   A2_INJ_b8,
nvl(mqcview_wn.A2_INJ_b9,0.0) as   A2_INJ_b9,
nvl(mqcview_wn.A2_INJ_b10,0.0) as  A2_INJ_b10,
nvl(mqcview_wn.A2_INJ_b11,0.0) as  A2_INJ_b11,
nvl(mqcview_wn.A2_INJ_b12,0.0) as  A2_INJ_b12,
nvl(mqcview_wn.A2_INJ_b13,0.0) as  A2_INJ_b13,
nvl(mqcview_wn.A2_INJ_b14,0.0) as  A2_INJ_b14,
nvl(mqcview_wn.A2_INJ_a3,0.0) as   A2_INJ_a3,
nvl(mqcview_wn.A2_INJ_a4,0.0) as   A2_INJ_a4,
nvl(mqcview_wn.A2_INJ_a5,0.0) as   A2_INJ_a5,
nvl(mqcview_wn.A2_INJ_a6,0.0) as   A2_INJ_a6,
nvl(mqcview_wn.A2_INJ_a7,0.0) as   A2_INJ_a7,
nvl(mqcview_wn.A2_INJ_a8,0.0) as   A2_INJ_a8,
nvl(mqcview_wn.A2_INJ_a9,0.0) as   A2_INJ_a9,
nvl(mqcview_wn.A2_INJ_a10,0.0) as  A2_INJ_a10,
nvl(mqcview_wn.A2_INJ_a11,0.0) as  A2_INJ_a11,
nvl(mqcview_wn.A2_INJ_a12,0.0) as  A2_INJ_a12,
nvl(mqcview_wn.A2_INJ_a13,0.0) as  A2_INJ_a13,
nvl(mqcview_wn.A2_INJ_a14,0.0) as  A2_INJ_a14,
nvl(mqcview_wn.A2_EOI_TF,0.0) as   A2_EOI_TF,
nvl(mqcview_wn.A2_EOI_ML,0.0) as   A2_EOI_ML,
nvl(mqcview_wn.A2_EOI_FD,0.0) as   A2_EOI_FD,
nvl(mqcview_wn.A2_EOI_b2,0.0) as   A2_EOI_b2,
nvl(mqcview_wn.A2_EOI_b3,0.0) as   A2_EOI_b3,
nvl(mqcview_wn.A2_EOI_b4,0.0) as   A2_EOI_b4,
nvl(mqcview_wn.A2_EOI_b5,0.0) as   A2_EOI_b5,
nvl(mqcview_wn.A2_EOI_b6,0.0) as   A2_EOI_b6,
nvl(mqcview_wn.A2_EOI_b7,0.0) as   A2_EOI_b7,
nvl(mqcview_wn.A2_EOI_b8,0.0) as   A2_EOI_b8,
nvl(mqcview_wn.A2_EOI_b9,0.0) as   A2_EOI_b9,
nvl(mqcview_wn.A2_EOI_b10,0.0) as  A2_EOI_b10,
nvl(mqcview_wn.A2_EOI_b11,0.0) as  A2_EOI_b11,
nvl(mqcview_wn.A2_EOI_b12,0.0) as  A2_EOI_b12,
nvl(mqcview_wn.A2_EOI_b13,0.0) as  A2_EOI_b13,
nvl(mqcview_wn.A2_EOI_b14,0.0) as  A2_EOI_b14,
nvl(mqcview_wn.A2_EOI_a3,0.0) as   A2_EOI_a3,
nvl(mqcview_wn.A2_EOI_a4,0.0) as   A2_EOI_a4,
nvl(mqcview_wn.A2_EOI_a5,0.0) as   A2_EOI_a5,
nvl(mqcview_wn.A2_EOI_a6,0.0) as   A2_EOI_a6,
nvl(mqcview_wn.A2_EOI_a7,0.0) as   A2_EOI_a7,
nvl(mqcview_wn.A2_EOI_a8,0.0) as   A2_EOI_a8,
nvl(mqcview_wn.A2_EOI_a9,0.0) as   A2_EOI_a9,
nvl(mqcview_wn.A2_EOI_a10,0.0) as  A2_EOI_a10,
nvl(mqcview_wn.A2_EOI_a11,0.0) as  A2_EOI_a11,
nvl(mqcview_wn.A2_EOI_a12,0.0) as  A2_EOI_a12,
nvl(mqcview_wn.A2_EOI_a13,0.0) as  A2_EOI_a13,
nvl(mqcview_wn.A2_EOI_a14,0.0) as  A2_EOI_a14,
nvl(mqcview_wn.A2_EOR_TF, 0.0) as A2_EOR_TF,
nvl(mqcview_wn.A2_EOR_ML,0.0) as   A2_EOR_ML,
nvl(mqcview_wn.A2_EOR_FD,0.0) as   A2_EOR_FD,
nvl(mqcview_wn.A2_EOR_b2,0.0) as   A2_EOR_b2,
nvl(mqcview_wn.A2_EOR_b3,0.0) as   A2_EOR_b3,
nvl(mqcview_wn.A2_EOR_b4,0.0) as   A2_EOR_b4,
nvl(mqcview_wn.A2_EOR_b5,0.0) as   A2_EOR_b5,
nvl(mqcview_wn.A2_EOR_b6,0.0) as   A2_EOR_b6,
nvl(mqcview_wn.A2_EOR_b7,0.0) as   A2_EOR_b7,
nvl(mqcview_wn.A2_EOR_b8,0.0) as   A2_EOR_b8,
nvl(mqcview_wn.A2_EOR_b9,0.0) as   A2_EOR_b9,
nvl(mqcview_wn.A2_EOR_b10,0.0) as  A2_EOR_b10,
nvl(mqcview_wn.A2_EOR_b11,0.0) as  A2_EOR_b11,
nvl(mqcview_wn.A2_EOR_b12,0.0) as  A2_EOR_b12,
nvl(mqcview_wn.A2_EOR_b13,0.0) as  A2_EOR_b13,
nvl(mqcview_wn.A2_EOR_b14,0.0) as  A2_EOR_b14,
nvl(mqcview_wn.A2_EOR_a3,0.0) as   A2_EOR_a3,
nvl(mqcview_wn.A2_EOR_a4,0.0) as   A2_EOR_a4,
nvl(mqcview_wn.A2_EOR_a5,0.0) as   A2_EOR_a5,
nvl(mqcview_wn.A2_EOR_a6,0.0) as   A2_EOR_a6,
nvl(mqcview_wn.A2_EOR_a7,0.0) as   A2_EOR_a7,
nvl(mqcview_wn.A2_EOR_a8,0.0) as   A2_EOR_a8,
nvl(mqcview_wn.A2_EOR_a9,0.0) as   A2_EOR_a9,
nvl(mqcview_wn.A2_EOR_a10,0.0) as  A2_EOR_a10,
nvl(mqcview_wn.A2_EOR_a11,0.0) as  A2_EOR_a11,
nvl(mqcview_wn.A2_EOR_a12,0.0) as  A2_EOR_a12,
nvl(mqcview_wn.A2_EOR_a13,0.0) as  A2_EOR_a13,
nvl(mqcview_wn.A2_EOR_a14,0.0) as  A2_EOR_a14,
nvl(mqcview_wn.A2_NOM_TF,0.0) as   A2_NOM_TF,
nvl(mqcview_wn.A2_NOM_ML,0.0) as   A2_NOM_ML,
nvl(mqcview_wn.A2_NOM_FD,0.0) as   A2_NOM_FD,
nvl(mqcview_wn.A2_NOM_b2,0.0) as   A2_NOM_b2,
nvl(mqcview_wn.A2_NOM_b3,0.0) as   A2_NOM_b3,
nvl(mqcview_wn.A2_NOM_b4,0.0) as   A2_NOM_b4,
nvl(mqcview_wn.A2_NOM_b5,0.0) as   A2_NOM_b5,
nvl(mqcview_wn.A2_NOM_b6,0.0) as   A2_NOM_b6,
nvl(mqcview_wn.A2_NOM_b7,0.0) as   A2_NOM_b7,
nvl(mqcview_wn.A2_NOM_b8,0.0) as   A2_NOM_b8,
nvl(mqcview_wn.A2_NOM_b9,0.0) as   A2_NOM_b9,
nvl(mqcview_wn.A2_NOM_b10,0.0) as  A2_NOM_b10,
nvl(mqcview_wn.A2_NOM_b11,0.0) as  A2_NOM_b11,
nvl(mqcview_wn.A2_NOM_b12,0.0) as  A2_NOM_b12,
nvl(mqcview_wn.A2_NOM_b13,0.0) as  A2_NOM_b13,
nvl(mqcview_wn.A2_NOM_b14,0.0) as  A2_NOM_b14,
nvl(mqcview_wn.A2_NOM_a3,0.0) as   A2_NOM_a3,
nvl(mqcview_wn.A2_NOM_a4,0.0) as   A2_NOM_a4,
nvl(mqcview_wn.A2_NOM_a5,0.0) as   A2_NOM_a5,
nvl(mqcview_wn.A2_NOM_a6,0.0) as   A2_NOM_a6,
nvl(mqcview_wn.A2_NOM_a7,0.0) as   A2_NOM_a7,
nvl(mqcview_wn.A2_NOM_a8,0.0) as   A2_NOM_a8,
nvl(mqcview_wn.A2_NOM_a9,0.0) as   A2_NOM_a9,
nvl(mqcview_wn.A2_NOM_a10,0.0) as  A2_NOM_a10,
nvl(mqcview_wn.A2_NOM_a11,0.0) as  A2_NOM_a11,
nvl(mqcview_wn.A2_NOM_a12,0.0) as  A2_NOM_a12,
nvl(mqcview_wn.A2_NOM_a13,0.0) as  A2_NOM_a13,
nvl(mqcview_wn.A2_NOM_a14,0.0) as  A2_NOM_a14
from MQCVIEW_WITH_NULLS mqcview_wn;