OLD vERSION

CREATE OR REPLACE VIEW TST_MBCVIEW_COLD_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
x.magnet_name as magnet_name,
TRANFCT_A1_INJ.transfer_function as A1_INJ_TF,
TRANFCT_A1_INJ.field_length as A1_INJ_ML,
(CASE WHEN INTHARM_A1_INJ.skew_1 < 3.14 THEN INTHARM_A1_INJ.skew_1 END) + gv.fiducial_angle - gv.coldmass_angle as A1_INJ_FD,
(TRANFCT_A1_INJ.transfer_function / MBCINFO.a1_inj_tf - 1.0 ) * 10000 as A1_INJ_b1,
INTHARM_A1_INJ.normal_2 as A1_INJ_b2,
INTHARM_A1_INJ.normal_3 as A1_INJ_b3,
INTHARM_A1_INJ.normal_4 as A1_INJ_b4,
INTHARM_A1_INJ.normal_5 as A1_INJ_b5,
INTHARM_A1_INJ.normal_6 as A1_INJ_b6,
INTHARM_A1_INJ.normal_7 as A1_INJ_b7,
INTHARM_A1_INJ.normal_8 as A1_INJ_b8,
INTHARM_A1_INJ.normal_9 as A1_INJ_b9,
INTHARM_A1_INJ.normal_10 as A1_INJ_b10,
INTHARM_A1_INJ.normal_11 as A1_INJ_b11,
INTHARM_A1_INJ.skew_2 as A1_INJ_a2,
INTHARM_A1_INJ.skew_3 as A1_INJ_a3,
INTHARM_A1_INJ.skew_4 as A1_INJ_a4,
INTHARM_A1_INJ.skew_5 as A1_INJ_a5,
INTHARM_A1_INJ.skew_6 as A1_INJ_a6,
INTHARM_A1_INJ.skew_7 as A1_INJ_a7,
INTHARM_A1_INJ.skew_8 as A1_INJ_a8,
INTHARM_A1_INJ.skew_9 as A1_INJ_a9,
INTHARM_A1_INJ.skew_10 as A1_INJ_a10,
INTHARM_A1_INJ.skew_11 as A1_INJ_a11,

(1 + (((TRANFCT_A1_INJ.transfer_function / MBCINFO.a1_inj_tf - 1.0 ) * 10000) + INTCOMP_A1_DECAY.normal_1) * .0001) * MBCINFO.a1_eoi_tf as A1_EOI_TF,
TRANFCT_A1_INJ.field_length as A1_EOI_ML,
(CASE WHEN INTHARM_A1_INJ.skew_1 < 3.14 THEN INTHARM_A1_INJ.skew_1 END) + gv.fiducial_angle - gv.coldmass_angle + INTCOMP_A1_DECAY.skew_1 * .0001 as A1_EOI_FD,
((TRANFCT_A1_INJ.transfer_function / MBCINFO.a1_inj_tf - 1.0 ) * 10000) + INTCOMP_A1_DECAY.normal_1 as A1_EOI_b1,
INTHARM_A1_INJ.normal_2+INTCOMP_A1_DECAY.normal_2 as A1_EOI_b2,
INTHARM_A1_INJ.normal_3+INTCOMP_A1_DECAY.normal_3 as A1_EOI_b3,
INTHARM_A1_INJ.normal_4+INTCOMP_A1_DECAY.normal_4 as A1_EOI_b4,
INTHARM_A1_INJ.normal_5+INTCOMP_A1_DECAY.normal_5 as A1_EOI_b5,
INTHARM_A1_INJ.normal_6+INTCOMP_A1_DECAY.normal_6 as A1_EOI_b6,
INTHARM_A1_INJ.normal_7+INTCOMP_A1_DECAY.normal_7 as A1_EOI_b7,
INTHARM_A1_INJ.normal_8+INTCOMP_A1_DECAY.normal_8 as A1_EOI_b8,
INTHARM_A1_INJ.normal_9+INTCOMP_A1_DECAY.normal_9 as A1_EOI_b9,
INTHARM_A1_INJ.normal_10+INTCOMP_A1_DECAY.normal_10 as A1_EOI_b10,
INTHARM_A1_INJ.normal_11+INTCOMP_A1_DECAY.normal_11 as A1_EOI_b11,
INTHARM_A1_INJ.skew_2+INTCOMP_A1_DECAY.skew_2 as A1_EOI_a2,
INTHARM_A1_INJ.skew_3+INTCOMP_A1_DECAY.skew_3 as A1_EOI_a3,
INTHARM_A1_INJ.skew_4+INTCOMP_A1_DECAY.skew_4 as A1_EOI_a4,
INTHARM_A1_INJ.skew_5+INTCOMP_A1_DECAY.skew_5 as A1_EOI_a5,
INTHARM_A1_INJ.skew_6+INTCOMP_A1_DECAY.skew_6 as A1_EOI_a6,
INTHARM_A1_INJ.skew_7+INTCOMP_A1_DECAY.skew_7 as A1_EOI_a7,
INTHARM_A1_INJ.skew_8+INTCOMP_A1_DECAY.skew_8 as A1_EOI_a8,
INTHARM_A1_INJ.skew_9+INTCOMP_A1_DECAY.skew_9 as A1_EOI_a9,
INTHARM_A1_INJ.skew_10+INTCOMP_A1_DECAY.skew_10 as A1_EOI_a10,
INTHARM_A1_INJ.skew_11+INTCOMP_A1_DECAY.skew_11 as A1_EOI_a11,

