OLD VERSION

CREATE OR REPLACE VIEW TST_MBCVIEW_WITH_NULLS (MAGNET_NAME, A1_INJ_TF, A1_INJ_ML, A1_INJ_FD, A1_INJ_B1, 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_A2, 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_EOI_TF, A1_EOI_ML, A1_EOI_FD, A1_EOI_B1, 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_A2, 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_EOR_TF, A1_EOR_ML, A1_EOR_FD, A1_EOR_B1, 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_A2, 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_NOM_TF, A1_NOM_ML, A1_NOM_FD, A1_NOM_B1, 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_A2, 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, A2_INJ_TF, A2_INJ_ML, A2_INJ_FD, A2_INJ_B1, 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_A2, 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_EOI_TF, A2_EOI_ML, A2_EOI_FD, A2_EOI_B1, 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_A2, 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_EOR_TF, A2_EOR_ML, A2_EOR_FD, A2_EOR_B1, 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_A2, 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_NOM_TF, A2_NOM_ML, A2_NOM_FD, A2_NOM_B1, 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_A2, 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) AS
select
mbcview_wrm_wn.magnet_name as MAGNET_NAME,

nvl(mbcview_cld_wn.A1_INJ_TF, mbcview_wrm_wn.A1_INJ_TF) as A1_INJ_TF,
nvl(mbcview_cld_wn.A1_INJ_ML, mbcview_wrm_wn.A1_INJ_ML) as A1_INJ_ML,
mbcview_cld_wn.A1_INJ_FD as A1_INJ_FD,
nvl(mbcview_cld_wn.A1_INJ_b1, mbcview_wrm_wn.A1_INJ_b1) as A1_INJ_b1,
nvl(mbcview_cld_wn.A1_INJ_b2, mbcview_wrm_wn.A1_INJ_b2) as A1_INJ_b2,
nvl(mbcview_cld_wn.A1_INJ_b3, mbcview_wrm_wn.A1_INJ_b3) as A1_INJ_b3,
nvl(mbcview_cld_wn.A1_INJ_b4, mbcview_wrm_wn.A1_INJ_b4) as A1_INJ_b4,
nvl(mbcview_cld_wn.A1_INJ_b5, mbcview_wrm_wn.A1_INJ_b5) as A1_INJ_b5,
nvl(mbcview_cld_wn.A1_INJ_b6, mbcview_wrm_wn.A1_INJ_b6) as A1_INJ_b6,
nvl(mbcview_cld_wn.A1_INJ_b7, mbcview_wrm_wn.A1_INJ_b7) as A1_INJ_b7,
nvl(mbcview_cld_wn.A1_INJ_b8, mbcview_wrm_wn.A1_INJ_b8) as A1_INJ_b8,
nvl(mbcview_cld_wn.A1_INJ_b9, mbcview_wrm_wn.A1_INJ_b9) as A1_INJ_b9,
nvl(mbcview_cld_wn.A1_INJ_b10,mbcview_wrm_wn.A1_INJ_b10) as A1_INJ_b10,
nvl(mbcview_cld_wn.A1_INJ_b11,mbcview_wrm_wn.A1_INJ_b11) as A1_INJ_b11,
nvl(mbcview_cld_wn.A1_INJ_a2, mbcview_wrm_wn.A1_INJ_a2) as A1_INJ_a2,
nvl(mbcview_cld_wn.A1_INJ_a3, mbcview_wrm_wn.A1_INJ_a3) as A1_INJ_a3,
nvl(mbcview_cld_wn.A1_INJ_a4, mbcview_wrm_wn.A1_INJ_a4) as A1_INJ_a4,
nvl(mbcview_cld_wn.A1_INJ_a5, mbcview_wrm_wn.A1_INJ_a5) as A1_INJ_a5,
nvl(mbcview_cld_wn.A1_INJ_a6, mbcview_wrm_wn.A1_INJ_a6) as A1_INJ_a6,
nvl(mbcview_cld_wn.A1_INJ_a7, mbcview_wrm_wn.A1_INJ_a7) as A1_INJ_a7,
nvl(mbcview_cld_wn.A1_INJ_a8, mbcview_wrm_wn.A1_INJ_a8) as A1_INJ_a8,
nvl(mbcview_cld_wn.A1_INJ_a9, mbcview_wrm_wn.A1_INJ_a9) as A1_INJ_a9,
nvl(mbcview_cld_wn.A1_INJ_a10,mbcview_wrm_wn.A1_INJ_a10) as A1_INJ_a10,
nvl(mbcview_cld_wn.A1_INJ_a11,mbcview_wrm_wn.A1_INJ_a11) as A1_INJ_a11,

nvl(mbcview_cld_wn.A1_EOI_TF, mbcview_wrm_wn.A1_EOI_TF ) as A1_EOI_TF,
nvl(mbcview_cld_wn.A1_EOI_ML, mbcview_wrm_wn.A1_EOI_ML ) as A1_EOI_ML,
mbcview_cld_wn.A1_EOI_FD as A1_EOI_FD,
nvl(mbcview_cld_wn.A1_EOI_b1, mbcview_wrm_wn.A1_EOI_b1 ) as A1_EOI_b1,
nvl(mbcview_cld_wn.A1_EOI_b2, mbcview_wrm_wn.A1_EOI_b2 ) as A1_EOI_b2,
nvl(mbcview_cld_wn.A1_EOI_b3, mbcview_wrm_wn.A1_EOI_b3 ) as A1_EOI_b3,
nvl(mbcview_cld_wn.A1_EOI_b4, mbcview_wrm_wn.A1_EOI_b4 ) as A1_EOI_b4,
nvl(mbcview_cld_wn.A1_EOI_b5, mbcview_wrm_wn.A1_EOI_b5 ) as A1_EOI_b5,
nvl(mbcview_cld_wn.A1_EOI_b6, mbcview_wrm_wn.A1_EOI_b6 ) as A1_EOI_b6,
nvl(mbcview_cld_wn.A1_EOI_b7, mbcview_wrm_wn.A1_EOI_b7 ) as A1_EOI_b7,
nvl(mbcview_cld_wn.A1_EOI_b8, mbcview_wrm_wn.A1_EOI_b8 ) as A1_EOI_b8,
nvl(mbcview_cld_wn.A1_EOI_b9, mbcview_wrm_wn.A1_EOI_b9 ) as A1_EOI_b9,
nvl(mbcview_cld_wn.A1_EOI_b10,mbcview_wrm_wn.A1_EOI_b10) as A1_EOI_b10,
nvl(mbcview_cld_wn.A1_EOI_b11,mbcview_wrm_wn.A1_EOI_b11) as A1_EOI_b11,
nvl(mbcview_cld_wn.A1_EOI_a2, mbcview_wrm_wn.A1_EOI_a2 ) as A1_EOI_a2,
nvl(mbcview_cld_wn.A1_EOI_a3, mbcview_wrm_wn.A1_EOI_a3 ) as A1_EOI_a3,
nvl(mbcview_cld_wn.A1_EOI_a4, mbcview_wrm_wn.A1_EOI_a4 ) as A1_EOI_a4,
nvl(mbcview_cld_wn.A1_EOI_a5, mbcview_wrm_wn.A1_EOI_a5 ) as A1_EOI_a5,
nvl(mbcview_cld_wn.A1_EOI_a6, mbcview_wrm_wn.A1_EOI_a6 ) as A1_EOI_a6,
nvl(mbcview_cld_wn.A1_EOI_a7, mbcview_wrm_wn.A1_EOI_a7 ) as A1_EOI_a7,
nvl(mbcview_cld_wn.A1_EOI_a8, mbcview_wrm_wn.A1_EOI_a8 ) as A1_EOI_a8,
nvl(mbcview_cld_wn.A1_EOI_a9, mbcview_wrm_wn.A1_EOI_a9 ) as A1_EOI_a9,
nvl(mbcview_cld_wn.A1_EOI_a10,mbcview_wrm_wn.A1_EOI_a10) as A1_EOI_a10,
nvl(mbcview_cld_wn.A1_EOI_a11,mbcview_wrm_wn.A1_EOI_a11) as A1_EOI_a11,

