OLD VERSION

CREATE OR REPLACE VIEW MQY45CVIEW_WITH_NULLS (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_wrm_wn.MAGNET_NAME as MAGNET_NAME,
nvl( mqcview_cld_wn.A1_INJ_TF, mqcview_wrm_wn.A1_INJ_TF ) as A1_INJ_TF,
nvl( mqcview_cld_wn.A1_INJ_ML, mqcview_wrm_wn.A1_INJ_ML ) as A1_INJ_ML,
mqcview_cld_wn.A1_INJ_FD as A1_INJ_FD,
null as A1_INJ_B2,
nvl( mqcview_cld_wn.A1_INJ_B3, mqcview_wrm_wn.A1_INJ_B3 ) as A1_INJ_B3,
nvl( mqcview_cld_wn.A1_INJ_B4, mqcview_wrm_wn.A1_INJ_B4 ) as A1_INJ_B4,
nvl( mqcview_cld_wn.A1_INJ_B5, mqcview_wrm_wn.A1_INJ_B5 ) as A1_INJ_B5,
nvl( mqcview_cld_wn.A1_INJ_B6, mqcview_wrm_wn.A1_INJ_B6 ) as A1_INJ_B6,
nvl( mqcview_cld_wn.A1_INJ_B7, mqcview_wrm_wn.A1_INJ_B7 ) as A1_INJ_B7,
nvl( mqcview_cld_wn.A1_INJ_B8, mqcview_wrm_wn.A1_INJ_B8 ) as A1_INJ_B8,
nvl( mqcview_cld_wn.A1_INJ_B9, mqcview_wrm_wn.A1_INJ_B9 ) as A1_INJ_B9,
nvl( mqcview_cld_wn.A1_INJ_B10, mqcview_wrm_wn.A1_INJ_B10 ) as A1_INJ_B10,
nvl( mqcview_cld_wn.A1_INJ_B11, mqcview_wrm_wn.A1_INJ_B11 ) as A1_INJ_B11,
nvl( mqcview_cld_wn.A1_INJ_B12, mqcview_wrm_wn.A1_INJ_B12 ) as A1_INJ_B12,
nvl( mqcview_cld_wn.A1_INJ_B13, mqcview_wrm_wn.A1_INJ_B13 ) as A1_INJ_B13,
nvl( mqcview_cld_wn.A1_INJ_B14, mqcview_wrm_wn.A1_INJ_B14 ) as A1_INJ_B14,
nvl( mqcview_cld_wn.A1_INJ_A3, mqcview_wrm_wn.A1_INJ_A3 ) as A1_INJ_A3,
nvl( mqcview_cld_wn.A1_INJ_A4, mqcview_wrm_wn.A1_INJ_A4 ) as A1_INJ_A4,
nvl( mqcview_cld_wn.A1_INJ_A5, mqcview_wrm_wn.A1_INJ_A5 ) as A1_INJ_A5,
nvl( mqcview_cld_wn.A1_INJ_A6, mqcview_wrm_wn.A1_INJ_A6 ) as A1_INJ_A6,
nvl( mqcview_cld_wn.A1_INJ_A7, mqcview_wrm_wn.A1_INJ_A7 ) as A1_INJ_A7,
nvl( mqcview_cld_wn.A1_INJ_A8, mqcview_wrm_wn.A1_INJ_A8 ) as A1_INJ_A8,
nvl( mqcview_cld_wn.A1_INJ_A9, mqcview_wrm_wn.A1_INJ_A9 ) as A1_INJ_A9,
nvl( mqcview_cld_wn.A1_INJ_A10, mqcview_wrm_wn.A1_INJ_A10 ) as A1_INJ_A10,
nvl( mqcview_cld_wn.A1_INJ_A11, mqcview_wrm_wn.A1_INJ_A11 ) as A1_INJ_A11,
nvl( mqcview_cld_wn.A1_INJ_A12, mqcview_wrm_wn.A1_INJ_A12 ) as A1_INJ_A12,
nvl(mqcview_cld_wn.A1_INJ_A13, mqcview_wrm_wn.A1_INJ_A13 ) as A1_INJ_A13,
nvl( mqcview_cld_wn.A1_INJ_A14, mqcview_wrm_wn.A1_INJ_A14 ) as A1_INJ_A14,
nvl( mqcview_cld_wn.A1_EOI_TF, mqcview_wrm_wn.A1_EOI_TF ) as A1_EOI_TF,
nvl( mqcview_cld_wn.A1_EOI_ML, mqcview_wrm_wn.A1_EOI_ML ) as A1_EOI_ML,
mqcview_cld_wn.A1_EOI_FD as A1_EOI_FD,
null as A1_EOI_B2,
nvl( mqcview_cld_wn.A1_EOI_B3, mqcview_wrm_wn.A1_EOI_B3 ) as A1_EOI_B3,
nvl( mqcview_cld_wn.A1_EOI_B4, mqcview_wrm_wn.A1_EOI_B4 ) as A1_EOI_B4,
nvl( mqcview_cld_wn.A1_EOI_B5, mqcview_wrm_wn.A1_EOI_B5 ) as A1_EOI_B5,
nvl( mqcview_cld_wn.A1_EOI_B6, mqcview_wrm_wn.A1_EOI_B6 ) as A1_EOI_B6,
nvl( mqcview_cld_wn.A1_EOI_B7, mqcview_wrm_wn.A1_EOI_B7 ) as A1_EOI_B7,
nvl( mqcview_cld_wn.A1_EOI_B8, mqcview_wrm_wn.A1_EOI_B8 ) as A1_EOI_B8,
nvl( mqcview_cld_wn.A1_EOI_B9, mqcview_wrm_wn.A1_EOI_B9 ) as A1_EOI_B9,
nvl( mqcview_cld_wn.A1_EOI_B10, mqcview_wrm_wn.A1_EOI_B10 ) as A1_EOI_B10,
nvl( mqcview_cld_wn.A1_EOI_B11, mqcview_wrm_wn.A1_EOI_B11 ) as A1_EOI_B11,
nvl( mqcview_cld_wn.A1_EOI_B12, mqcview_wrm_wn.A1_EOI_B12 ) as A1_EOI_B12,
nvl( mqcview_cld_wn.A1_EOI_B13, mqcview_wrm_wn.A1_EOI_B13 ) as A1_EOI_B13,
nvl( mqcview_cld_wn.A1_EOI_B14, mqcview_wrm_wn.A1_EOI_B14 ) as A1_EOI_B14,
nvl( mqcview_cld_wn.A1_EOI_A3, mqcview_wrm_wn.A1_EOI_A3 ) as A1_EOI_A3,
nvl( mqcview_cld_wn.A1_EOI_A4, mqcview_wrm_wn.A1_EOI_A4 ) as A1_EOI_A4,
nvl( mqcview_cld_wn.A1_EOI_A5, mqcview_wrm_wn.A1_EOI_A5 ) as A1_EOI_A5,
nvl( mqcview_cld_wn.A1_EOI_A6, mqcview_wrm_wn.A1_EOI_A6 ) as A1_EOI_A6,
nvl(mqcview_cld_wn.A1_EOI_A7, mqcview_wrm_wn.A1_EOI_A7 ) as A1_EOI_A7,
nvl(mqcview_cld_wn.A1_EOI_A8, mqcview_wrm_wn.A1_EOI_A8 ) as A1_EOI_A8,
nvl(mqcview_cld_wn.A1_EOI_A9, mqcview_wrm_wn.A1_EOI_A9 ) as A1_EOI_A9,
nvl(mqcview_cld_wn.A1_EOI_A10, mqcview_wrm_wn.A1_EOI_A10 ) as A1_EOI_A10,
nvl(mqcview_cld_wn.A1_EOI_A11, mqcview_wrm_wn.A1_EOI_A11 ) as A1_EOI_A11,
nvl(mqcview_cld_wn.A1_EOI_A12, mqcview_wrm_wn.A1_EOI_A12 ) as A1_EOI_A12,
nvl(mqcview_cld_wn.A1_EOI_A13, mqcview_wrm_wn.A1_EOI_A13 ) as A1_EOI_A13,
nvl(mqcview_cld_wn.A1_EOI_A14, mqcview_wrm_wn.A1_EOI_A14 ) as A1_EOI_A14,
mqcview_cld_wn.A1_EOR_TF as A1_EOR_TF,
mqcview_cld_wn.A1_EOR_ML as A1_EOR_ML,
mqcview_cld_wn.A1_EOR_FD as A1_EOR_FD,
null as A1_EOR_B2,
mqcview_cld_wn.A1_EOR_B3 as A1_EOR_B3,
mqcview_cld_wn.A1_EOR_B4 as A1_EOR_B4,
mqcview_cld_wn.A1_EOR_B5 as A1_EOR_B5,
mqcview_cld_wn.A1_EOR_B6 as A1_EOR_B6,
mqcview_cld_wn.A1_EOR_B7 as A1_EOR_B7,
mqcview_cld_wn.A1_EOR_B8 as A1_EOR_B8,
mqcview_cld_wn.A1_EOR_B9 as A1_EOR_B9,
mqcview_cld_wn.A1_EOR_B10 as A1_EOR_B10,
mqcview_cld_wn.A1_EOR_B11 as A1_EOR_B11,
mqcview_cld_wn.A1_EOR_B12 as A1_EOR_B12,
mqcview_cld_wn.A1_EOR_B13 as A1_EOR_B13,
mqcview_cld_wn.A1_EOR_B14 as A1_EOR_B14,
mqcview_cld_wn.A1_EOR_A3 as A1_EOR_A3,
mqcview_cld_wn.A1_EOR_A4 as A1_EOR_A4,
mqcview_cld_wn.A1_EOR_A5 as A1_EOR_A5,
mqcview_cld_wn.A1_EOR_A6 as A1_EOR_A6,
mqcview_cld_wn.A1_EOR_A7 as A1_EOR_A7,
mqcview_cld_wn.A1_EOR_A8 as A1_EOR_A8,
mqcview_cld_wn.A1_EOR_A9 as A1_EOR_A9,
mqcview_cld_wn.A1_EOR_A10 as A1_EOR_A10,
mqcview_cld_wn.A1_EOR_A11 as A1_EOR_A11,
mqcview_cld_wn.A1_EOR_A12 as A1_EOR_A12,
mqcview_cld_wn.A1_EOR_A13 as A1_EOR_A13,
mqcview_cld_wn.A1_EOR_A14 as A1_EOR_A14,
nvl( mqcview_cld_wn.A1_NOM_TF, mqcview_wrm_wn.A1_NOM_TF ) as A1_NOM_TF,
nvl( mqcview_cld_wn.A1_NOM_ML, mqcview_wrm_wn.A1_NOM_ML ) as A1_NOM_ML,
mqcview_cld_wn.A1_NOM_FD as A1_NOM_FD,
null as A1_NOM_B2,
nvl( mqcview_cld_wn.A1_NOM_B3, mqcview_wrm_wn.A1_NOM_B3 ) as A1_NOM_B3,
nvl( mqcview_cld_wn.A1_NOM_B4, mqcview_wrm_wn.A1_NOM_B4 ) as A1_NOM_B4,
nvl( mqcview_cld_wn.A1_NOM_B5, mqcview_wrm_wn.A1_NOM_B5 ) as A1_NOM_B5,
nvl( mqcview_cld_wn.A1_NOM_B6, mqcview_wrm_wn.A1_NOM_B6 ) as A1_NOM_B6,
nvl( mqcview_cld_wn.A1_NOM_B7, mqcview_wrm_wn.A1_NOM_B7 ) as A1_NOM_B7,
nvl( mqcview_cld_wn.A1_NOM_B8, mqcview_wrm_wn.A1_NOM_B8 ) as A1_NOM_B8,
nvl( mqcview_cld_wn.A1_NOM_B9, mqcview_wrm_wn.A1_NOM_B9 ) as A1_NOM_B9,
nvl( mqcview_cld_wn.A1_NOM_B10, mqcview_wrm_wn.A1_NOM_B10 ) as A1_NOM_B10,
nvl( mqcview_cld_wn.A1_NOM_B11, mqcview_wrm_wn.A1_NOM_B11 ) as A1_NOM_B11,
nvl( mqcview_cld_wn.A1_NOM_B12, mqcview_wrm_wn.A1_NOM_B12 ) as A1_NOM_B12,
nvl(mqcview_cld_wn.A1_NOM_B13, mqcview_wrm_wn.A1_NOM_B13 ) as A1_NOM_B13,
nvl( mqcview_cld_wn.A1_NOM_B14, mqcview_wrm_wn.A1_NOM_B14 ) as A1_NOM_B14,
nvl( mqcview_cld_wn.A1_NOM_A3, mqcview_wrm_wn.A1_NOM_A3 ) as A1_NOM_A3,
nvl( mqcview_cld_wn.A1_NOM_A4, mqcview_wrm_wn.A1_NOM_A4 ) as A1_NOM_A4,
nvl( mqcview_cld_wn.A1_NOM_A5, mqcview_wrm_wn.A1_NOM_A5 ) as A1_NOM_A5,
nvl( mqcview_cld_wn.A1_NOM_A6, mqcview_wrm_wn.A1_NOM_A6 ) as A1_NOM_A6,
nvl( mqcview_cld_wn.A1_NOM_A7, mqcview_wrm_wn.A1_NOM_A7 ) as A1_NOM_A7,
nvl( mqcview_cld_wn.A1_NOM_A8, mqcview_wrm_wn.A1_NOM_A8 ) as A1_NOM_A8,
nvl( mqcview_cld_wn.A1_NOM_A9, mqcview_wrm_wn.A1_NOM_A9 ) as A1_NOM_A9,
nvl( mqcview_cld_wn.A1_NOM_A10, mqcview_wrm_wn.A1_NOM_A10 ) as A1_NOM_A10,
nvl( mqcview_cld_wn.A1_NOM_A11, mqcview_wrm_wn.A1_NOM_A11 ) as A1_NOM_A11,
nvl( mqcview_cld_wn.A1_NOM_A12, mqcview_wrm_wn.A1_NOM_A12 ) as A1_NOM_A12,
nvl( mqcview_cld_wn.A1_NOM_A13, mqcview_wrm_wn.A1_NOM_A13 ) as A1_NOM_A13,
nvl( mqcview_cld_wn.A1_NOM_A14, mqcview_wrm_wn.A1_NOM_A14 ) as A1_NOM_A14,
nvl( mqcview_cld_wn.A2_INJ_TF, mqcview_wrm_wn.A2_INJ_TF ) as A2_INJ_TF,
nvl( mqcview_cld_wn.A2_INJ_ML, mqcview_wrm_wn.A2_INJ_ML ) as A2_INJ_ML,
mqcview_cld_wn.A2_INJ_FD as A2_INJ_FD,
null as A2_INJ_B2,
nvl( mqcview_cld_wn.A2_INJ_B3, mqcview_wrm_wn.A2_INJ_B3 ) as A2_INJ_B3,
nvl( mqcview_cld_wn.A2_INJ_B4, mqcview_wrm_wn.A2_INJ_B4 ) as A2_INJ_B4,
nvl( mqcview_cld_wn.A2_INJ_B5, mqcview_wrm_wn.A2_INJ_B5 ) as A2_INJ_B5,
nvl( mqcview_cld_wn.A2_INJ_B6, mqcview_wrm_wn.A2_INJ_B6 ) as A2_INJ_B6,
nvl( mqcview_cld_wn.A2_INJ_B7, mqcview_wrm_wn.A2_INJ_B7 ) as A2_INJ_B7,
nvl( mqcview_cld_wn.A2_INJ_B8, mqcview_wrm_wn.A2_INJ_B8 ) as A2_INJ_B8,
nvl(mqcview_cld_wn.A2_INJ_B9, mqcview_wrm_wn.A2_INJ_B9 ) as A2_INJ_B9,
nvl( mqcview_cld_wn.A2_INJ_B10, mqcview_wrm_wn.A2_INJ_B10 ) as A2_INJ_B10,
nvl( mqcview_cld_wn.A2_INJ_B11, mqcview_wrm_wn.A2_INJ_B11 ) as A2_INJ_B11,
nvl( mqcview_cld_wn.A2_INJ_B12, mqcview_wrm_wn.A2_INJ_B12 ) as A2_INJ_B12,
nvl( mqcview_cld_wn.A2_INJ_B13, mqcview_wrm_wn.A2_INJ_B13 ) as A2_INJ_B13,
nvl( mqcview_cld_wn.A2_INJ_B14, mqcview_wrm_wn.A2_INJ_B14 ) as A2_INJ_B14,
nvl( mqcview_cld_wn.A2_INJ_A3, mqcview_wrm_wn.A2_INJ_A3 ) as A2_INJ_A3,
nvl( mqcview_cld_wn.A2_INJ_A4, mqcview_wrm_wn.A2_INJ_A4 ) as A2_INJ_A4,
nvl( mqcview_cld_wn.A2_INJ_A5, mqcview_wrm_wn.A2_INJ_A5 ) as A2_INJ_A5,
nvl( mqcview_cld_wn.A2_INJ_A6, mqcview_wrm_wn.A2_INJ_A6 ) as A2_INJ_A6,
nvl( mqcview_cld_wn.A2_INJ_A7, mqcview_wrm_wn.A2_INJ_A7 ) as A2_INJ_A7,
nvl( mqcview_cld_wn.A2_INJ_A8, mqcview_wrm_wn.A2_INJ_A8 ) as A2_INJ_A8,
nvl( mqcview_cld_wn.A2_INJ_A9, mqcview_wrm_wn.A2_INJ_A9 ) as A2_INJ_A9,
nvl( mqcview_cld_wn.A2_INJ_A10, mqcview_wrm_wn.A2_INJ_A10 ) as A2_INJ_A10,
nvl( mqcview_cld_wn.A2_INJ_A11, mqcview_wrm_wn.A2_INJ_A11 ) as A2_INJ_A11,
nvl( mqcview_cld_wn.A2_INJ_A12, mqcview_wrm_wn.A2_INJ_A12 ) as A2_INJ_A12,
nvl( mqcview_cld_wn.A2_INJ_A13, mqcview_wrm_wn.A2_INJ_A13 ) as A2_INJ_A13,
nvl( mqcview_cld_wn.A2_INJ_A14, mqcview_wrm_wn.A2_INJ_A14 ) as A2_INJ_A14,
nvl( mqcview_cld_wn.A2_EOI_TF, mqcview_wrm_wn.A2_EOI_TF ) as A2_EOI_TF,
nvl( mqcview_cld_wn.A2_EOI_ML, mqcview_wrm_wn.A2_EOI_ML ) as A2_EOI_ML,
mqcview_cld_wn.A2_EOI_FD as A2_EOI_FD,
null as A2_EOI_B2,
nvl(mqcview_cld_wn.A2_EOI_B3, mqcview_wrm_wn.A2_EOI_B3 ) as A2_EOI_B3,
nvl(mqcview_cld_wn.A2_EOI_B4, mqcview_wrm_wn.A2_EOI_B4 ) as A2_EOI_B4,
nvl(mqcview_cld_wn.A2_EOI_B5, mqcview_wrm_wn.A2_EOI_B5 ) as A2_EOI_B5,
nvl(mqcview_cld_wn.A2_EOI_B6, mqcview_wrm_wn.A2_EOI_B6 ) as A2_EOI_B6,
nvl(mqcview_cld_wn.A2_EOI_B7, mqcview_wrm_wn.A2_EOI_B7 ) as A2_EOI_B7,
nvl(mqcview_cld_wn.A2_EOI_B8, mqcview_wrm_wn.A2_EOI_B8 ) as A2_EOI_B8,
nvl(mqcview_cld_wn.A2_EOI_B9, mqcview_wrm_wn.A2_EOI_B9 ) as A2_EOI_B9,
nvl(mqcview_cld_wn.A2_EOI_B10, mqcview_wrm_wn.A2_EOI_B10 ) as A2_EOI_B10,
nvl(mqcview_cld_wn.A2_EOI_B11, mqcview_wrm_wn.A2_EOI_B11 ) as A2_EOI_B11,
nvl(mqcview_cld_wn.A2_EOI_B12, mqcview_wrm_wn.A2_EOI_B12 ) as A2_EOI_B12,
nvl(mqcview_cld_wn.A2_EOI_B13, mqcview_wrm_wn.A2_EOI_B13 ) as A2_EOI_B13,
nvl(mqcview_cld_wn.A2_EOI_B14, mqcview_wrm_wn.A2_EOI_B14 ) as A2_EOI_B14,
nvl(mqcview_cld_wn.A2_EOI_A3, mqcview_wrm_wn.A2_EOI_A3 ) as A2_EOI_A3,
nvl(mqcview_cld_wn.A2_EOI_A4, mqcview_wrm_wn.A2_EOI_A4 ) as A2_EOI_A4,
nvl(mqcview_cld_wn.A2_EOI_A5, mqcview_wrm_wn.A2_EOI_A5 ) as A2_EOI_A5,
nvl(mqcview_cld_wn.A2_EOI_A6, mqcview_wrm_wn.A2_EOI_A6 ) as A2_EOI_A6,
nvl(mqcview_cld_wn.A2_EOI_A7, mqcview_wrm_wn.A2_EOI_A7 ) as A2_EOI_A7,
nvl(mqcview_cld_wn.A2_EOI_A8, mqcview_wrm_wn.A2_EOI_A8 ) as A2_EOI_A8,
nvl(mqcview_cld_wn.A2_EOI_A9, mqcview_wrm_wn.A2_EOI_A9 ) as A2_EOI_A9,
nvl(mqcview_cld_wn.A2_EOI_A10, mqcview_wrm_wn.A2_EOI_A10 ) as A2_EOI_A10,
nvl(mqcview_cld_wn.A2_EOI_A11, mqcview_wrm_wn.A2_EOI_A11 ) as A2_EOI_A11,
nvl(mqcview_cld_wn.A2_EOI_A12, mqcview_wrm_wn.A2_EOI_A12 ) as A2_EOI_A12,
nvl(mqcview_cld_wn.A2_EOI_A13, mqcview_wrm_wn.A2_EOI_A13 ) as A2_EOI_A13,
nvl(mqcview_cld_wn.A2_EOI_A14, mqcview_wrm_wn.A2_EOI_A14 ) as A2_EOI_A14,
mqcview_cld_wn.A2_EOR_TF as A2_EOR_TF,
mqcview_cld_wn.A2_EOR_ML as A2_EOR_ML,
mqcview_cld_wn.A2_EOR_FD as A2_EOR_FD,
null as A2_EOR_B2,
mqcview_cld_wn.A2_EOR_B3 as A2_EOR_B3,
mqcview_cld_wn.A2_EOR_B4 as A2_EOR_B4,
mqcview_cld_wn.A2_EOR_B5 as A2_EOR_B5,
mqcview_cld_wn.A2_EOR_B6 as A2_EOR_B6,
mqcview_cld_wn.A2_EOR_B7 as A2_EOR_B7,
mqcview_cld_wn.A2_EOR_B8 as A2_EOR_B8,
mqcview_cld_wn.A2_EOR_B9 as A2_EOR_B9,
mqcview_cld_wn.A2_EOR_B10 as A2_EOR_B10,
mqcview_cld_wn.A2_EOR_B11 as A2_EOR_B11,
mqcview_cld_wn.A2_EOR_B12 as A2_EOR_B12,
mqcview_cld_wn.A2_EOR_B13 as A2_EOR_B13,
mqcview_cld_wn.A2_EOR_B14 as A2_EOR_B14,
mqcview_cld_wn.A2_EOR_A3 as A2_EOR_A3,
mqcview_cld_wn.A2_EOR_A4 as A2_EOR_A4,
mqcview_cld_wn.A2_EOR_A5 as A2_EOR_A5,
mqcview_cld_wn.A2_EOR_A6 as A2_EOR_A6,
mqcview_cld_wn.A2_EOR_A7 as A2_EOR_A7,
mqcview_cld_wn.A2_EOR_A8 as A2_EOR_A8,
mqcview_cld_wn.A2_EOR_A9 as A2_EOR_A9,
mqcview_cld_wn.A2_EOR_A10 as A2_EOR_A10,
mqcview_cld_wn.A2_EOR_A11 as A2_EOR_A11,
mqcview_cld_wn.A2_EOR_A12 as A2_EOR_A12,
mqcview_cld_wn.A2_EOR_A13 as A2_EOR_A13,
mqcview_cld_wn.A2_EOR_A14 as A2_EOR_A14,
nvl(mqcview_cld_wn.A2_NOM_TF, mqcview_wrm_wn.A2_NOM_TF ) as A2_NOM_TF,
nvl(mqcview_cld_wn.A2_NOM_ML, mqcview_wrm_wn.A2_NOM_ML ) as A2_NOM_ML,
mqcview_cld_wn.A2_NOM_FD as A2_NOM_FD,
null as A2_NOM_B2,
nvl(mqcview_cld_wn.A2_NOM_B3, mqcview_wrm_wn.A2_NOM_B3 ) as A2_NOM_B3,
nvl(mqcview_cld_wn.A2_NOM_B4, mqcview_wrm_wn.A2_NOM_B4 ) as A2_NOM_B4,
nvl(mqcview_cld_wn.A2_NOM_B5, mqcview_wrm_wn.A2_NOM_B5 ) as A2_NOM_B5,
nvl(mqcview_cld_wn.A2_NOM_B6, mqcview_wrm_wn.A2_NOM_B6 ) as A2_NOM_B6,
nvl(mqcview_cld_wn.A2_NOM_B7, mqcview_wrm_wn.A2_NOM_B7 ) as A2_NOM_B7,
nvl(mqcview_cld_wn.A2_NOM_B8, mqcview_wrm_wn.A2_NOM_B8 ) as A2_NOM_B8,
nvl(mqcview_cld_wn.A2_NOM_B9, mqcview_wrm_wn.A2_NOM_B9 ) as A2_NOM_B9,
nvl(mqcview_cld_wn.A2_NOM_B10, mqcview_wrm_wn.A2_NOM_B10 ) as A2_NOM_B10,
nvl(mqcview_cld_wn.A2_NOM_B11, mqcview_wrm_wn.A2_NOM_B11 ) as A2_NOM_B11,
nvl(mqcview_cld_wn.A2_NOM_B12, mqcview_wrm_wn.A2_NOM_B12 ) as A2_NOM_B12,
nvl(mqcview_cld_wn.A2_NOM_B13, mqcview_wrm_wn.A2_NOM_B13 ) as A2_NOM_B13,
nvl(mqcview_cld_wn.A2_NOM_B14, mqcview_wrm_wn.A2_NOM_B14 ) as A2_NOM_B14,
nvl(mqcview_cld_wn.A2_NOM_A3, mqcview_wrm_wn.A2_NOM_A3 ) as A2_NOM_A3,
nvl(mqcview_cld_wn.A2_NOM_A4, mqcview_wrm_wn.A2_NOM_A4 ) as A2_NOM_A4,
nvl(mqcview_cld_wn.A2_NOM_A5, mqcview_wrm_wn.A2_NOM_A5 ) as A2_NOM_A5,
nvl(mqcview_cld_wn.A2_NOM_A6, mqcview_wrm_wn.A2_NOM_A6 ) as A2_NOM_A6,
nvl(mqcview_cld_wn.A2_NOM_A7, mqcview_wrm_wn.A2_NOM_A7 ) as A2_NOM_A7,
nvl(mqcview_cld_wn.A2_NOM_A8, mqcview_wrm_wn.A2_NOM_A8 ) as A2_NOM_A8,
nvl(mqcview_cld_wn.A2_NOM_A9, mqcview_wrm_wn.A2_NOM_A9 ) as A2_NOM_A9,
nvl(mqcview_cld_wn.A2_NOM_A10, mqcview_wrm_wn.A2_NOM_A10 ) as A2_NOM_A10,
nvl(mqcview_cld_wn.A2_NOM_A11, mqcview_wrm_wn.A2_NOM_A11 ) as A2_NOM_A11,
nvl(mqcview_cld_wn.A2_NOM_A12, mqcview_wrm_wn.A2_NOM_A12 ) as A2_NOM_A12,
nvl(mqcview_cld_wn.A2_NOM_A13, mqcview_wrm_wn.A2_NOM_A13 ) as A2_NOM_A13,
nvl(mqcview_cld_wn.A2_NOM_A14, mqcview_wrm_wn.A2_NOM_A14 ) as A2_NOM_A14
from
  MQY45CVIEW_COLD_WITH_NULLS mqcview_cld_wn,
  MQY45CVIEW_WARM_WITH_NULLS mqcview_wrm_wn
where
  mqcview_wrm_wn.magnet_name = mqcview_cld_wn.magnet_name (+);

NEW VERSION

CREATE OR REPLACE VIEW MQY45CVIEW_WITH_NULLS (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_wrm_wn.MAGNET_NAME as MAGNET_NAME,
MOST_RECENT_DATE_2( mqcview_cld_wn.measdate, mqcview_wrm_wn.measdate ) as MEASDATE,
nvl( mqcview_cld_wn.A1_INJ_TF, mqcview_wrm_wn.A1_INJ_TF ) as A1_INJ_TF,
nvl( mqcview_cld_wn.A1_INJ_ML, mqcview_wrm_wn.A1_INJ_ML ) as A1_INJ_ML,
mqcview_cld_wn.A1_INJ_FD as A1_INJ_FD,
null as A1_INJ_B2,
nvl( mqcview_cld_wn.A1_INJ_B3, mqcview_wrm_wn.A1_INJ_B3 ) as A1_INJ_B3,
nvl( mqcview_cld_wn.A1_INJ_B4, mqcview_wrm_wn.A1_INJ_B4 ) as A1_INJ_B4,
nvl( mqcview_cld_wn.A1_INJ_B5, mqcview_wrm_wn.A1_INJ_B5 ) as A1_INJ_B5,
nvl( mqcview_cld_wn.A1_INJ_B6, mqcview_wrm_wn.A1_INJ_B6 ) as A1_INJ_B6,
nvl( mqcview_cld_wn.A1_INJ_B7, mqcview_wrm_wn.A1_INJ_B7 ) as A1_INJ_B7,
nvl( mqcview_cld_wn.A1_INJ_B8, mqcview_wrm_wn.A1_INJ_B8 ) as A1_INJ_B8,
nvl( mqcview_cld_wn.A1_INJ_B9, mqcview_wrm_wn.A1_INJ_B9 ) as A1_INJ_B9,
nvl( mqcview_cld_wn.A1_INJ_B10, mqcview_wrm_wn.A1_INJ_B10 ) as A1_INJ_B10,
nvl( mqcview_cld_wn.A1_INJ_B11, mqcview_wrm_wn.A1_INJ_B11 ) as A1_INJ_B11,
nvl( mqcview_cld_wn.A1_INJ_B12, mqcview_wrm_wn.A1_INJ_B12 ) as A1_INJ_B12,
nvl( mqcview_cld_wn.A1_INJ_B13, mqcview_wrm_wn.A1_INJ_B13 ) as A1_INJ_B13,
nvl( mqcview_cld_wn.A1_INJ_B14, mqcview_wrm_wn.A1_INJ_B14 ) as A1_INJ_B14,
nvl( mqcview_cld_wn.A1_INJ_A3, mqcview_wrm_wn.A1_INJ_A3 ) as A1_INJ_A3,
nvl( mqcview_cld_wn.A1_INJ_A4, mqcview_wrm_wn.A1_INJ_A4 ) as A1_INJ_A4,
nvl( mqcview_cld_wn.A1_INJ_A5, mqcview_wrm_wn.A1_INJ_A5 ) as A1_INJ_A5,
nvl( mqcview_cld_wn.A1_INJ_A6, mqcview_wrm_wn.A1_INJ_A6 ) as A1_INJ_A6,
nvl( mqcview_cld_wn.A1_INJ_A7, mqcview_wrm_wn.A1_INJ_A7 ) as A1_INJ_A7,
nvl( mqcview_cld_wn.A1_INJ_A8, mqcview_wrm_wn.A1_INJ_A8 ) as A1_INJ_A8,
nvl( mqcview_cld_wn.A1_INJ_A9, mqcview_wrm_wn.A1_INJ_A9 ) as A1_INJ_A9,
nvl( mqcview_cld_wn.A1_INJ_A10, mqcview_wrm_wn.A1_INJ_A10 ) as A1_INJ_A10,
nvl( mqcview_cld_wn.A1_INJ_A11, mqcview_wrm_wn.A1_INJ_A11 ) as A1_INJ_A11,
nvl( mqcview_cld_wn.A1_INJ_A12, mqcview_wrm_wn.A1_INJ_A12 ) as A1_INJ_A12,
nvl(mqcview_cld_wn.A1_INJ_A13, mqcview_wrm_wn.A1_INJ_A13 ) as A1_INJ_A13,
nvl( mqcview_cld_wn.A1_INJ_A14, mqcview_wrm_wn.A1_INJ_A14 ) as A1_INJ_A14,
nvl( mqcview_cld_wn.A1_EOI_TF, mqcview_wrm_wn.A1_EOI_TF ) as A1_EOI_TF,
nvl( mqcview_cld_wn.A1_EOI_ML, mqcview_wrm_wn.A1_EOI_ML ) as A1_EOI_ML,
mqcview_cld_wn.A1_EOI_FD as A1_EOI_FD,
null as A1_EOI_B2,
nvl( mqcview_cld_wn.A1_EOI_B3, mqcview_wrm_wn.A1_EOI_B3 ) as A1_EOI_B3,
nvl( mqcview_cld_wn.A1_EOI_B4, mqcview_wrm_wn.A1_EOI_B4 ) as A1_EOI_B4,
nvl( mqcview_cld_wn.A1_EOI_B5, mqcview_wrm_wn.A1_EOI_B5 ) as A1_EOI_B5,
nvl( mqcview_cld_wn.A1_EOI_B6, mqcview_wrm_wn.A1_EOI_B6 ) as A1_EOI_B6,
nvl( mqcview_cld_wn.A1_EOI_B7, mqcview_wrm_wn.A1_EOI_B7 ) as A1_EOI_B7,
nvl( mqcview_cld_wn.A1_EOI_B8, mqcview_wrm_wn.A1_EOI_B8 ) as A1_EOI_B8,
nvl( mqcview_cld_wn.A1_EOI_B9, mqcview_wrm_wn.A1_EOI_B9 ) as A1_EOI_B9,
nvl( mqcview_cld_wn.A1_EOI_B10, mqcview_wrm_wn.A1_EOI_B10 ) as A1_EOI_B10,
nvl( mqcview_cld_wn.A1_EOI_B11, mqcview_wrm_wn.A1_EOI_B11 ) as A1_EOI_B11,
nvl( mqcview_cld_wn.A1_EOI_B12, mqcview_wrm_wn.A1_EOI_B12 ) as A1_EOI_B12,
nvl( mqcview_cld_wn.A1_EOI_B13, mqcview_wrm_wn.A1_EOI_B13 ) as A1_EOI_B13,
nvl( mqcview_cld_wn.A1_EOI_B14, mqcview_wrm_wn.A1_EOI_B14 ) as A1_EOI_B14,
nvl( mqcview_cld_wn.A1_EOI_A3, mqcview_wrm_wn.A1_EOI_A3 ) as A1_EOI_A3,
nvl( mqcview_cld_wn.A1_EOI_A4, mqcview_wrm_wn.A1_EOI_A4 ) as A1_EOI_A4,
nvl( mqcview_cld_wn.A1_EOI_A5, mqcview_wrm_wn.A1_EOI_A5 ) as A1_EOI_A5,
nvl( mqcview_cld_wn.A1_EOI_A6, mqcview_wrm_wn.A1_EOI_A6 ) as A1_EOI_A6,
nvl(mqcview_cld_wn.A1_EOI_A7, mqcview_wrm_wn.A1_EOI_A7 ) as A1_EOI_A7,
nvl(mqcview_cld_wn.A1_EOI_A8, mqcview_wrm_wn.A1_EOI_A8 ) as A1_EOI_A8,
nvl(mqcview_cld_wn.A1_EOI_A9, mqcview_wrm_wn.A1_EOI_A9 ) as A1_EOI_A9,
nvl(mqcview_cld_wn.A1_EOI_A10, mqcview_wrm_wn.A1_EOI_A10 ) as A1_EOI_A10,
nvl(mqcview_cld_wn.A1_EOI_A11, mqcview_wrm_wn.A1_EOI_A11 ) as A1_EOI_A11,
nvl(mqcview_cld_wn.A1_EOI_A12, mqcview_wrm_wn.A1_EOI_A12 ) as A1_EOI_A12,
nvl(mqcview_cld_wn.A1_EOI_A13, mqcview_wrm_wn.A1_EOI_A13 ) as A1_EOI_A13,
nvl(mqcview_cld_wn.A1_EOI_A14, mqcview_wrm_wn.A1_EOI_A14 ) as A1_EOI_A14,
mqcview_cld_wn.A1_EOR_TF as A1_EOR_TF,
mqcview_cld_wn.A1_EOR_ML as A1_EOR_ML,
mqcview_cld_wn.A1_EOR_FD as A1_EOR_FD,
null as A1_EOR_B2,
mqcview_cld_wn.A1_EOR_B3 as A1_EOR_B3,
mqcview_cld_wn.A1_EOR_B4 as A1_EOR_B4,
mqcview_cld_wn.A1_EOR_B5 as A1_EOR_B5,
mqcview_cld_wn.A1_EOR_B6 as A1_EOR_B6,
mqcview_cld_wn.A1_EOR_B7 as A1_EOR_B7,
mqcview_cld_wn.A1_EOR_B8 as A1_EOR_B8,
mqcview_cld_wn.A1_EOR_B9 as A1_EOR_B9,
mqcview_cld_wn.A1_EOR_B10 as A1_EOR_B10,
mqcview_cld_wn.A1_EOR_B11 as A1_EOR_B11,
mqcview_cld_wn.A1_EOR_B12 as A1_EOR_B12,
mqcview_cld_wn.A1_EOR_B13 as A1_EOR_B13,
mqcview_cld_wn.A1_EOR_B14 as A1_EOR_B14,
mqcview_cld_wn.A1_EOR_A3 as A1_EOR_A3,
mqcview_cld_wn.A1_EOR_A4 as A1_EOR_A4,
mqcview_cld_wn.A1_EOR_A5 as A1_EOR_A5,
mqcview_cld_wn.A1_EOR_A6 as A1_EOR_A6,
mqcview_cld_wn.A1_EOR_A7 as A1_EOR_A7,
mqcview_cld_wn.A1_EOR_A8 as A1_EOR_A8,
mqcview_cld_wn.A1_EOR_A9 as A1_EOR_A9,
mqcview_cld_wn.A1_EOR_A10 as A1_EOR_A10,
mqcview_cld_wn.A1_EOR_A11 as A1_EOR_A11,
mqcview_cld_wn.A1_EOR_A12 as A1_EOR_A12,
mqcview_cld_wn.A1_EOR_A13 as A1_EOR_A13,
mqcview_cld_wn.A1_EOR_A14 as A1_EOR_A14,
nvl( mqcview_cld_wn.A1_NOM_TF, mqcview_wrm_wn.A1_NOM_TF ) as A1_NOM_TF,
nvl( mqcview_cld_wn.A1_NOM_ML, mqcview_wrm_wn.A1_NOM_ML ) as A1_NOM_ML,
mqcview_cld_wn.A1_NOM_FD as A1_NOM_FD,
null as A1_NOM_B2,
nvl( mqcview_cld_wn.A1_NOM_B3, mqcview_wrm_wn.A1_NOM_B3 ) as A1_NOM_B3,
nvl( mqcview_cld_wn.A1_NOM_B4, mqcview_wrm_wn.A1_NOM_B4 ) as A1_NOM_B4,
nvl( mqcview_cld_wn.A1_NOM_B5, mqcview_wrm_wn.A1_NOM_B5 ) as A1_NOM_B5,
nvl( mqcview_cld_wn.A1_NOM_B6, mqcview_wrm_wn.A1_NOM_B6 ) as A1_NOM_B6,
nvl( mqcview_cld_wn.A1_NOM_B7, mqcview_wrm_wn.A1_NOM_B7 ) as A1_NOM_B7,
nvl( mqcview_cld_wn.A1_NOM_B8, mqcview_wrm_wn.A1_NOM_B8 ) as A1_NOM_B8,
nvl( mqcview_cld_wn.A1_NOM_B9, mqcview_wrm_wn.A1_NOM_B9 ) as A1_NOM_B9,
nvl( mqcview_cld_wn.A1_NOM_B10, mqcview_wrm_wn.A1_NOM_B10 ) as A1_NOM_B10,
nvl( mqcview_cld_wn.A1_NOM_B11, mqcview_wrm_wn.A1_NOM_B11 ) as A1_NOM_B11,
nvl( mqcview_cld_wn.A1_NOM_B12, mqcview_wrm_wn.A1_NOM_B12 ) as A1_NOM_B12,
nvl(mqcview_cld_wn.A1_NOM_B13, mqcview_wrm_wn.A1_NOM_B13 ) as A1_NOM_B13,
nvl( mqcview_cld_wn.A1_NOM_B14, mqcview_wrm_wn.A1_NOM_B14 ) as A1_NOM_B14,
nvl( mqcview_cld_wn.A1_NOM_A3, mqcview_wrm_wn.A1_NOM_A3 ) as A1_NOM_A3,
nvl( mqcview_cld_wn.A1_NOM_A4, mqcview_wrm_wn.A1_NOM_A4 ) as A1_NOM_A4,
nvl( mqcview_cld_wn.A1_NOM_A5, mqcview_wrm_wn.A1_NOM_A5 ) as A1_NOM_A5,
nvl( mqcview_cld_wn.A1_NOM_A6, mqcview_wrm_wn.A1_NOM_A6 ) as A1_NOM_A6,
nvl( mqcview_cld_wn.A1_NOM_A7, mqcview_wrm_wn.A1_NOM_A7 ) as A1_NOM_A7,
nvl( mqcview_cld_wn.A1_NOM_A8, mqcview_wrm_wn.A1_NOM_A8 ) as A1_NOM_A8,
nvl( mqcview_cld_wn.A1_NOM_A9, mqcview_wrm_wn.A1_NOM_A9 ) as A1_NOM_A9,
nvl( mqcview_cld_wn.A1_NOM_A10, mqcview_wrm_wn.A1_NOM_A10 ) as A1_NOM_A10,
nvl( mqcview_cld_wn.A1_NOM_A11, mqcview_wrm_wn.A1_NOM_A11 ) as A1_NOM_A11,
nvl( mqcview_cld_wn.A1_NOM_A12, mqcview_wrm_wn.A1_NOM_A12 ) as A1_NOM_A12,
nvl( mqcview_cld_wn.A1_NOM_A13, mqcview_wrm_wn.A1_NOM_A13 ) as A1_NOM_A13,
nvl( mqcview_cld_wn.A1_NOM_A14, mqcview_wrm_wn.A1_NOM_A14 ) as A1_NOM_A14,
nvl( mqcview_cld_wn.A2_INJ_TF, mqcview_wrm_wn.A2_INJ_TF ) as A2_INJ_TF,
nvl( mqcview_cld_wn.A2_INJ_ML, mqcview_wrm_wn.A2_INJ_ML ) as A2_INJ_ML,
mqcview_cld_wn.A2_INJ_FD as A2_INJ_FD,
null as A2_INJ_B2,
nvl( mqcview_cld_wn.A2_INJ_B3, mqcview_wrm_wn.A2_INJ_B3 ) as A2_INJ_B3,
nvl( mqcview_cld_wn.A2_INJ_B4, mqcview_wrm_wn.A2_INJ_B4 ) as A2_INJ_B4,
nvl( mqcview_cld_wn.A2_INJ_B5, mqcview_wrm_wn.A2_INJ_B5 ) as A2_INJ_B5,
nvl( mqcview_cld_wn.A2_INJ_B6, mqcview_wrm_wn.A2_INJ_B6 ) as A2_INJ_B6,
nvl( mqcview_cld_wn.A2_INJ_B7, mqcview_wrm_wn.A2_INJ_B7 ) as A2_INJ_B7,
nvl( mqcview_cld_wn.A2_INJ_B8, mqcview_wrm_wn.A2_INJ_B8 ) as A2_INJ_B8,
nvl(mqcview_cld_wn.A2_INJ_B9, mqcview_wrm_wn.A2_INJ_B9 ) as A2_INJ_B9,
nvl( mqcview_cld_wn.A2_INJ_B10, mqcview_wrm_wn.A2_INJ_B10 ) as A2_INJ_B10,
nvl( mqcview_cld_wn.A2_INJ_B11, mqcview_wrm_wn.A2_INJ_B11 ) as A2_INJ_B11,
nvl( mqcview_cld_wn.A2_INJ_B12, mqcview_wrm_wn.A2_INJ_B12 ) as A2_INJ_B12,
nvl( mqcview_cld_wn.A2_INJ_B13, mqcview_wrm_wn.A2_INJ_B13 ) as A2_INJ_B13,
nvl( mqcview_cld_wn.A2_INJ_B14, mqcview_wrm_wn.A2_INJ_B14 ) as A2_INJ_B14,
nvl( mqcview_cld_wn.A2_INJ_A3, mqcview_wrm_wn.A2_INJ_A3 ) as A2_INJ_A3,
nvl( mqcview_cld_wn.A2_INJ_A4, mqcview_wrm_wn.A2_INJ_A4 ) as A2_INJ_A4,
nvl( mqcview_cld_wn.A2_INJ_A5, mqcview_wrm_wn.A2_INJ_A5 ) as A2_INJ_A5,
nvl( mqcview_cld_wn.A2_INJ_A6, mqcview_wrm_wn.A2_INJ_A6 ) as A2_INJ_A6,
nvl( mqcview_cld_wn.A2_INJ_A7, mqcview_wrm_wn.A2_INJ_A7 ) as A2_INJ_A7,
nvl( mqcview_cld_wn.A2_INJ_A8, mqcview_wrm_wn.A2_INJ_A8 ) as A2_INJ_A8,
nvl( mqcview_cld_wn.A2_INJ_A9, mqcview_wrm_wn.A2_INJ_A9 ) as A2_INJ_A9,
nvl( mqcview_cld_wn.A2_INJ_A10, mqcview_wrm_wn.A2_INJ_A10 ) as A2_INJ_A10,
nvl( mqcview_cld_wn.A2_INJ_A11, mqcview_wrm_wn.A2_INJ_A11 ) as A2_INJ_A11,
nvl( mqcview_cld_wn.A2_INJ_A12, mqcview_wrm_wn.A2_INJ_A12 ) as A2_INJ_A12,
nvl( mqcview_cld_wn.A2_INJ_A13, mqcview_wrm_wn.A2_INJ_A13 ) as A2_INJ_A13,
nvl( mqcview_cld_wn.A2_INJ_A14, mqcview_wrm_wn.A2_INJ_A14 ) as A2_INJ_A14,
nvl( mqcview_cld_wn.A2_EOI_TF, mqcview_wrm_wn.A2_EOI_TF ) as A2_EOI_TF,
nvl( mqcview_cld_wn.A2_EOI_ML, mqcview_wrm_wn.A2_EOI_ML ) as A2_EOI_ML,
mqcview_cld_wn.A2_EOI_FD as A2_EOI_FD,
null as A2_EOI_B2,
nvl(mqcview_cld_wn.A2_EOI_B3, mqcview_wrm_wn.A2_EOI_B3 ) as A2_EOI_B3,
nvl(mqcview_cld_wn.A2_EOI_B4, mqcview_wrm_wn.A2_EOI_B4 ) as A2_EOI_B4,
nvl(mqcview_cld_wn.A2_EOI_B5, mqcview_wrm_wn.A2_EOI_B5 ) as A2_EOI_B5,
nvl(mqcview_cld_wn.A2_EOI_B6, mqcview_wrm_wn.A2_EOI_B6 ) as A2_EOI_B6,
nvl(mqcview_cld_wn.A2_EOI_B7, mqcview_wrm_wn.A2_EOI_B7 ) as A2_EOI_B7,
nvl(mqcview_cld_wn.A2_EOI_B8, mqcview_wrm_wn.A2_EOI_B8 ) as A2_EOI_B8,
nvl(mqcview_cld_wn.A2_EOI_B9, mqcview_wrm_wn.A2_EOI_B9 ) as A2_EOI_B9,
nvl(mqcview_cld_wn.A2_EOI_B10, mqcview_wrm_wn.A2_EOI_B10 ) as A2_EOI_B10,
nvl(mqcview_cld_wn.A2_EOI_B11, mqcview_wrm_wn.A2_EOI_B11 ) as A2_EOI_B11,
nvl(mqcview_cld_wn.A2_EOI_B12, mqcview_wrm_wn.A2_EOI_B12 ) as A2_EOI_B12,
nvl(mqcview_cld_wn.A2_EOI_B13, mqcview_wrm_wn.A2_EOI_B13 ) as A2_EOI_B13,
nvl(mqcview_cld_wn.A2_EOI_B14, mqcview_wrm_wn.A2_EOI_B14 ) as A2_EOI_B14,
nvl(mqcview_cld_wn.A2_EOI_A3, mqcview_wrm_wn.A2_EOI_A3 ) as A2_EOI_A3,
nvl(mqcview_cld_wn.A2_EOI_A4, mqcview_wrm_wn.A2_EOI_A4 ) as A2_EOI_A4,
nvl(mqcview_cld_wn.A2_EOI_A5, mqcview_wrm_wn.A2_EOI_A5 ) as A2_EOI_A5,
nvl(mqcview_cld_wn.A2_EOI_A6, mqcview_wrm_wn.A2_EOI_A6 ) as A2_EOI_A6,
nvl(mqcview_cld_wn.A2_EOI_A7, mqcview_wrm_wn.A2_EOI_A7 ) as A2_EOI_A7,
nvl(mqcview_cld_wn.A2_EOI_A8, mqcview_wrm_wn.A2_EOI_A8 ) as A2_EOI_A8,
nvl(mqcview_cld_wn.A2_EOI_A9, mqcview_wrm_wn.A2_EOI_A9 ) as A2_EOI_A9,
nvl(mqcview_cld_wn.A2_EOI_A10, mqcview_wrm_wn.A2_EOI_A10 ) as A2_EOI_A10,
nvl(mqcview_cld_wn.A2_EOI_A11, mqcview_wrm_wn.A2_EOI_A11 ) as A2_EOI_A11,
nvl(mqcview_cld_wn.A2_EOI_A12, mqcview_wrm_wn.A2_EOI_A12 ) as A2_EOI_A12,
nvl(mqcview_cld_wn.A2_EOI_A13, mqcview_wrm_wn.A2_EOI_A13 ) as A2_EOI_A13,
nvl(mqcview_cld_wn.A2_EOI_A14, mqcview_wrm_wn.A2_EOI_A14 ) as A2_EOI_A14,
mqcview_cld_wn.A2_EOR_TF as A2_EOR_TF,
mqcview_cld_wn.A2_EOR_ML as A2_EOR_ML,
mqcview_cld_wn.A2_EOR_FD as A2_EOR_FD,
null as A2_EOR_B2,
mqcview_cld_wn.A2_EOR_B3 as A2_EOR_B3,
mqcview_cld_wn.A2_EOR_B4 as A2_EOR_B4,
mqcview_cld_wn.A2_EOR_B5 as A2_EOR_B5,
mqcview_cld_wn.A2_EOR_B6 as A2_EOR_B6,
mqcview_cld_wn.A2_EOR_B7 as A2_EOR_B7,
mqcview_cld_wn.A2_EOR_B8 as A2_EOR_B8,
mqcview_cld_wn.A2_EOR_B9 as A2_EOR_B9,
mqcview_cld_wn.A2_EOR_B10 as A2_EOR_B10,
mqcview_cld_wn.A2_EOR_B11 as A2_EOR_B11,
mqcview_cld_wn.A2_EOR_B12 as A2_EOR_B12,
mqcview_cld_wn.A2_EOR_B13 as A2_EOR_B13,
mqcview_cld_wn.A2_EOR_B14 as A2_EOR_B14,
mqcview_cld_wn.A2_EOR_A3 as A2_EOR_A3,
mqcview_cld_wn.A2_EOR_A4 as A2_EOR_A4,
mqcview_cld_wn.A2_EOR_A5 as A2_EOR_A5,
mqcview_cld_wn.A2_EOR_A6 as A2_EOR_A6,
mqcview_cld_wn.A2_EOR_A7 as A2_EOR_A7,
mqcview_cld_wn.A2_EOR_A8 as A2_EOR_A8,
mqcview_cld_wn.A2_EOR_A9 as A2_EOR_A9,
mqcview_cld_wn.A2_EOR_A10 as A2_EOR_A10,
mqcview_cld_wn.A2_EOR_A11 as A2_EOR_A11,
mqcview_cld_wn.A2_EOR_A12 as A2_EOR_A12,
mqcview_cld_wn.A2_EOR_A13 as A2_EOR_A13,
mqcview_cld_wn.A2_EOR_A14 as A2_EOR_A14,
nvl(mqcview_cld_wn.A2_NOM_TF, mqcview_wrm_wn.A2_NOM_TF ) as A2_NOM_TF,
nvl(mqcview_cld_wn.A2_NOM_ML, mqcview_wrm_wn.A2_NOM_ML ) as A2_NOM_ML,
mqcview_cld_wn.A2_NOM_FD as A2_NOM_FD,
null as A2_NOM_B2,
nvl(mqcview_cld_wn.A2_NOM_B3, mqcview_wrm_wn.A2_NOM_B3 ) as A2_NOM_B3,
nvl(mqcview_cld_wn.A2_NOM_B4, mqcview_wrm_wn.A2_NOM_B4 ) as A2_NOM_B4,
nvl(mqcview_cld_wn.A2_NOM_B5, mqcview_wrm_wn.A2_NOM_B5 ) as A2_NOM_B5,
nvl(mqcview_cld_wn.A2_NOM_B6, mqcview_wrm_wn.A2_NOM_B6 ) as A2_NOM_B6,
nvl(mqcview_cld_wn.A2_NOM_B7, mqcview_wrm_wn.A2_NOM_B7 ) as A2_NOM_B7,
nvl(mqcview_cld_wn.A2_NOM_B8, mqcview_wrm_wn.A2_NOM_B8 ) as A2_NOM_B8,
nvl(mqcview_cld_wn.A2_NOM_B9, mqcview_wrm_wn.A2_NOM_B9 ) as A2_NOM_B9,
nvl(mqcview_cld_wn.A2_NOM_B10, mqcview_wrm_wn.A2_NOM_B10 ) as A2_NOM_B10,
nvl(mqcview_cld_wn.A2_NOM_B11, mqcview_wrm_wn.A2_NOM_B11 ) as A2_NOM_B11,
nvl(mqcview_cld_wn.A2_NOM_B12, mqcview_wrm_wn.A2_NOM_B12 ) as A2_NOM_B12,
nvl(mqcview_cld_wn.A2_NOM_B13, mqcview_wrm_wn.A2_NOM_B13 ) as A2_NOM_B13,
nvl(mqcview_cld_wn.A2_NOM_B14, mqcview_wrm_wn.A2_NOM_B14 ) as A2_NOM_B14,
nvl(mqcview_cld_wn.A2_NOM_A3, mqcview_wrm_wn.A2_NOM_A3 ) as A2_NOM_A3,
nvl(mqcview_cld_wn.A2_NOM_A4, mqcview_wrm_wn.A2_NOM_A4 ) as A2_NOM_A4,
nvl(mqcview_cld_wn.A2_NOM_A5, mqcview_wrm_wn.A2_NOM_A5 ) as A2_NOM_A5,
nvl(mqcview_cld_wn.A2_NOM_A6, mqcview_wrm_wn.A2_NOM_A6 ) as A2_NOM_A6,
nvl(mqcview_cld_wn.A2_NOM_A7, mqcview_wrm_wn.A2_NOM_A7 ) as A2_NOM_A7,
nvl(mqcview_cld_wn.A2_NOM_A8, mqcview_wrm_wn.A2_NOM_A8 ) as A2_NOM_A8,
nvl(mqcview_cld_wn.A2_NOM_A9, mqcview_wrm_wn.A2_NOM_A9 ) as A2_NOM_A9,
nvl(mqcview_cld_wn.A2_NOM_A10, mqcview_wrm_wn.A2_NOM_A10 ) as A2_NOM_A10,
nvl(mqcview_cld_wn.A2_NOM_A11, mqcview_wrm_wn.A2_NOM_A11 ) as A2_NOM_A11,
nvl(mqcview_cld_wn.A2_NOM_A12, mqcview_wrm_wn.A2_NOM_A12 ) as A2_NOM_A12,
nvl(mqcview_cld_wn.A2_NOM_A13, mqcview_wrm_wn.A2_NOM_A13 ) as A2_NOM_A13,
nvl(mqcview_cld_wn.A2_NOM_A14, mqcview_wrm_wn.A2_NOM_A14 ) as A2_NOM_A14
from
  MQY45CVIEW_COLD_WITH_NULLS mqcview_cld_wn,
  MQY45CVIEW_WARM_WITH_NULLS mqcview_wrm_wn
where
  mqcview_wrm_wn.magnet_name = mqcview_cld_wn.magnet_name (+);