(1 + (((TRANFCT_A1_NOM.transfer_function / MBCINFO.a1_nom_tf - 1.0) * 10000) + INTCOMP_A1_RAMP.normal_1 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1)) * .0001) * MBCINFO.A1_EOR_TF as A1_EOR_TF,
TRANFCT_A1_NOM.field_length as A1_EOR_ML,
(CASE WHEN INTHARM_A1_NOM.skew_1 < 3.14 THEN INTHARM_A1_NOM.skew_1 END) + gv.fiducial_angle - gv.coldmass_angle + INTCOMP_A1_RAMP.skew_1 * INTCOMP_A1_RAMP.ref_field_module/DECODE(INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) * .0001 as A1_EOR_FD,
((TRANFCT_A1_NOM.transfer_function / MBCINFO.a1_nom_tf - 1.0) * 10000) + INTCOMP_A1_RAMP.normal_1 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_b1,
INTHARM_A1_NOM.normal_2 + INTCOMP_A1_RAMP.normal_2 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_b2,
INTHARM_A1_NOM.normal_3 + INTCOMP_A1_RAMP.normal_3 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_b3,
INTHARM_A1_NOM.normal_4 + INTCOMP_A1_RAMP.normal_4 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_b4,
INTHARM_A1_NOM.normal_5 + INTCOMP_A1_RAMP.normal_5 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_b5,
INTHARM_A1_NOM.normal_6 + INTCOMP_A1_RAMP.normal_6 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_b6,
INTHARM_A1_NOM.normal_7 + INTCOMP_A1_RAMP.normal_7 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_b7,
INTHARM_A1_NOM.normal_8 + INTCOMP_A1_RAMP.normal_8 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_b8,
INTHARM_A1_NOM.normal_9 + INTCOMP_A1_RAMP.normal_9 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_b9,
INTHARM_A1_NOM.normal_10 + INTCOMP_A1_RAMP.normal_10 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_b10,
INTHARM_A1_NOM.normal_11 + INTCOMP_A1_RAMP.normal_11 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_b11,
INTHARM_A1_NOM.skew_2 + INTCOMP_A1_RAMP.skew_2 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_a2,
INTHARM_A1_NOM.skew_3 + INTCOMP_A1_RAMP.skew_3 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_a3,
INTHARM_A1_NOM.skew_4 + INTCOMP_A1_RAMP.skew_4 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_a4,
INTHARM_A1_NOM.skew_5 + INTCOMP_A1_RAMP.skew_5 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_a5,
INTHARM_A1_NOM.skew_6 + INTCOMP_A1_RAMP.skew_6 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_a6,
INTHARM_A1_NOM.skew_7 + INTCOMP_A1_RAMP.skew_7 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_a7,
INTHARM_A1_NOM.skew_8 + INTCOMP_A1_RAMP.skew_8 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_a8,
INTHARM_A1_NOM.skew_9 + INTCOMP_A1_RAMP.skew_9 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_a9,
INTHARM_A1_NOM.skew_10 + INTCOMP_A1_RAMP.skew_10 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_a10,
INTHARM_A1_NOM.skew_11 + INTCOMP_A1_RAMP.skew_11 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_a11,

TRANFCT_A1_NOM.transfer_function as A1_NOM_TF,
TRANFCT_A1_NOM.field_length as A1_NOM_ML,
(CASE WHEN INTHARM_A1_NOM.skew_1 < 3.14 THEN INTHARM_A1_NOM.skew_1 END) + gv.fiducial_angle - gv.coldmass_angle as A1_NOM_FD,
(TRANFCT_A1_NOM.transfer_function / MBCINFO.a1_nom_tf - 1.0) * 10000 as A1_NOM_B1,
INTHARM_A1_NOM.normal_2 as A1_NOM_b2,
INTHARM_A1_NOM.normal_3 as A1_NOM_b3,
INTHARM_A1_NOM.normal_4 as A1_NOM_b4,
INTHARM_A1_NOM.normal_5 as A1_NOM_b5,
INTHARM_A1_NOM.normal_6 as A1_NOM_b6,
INTHARM_A1_NOM.normal_7 as A1_NOM_b7,
INTHARM_A1_NOM.normal_8 as A1_NOM_b8,
INTHARM_A1_NOM.normal_9 as A1_NOM_b9,
INTHARM_A1_NOM.normal_10 as A1_NOM_b10,
INTHARM_A1_NOM.normal_11 as A1_NOM_b11,
INTHARM_A1_NOM.skew_2 as A1_NOM_a2,
INTHARM_A1_NOM.skew_3 as A1_NOM_a3,
INTHARM_A1_NOM.skew_4 as A1_NOM_a4,
INTHARM_A1_NOM.skew_5 as A1_NOM_a5,
INTHARM_A1_NOM.skew_6 as A1_NOM_a6,
INTHARM_A1_NOM.skew_7 as A1_NOM_a7,
INTHARM_A1_NOM.skew_8 as A1_NOM_a8,
INTHARM_A1_NOM.skew_9 as A1_NOM_a9,
INTHARM_A1_NOM.skew_10 as A1_NOM_a10,
INTHARM_A1_NOM.skew_11 as A1_NOM_a11,