mbcview_cld_wn.A1_EOR_TF  as A1_EOR_TF,
mbcview_cld_wn.A1_EOR_ML  as A1_EOR_ML,
mbcview_cld_wn.A1_EOR_FD  as A1_EOR_FD,
mbcview_cld_wn.A1_EOR_b1  as A1_EOR_b1,
mbcview_cld_wn.A1_EOR_b2  as A1_EOR_b2,
mbcview_cld_wn.A1_EOR_b3  as A1_EOR_b3,
mbcview_cld_wn.A1_EOR_b4  as A1_EOR_b4,
mbcview_cld_wn.A1_EOR_b5  as A1_EOR_b5,
mbcview_cld_wn.A1_EOR_b6  as A1_EOR_b6,
mbcview_cld_wn.A1_EOR_b7  as A1_EOR_b7,
mbcview_cld_wn.A1_EOR_b8  as A1_EOR_b8,
mbcview_cld_wn.A1_EOR_b9  as A1_EOR_b9,
mbcview_cld_wn.A1_EOR_b10 as A1_EOR_b10,
mbcview_cld_wn.A1_EOR_b11 as A1_EOR_b11,
mbcview_cld_wn.A1_EOR_a2  as A1_EOR_a2,
mbcview_cld_wn.A1_EOR_a3  as A1_EOR_a3,
mbcview_cld_wn.A1_EOR_a4  as A1_EOR_a4,
mbcview_cld_wn.A1_EOR_a5  as A1_EOR_a5,
mbcview_cld_wn.A1_EOR_a6  as A1_EOR_a6,
mbcview_cld_wn.A1_EOR_a7  as A1_EOR_a7,
mbcview_cld_wn.A1_EOR_a8  as A1_EOR_a8,
mbcview_cld_wn.A1_EOR_a9  as A1_EOR_a9,
mbcview_cld_wn.A1_EOR_a10 as A1_EOR_a10,
mbcview_cld_wn.A1_EOR_a11 as A1_EOR_a11,

nvl(mbcview_cld_wn.A1_NOM_TF ,mbcview_wrm_wn.A1_NOM_TF ) as A1_NOM_TF,
nvl(mbcview_cld_wn.A1_NOM_ML ,mbcview_wrm_wn.A1_NOM_ML ) as A1_NOM_ML,
mbcview_cld_wn.A1_NOM_FD as A1_NOM_FD,
nvl(mbcview_cld_wn.A1_NOM_b1 ,mbcview_wrm_wn.A1_NOM_b1 ) as A1_NOM_b1,
nvl(mbcview_cld_wn.A1_NOM_b2 ,mbcview_wrm_wn.A1_NOM_b2 ) as A1_NOM_b2,
nvl(mbcview_cld_wn.A1_NOM_b3 ,mbcview_wrm_wn.A1_NOM_b3 ) as A1_NOM_b3,
nvl(mbcview_cld_wn.A1_NOM_b4 ,mbcview_wrm_wn.A1_NOM_b4 ) as A1_NOM_b4,
nvl(mbcview_cld_wn.A1_NOM_b5 ,mbcview_wrm_wn.A1_NOM_b5 ) as A1_NOM_b5,
nvl(mbcview_cld_wn.A1_NOM_b6 ,mbcview_wrm_wn.A1_NOM_b6 ) as A1_NOM_b6,
nvl(mbcview_cld_wn.A1_NOM_b7 ,mbcview_wrm_wn.A1_NOM_b7 ) as A1_NOM_b7,
nvl(mbcview_cld_wn.A1_NOM_b8 ,mbcview_wrm_wn.A1_NOM_b8 ) as A1_NOM_b8,
nvl(mbcview_cld_wn.A1_NOM_b9 ,mbcview_wrm_wn.A1_NOM_b9 ) as A1_NOM_b9,
nvl(mbcview_cld_wn.A1_NOM_b10,mbcview_wrm_wn.A1_NOM_b10) as A1_NOM_b10,
nvl(mbcview_cld_wn.A1_NOM_b11,mbcview_wrm_wn.A1_NOM_b11) as A1_NOM_b11,
nvl(mbcview_cld_wn.A1_NOM_a2 ,mbcview_wrm_wn.A1_NOM_a2 ) as A1_NOM_a2,
nvl(mbcview_cld_wn.A1_NOM_a3 ,mbcview_wrm_wn.A1_NOM_a3 ) as A1_NOM_a3,
nvl(mbcview_cld_wn.A1_NOM_a4 ,mbcview_wrm_wn.A1_NOM_a4 ) as A1_NOM_a4,
nvl(mbcview_cld_wn.A1_NOM_a5 ,mbcview_wrm_wn.A1_NOM_a5 ) as A1_NOM_a5,
nvl(mbcview_cld_wn.A1_NOM_a6 ,mbcview_wrm_wn.A1_NOM_a6 ) as A1_NOM_a6,
nvl(mbcview_cld_wn.A1_NOM_a7 ,mbcview_wrm_wn.A1_NOM_a7 ) as A1_NOM_a7,
nvl(mbcview_cld_wn.A1_NOM_a8 ,mbcview_wrm_wn.A1_NOM_a8 ) as A1_NOM_a8,
nvl(mbcview_cld_wn.A1_NOM_a9 ,mbcview_wrm_wn.A1_NOM_a9 ) as A1_NOM_a9,
nvl(mbcview_cld_wn.A1_NOM_a10,mbcview_wrm_wn.A1_NOM_a10) as A1_NOM_a10,
nvl(mbcview_cld_wn.A1_NOM_a11,mbcview_wrm_wn.A1_NOM_a11) as A1_NOM_a11,