TRANFCT_A2_INJ.transfer_function as A2_INJ_TF,
TRANFCT_A2_INJ.field_length as A2_INJ_ML,
(CASE WHEN INTHARM_A2_INJ.skew_1 < 3.14 THEN INTHARM_A2_INJ.skew_1 END) + gv.fiducial_angle - gv.coldmass_angle as A2_INJ_FD,
(TRANFCT_A2_INJ.transfer_function / MBCINFO.a2_inj_tf - 1) * 10000 as A2_INJ_b1,
INTHARM_A2_INJ.normal_2 as A2_INJ_b2,
INTHARM_A2_INJ.normal_3 as A2_INJ_b3,
INTHARM_A2_INJ.normal_4 as A2_INJ_b4,
INTHARM_A2_INJ.normal_5 as A2_INJ_b5,
INTHARM_A2_INJ.normal_6 as A2_INJ_b6,
INTHARM_A2_INJ.normal_7 as A2_INJ_b7,
INTHARM_A2_INJ.normal_8 as A2_INJ_b8,
INTHARM_A2_INJ.normal_9 as A2_INJ_b9,
INTHARM_A2_INJ.normal_10 as A2_INJ_b10,
INTHARM_A2_INJ.normal_11 as A2_INJ_b11,
INTHARM_A2_INJ.skew_2 as A2_INJ_a2,
INTHARM_A2_INJ.skew_3 as A2_INJ_a3,
INTHARM_A2_INJ.skew_4 as A2_INJ_a4,
INTHARM_A2_INJ.skew_5 as A2_INJ_a5,
INTHARM_A2_INJ.skew_6 as A2_INJ_a6,
INTHARM_A2_INJ.skew_7 as A2_INJ_a7,
INTHARM_A2_INJ.skew_8 as A2_INJ_a8,
INTHARM_A2_INJ.skew_9 as A2_INJ_a9,
INTHARM_A2_INJ.skew_10 as A2_INJ_a10,
INTHARM_A2_INJ.skew_11 as A2_INJ_a11,

(1 + ((TRANFCT_A2_INJ.transfer_function / MBCINFO.a2_inj_tf - 1) * 10000 + INTCOMP_A2_DECAY.normal_1) * .0001) * MBCINFO.A2_EOI_TF as A2_EOI_TF,
TRANFCT_A2_INJ.field_length as A2_EOI_ML,
(CASE WHEN INTHARM_A2_INJ.skew_1 < 3.14 THEN INTHARM_A2_INJ.skew_1 END) + gv.fiducial_angle - gv.coldmass_angle + INTCOMP_A2_DECAY.skew_1 * .0001 as A2_EOI_FD,
(TRANFCT_A2_INJ.transfer_function / MBCINFO.a2_inj_tf - 1) * 10000 + INTCOMP_A2_DECAY.normal_1 as A2_EOI_b1,
INTHARM_A2_INJ.normal_2 + INTCOMP_A2_DECAY.normal_2 as A2_EOI_b2,
INTHARM_A2_INJ.normal_3 + INTCOMP_A2_DECAY.normal_3 as A2_EOI_b3,
INTHARM_A2_INJ.normal_4 + INTCOMP_A2_DECAY.normal_4 as A2_EOI_b4,
INTHARM_A2_INJ.normal_5 + INTCOMP_A2_DECAY.normal_5 as A2_EOI_b5,
INTHARM_A2_INJ.normal_6 + INTCOMP_A2_DECAY.normal_6 as A2_EOI_b6,
INTHARM_A2_INJ.normal_7 + INTCOMP_A2_DECAY.normal_7 as A2_EOI_b7,
INTHARM_A2_INJ.normal_8 + INTCOMP_A2_DECAY.normal_8 as A2_EOI_b8,
INTHARM_A2_INJ.normal_9 + INTCOMP_A2_DECAY.normal_9 as A2_EOI_b9,
INTHARM_A2_INJ.normal_10 + INTCOMP_A2_DECAY.normal_10 as A2_EOI_b10,
INTHARM_A2_INJ.normal_11 + INTCOMP_A2_DECAY.normal_11 as A2_EOI_b11,
INTHARM_A2_INJ.skew_2 + INTCOMP_A2_DECAY.skew_2 as A2_EOI_a2,
INTHARM_A2_INJ.skew_3 + INTCOMP_A2_DECAY.skew_3 as A2_EOI_a3,
INTHARM_A2_INJ.skew_4 + INTCOMP_A2_DECAY.skew_4 as A2_EOI_a4,
INTHARM_A2_INJ.skew_5 + INTCOMP_A2_DECAY.skew_5 as A2_EOI_a5,
INTHARM_A2_INJ.skew_6 + INTCOMP_A2_DECAY.skew_6 as A2_EOI_a6,
INTHARM_A2_INJ.skew_7 + INTCOMP_A2_DECAY.skew_7 as A2_EOI_a7,
INTHARM_A2_INJ.skew_8 + INTCOMP_A2_DECAY.skew_8 as A2_EOI_a8,
INTHARM_A2_INJ.skew_9 + INTCOMP_A2_DECAY.skew_9 as A2_EOI_a9,
INTHARM_A2_INJ.skew_10 + INTCOMP_A2_DECAY.skew_10 as A2_EOI_a10,
INTHARM_A2_INJ.skew_11 + INTCOMP_A2_DECAY.skew_11 as A2_EOI_a11,

(1 + (((TRANFCT_A2_NOM.transfer_function  / MBCINFO.A2_NOM_TF - 1.0 ) * 10000) + INTCOMP_A2_RAMP.normal_1 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1)) * .0001) * MBCINFO.A2_EOR_TF as A2_EOR_TF,
TRANFCT_A2_NOM.field_length as A2_EOR_ML,
(CASE WHEN INTHARM_A2_NOM.skew_1 < 3.14 THEN INTHARM_A2_NOM.skew_1 END) + gv.fiducial_angle - gv.coldmass_angle + INTCOMP_A2_RAMP.skew_1 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) * .0001 as A2_EOR_FD,
((TRANFCT_A2_NOM.transfer_function  / MBCINFO.A2_NOM_TF - 1.0 ) * 10000) + INTCOMP_A2_RAMP.normal_1 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_b1,
INTHARM_A2_NOM.normal_2 + INTCOMP_A2_RAMP.normal_2 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_b2,
INTHARM_A2_NOM.normal_3 + INTCOMP_A2_RAMP.normal_3 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_b3,
INTHARM_A2_NOM.normal_4 + INTCOMP_A2_RAMP.normal_4 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_b4,
INTHARM_A2_NOM.normal_5 + INTCOMP_A2_RAMP.normal_5 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_b5,
INTHARM_A2_NOM.normal_6 + INTCOMP_A2_RAMP.normal_6 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_b6,
INTHARM_A2_NOM.normal_7 + INTCOMP_A2_RAMP.normal_7 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_b7,
INTHARM_A2_NOM.normal_8 + INTCOMP_A2_RAMP.normal_8 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_b8,
INTHARM_A2_NOM.normal_9 + INTCOMP_A2_RAMP.normal_9 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_b9,
INTHARM_A2_NOM.normal_10 + INTCOMP_A2_RAMP.normal_10 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_b10,
INTHARM_A2_NOM.normal_11 + INTCOMP_A2_RAMP.normal_11 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_b11,
INTHARM_A2_NOM.skew_2 + INTCOMP_A2_RAMP.skew_2 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_a2,
INTHARM_A2_NOM.skew_3 + INTCOMP_A2_RAMP.skew_3 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_a3,
INTHARM_A2_NOM.skew_4 + INTCOMP_A2_RAMP.skew_4 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_a4,
INTHARM_A2_NOM.skew_5 + INTCOMP_A2_RAMP.skew_5 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_a5,
INTHARM_A2_NOM.skew_6 + INTCOMP_A2_RAMP.skew_6 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_a6,
INTHARM_A2_NOM.skew_7 + INTCOMP_A2_RAMP.skew_7 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_a7,
INTHARM_A2_NOM.skew_8 + INTCOMP_A2_RAMP.skew_8 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_a8,
INTHARM_A2_NOM.skew_9 + INTCOMP_A2_RAMP.skew_9 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_a9,
INTHARM_A2_NOM.skew_10 + INTCOMP_A2_RAMP.skew_10 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_a10,
INTHARM_A2_NOM.skew_11 + INTCOMP_A2_RAMP.skew_11 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_a11,

TRANFCT_A2_NOM.transfer_function as A2_NOM_TF,
TRANFCT_A2_NOM.field_length as A2_NOM_ML,
(CASE WHEN INTHARM_A2_NOM.skew_1 < 3.14 THEN INTHARM_A2_NOM.skew_1 END) + gv.fiducial_angle - gv.coldmass_angle as A2_NOM_FD,
(TRANFCT_A2_NOM.transfer_function  / MBCINFO.A2_NOM_TF - 1.0 ) * 10000 as A2_NOM_b1,
INTHARM_A2_NOM.normal_2 as A2_NOM_b2,
INTHARM_A2_NOM.normal_3 as A2_NOM_b3,
INTHARM_A2_NOM.normal_4 as A2_NOM_b4,
INTHARM_A2_NOM.normal_5 as A2_NOM_b5,
INTHARM_A2_NOM.normal_6 as A2_NOM_b6,
INTHARM_A2_NOM.normal_7 as A2_NOM_b7,
INTHARM_A2_NOM.normal_8 as A2_NOM_b8,
INTHARM_A2_NOM.normal_9 as A2_NOM_b9,
INTHARM_A2_NOM.normal_10 as A2_NOM_b10,
INTHARM_A2_NOM.normal_11 as A2_NOM_b11,
INTHARM_A2_NOM.skew_2 as A2_NOM_a2,
INTHARM_A2_NOM.skew_3 as A2_NOM_a3,
INTHARM_A2_NOM.skew_4 as A2_NOM_a4,
INTHARM_A2_NOM.skew_5 as A2_NOM_a5,
INTHARM_A2_NOM.skew_6 as A2_NOM_a6,
INTHARM_A2_NOM.skew_7 as A2_NOM_a7,
INTHARM_A2_NOM.skew_8 as A2_NOM_a8,
INTHARM_A2_NOM.skew_9 as A2_NOM_a9,
INTHARM_A2_NOM.skew_10 as A2_NOM_a10,
INTHARM_A2_NOM.skew_11 as A2_NOM_a11

from
MV_ALL_COLD_MAGNET_NAMES x,
TRANFCT_A1_INJ,
TRANFCT_A1_NOM,
TRANFCT_A2_INJ,
TRANFCT_A2_NOM,
INTHARM_A1_INJ,
INTHARM_A1_NOM,
INTHARM_A2_INJ,
INTHARM_A2_NOM,
INTCOMP_A1_DECAY,
INTCOMP_A1_RAMP,
INTCOMP_A2_DECAY,
INTCOMP_A2_RAMP,
MV_GEOVIEW gv
MBCINFO
where x.magnet_name = TRANFCT_A1_INJ.magnet_name (+)
and x.magnet_name = TRANFCT_A1_NOM.magnet_name (+)
and x.magnet_name = TRANFCT_A2_INJ.magnet_name (+)
and x.magnet_name = TRANFCT_A2_NOM.magnet_name (+)
and x.magnet_name = INTHARM_A1_INJ.magnet_name (+)
and x.magnet_name = INTHARM_A1_NOM.magnet_name (+)
and x.magnet_name = INTHARM_A2_INJ.magnet_name (+)
and x.magnet_name = INTHARM_A2_NOM.magnet_name (+)
and x.magnet_name = INTCOMP_A1_DECAY.magnet_name (+)
and x.magnet_name = INTCOMP_A1_RAMP.magnet_name (+)
and x.magnet_name = INTCOMP_A2_DECAY.magnet_name (+)
and x.magnet_name = INTCOMP_A2_RAMP.magnet_name (+)
and x.magnet_name = gv.magnet_name (+)
and substr(x.magnet_name,1,4)||'_REF_FLD' = MBCINFO.magnet_name (+);

NEW vERSION