nvl(mbcview_cld_wn.A2_INJ_TF,mbcview_wrm_wn.A2_INJ_TF) as A2_INJ_TF,
nvl(mbcview_cld_wn.A2_INJ_ML,mbcview_wrm_wn.A2_INJ_ML) as A2_INJ_ML,
mbcview_cld_wn.A2_INJ_FD as A2_INJ_FD,
nvl(mbcview_cld_wn.A2_INJ_b1,mbcview_wrm_wn.A2_INJ_b1) as A2_INJ_b1,
nvl(mbcview_cld_wn.A2_INJ_b2,mbcview_wrm_wn.A2_INJ_b2) as A2_INJ_b2,
nvl(mbcview_cld_wn.A2_INJ_b3,mbcview_wrm_wn.A2_INJ_b3) as A2_INJ_b3,
nvl(mbcview_cld_wn.A2_INJ_b4,mbcview_wrm_wn.A2_INJ_b4) as A2_INJ_b4,
nvl(mbcview_cld_wn.A2_INJ_b5,mbcview_wrm_wn.A2_INJ_b5) as A2_INJ_b5,
nvl(mbcview_cld_wn.A2_INJ_b6,mbcview_wrm_wn.A2_INJ_b6) as A2_INJ_b6,
nvl(mbcview_cld_wn.A2_INJ_b7,mbcview_wrm_wn.A2_INJ_b7) as A2_INJ_b7,
nvl(mbcview_cld_wn.A2_INJ_b8,mbcview_wrm_wn.A2_INJ_b8) as A2_INJ_b8,
nvl(mbcview_cld_wn.A2_INJ_b9,mbcview_wrm_wn.A2_INJ_b9) as A2_INJ_b9,
nvl(mbcview_cld_wn.A2_INJ_b10,mbcview_wrm_wn.A2_INJ_b10) as A2_INJ_b10,
nvl(mbcview_cld_wn.A2_INJ_b11,mbcview_wrm_wn.A2_INJ_b11) as A2_INJ_b11,
nvl(mbcview_cld_wn.A2_INJ_a2,mbcview_wrm_wn.A2_INJ_a2) as A2_INJ_a2,
nvl(mbcview_cld_wn.A2_INJ_a3,mbcview_wrm_wn.A2_INJ_a3) as A2_INJ_a3,
nvl(mbcview_cld_wn.A2_INJ_a4,mbcview_wrm_wn.A2_INJ_a4) as A2_INJ_a4,
nvl(mbcview_cld_wn.A2_INJ_a5,mbcview_wrm_wn.A2_INJ_a5) as A2_INJ_a5,
nvl(mbcview_cld_wn.A2_INJ_a6,mbcview_wrm_wn.A2_INJ_a6) as A2_INJ_a6,
nvl(mbcview_cld_wn.A2_INJ_a7,mbcview_wrm_wn.A2_INJ_a7) as A2_INJ_a7,
nvl(mbcview_cld_wn.A2_INJ_a8,mbcview_wrm_wn.A2_INJ_a8) as A2_INJ_a8,
nvl(mbcview_cld_wn.A2_INJ_a9,mbcview_wrm_wn.A2_INJ_a9) as A2_INJ_a9,
nvl(mbcview_cld_wn.A2_INJ_a10,mbcview_wrm_wn.A2_INJ_a10) as A2_INJ_a10,
nvl(mbcview_cld_wn.A2_INJ_a11,mbcview_wrm_wn.A2_INJ_a11) as A2_INJ_a11,

nvl(mbcview_cld_wn.A2_EOI_TF, mbcview_wrm_wn.A2_EOI_TF ) as A2_EOI_TF,
nvl(mbcview_cld_wn.A2_EOI_ML, mbcview_wrm_wn.A2_EOI_ML ) as A2_EOI_ML,
mbcview_cld_wn.A2_EOI_FD as A2_EOI_FD,
nvl(mbcview_cld_wn.A2_EOI_b1, mbcview_wrm_wn.A2_EOI_b1 ) as A2_EOI_b1,
nvl(mbcview_cld_wn.A2_EOI_b2, mbcview_wrm_wn.A2_EOI_b2 ) as A2_EOI_b2,
nvl(mbcview_cld_wn.A2_EOI_b3, mbcview_wrm_wn.A2_EOI_b3 ) as A2_EOI_b3,
nvl(mbcview_cld_wn.A2_EOI_b4, mbcview_wrm_wn.A2_EOI_b4 ) as A2_EOI_b4,
nvl(mbcview_cld_wn.A2_EOI_b5, mbcview_wrm_wn.A2_EOI_b5 ) as A2_EOI_b5,
nvl(mbcview_cld_wn.A2_EOI_b6, mbcview_wrm_wn.A2_EOI_b6 ) as A2_EOI_b6,
nvl(mbcview_cld_wn.A2_EOI_b7, mbcview_wrm_wn.A2_EOI_b7 ) as A2_EOI_b7,
nvl(mbcview_cld_wn.A2_EOI_b8, mbcview_wrm_wn.A2_EOI_b8 ) as A2_EOI_b8,
nvl(mbcview_cld_wn.A2_EOI_b9, mbcview_wrm_wn.A2_EOI_b9 ) as A2_EOI_b9,
nvl(mbcview_cld_wn.A2_EOI_b10,mbcview_wrm_wn.A2_EOI_b10) as A2_EOI_b10,
nvl(mbcview_cld_wn.A2_EOI_b11,mbcview_wrm_wn.A2_EOI_b11) as A2_EOI_b11,
nvl(mbcview_cld_wn.A2_EOI_a2, mbcview_wrm_wn.A2_EOI_a2 ) as A2_EOI_a2,
nvl(mbcview_cld_wn.A2_EOI_a3, mbcview_wrm_wn.A2_EOI_a3 ) as A2_EOI_a3,
nvl(mbcview_cld_wn.A2_EOI_a4, mbcview_wrm_wn.A2_EOI_a4 ) as A2_EOI_a4,
nvl(mbcview_cld_wn.A2_EOI_a5, mbcview_wrm_wn.A2_EOI_a5 ) as A2_EOI_a5,
nvl(mbcview_cld_wn.A2_EOI_a6, mbcview_wrm_wn.A2_EOI_a6 ) as A2_EOI_a6,
nvl(mbcview_cld_wn.A2_EOI_a7, mbcview_wrm_wn.A2_EOI_a7 ) as A2_EOI_a7,
nvl(mbcview_cld_wn.A2_EOI_a8, mbcview_wrm_wn.A2_EOI_a8 ) as A2_EOI_a8,
nvl(mbcview_cld_wn.A2_EOI_a9, mbcview_wrm_wn.A2_EOI_a9 ) as A2_EOI_a9,
nvl(mbcview_cld_wn.A2_EOI_a10,mbcview_wrm_wn.A2_EOI_a10) as A2_EOI_a10,
nvl(mbcview_cld_wn.A2_EOI_a11,mbcview_wrm_wn.A2_EOI_a11) as A2_EOI_a11,