CREATE OR REPLACE VIEW TST_MBCVIEW_COLD_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
x.magnet_name as magnet_name,
MOST_RECENT_DATE_8(
TRANFCT_A1_INJ.measure_date,
TRANFCT_A1_NOM.measure_date,
INTHARM_A2_INJ.measure_date,
INTHARM_A2_NOM.measure_date,
INTHARM_A1_INJ.measure_date,
INTHARM_A1_NOM.measure_date,
INTHARM_A2_INJ.measure_date,
INTHARM_A2_NOM.measure_date) as measdate,
TRANFCT_A1_INJ.transfer_function as A1_INJ_TF,
TRANFCT_A1_INJ.field_length as A1_INJ_ML,
(CASE WHEN INTHARM_A1_INJ.skew_1 < 3.14 THEN INTHARM_A1_INJ.skew_1 END) + gv.fiducial_angle - gv.coldmass_angle as A1_INJ_FD,
(TRANFCT_A1_INJ.transfer_function / MBCINFO.a1_inj_tf - 1.0 ) * 10000 as A1_INJ_b1,
INTHARM_A1_INJ.normal_2 as A1_INJ_b2,
INTHARM_A1_INJ.normal_3 as A1_INJ_b3,
INTHARM_A1_INJ.normal_4 as A1_INJ_b4,
INTHARM_A1_INJ.normal_5 as A1_INJ_b5,
INTHARM_A1_INJ.normal_6 as A1_INJ_b6,
INTHARM_A1_INJ.normal_7 as A1_INJ_b7,
INTHARM_A1_INJ.normal_8 as A1_INJ_b8,
INTHARM_A1_INJ.normal_9 as A1_INJ_b9,
INTHARM_A1_INJ.normal_10 as A1_INJ_b10,
INTHARM_A1_INJ.normal_11 as A1_INJ_b11,
INTHARM_A1_INJ.skew_2 as A1_INJ_a2,
INTHARM_A1_INJ.skew_3 as A1_INJ_a3,
INTHARM_A1_INJ.skew_4 as A1_INJ_a4,
INTHARM_A1_INJ.skew_5 as A1_INJ_a5,
INTHARM_A1_INJ.skew_6 as A1_INJ_a6,
INTHARM_A1_INJ.skew_7 as A1_INJ_a7,
INTHARM_A1_INJ.skew_8 as A1_INJ_a8,
INTHARM_A1_INJ.skew_9 as A1_INJ_a9,
INTHARM_A1_INJ.skew_10 as A1_INJ_a10,
INTHARM_A1_INJ.skew_11 as A1_INJ_a11,

(1 + (((TRANFCT_A1_INJ.transfer_function / MBCINFO.a1_inj_tf - 1.0 ) * 10000) + INTCOMP_A1_DECAY.normal_1) * .0001) * MBCINFO.a1_eoi_tf as A1_EOI_TF,
TRANFCT_A1_INJ.field_length as A1_EOI_ML,
(CASE WHEN INTHARM_A1_INJ.skew_1 < 3.14 THEN INTHARM_A1_INJ.skew_1 END) + gv.fiducial_angle - gv.coldmass_angle + INTCOMP_A1_DECAY.skew_1 * .0001 as A1_EOI_FD,
((TRANFCT_A1_INJ.transfer_function / MBCINFO.a1_inj_tf - 1.0 ) * 10000) + INTCOMP_A1_DECAY.normal_1 as A1_EOI_b1,
INTHARM_A1_INJ.normal_2+INTCOMP_A1_DECAY.normal_2 as A1_EOI_b2,
INTHARM_A1_INJ.normal_3+INTCOMP_A1_DECAY.normal_3 as A1_EOI_b3,
INTHARM_A1_INJ.normal_4+INTCOMP_A1_DECAY.normal_4 as A1_EOI_b4,
INTHARM_A1_INJ.normal_5+INTCOMP_A1_DECAY.normal_5 as A1_EOI_b5,
INTHARM_A1_INJ.normal_6+INTCOMP_A1_DECAY.normal_6 as A1_EOI_b6,
INTHARM_A1_INJ.normal_7+INTCOMP_A1_DECAY.normal_7 as A1_EOI_b7,
INTHARM_A1_INJ.normal_8+INTCOMP_A1_DECAY.normal_8 as A1_EOI_b8,
INTHARM_A1_INJ.normal_9+INTCOMP_A1_DECAY.normal_9 as A1_EOI_b9,
INTHARM_A1_INJ.normal_10+INTCOMP_A1_DECAY.normal_10 as A1_EOI_b10,
INTHARM_A1_INJ.normal_11+INTCOMP_A1_DECAY.normal_11 as A1_EOI_b11,
INTHARM_A1_INJ.skew_2+INTCOMP_A1_DECAY.skew_2 as A1_EOI_a2,
INTHARM_A1_INJ.skew_3+INTCOMP_A1_DECAY.skew_3 as A1_EOI_a3,
INTHARM_A1_INJ.skew_4+INTCOMP_A1_DECAY.skew_4 as A1_EOI_a4,
INTHARM_A1_INJ.skew_5+INTCOMP_A1_DECAY.skew_5 as A1_EOI_a5,
INTHARM_A1_INJ.skew_6+INTCOMP_A1_DECAY.skew_6 as A1_EOI_a6,
INTHARM_A1_INJ.skew_7+INTCOMP_A1_DECAY.skew_7 as A1_EOI_a7,
INTHARM_A1_INJ.skew_8+INTCOMP_A1_DECAY.skew_8 as A1_EOI_a8,
INTHARM_A1_INJ.skew_9+INTCOMP_A1_DECAY.skew_9 as A1_EOI_a9,
INTHARM_A1_INJ.skew_10+INTCOMP_A1_DECAY.skew_10 as A1_EOI_a10,
INTHARM_A1_INJ.skew_11+INTCOMP_A1_DECAY.skew_11 as A1_EOI_a11,

(1 + (((TRANFCT_A1_NOM.transfer_function / MBCINFO.a1_nom_tf - 1.0) * 10000) + INTCOMP_A1_RAMP.normal_1 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1)) * .0001) * MBCINFO.A1_EOR_TF as A1_EOR_TF,
TRANFCT_A1_NOM.field_length as A1_EOR_ML,
(CASE WHEN INTHARM_A1_NOM.skew_1 < 3.14 THEN INTHARM_A1_NOM.skew_1 END) + gv.fiducial_angle - gv.coldmass_angle + INTCOMP_A1_RAMP.skew_1 * INTCOMP_A1_RAMP.ref_field_module/DECODE(INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) * .0001 as A1_EOR_FD,
((TRANFCT_A1_NOM.transfer_function / MBCINFO.a1_nom_tf - 1.0) * 10000) + INTCOMP_A1_RAMP.normal_1 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_b1,
INTHARM_A1_NOM.normal_2 + INTCOMP_A1_RAMP.normal_2 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_b2,
INTHARM_A1_NOM.normal_3 + INTCOMP_A1_RAMP.normal_3 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_b3,
INTHARM_A1_NOM.normal_4 + INTCOMP_A1_RAMP.normal_4 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_b4,
INTHARM_A1_NOM.normal_5 + INTCOMP_A1_RAMP.normal_5 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_b5,
INTHARM_A1_NOM.normal_6 + INTCOMP_A1_RAMP.normal_6 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_b6,
INTHARM_A1_NOM.normal_7 + INTCOMP_A1_RAMP.normal_7 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_b7,
INTHARM_A1_NOM.normal_8 + INTCOMP_A1_RAMP.normal_8 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_b8,
INTHARM_A1_NOM.normal_9 + INTCOMP_A1_RAMP.normal_9 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_b9,
INTHARM_A1_NOM.normal_10 + INTCOMP_A1_RAMP.normal_10 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_b10,
INTHARM_A1_NOM.normal_11 + INTCOMP_A1_RAMP.normal_11 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_b11,
INTHARM_A1_NOM.skew_2 + INTCOMP_A1_RAMP.skew_2 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_a2,
INTHARM_A1_NOM.skew_3 + INTCOMP_A1_RAMP.skew_3 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_a3,
INTHARM_A1_NOM.skew_4 + INTCOMP_A1_RAMP.skew_4 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_a4,
INTHARM_A1_NOM.skew_5 + INTCOMP_A1_RAMP.skew_5 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_a5,
INTHARM_A1_NOM.skew_6 + INTCOMP_A1_RAMP.skew_6 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_a6,
INTHARM_A1_NOM.skew_7 + INTCOMP_A1_RAMP.skew_7 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_a7,
INTHARM_A1_NOM.skew_8 + INTCOMP_A1_RAMP.skew_8 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_a8,
INTHARM_A1_NOM.skew_9 + INTCOMP_A1_RAMP.skew_9 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_a9,
INTHARM_A1_NOM.skew_10 + INTCOMP_A1_RAMP.skew_10 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_a10,
INTHARM_A1_NOM.skew_11 + INTCOMP_A1_RAMP.skew_11 * INTCOMP_A1_RAMP.ref_field_module / DECODE (INTHARM_A1_NOM.normal_1,0,NULL,INTHARM_A1_NOM.normal_1) as A1_EOR_a11,

TRANFCT_A1_NOM.transfer_function as A1_NOM_TF,
TRANFCT_A1_NOM.field_length as A1_NOM_ML,
(CASE WHEN INTHARM_A1_NOM.skew_1 < 3.14 THEN INTHARM_A1_NOM.skew_1 END) + gv.fiducial_angle - gv.coldmass_angle as A1_NOM_FD,
(TRANFCT_A1_NOM.transfer_function / MBCINFO.a1_nom_tf - 1.0) * 10000 as A1_NOM_B1,
INTHARM_A1_NOM.normal_2 as A1_NOM_b2,
INTHARM_A1_NOM.normal_3 as A1_NOM_b3,
INTHARM_A1_NOM.normal_4 as A1_NOM_b4,
INTHARM_A1_NOM.normal_5 as A1_NOM_b5,
INTHARM_A1_NOM.normal_6 as A1_NOM_b6,
INTHARM_A1_NOM.normal_7 as A1_NOM_b7,
INTHARM_A1_NOM.normal_8 as A1_NOM_b8,
INTHARM_A1_NOM.normal_9 as A1_NOM_b9,
INTHARM_A1_NOM.normal_10 as A1_NOM_b10,
INTHARM_A1_NOM.normal_11 as A1_NOM_b11,
INTHARM_A1_NOM.skew_2 as A1_NOM_a2,
INTHARM_A1_NOM.skew_3 as A1_NOM_a3,
INTHARM_A1_NOM.skew_4 as A1_NOM_a4,
INTHARM_A1_NOM.skew_5 as A1_NOM_a5,
INTHARM_A1_NOM.skew_6 as A1_NOM_a6,
INTHARM_A1_NOM.skew_7 as A1_NOM_a7,
INTHARM_A1_NOM.skew_8 as A1_NOM_a8,
INTHARM_A1_NOM.skew_9 as A1_NOM_a9,
INTHARM_A1_NOM.skew_10 as A1_NOM_a10,
INTHARM_A1_NOM.skew_11 as A1_NOM_a11,