mbcview_cld_wn.A2_EOR_TF  as A2_EOR_TF,
mbcview_cld_wn.A2_EOR_ML  as A2_EOR_ML,
mbcview_cld_wn.A2_EOR_FD  as A2_EOR_FD,
mbcview_cld_wn.A2_EOR_b1  as A2_EOR_b1,
mbcview_cld_wn.A2_EOR_b2  as A2_EOR_b2,
mbcview_cld_wn.A2_EOR_b3  as A2_EOR_b3,
mbcview_cld_wn.A2_EOR_b4  as A2_EOR_b4,
mbcview_cld_wn.A2_EOR_b5  as A2_EOR_b5,
mbcview_cld_wn.A2_EOR_b6  as A2_EOR_b6,
mbcview_cld_wn.A2_EOR_b7  as A2_EOR_b7,
mbcview_cld_wn.A2_EOR_b8  as A2_EOR_b8,
mbcview_cld_wn.A2_EOR_b9  as A2_EOR_b9,
mbcview_cld_wn.A2_EOR_b10 as A2_EOR_b10,
mbcview_cld_wn.A2_EOR_b11 as A2_EOR_b11,
mbcview_cld_wn.A2_EOR_a2  as A2_EOR_a2,
mbcview_cld_wn.A2_EOR_a3  as A2_EOR_a3,
mbcview_cld_wn.A2_EOR_a4  as A2_EOR_a4,
mbcview_cld_wn.A2_EOR_a5  as A2_EOR_a5,
mbcview_cld_wn.A2_EOR_a6  as A2_EOR_a6,
mbcview_cld_wn.A2_EOR_a7  as A2_EOR_a7,
mbcview_cld_wn.A2_EOR_a8  as A2_EOR_a8,
mbcview_cld_wn.A2_EOR_a9  as A2_EOR_a9,
mbcview_cld_wn.A2_EOR_a10 as A2_EOR_a10,
mbcview_cld_wn.A2_EOR_a11 as A2_EOR_a11,

nvl(mbcview_cld_wn.A2_NOM_TF ,mbcview_wrm_wn.A2_NOM_TF ) as A2_NOM_TF,
nvl(mbcview_cld_wn.A2_NOM_ML ,mbcview_wrm_wn.A2_NOM_ML ) as A2_NOM_ML,
mbcview_cld_wn.A2_NOM_FD as A2_NOM_FD,
nvl(mbcview_cld_wn.A2_NOM_b1 ,mbcview_wrm_wn.A2_NOM_b1 ) as A2_NOM_b1,
nvl(mbcview_cld_wn.A2_NOM_b2 ,mbcview_wrm_wn.A2_NOM_b2 ) as A2_NOM_b2,
nvl(mbcview_cld_wn.A2_NOM_b3 ,mbcview_wrm_wn.A2_NOM_b3 ) as A2_NOM_b3,
nvl(mbcview_cld_wn.A2_NOM_b4 ,mbcview_wrm_wn.A2_NOM_b4 ) as A2_NOM_b4,
nvl(mbcview_cld_wn.A2_NOM_b5 ,mbcview_wrm_wn.A2_NOM_b5 ) as A2_NOM_b5,
nvl(mbcview_cld_wn.A2_NOM_b6 ,mbcview_wrm_wn.A2_NOM_b6 ) as A2_NOM_b6,
nvl(mbcview_cld_wn.A2_NOM_b7 ,mbcview_wrm_wn.A2_NOM_b7 ) as A2_NOM_b7,
nvl(mbcview_cld_wn.A2_NOM_b8 ,mbcview_wrm_wn.A2_NOM_b8 ) as A2_NOM_b8,
nvl(mbcview_cld_wn.A2_NOM_b9 ,mbcview_wrm_wn.A2_NOM_b9 ) as A2_NOM_b9,
nvl(mbcview_cld_wn.A2_NOM_b10,mbcview_wrm_wn.A2_NOM_b10) as A2_NOM_b10,
nvl(mbcview_cld_wn.A2_NOM_b11,mbcview_wrm_wn.A2_NOM_b11) as A2_NOM_b11,
nvl(mbcview_cld_wn.A2_NOM_a2 ,mbcview_wrm_wn.A2_NOM_a2 ) as A2_NOM_a2,
nvl(mbcview_cld_wn.A2_NOM_a3 ,mbcview_wrm_wn.A2_NOM_a3 ) as A2_NOM_a3,
nvl(mbcview_cld_wn.A2_NOM_a4 ,mbcview_wrm_wn.A2_NOM_a4 ) as A2_NOM_a4,
nvl(mbcview_cld_wn.A2_NOM_a5 ,mbcview_wrm_wn.A2_NOM_a5 ) as A2_NOM_a5,
nvl(mbcview_cld_wn.A2_NOM_a6 ,mbcview_wrm_wn.A2_NOM_a6 ) as A2_NOM_a6,
nvl(mbcview_cld_wn.A2_NOM_a7 ,mbcview_wrm_wn.A2_NOM_a7 ) as A2_NOM_a7,
nvl(mbcview_cld_wn.A2_NOM_a8 ,mbcview_wrm_wn.A2_NOM_a8 ) as A2_NOM_a8,
nvl(mbcview_cld_wn.A2_NOM_a9 ,mbcview_wrm_wn.A2_NOM_a9 ) as A2_NOM_a9,
nvl(mbcview_cld_wn.A2_NOM_a10,mbcview_wrm_wn.A2_NOM_a10) as A2_NOM_a10,
nvl(mbcview_cld_wn.A2_NOM_a11,mbcview_wrm_wn.A2_NOM_a11) as A2_NOM_a11
from
  TST_MBCVIEW_WARM_WITH_NULLS mbcview_wrm_wn,
  TST_MBCVIEW_COLD_WITH_NULLS mbcview_cld_wn
where
  mbcview_wrm_wn.magnet_name = mbcview_cld_wn.magnet_name (+);

NEW VERSION