TRANFCT_A2_INJ.transfer_function as A2_INJ_TF,
TRANFCT_A2_INJ.field_length as A2_INJ_ML,
(CASE WHEN INTHARM_A2_INJ.skew_1 < 3.14 THEN INTHARM_A2_INJ.skew_1 END) + gv.fiducial_angle - gv.coldmass_angle as A2_INJ_FD,
(TRANFCT_A2_INJ.transfer_function / MBCINFO.a2_inj_tf - 1) * 10000 as A2_INJ_b1,
INTHARM_A2_INJ.normal_2 as A2_INJ_b2,
INTHARM_A2_INJ.normal_3 as A2_INJ_b3,
INTHARM_A2_INJ.normal_4 as A2_INJ_b4,
INTHARM_A2_INJ.normal_5 as A2_INJ_b5,
INTHARM_A2_INJ.normal_6 as A2_INJ_b6,
INTHARM_A2_INJ.normal_7 as A2_INJ_b7,
INTHARM_A2_INJ.normal_8 as A2_INJ_b8,
INTHARM_A2_INJ.normal_9 as A2_INJ_b9,
INTHARM_A2_INJ.normal_10 as A2_INJ_b10,
INTHARM_A2_INJ.normal_11 as A2_INJ_b11,
INTHARM_A2_INJ.skew_2 as A2_INJ_a2,
INTHARM_A2_INJ.skew_3 as A2_INJ_a3,
INTHARM_A2_INJ.skew_4 as A2_INJ_a4,
INTHARM_A2_INJ.skew_5 as A2_INJ_a5,
INTHARM_A2_INJ.skew_6 as A2_INJ_a6,
INTHARM_A2_INJ.skew_7 as A2_INJ_a7,
INTHARM_A2_INJ.skew_8 as A2_INJ_a8,
INTHARM_A2_INJ.skew_9 as A2_INJ_a9,
INTHARM_A2_INJ.skew_10 as A2_INJ_a10,
INTHARM_A2_INJ.skew_11 as A2_INJ_a11,

(1 + ((TRANFCT_A2_INJ.transfer_function / MBCINFO.a2_inj_tf - 1) * 10000 + INTCOMP_A2_DECAY.normal_1) * .0001) * MBCINFO.A2_EOI_TF as A2_EOI_TF,
TRANFCT_A2_INJ.field_length as A2_EOI_ML,
(CASE WHEN INTHARM_A2_INJ.skew_1 < 3.14 THEN INTHARM_A2_INJ.skew_1 END) + gv.fiducial_angle - gv.coldmass_angle + INTCOMP_A2_DECAY.skew_1 * .0001 as A2_EOI_FD,
(TRANFCT_A2_INJ.transfer_function / MBCINFO.a2_inj_tf - 1) * 10000 + INTCOMP_A2_DECAY.normal_1 as A2_EOI_b1,
INTHARM_A2_INJ.normal_2 + INTCOMP_A2_DECAY.normal_2 as A2_EOI_b2,
INTHARM_A2_INJ.normal_3 + INTCOMP_A2_DECAY.normal_3 as A2_EOI_b3,
INTHARM_A2_INJ.normal_4 + INTCOMP_A2_DECAY.normal_4 as A2_EOI_b4,
INTHARM_A2_INJ.normal_5 + INTCOMP_A2_DECAY.normal_5 as A2_EOI_b5,
INTHARM_A2_INJ.normal_6 + INTCOMP_A2_DECAY.normal_6 as A2_EOI_b6,
INTHARM_A2_INJ.normal_7 + INTCOMP_A2_DECAY.normal_7 as A2_EOI_b7,
INTHARM_A2_INJ.normal_8 + INTCOMP_A2_DECAY.normal_8 as A2_EOI_b8,
INTHARM_A2_INJ.normal_9 + INTCOMP_A2_DECAY.normal_9 as A2_EOI_b9,
INTHARM_A2_INJ.normal_10 + INTCOMP_A2_DECAY.normal_10 as A2_EOI_b10,
INTHARM_A2_INJ.normal_11 + INTCOMP_A2_DECAY.normal_11 as A2_EOI_b11,
INTHARM_A2_INJ.skew_2 + INTCOMP_A2_DECAY.skew_2 as A2_EOI_a2,
INTHARM_A2_INJ.skew_3 + INTCOMP_A2_DECAY.skew_3 as A2_EOI_a3,
INTHARM_A2_INJ.skew_4 + INTCOMP_A2_DECAY.skew_4 as A2_EOI_a4,
INTHARM_A2_INJ.skew_5 + INTCOMP_A2_DECAY.skew_5 as A2_EOI_a5,
INTHARM_A2_INJ.skew_6 + INTCOMP_A2_DECAY.skew_6 as A2_EOI_a6,
INTHARM_A2_INJ.skew_7 + INTCOMP_A2_DECAY.skew_7 as A2_EOI_a7,
INTHARM_A2_INJ.skew_8 + INTCOMP_A2_DECAY.skew_8 as A2_EOI_a8,
INTHARM_A2_INJ.skew_9 + INTCOMP_A2_DECAY.skew_9 as A2_EOI_a9,
INTHARM_A2_INJ.skew_10 + INTCOMP_A2_DECAY.skew_10 as A2_EOI_a10,
INTHARM_A2_INJ.skew_11 + INTCOMP_A2_DECAY.skew_11 as A2_EOI_a11,