CREATE OR REPLACE VIEW TST_MBCVIEW_WITH_NULLS (MAGNET_NAME, MEASDATE, 
A1_INJ_TF, A1_INJ_ML, A1_INJ_FD, A1_INJ_B1, 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_A2, 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_EOI_TF, A1_EOI_ML, A1_EOI_FD, A1_EOI_B1, 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_A2, 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_EOR_TF, A1_EOR_ML, A1_EOR_FD, A1_EOR_B1, 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_A2, 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_NOM_TF, A1_NOM_ML, A1_NOM_FD, A1_NOM_B1, 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_A2, 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,
A2_INJ_TF, A2_INJ_ML, A2_INJ_FD, A2_INJ_B1, 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_A2, 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_EOI_TF, A2_EOI_ML, A2_EOI_FD, A2_EOI_B1, 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_A2, 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_EOR_TF, A2_EOR_ML, A2_EOR_FD, A2_EOR_B1, 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_A2, 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_NOM_TF, A2_NOM_ML, A2_NOM_FD, A2_NOM_B1, 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_A2, 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) AS
select
mbcview_wrm_wn.magnet_name as MAGNET_NAME,
nvl(mbcview_cld_wn.MEASDATE, mbcview_wrm_wn.MEASDATE) as MEASDATE,

nvl(mbcview_cld_wn.A1_INJ_TF, mbcview_wrm_wn.A1_INJ_TF) as A1_INJ_TF,
nvl(mbcview_cld_wn.A1_INJ_ML, mbcview_wrm_wn.A1_INJ_ML) as A1_INJ_ML,
mbcview_cld_wn.A1_INJ_FD as A1_INJ_FD,
nvl(mbcview_cld_wn.A1_INJ_b1, mbcview_wrm_wn.A1_INJ_b1) as A1_INJ_b1,
nvl(mbcview_cld_wn.A1_INJ_b2, mbcview_wrm_wn.A1_INJ_b2) as A1_INJ_b2,
nvl(mbcview_cld_wn.A1_INJ_b3, mbcview_wrm_wn.A1_INJ_b3) as A1_INJ_b3,
nvl(mbcview_cld_wn.A1_INJ_b4, mbcview_wrm_wn.A1_INJ_b4) as A1_INJ_b4,
nvl(mbcview_cld_wn.A1_INJ_b5, mbcview_wrm_wn.A1_INJ_b5) as A1_INJ_b5,
nvl(mbcview_cld_wn.A1_INJ_b6, mbcview_wrm_wn.A1_INJ_b6) as A1_INJ_b6,
nvl(mbcview_cld_wn.A1_INJ_b7, mbcview_wrm_wn.A1_INJ_b7) as A1_INJ_b7,
nvl(mbcview_cld_wn.A1_INJ_b8, mbcview_wrm_wn.A1_INJ_b8) as A1_INJ_b8,
nvl(mbcview_cld_wn.A1_INJ_b9, mbcview_wrm_wn.A1_INJ_b9) as A1_INJ_b9,
nvl(mbcview_cld_wn.A1_INJ_b10,mbcview_wrm_wn.A1_INJ_b10) as A1_INJ_b10,
nvl(mbcview_cld_wn.A1_INJ_b11,mbcview_wrm_wn.A1_INJ_b11) as A1_INJ_b11,
nvl(mbcview_cld_wn.A1_INJ_a2, mbcview_wrm_wn.A1_INJ_a2) as A1_INJ_a2,
nvl(mbcview_cld_wn.A1_INJ_a3, mbcview_wrm_wn.A1_INJ_a3) as A1_INJ_a3,
nvl(mbcview_cld_wn.A1_INJ_a4, mbcview_wrm_wn.A1_INJ_a4) as A1_INJ_a4,
nvl(mbcview_cld_wn.A1_INJ_a5, mbcview_wrm_wn.A1_INJ_a5) as A1_INJ_a5,
nvl(mbcview_cld_wn.A1_INJ_a6, mbcview_wrm_wn.A1_INJ_a6) as A1_INJ_a6,
nvl(mbcview_cld_wn.A1_INJ_a7, mbcview_wrm_wn.A1_INJ_a7) as A1_INJ_a7,
nvl(mbcview_cld_wn.A1_INJ_a8, mbcview_wrm_wn.A1_INJ_a8) as A1_INJ_a8,
nvl(mbcview_cld_wn.A1_INJ_a9, mbcview_wrm_wn.A1_INJ_a9) as A1_INJ_a9,
nvl(mbcview_cld_wn.A1_INJ_a10,mbcview_wrm_wn.A1_INJ_a10) as A1_INJ_a10,
nvl(mbcview_cld_wn.A1_INJ_a11,mbcview_wrm_wn.A1_INJ_a11) as A1_INJ_a11,

nvl(mbcview_cld_wn.A1_EOI_TF, mbcview_wrm_wn.A1_EOI_TF ) as A1_EOI_TF,
nvl(mbcview_cld_wn.A1_EOI_ML, mbcview_wrm_wn.A1_EOI_ML ) as A1_EOI_ML,
mbcview_cld_wn.A1_EOI_FD as A1_EOI_FD,
nvl(mbcview_cld_wn.A1_EOI_b1, mbcview_wrm_wn.A1_EOI_b1 ) as A1_EOI_b1,
nvl(mbcview_cld_wn.A1_EOI_b2, mbcview_wrm_wn.A1_EOI_b2 ) as A1_EOI_b2,
nvl(mbcview_cld_wn.A1_EOI_b3, mbcview_wrm_wn.A1_EOI_b3 ) as A1_EOI_b3,
nvl(mbcview_cld_wn.A1_EOI_b4, mbcview_wrm_wn.A1_EOI_b4 ) as A1_EOI_b4,
nvl(mbcview_cld_wn.A1_EOI_b5, mbcview_wrm_wn.A1_EOI_b5 ) as A1_EOI_b5,
nvl(mbcview_cld_wn.A1_EOI_b6, mbcview_wrm_wn.A1_EOI_b6 ) as A1_EOI_b6,
nvl(mbcview_cld_wn.A1_EOI_b7, mbcview_wrm_wn.A1_EOI_b7 ) as A1_EOI_b7,
nvl(mbcview_cld_wn.A1_EOI_b8, mbcview_wrm_wn.A1_EOI_b8 ) as A1_EOI_b8,
nvl(mbcview_cld_wn.A1_EOI_b9, mbcview_wrm_wn.A1_EOI_b9 ) as A1_EOI_b9,
nvl(mbcview_cld_wn.A1_EOI_b10,mbcview_wrm_wn.A1_EOI_b10) as A1_EOI_b10,
nvl(mbcview_cld_wn.A1_EOI_b11,mbcview_wrm_wn.A1_EOI_b11) as A1_EOI_b11,
nvl(mbcview_cld_wn.A1_EOI_a2, mbcview_wrm_wn.A1_EOI_a2 ) as A1_EOI_a2,
nvl(mbcview_cld_wn.A1_EOI_a3, mbcview_wrm_wn.A1_EOI_a3 ) as A1_EOI_a3,
nvl(mbcview_cld_wn.A1_EOI_a4, mbcview_wrm_wn.A1_EOI_a4 ) as A1_EOI_a4,
nvl(mbcview_cld_wn.A1_EOI_a5, mbcview_wrm_wn.A1_EOI_a5 ) as A1_EOI_a5,
nvl(mbcview_cld_wn.A1_EOI_a6, mbcview_wrm_wn.A1_EOI_a6 ) as A1_EOI_a6,
nvl(mbcview_cld_wn.A1_EOI_a7, mbcview_wrm_wn.A1_EOI_a7 ) as A1_EOI_a7,
nvl(mbcview_cld_wn.A1_EOI_a8, mbcview_wrm_wn.A1_EOI_a8 ) as A1_EOI_a8,
nvl(mbcview_cld_wn.A1_EOI_a9, mbcview_wrm_wn.A1_EOI_a9 ) as A1_EOI_a9,
nvl(mbcview_cld_wn.A1_EOI_a10,mbcview_wrm_wn.A1_EOI_a10) as A1_EOI_a10,
nvl(mbcview_cld_wn.A1_EOI_a11,mbcview_wrm_wn.A1_EOI_a11) as A1_EOI_a11,

mbcview_cld_wn.A1_EOR_TF  as A1_EOR_TF,
mbcview_cld_wn.A1_EOR_ML  as A1_EOR_ML,
mbcview_cld_wn.A1_EOR_FD  as A1_EOR_FD,
mbcview_cld_wn.A1_EOR_b1  as A1_EOR_b1,
mbcview_cld_wn.A1_EOR_b2  as A1_EOR_b2,
mbcview_cld_wn.A1_EOR_b3  as A1_EOR_b3,
mbcview_cld_wn.A1_EOR_b4  as A1_EOR_b4,
mbcview_cld_wn.A1_EOR_b5  as A1_EOR_b5,
mbcview_cld_wn.A1_EOR_b6  as A1_EOR_b6,
mbcview_cld_wn.A1_EOR_b7  as A1_EOR_b7,
mbcview_cld_wn.A1_EOR_b8  as A1_EOR_b8,
mbcview_cld_wn.A1_EOR_b9  as A1_EOR_b9,
mbcview_cld_wn.A1_EOR_b10 as A1_EOR_b10,
mbcview_cld_wn.A1_EOR_b11 as A1_EOR_b11,
mbcview_cld_wn.A1_EOR_a2  as A1_EOR_a2,
mbcview_cld_wn.A1_EOR_a3  as A1_EOR_a3,
mbcview_cld_wn.A1_EOR_a4  as A1_EOR_a4,
mbcview_cld_wn.A1_EOR_a5  as A1_EOR_a5,
mbcview_cld_wn.A1_EOR_a6  as A1_EOR_a6,
mbcview_cld_wn.A1_EOR_a7  as A1_EOR_a7,
mbcview_cld_wn.A1_EOR_a8  as A1_EOR_a8,
mbcview_cld_wn.A1_EOR_a9  as A1_EOR_a9,
mbcview_cld_wn.A1_EOR_a10 as A1_EOR_a10,
mbcview_cld_wn.A1_EOR_a11 as A1_EOR_a11,

nvl(mbcview_cld_wn.A1_NOM_TF ,mbcview_wrm_wn.A1_NOM_TF ) as A1_NOM_TF,
nvl(mbcview_cld_wn.A1_NOM_ML ,mbcview_wrm_wn.A1_NOM_ML ) as A1_NOM_ML,
mbcview_cld_wn.A1_NOM_FD as A1_NOM_FD,
nvl(mbcview_cld_wn.A1_NOM_b1 ,mbcview_wrm_wn.A1_NOM_b1 ) as A1_NOM_b1,
nvl(mbcview_cld_wn.A1_NOM_b2 ,mbcview_wrm_wn.A1_NOM_b2 ) as A1_NOM_b2,
nvl(mbcview_cld_wn.A1_NOM_b3 ,mbcview_wrm_wn.A1_NOM_b3 ) as A1_NOM_b3,
nvl(mbcview_cld_wn.A1_NOM_b4 ,mbcview_wrm_wn.A1_NOM_b4 ) as A1_NOM_b4,
nvl(mbcview_cld_wn.A1_NOM_b5 ,mbcview_wrm_wn.A1_NOM_b5 ) as A1_NOM_b5,
nvl(mbcview_cld_wn.A1_NOM_b6 ,mbcview_wrm_wn.A1_NOM_b6 ) as A1_NOM_b6,
nvl(mbcview_cld_wn.A1_NOM_b7 ,mbcview_wrm_wn.A1_NOM_b7 ) as A1_NOM_b7,
nvl(mbcview_cld_wn.A1_NOM_b8 ,mbcview_wrm_wn.A1_NOM_b8 ) as A1_NOM_b8,
nvl(mbcview_cld_wn.A1_NOM_b9 ,mbcview_wrm_wn.A1_NOM_b9 ) as A1_NOM_b9,
nvl(mbcview_cld_wn.A1_NOM_b10,mbcview_wrm_wn.A1_NOM_b10) as A1_NOM_b10,
nvl(mbcview_cld_wn.A1_NOM_b11,mbcview_wrm_wn.A1_NOM_b11) as A1_NOM_b11,
nvl(mbcview_cld_wn.A1_NOM_a2 ,mbcview_wrm_wn.A1_NOM_a2 ) as A1_NOM_a2,
nvl(mbcview_cld_wn.A1_NOM_a3 ,mbcview_wrm_wn.A1_NOM_a3 ) as A1_NOM_a3,
nvl(mbcview_cld_wn.A1_NOM_a4 ,mbcview_wrm_wn.A1_NOM_a4 ) as A1_NOM_a4,
nvl(mbcview_cld_wn.A1_NOM_a5 ,mbcview_wrm_wn.A1_NOM_a5 ) as A1_NOM_a5,
nvl(mbcview_cld_wn.A1_NOM_a6 ,mbcview_wrm_wn.A1_NOM_a6 ) as A1_NOM_a6,
nvl(mbcview_cld_wn.A1_NOM_a7 ,mbcview_wrm_wn.A1_NOM_a7 ) as A1_NOM_a7,
nvl(mbcview_cld_wn.A1_NOM_a8 ,mbcview_wrm_wn.A1_NOM_a8 ) as A1_NOM_a8,
nvl(mbcview_cld_wn.A1_NOM_a9 ,mbcview_wrm_wn.A1_NOM_a9 ) as A1_NOM_a9,
nvl(mbcview_cld_wn.A1_NOM_a10,mbcview_wrm_wn.A1_NOM_a10) as A1_NOM_a10,
nvl(mbcview_cld_wn.A1_NOM_a11,mbcview_wrm_wn.A1_NOM_a11) as A1_NOM_a11,