(1 + (((TRANFCT_A2_NOM.transfer_function  / MBCINFO.A2_NOM_TF - 1.0 ) * 10000) + INTCOMP_A2_RAMP.normal_1 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1)) * .0001) * MBCINFO.A2_EOR_TF as A2_EOR_TF,
TRANFCT_A2_NOM.field_length as A2_EOR_ML,
(CASE WHEN INTHARM_A2_NOM.skew_1 < 3.14 THEN INTHARM_A2_NOM.skew_1 END) + gv.fiducial_angle - gv.coldmass_angle + INTCOMP_A2_RAMP.skew_1 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) * .0001 as A2_EOR_FD,
((TRANFCT_A2_NOM.transfer_function  / MBCINFO.A2_NOM_TF - 1.0 ) * 10000) + INTCOMP_A2_RAMP.normal_1 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_b1,
INTHARM_A2_NOM.normal_2 + INTCOMP_A2_RAMP.normal_2 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_b2,
INTHARM_A2_NOM.normal_3 + INTCOMP_A2_RAMP.normal_3 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_b3,
INTHARM_A2_NOM.normal_4 + INTCOMP_A2_RAMP.normal_4 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_b4,
INTHARM_A2_NOM.normal_5 + INTCOMP_A2_RAMP.normal_5 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_b5,
INTHARM_A2_NOM.normal_6 + INTCOMP_A2_RAMP.normal_6 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_b6,
INTHARM_A2_NOM.normal_7 + INTCOMP_A2_RAMP.normal_7 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_b7,
INTHARM_A2_NOM.normal_8 + INTCOMP_A2_RAMP.normal_8 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_b8,
INTHARM_A2_NOM.normal_9 + INTCOMP_A2_RAMP.normal_9 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_b9,
INTHARM_A2_NOM.normal_10 + INTCOMP_A2_RAMP.normal_10 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_b10,
INTHARM_A2_NOM.normal_11 + INTCOMP_A2_RAMP.normal_11 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_b11,
INTHARM_A2_NOM.skew_2 + INTCOMP_A2_RAMP.skew_2 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_a2,
INTHARM_A2_NOM.skew_3 + INTCOMP_A2_RAMP.skew_3 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_a3,
INTHARM_A2_NOM.skew_4 + INTCOMP_A2_RAMP.skew_4 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_a4,
INTHARM_A2_NOM.skew_5 + INTCOMP_A2_RAMP.skew_5 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_a5,
INTHARM_A2_NOM.skew_6 + INTCOMP_A2_RAMP.skew_6 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_a6,
INTHARM_A2_NOM.skew_7 + INTCOMP_A2_RAMP.skew_7 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_a7,
INTHARM_A2_NOM.skew_8 + INTCOMP_A2_RAMP.skew_8 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_a8,
INTHARM_A2_NOM.skew_9 + INTCOMP_A2_RAMP.skew_9 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_a9,
INTHARM_A2_NOM.skew_10 + INTCOMP_A2_RAMP.skew_10 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_a10,
INTHARM_A2_NOM.skew_11 + INTCOMP_A2_RAMP.skew_11 * INTCOMP_A2_RAMP.ref_field_module / DECODE (INTHARM_A2_NOM.normal_1,0,NULL,INTHARM_A2_NOM.normal_1) as A2_EOR_a11,

TRANFCT_A2_NOM.transfer_function as A2_NOM_TF,
TRANFCT_A2_NOM.field_length as A2_NOM_ML,
(CASE WHEN INTHARM_A2_NOM.skew_1 < 3.14 THEN INTHARM_A2_NOM.skew_1 END) + gv.fiducial_angle - gv.coldmass_angle as A2_NOM_FD,
(TRANFCT_A2_NOM.transfer_function  / MBCINFO.A2_NOM_TF - 1.0 ) * 10000 as A2_NOM_b1,
INTHARM_A2_NOM.normal_2 as A2_NOM_b2,
INTHARM_A2_NOM.normal_3 as A2_NOM_b3,
INTHARM_A2_NOM.normal_4 as A2_NOM_b4,
INTHARM_A2_NOM.normal_5 as A2_NOM_b5,
INTHARM_A2_NOM.normal_6 as A2_NOM_b6,
INTHARM_A2_NOM.normal_7 as A2_NOM_b7,
INTHARM_A2_NOM.normal_8 as A2_NOM_b8,
INTHARM_A2_NOM.normal_9 as A2_NOM_b9,
INTHARM_A2_NOM.normal_10 as A2_NOM_b10,
INTHARM_A2_NOM.normal_11 as A2_NOM_b11,
INTHARM_A2_NOM.skew_2 as A2_NOM_a2,
INTHARM_A2_NOM.skew_3 as A2_NOM_a3,
INTHARM_A2_NOM.skew_4 as A2_NOM_a4,
INTHARM_A2_NOM.skew_5 as A2_NOM_a5,
INTHARM_A2_NOM.skew_6 as A2_NOM_a6,
INTHARM_A2_NOM.skew_7 as A2_NOM_a7,
INTHARM_A2_NOM.skew_8 as A2_NOM_a8,
INTHARM_A2_NOM.skew_9 as A2_NOM_a9,
INTHARM_A2_NOM.skew_10 as A2_NOM_a10,
INTHARM_A2_NOM.skew_11 as A2_NOM_a11

from
-- MV_ALL_COLD_MAGNET_NAMES x,
ALL_VALID_COLD_MAGNET_NAMES x,
TRANFCT_A1_INJ,
TRANFCT_A1_NOM,
TRANFCT_A2_INJ,
TRANFCT_A2_NOM,
INTHARM_A1_INJ,
INTHARM_A1_NOM,
INTHARM_A2_INJ,
INTHARM_A2_NOM,
INTCOMP_A1_DECAY,
INTCOMP_A1_RAMP,
INTCOMP_A2_DECAY,
INTCOMP_A2_RAMP,
-- MV_GEOVIEW gv
geo_angl@mms_db gv,
MBCINFO
where x.magnet_name like 'HCMB__A001-0_0%'
and x.magnet_name = TRANFCT_A1_INJ.magnet_name (+)
and x.magnet_name = TRANFCT_A1_NOM.magnet_name (+)
and x.magnet_name = TRANFCT_A2_INJ.magnet_name (+)
and x.magnet_name = TRANFCT_A2_NOM.magnet_name (+)
and x.magnet_name = INTHARM_A1_INJ.magnet_name (+)
and x.magnet_name = INTHARM_A1_NOM.magnet_name (+)
and x.magnet_name = INTHARM_A2_INJ.magnet_name (+)
and x.magnet_name = INTHARM_A2_NOM.magnet_name (+)
and x.magnet_name = INTCOMP_A1_DECAY.magnet_name (+)
and x.magnet_name = INTCOMP_A1_RAMP.magnet_name (+)
and x.magnet_name = INTCOMP_A2_DECAY.magnet_name (+)
and x.magnet_name = INTCOMP_A2_RAMP.magnet_name (+)
and x.magnet_name = gv.magnet_name (+)
and 'HCMB_REF_FLD' = MBCINFO.magnet_name (+);