nvl(mbcview_cld_wn.A2_INJ_TF,mbcview_wrm_wn.A2_INJ_TF) as A2_INJ_TF,
nvl(mbcview_cld_wn.A2_INJ_ML,mbcview_wrm_wn.A2_INJ_ML) as A2_INJ_ML,
mbcview_cld_wn.A2_INJ_FD as A2_INJ_FD,
nvl(mbcview_cld_wn.A2_INJ_b1,mbcview_wrm_wn.A2_INJ_b1) as A2_INJ_b1,
nvl(mbcview_cld_wn.A2_INJ_b2,mbcview_wrm_wn.A2_INJ_b2) as A2_INJ_b2,
nvl(mbcview_cld_wn.A2_INJ_b3,mbcview_wrm_wn.A2_INJ_b3) as A2_INJ_b3,
nvl(mbcview_cld_wn.A2_INJ_b4,mbcview_wrm_wn.A2_INJ_b4) as A2_INJ_b4,
nvl(mbcview_cld_wn.A2_INJ_b5,mbcview_wrm_wn.A2_INJ_b5) as A2_INJ_b5,
nvl(mbcview_cld_wn.A2_INJ_b6,mbcview_wrm_wn.A2_INJ_b6) as A2_INJ_b6,
nvl(mbcview_cld_wn.A2_INJ_b7,mbcview_wrm_wn.A2_INJ_b7) as A2_INJ_b7,
nvl(mbcview_cld_wn.A2_INJ_b8,mbcview_wrm_wn.A2_INJ_b8) as A2_INJ_b8,
nvl(mbcview_cld_wn.A2_INJ_b9,mbcview_wrm_wn.A2_INJ_b9) as A2_INJ_b9,
nvl(mbcview_cld_wn.A2_INJ_b10,mbcview_wrm_wn.A2_INJ_b10) as A2_INJ_b10,
nvl(mbcview_cld_wn.A2_INJ_b11,mbcview_wrm_wn.A2_INJ_b11) as A2_INJ_b11,
nvl(mbcview_cld_wn.A2_INJ_a2,mbcview_wrm_wn.A2_INJ_a2) as A2_INJ_a2,
nvl(mbcview_cld_wn.A2_INJ_a3,mbcview_wrm_wn.A2_INJ_a3) as A2_INJ_a3,
nvl(mbcview_cld_wn.A2_INJ_a4,mbcview_wrm_wn.A2_INJ_a4) as A2_INJ_a4,
nvl(mbcview_cld_wn.A2_INJ_a5,mbcview_wrm_wn.A2_INJ_a5) as A2_INJ_a5,
nvl(mbcview_cld_wn.A2_INJ_a6,mbcview_wrm_wn.A2_INJ_a6) as A2_INJ_a6,
nvl(mbcview_cld_wn.A2_INJ_a7,mbcview_wrm_wn.A2_INJ_a7) as A2_INJ_a7,
nvl(mbcview_cld_wn.A2_INJ_a8,mbcview_wrm_wn.A2_INJ_a8) as A2_INJ_a8,
nvl(mbcview_cld_wn.A2_INJ_a9,mbcview_wrm_wn.A2_INJ_a9) as A2_INJ_a9,
nvl(mbcview_cld_wn.A2_INJ_a10,mbcview_wrm_wn.A2_INJ_a10) as A2_INJ_a10,
nvl(mbcview_cld_wn.A2_INJ_a11,mbcview_wrm_wn.A2_INJ_a11) as A2_INJ_a11,

nvl(mbcview_cld_wn.A2_EOI_TF, mbcview_wrm_wn.A2_EOI_TF ) as A2_EOI_TF,
nvl(mbcview_cld_wn.A2_EOI_ML, mbcview_wrm_wn.A2_EOI_ML ) as A2_EOI_ML,
mbcview_cld_wn.A2_EOI_FD as A2_EOI_FD,
nvl(mbcview_cld_wn.A2_EOI_b1, mbcview_wrm_wn.A2_EOI_b1 ) as A2_EOI_b1,
nvl(mbcview_cld_wn.A2_EOI_b2, mbcview_wrm_wn.A2_EOI_b2 ) as A2_EOI_b2,
nvl(mbcview_cld_wn.A2_EOI_b3, mbcview_wrm_wn.A2_EOI_b3 ) as A2_EOI_b3,
nvl(mbcview_cld_wn.A2_EOI_b4, mbcview_wrm_wn.A2_EOI_b4 ) as A2_EOI_b4,
nvl(mbcview_cld_wn.A2_EOI_b5, mbcview_wrm_wn.A2_EOI_b5 ) as A2_EOI_b5,
nvl(mbcview_cld_wn.A2_EOI_b6, mbcview_wrm_wn.A2_EOI_b6 ) as A2_EOI_b6,
nvl(mbcview_cld_wn.A2_EOI_b7, mbcview_wrm_wn.A2_EOI_b7 ) as A2_EOI_b7,
nvl(mbcview_cld_wn.A2_EOI_b8, mbcview_wrm_wn.A2_EOI_b8 ) as A2_EOI_b8,
nvl(mbcview_cld_wn.A2_EOI_b9, mbcview_wrm_wn.A2_EOI_b9 ) as A2_EOI_b9,
nvl(mbcview_cld_wn.A2_EOI_b10,mbcview_wrm_wn.A2_EOI_b10) as A2_EOI_b10,
nvl(mbcview_cld_wn.A2_EOI_b11,mbcview_wrm_wn.A2_EOI_b11) as A2_EOI_b11,
nvl(mbcview_cld_wn.A2_EOI_a2, mbcview_wrm_wn.A2_EOI_a2 ) as A2_EOI_a2,
nvl(mbcview_cld_wn.A2_EOI_a3, mbcview_wrm_wn.A2_EOI_a3 ) as A2_EOI_a3,
nvl(mbcview_cld_wn.A2_EOI_a4, mbcview_wrm_wn.A2_EOI_a4 ) as A2_EOI_a4,
nvl(mbcview_cld_wn.A2_EOI_a5, mbcview_wrm_wn.A2_EOI_a5 ) as A2_EOI_a5,
nvl(mbcview_cld_wn.A2_EOI_a6, mbcview_wrm_wn.A2_EOI_a6 ) as A2_EOI_a6,
nvl(mbcview_cld_wn.A2_EOI_a7, mbcview_wrm_wn.A2_EOI_a7 ) as A2_EOI_a7,
nvl(mbcview_cld_wn.A2_EOI_a8, mbcview_wrm_wn.A2_EOI_a8 ) as A2_EOI_a8,
nvl(mbcview_cld_wn.A2_EOI_a9, mbcview_wrm_wn.A2_EOI_a9 ) as A2_EOI_a9,
nvl(mbcview_cld_wn.A2_EOI_a10,mbcview_wrm_wn.A2_EOI_a10) as A2_EOI_a10,
nvl(mbcview_cld_wn.A2_EOI_a11,mbcview_wrm_wn.A2_EOI_a11) as A2_EOI_a11,

mbcview_cld_wn.A2_EOR_TF  as A2_EOR_TF,
mbcview_cld_wn.A2_EOR_ML  as A2_EOR_ML,
mbcview_cld_wn.A2_EOR_FD  as A2_EOR_FD,
mbcview_cld_wn.A2_EOR_b1  as A2_EOR_b1,
mbcview_cld_wn.A2_EOR_b2  as A2_EOR_b2,
mbcview_cld_wn.A2_EOR_b3  as A2_EOR_b3,
mbcview_cld_wn.A2_EOR_b4  as A2_EOR_b4,
mbcview_cld_wn.A2_EOR_b5  as A2_EOR_b5,
mbcview_cld_wn.A2_EOR_b6  as A2_EOR_b6,
mbcview_cld_wn.A2_EOR_b7  as A2_EOR_b7,
mbcview_cld_wn.A2_EOR_b8  as A2_EOR_b8,
mbcview_cld_wn.A2_EOR_b9  as A2_EOR_b9,
mbcview_cld_wn.A2_EOR_b10 as A2_EOR_b10,
mbcview_cld_wn.A2_EOR_b11 as A2_EOR_b11,
mbcview_cld_wn.A2_EOR_a2  as A2_EOR_a2,
mbcview_cld_wn.A2_EOR_a3  as A2_EOR_a3,
mbcview_cld_wn.A2_EOR_a4  as A2_EOR_a4,
mbcview_cld_wn.A2_EOR_a5  as A2_EOR_a5,
mbcview_cld_wn.A2_EOR_a6  as A2_EOR_a6,
mbcview_cld_wn.A2_EOR_a7  as A2_EOR_a7,
mbcview_cld_wn.A2_EOR_a8  as A2_EOR_a8,
mbcview_cld_wn.A2_EOR_a9  as A2_EOR_a9,
mbcview_cld_wn.A2_EOR_a10 as A2_EOR_a10,
mbcview_cld_wn.A2_EOR_a11 as A2_EOR_a11,

nvl(mbcview_cld_wn.A2_NOM_TF ,mbcview_wrm_wn.A2_NOM_TF ) as A2_NOM_TF,
nvl(mbcview_cld_wn.A2_NOM_ML ,mbcview_wrm_wn.A2_NOM_ML ) as A2_NOM_ML,
mbcview_cld_wn.A2_NOM_FD as A2_NOM_FD,
nvl(mbcview_cld_wn.A2_NOM_b1 ,mbcview_wrm_wn.A2_NOM_b1 ) as A2_NOM_b1,
nvl(mbcview_cld_wn.A2_NOM_b2 ,mbcview_wrm_wn.A2_NOM_b2 ) as A2_NOM_b2,
nvl(mbcview_cld_wn.A2_NOM_b3 ,mbcview_wrm_wn.A2_NOM_b3 ) as A2_NOM_b3,
nvl(mbcview_cld_wn.A2_NOM_b4 ,mbcview_wrm_wn.A2_NOM_b4 ) as A2_NOM_b4,
nvl(mbcview_cld_wn.A2_NOM_b5 ,mbcview_wrm_wn.A2_NOM_b5 ) as A2_NOM_b5,
nvl(mbcview_cld_wn.A2_NOM_b6 ,mbcview_wrm_wn.A2_NOM_b6 ) as A2_NOM_b6,
nvl(mbcview_cld_wn.A2_NOM_b7 ,mbcview_wrm_wn.A2_NOM_b7 ) as A2_NOM_b7,
nvl(mbcview_cld_wn.A2_NOM_b8 ,mbcview_wrm_wn.A2_NOM_b8 ) as A2_NOM_b8,
nvl(mbcview_cld_wn.A2_NOM_b9 ,mbcview_wrm_wn.A2_NOM_b9 ) as A2_NOM_b9,
nvl(mbcview_cld_wn.A2_NOM_b10,mbcview_wrm_wn.A2_NOM_b10) as A2_NOM_b10,
nvl(mbcview_cld_wn.A2_NOM_b11,mbcview_wrm_wn.A2_NOM_b11) as A2_NOM_b11,
nvl(mbcview_cld_wn.A2_NOM_a2 ,mbcview_wrm_wn.A2_NOM_a2 ) as A2_NOM_a2,
nvl(mbcview_cld_wn.A2_NOM_a3 ,mbcview_wrm_wn.A2_NOM_a3 ) as A2_NOM_a3,
nvl(mbcview_cld_wn.A2_NOM_a4 ,mbcview_wrm_wn.A2_NOM_a4 ) as A2_NOM_a4,
nvl(mbcview_cld_wn.A2_NOM_a5 ,mbcview_wrm_wn.A2_NOM_a5 ) as A2_NOM_a5,
nvl(mbcview_cld_wn.A2_NOM_a6 ,mbcview_wrm_wn.A2_NOM_a6 ) as A2_NOM_a6,
nvl(mbcview_cld_wn.A2_NOM_a7 ,mbcview_wrm_wn.A2_NOM_a7 ) as A2_NOM_a7,
nvl(mbcview_cld_wn.A2_NOM_a8 ,mbcview_wrm_wn.A2_NOM_a8 ) as A2_NOM_a8,
nvl(mbcview_cld_wn.A2_NOM_a9 ,mbcview_wrm_wn.A2_NOM_a9 ) as A2_NOM_a9,
nvl(mbcview_cld_wn.A2_NOM_a10,mbcview_wrm_wn.A2_NOM_a10) as A2_NOM_a10,
nvl(mbcview_cld_wn.A2_NOM_a11,mbcview_wrm_wn.A2_NOM_a11) as A2_NOM_a11
from
  TST_MBCVIEW_WARM_WITH_NULLS mbcview_wrm_wn,
  TST_MBCVIEW_COLD_WITH_NULLS mbcview_cld_wn
where
  mbcview_wrm_wn.magnet_name = mbcview_cld_wn.magnet_name (+);