OLD VERSION CREATE OR REPLACE VIEW TST_MBCVIEW_WARM_WITH_NULLS (MAGNET_NAME, A1_INJ_TF, A1_INJ_ML, 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_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_NOM_TF, A1_NOM_ML, 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_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_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_NOM_TF, A2_NOM_ML, 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_CM.transfer_function + MBCINFO_WC_OFFSET.A1_INJ_TF as A1_INJ_TF , TRANFCT_A1_CM.field_length * 0.997 + MBCINFO_WC_OFFSET.A1_INJ_ML as A1_INJ_ML , ((TRANFCT_A1_CM.transfer_function + MBCINFO_WC_OFFSET.A1_INJ_TF) / MBCINFO_REF_FLD.A1_INJ_TF - 1) * 10000.0 as A1_INJ_b1, INTHARM_A1_CC.normal_2 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_b2 as A1_INJ_b2 , INTHARM_A1_CC.normal_3 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_b3 as A1_INJ_b3 , INTHARM_A1_CC.normal_4 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_b4 as A1_INJ_b4 , INTHARM_A1_CC.normal_5 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_b5 as A1_INJ_b5 , INTHARM_A1_CC.normal_6 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_b6 as A1_INJ_b6 , INTHARM_A1_CC.normal_7 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_b7 as A1_INJ_b7 , INTHARM_A1_CC.normal_8 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_b8 as A1_INJ_b8 , INTHARM_A1_CC.normal_9 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_b9 as A1_INJ_b9 , INTHARM_A1_CC.normal_10 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_b10 as A1_INJ_b10 , INTHARM_A1_CC.normal_11 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_b11 as A1_INJ_b11 , INTHARM_A1_CC.skew_2 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_a2 as A1_INJ_a2 , INTHARM_A1_CC.skew_3 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_a3 as A1_INJ_a3 , INTHARM_A1_CC.skew_4 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_a4 as A1_INJ_a4 , INTHARM_A1_CC.skew_5 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_a5 as A1_INJ_a5 , INTHARM_A1_CC.skew_6 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_a6 as A1_INJ_a6 , INTHARM_A1_CC.skew_7 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_a7 as A1_INJ_a7 , INTHARM_A1_CC.skew_8 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_a8 as A1_INJ_a8 , INTHARM_A1_CC.skew_9 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_a9 as A1_INJ_a9 , INTHARM_A1_CC.skew_10 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_a10 as A1_INJ_a10 , INTHARM_A1_CC.skew_11 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_a11 as A1_INJ_a11 , TRANFCT_A1_CM.transfer_function + MBCINFO_WC_OFFSET.A1_EOI_TF as A1_EOI_TF , TRANFCT_A1_CM.field_length * 0.997 + MBCINFO_WC_OFFSET.A1_EOI_ML as A1_EOI_ML , ((TRANFCT_A1_CM.transfer_function + MBCINFO_WC_OFFSET.A1_EOI_TF) / MBCINFO_REF_FLD.A1_EOI_TF - 1) * 10000.0 as A1_EOI_b1, INTHARM_A1_CC.normal_2 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_b2 as A1_EOI_b2 , INTHARM_A1_CC.normal_3 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_b3 as A1_EOI_b3 , INTHARM_A1_CC.normal_4 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_b4 as A1_EOI_b4 , INTHARM_A1_CC.normal_5 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_b5 as A1_EOI_b5 , INTHARM_A1_CC.normal_6 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_b6 as A1_EOI_b6 , INTHARM_A1_CC.normal_7 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_b7 as A1_EOI_b7 , INTHARM_A1_CC.normal_8 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_b8 as A1_EOI_b8 , INTHARM_A1_CC.normal_9 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_b9 as A1_EOI_b9 , INTHARM_A1_CC.normal_10 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_b10 as A1_EOI_b10 , INTHARM_A1_CC.normal_11 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_b11 as A1_EOI_b11 , INTHARM_A1_CC.skew_2 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_a2 as A1_EOI_a2 , INTHARM_A1_CC.skew_3 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_a3 as A1_EOI_a3 , INTHARM_A1_CC.skew_4 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_a4 as A1_EOI_a4 , INTHARM_A1_CC.skew_5 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_a5 as A1_EOI_a5 , INTHARM_A1_CC.skew_6 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_a6 as A1_EOI_a6 , INTHARM_A1_CC.skew_7 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_a7 as A1_EOI_a7 , INTHARM_A1_CC.skew_8 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_a8 as A1_EOI_a8 , INTHARM_A1_CC.skew_9 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_a9 as A1_EOI_a9 , INTHARM_A1_CC.skew_10 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_a10 as A1_EOI_a10 , INTHARM_A1_CC.skew_11 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_a11 as A1_EOI_a11 , TRANFCT_A1_CM.transfer_function + MBCINFO_WC_OFFSET.A1_NOM_TF as A1_NOM_TF , TRANFCT_A1_CM.field_length * 0.997 + MBCINFO_WC_OFFSET.A1_NOM_ML as A1_NOM_ML , ((TRANFCT_A1_CM.transfer_function + MBCINFO_WC_OFFSET.A1_NOM_TF) / MBCINFO_REF_FLD.A1_NOM_TF - 1) * 10000.0 as A1_NOM_b1, INTHARM_A1_CC.normal_2 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_b2 as A1_NOM_b2 , INTHARM_A1_CC.normal_3 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_b3 as A1_NOM_b3 , INTHARM_A1_CC.normal_4 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_b4 as A1_NOM_b4 , INTHARM_A1_CC.normal_5 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_b5 as A1_NOM_b5 , INTHARM_A1_CC.normal_6 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_b6 as A1_NOM_b6 , INTHARM_A1_CC.normal_7 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_b7 as A1_NOM_b7 , INTHARM_A1_CC.normal_8 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_b8 as A1_NOM_b8 , INTHARM_A1_CC.normal_9 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_b9 as A1_NOM_b9 , INTHARM_A1_CC.normal_10 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_b10 as A1_NOM_b10 , INTHARM_A1_CC.normal_11 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_b11 as A1_NOM_b11 , INTHARM_A1_CC.skew_2 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_a2 as A1_NOM_a2 , INTHARM_A1_CC.skew_3 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_a3 as A1_NOM_a3 , INTHARM_A1_CC.skew_4 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_a4 as A1_NOM_a4 , INTHARM_A1_CC.skew_5 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_a5 as A1_NOM_a5 , INTHARM_A1_CC.skew_6 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_a6 as A1_NOM_a6 , INTHARM_A1_CC.skew_7 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_a7 as A1_NOM_a7 , INTHARM_A1_CC.skew_8 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_a8 as A1_NOM_a8 , INTHARM_A1_CC.skew_9 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_a9 as A1_NOM_a9 , INTHARM_A1_CC.skew_10 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_a10 as A1_NOM_a10 , INTHARM_A1_CC.skew_11 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_a11 as A1_NOM_a11 , TRANFCT_A2_CM.transfer_function + MBCINFO_WC_OFFSET.A2_INJ_TF as A2_INJ_TF , TRANFCT_A2_CM.field_length * 0.997 + MBCINFO_WC_OFFSET.A2_INJ_ML as A2_INJ_ML , ((TRANFCT_A2_CM.transfer_function + MBCINFO_WC_OFFSET.A2_INJ_TF) / MBCINFO_REF_FLD.A2_INJ_TF - 1) * 10000.0 as A2_INJ_b1, INTHARM_A2_CC.normal_2 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_b2 as A2_INJ_b2 , INTHARM_A2_CC.normal_3 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_b3 as A2_INJ_b3 , INTHARM_A2_CC.normal_4 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_b4 as A2_INJ_b4 , INTHARM_A2_CC.normal_5 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_b5 as A2_INJ_b5 , INTHARM_A2_CC.normal_6 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_b6 as A2_INJ_b6 , INTHARM_A2_CC.normal_7 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_b7 as A2_INJ_b7 , INTHARM_A2_CC.normal_8 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_b8 as A2_INJ_b8 , INTHARM_A2_CC.normal_9 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_b9 as A2_INJ_b9 , INTHARM_A2_CC.normal_10 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_b10 as A2_INJ_b10 , INTHARM_A2_CC.normal_11 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_b11 as A2_INJ_b11 , INTHARM_A2_CC.skew_2 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_a2 as A2_INJ_a2 , INTHARM_A2_CC.skew_3 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_a3 as A2_INJ_a3 , INTHARM_A2_CC.skew_4 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_a4 as A2_INJ_a4 , INTHARM_A2_CC.skew_5 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_a5 as A2_INJ_a5 , INTHARM_A2_CC.skew_6 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_a6 as A2_INJ_a6 , INTHARM_A2_CC.skew_7 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_a7 as A2_INJ_a7 , INTHARM_A2_CC.skew_8 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_a8 as A2_INJ_a8 , INTHARM_A2_CC.skew_9 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_a9 as A2_INJ_a9 , INTHARM_A2_CC.skew_10 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_a10 as A2_INJ_a10 , INTHARM_A2_CC.skew_11 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_a11 as A2_INJ_a11 , TRANFCT_A2_CM.transfer_function + MBCINFO_WC_OFFSET.A2_EOI_TF as A2_EOI_TF , TRANFCT_A2_CM.field_length * 0.997 + MBCINFO_WC_OFFSET.A2_EOI_ML as A2_EOI_ML , ((TRANFCT_A2_CM.transfer_function + MBCINFO_WC_OFFSET.A2_EOI_TF) / MBCINFO_REF_FLD.A2_EOI_TF - 1) * 10000.0 as A2_EOI_b1, INTHARM_A2_CC.normal_2 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_b2 as A2_EOI_b2 , INTHARM_A2_CC.normal_3 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_b3 as A2_EOI_b3 , INTHARM_A2_CC.normal_4 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_b4 as A2_EOI_b4 , INTHARM_A2_CC.normal_5 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_b5 as A2_EOI_b5 , INTHARM_A2_CC.normal_6 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_b6 as A2_EOI_b6 , INTHARM_A2_CC.normal_7 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_b7 as A2_EOI_b7 , INTHARM_A2_CC.normal_8 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_b8 as A2_EOI_b8 , INTHARM_A2_CC.normal_9 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_b9 as A2_EOI_b9 , INTHARM_A2_CC.normal_10 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_b10 as A2_EOI_b10 , INTHARM_A2_CC.normal_11 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_b11 as A2_EOI_b11 , INTHARM_A2_CC.skew_2 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_a2 as A2_EOI_a2 , INTHARM_A2_CC.skew_3 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_a3 as A2_EOI_a3 , INTHARM_A2_CC.skew_4 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_a4 as A2_EOI_a4 , INTHARM_A2_CC.skew_5 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_a5 as A2_EOI_a5 , INTHARM_A2_CC.skew_6 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_a6 as A2_EOI_a6 , INTHARM_A2_CC.skew_7 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_a7 as A2_EOI_a7 , INTHARM_A2_CC.skew_8 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_a8 as A2_EOI_a8 , INTHARM_A2_CC.skew_9 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_a9 as A2_EOI_a9 , INTHARM_A2_CC.skew_10 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_a10 as A2_EOI_a10 , INTHARM_A2_CC.skew_11 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_a11 as A2_EOI_a11 , TRANFCT_A2_CM.transfer_function + MBCINFO_WC_OFFSET.A2_NOM_TF as A2_NOM_TF , TRANFCT_A2_CM.field_length * 0.997 + MBCINFO_WC_OFFSET.A2_NOM_ML as A2_NOM_ML , ((TRANFCT_A2_CM.transfer_function + MBCINFO_WC_OFFSET.A2_NOM_TF) / MBCINFO_REF_FLD.A2_NOM_TF - 1) * 10000.0 as A2_NOM_b1, INTHARM_A2_CC.normal_2 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_b2 as A2_NOM_b2 , INTHARM_A2_CC.normal_3 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_b3 as A2_NOM_b3 , INTHARM_A2_CC.normal_4 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_b4 as A2_NOM_b4 , INTHARM_A2_CC.normal_5 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_b5 as A2_NOM_b5 , INTHARM_A2_CC.normal_6 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_b6 as A2_NOM_b6 , INTHARM_A2_CC.normal_7 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_b7 as A2_NOM_b7 , INTHARM_A2_CC.normal_8 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_b8 as A2_NOM_b8 , INTHARM_A2_CC.normal_9 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_b9 as A2_NOM_b9 , INTHARM_A2_CC.normal_10 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_b10 as A2_NOM_b10 , INTHARM_A2_CC.normal_11 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_b11 as A2_NOM_b11 , INTHARM_A2_CC.skew_2 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_a2 as A2_NOM_a2 , INTHARM_A2_CC.skew_3 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_a3 as A2_NOM_a3 , INTHARM_A2_CC.skew_4 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_a4 as A2_NOM_a4 , INTHARM_A2_CC.skew_5 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_a5 as A2_NOM_a5 , INTHARM_A2_CC.skew_6 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_a6 as A2_NOM_a6 , INTHARM_A2_CC.skew_7 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_a7 as A2_NOM_a7 , INTHARM_A2_CC.skew_8 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_a8 as A2_NOM_a8 , INTHARM_A2_CC.skew_9 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_a9 as A2_NOM_a9 , INTHARM_A2_CC.skew_10 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_a10 as A2_NOM_a10 , INTHARM_A2_CC.skew_11 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_a11 as A2_NOM_a11 from tst_all_warm_magnet_names x, mv_mbxsview_ccc mbxsview, TST_TRANFCT_A1_CM TRANFCT_A1_CM, TST_TRANFCT_A2_CM TRANFCT_A2_CM, TST_INTHARM_A1_CM INTHARM_A1_CM, TST_INTHARM_A2_CM INTHARM_A2_CM, TST_INTHARM_A1_CC INTHARM_A1_CC, TST_INTHARM_A2_CC INTHARM_A2_CC, MBCINFO mbcinfo_ref_fld, MBCINFO mbcinfo_wc_offset where (x.magnet_name = mbxsview.cold_mass_name or x.magnet_name = mbxsview.collared_coil_name or x.magnet_name = mbxsview.cryodipole_name) and x.magnet_name = TRANFCT_A1_CM.magnet_name(+) and x.magnet_name = TRANFCT_A2_CM.magnet_name(+) and x.magnet_name = INTHARM_A1_CM.magnet_name(+) and x.magnet_name = INTHARM_A2_CM.magnet_name(+) and mbxsview.collared_coil_name = INTHARM_A1_CC.magnet_name and mbxsview.collared_coil_name = INTHARM_A2_CC.magnet_name and substr(x.magnet_name,1,4)||'_WC_OFFSET' = mbcinfo_wc_offset.magnet_name and substr(x.magnet_name,1,4)||'_REF_FLD' = mbcinfo_ref_fld.magnet_name; NEW VERSION CREATE OR REPLACE VIEW TST_MBCVIEW_WARM_WITH_NULLS (MAGNET_NAME, MEASDATE, A1_INJ_TF, A1_INJ_ML, 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_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_NOM_TF, A1_NOM_ML, 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_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_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_NOM_TF, A2_NOM_ML, 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_4(TRANFCT_A1_CM.measure_date,TRANFCT_A2_CM.measure_date,INTHARM_A1_CC.measure_date,INTHARM_A2_CC.measure_date) as measdate, TRANFCT_A1_CM.transfer_function + MBCINFO_WC_OFFSET.A1_INJ_TF as A1_INJ_TF , TRANFCT_A1_CM.field_length * 0.997 + MBCINFO_WC_OFFSET.A1_INJ_ML as A1_INJ_ML , ((TRANFCT_A1_CM.transfer_function + MBCINFO_WC_OFFSET.A1_INJ_TF) / MBCINFO_REF_FLD.A1_INJ_TF - 1) * 10000.0 as A1_INJ_b1, INTHARM_A1_CC.normal_2 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_b2 as A1_INJ_b2 , INTHARM_A1_CC.normal_3 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_b3 as A1_INJ_b3 , INTHARM_A1_CC.normal_4 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_b4 as A1_INJ_b4 , INTHARM_A1_CC.normal_5 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_b5 as A1_INJ_b5 , INTHARM_A1_CC.normal_6 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_b6 as A1_INJ_b6 , INTHARM_A1_CC.normal_7 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_b7 as A1_INJ_b7 , INTHARM_A1_CC.normal_8 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_b8 as A1_INJ_b8 , INTHARM_A1_CC.normal_9 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_b9 as A1_INJ_b9 , INTHARM_A1_CC.normal_10 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_b10 as A1_INJ_b10 , INTHARM_A1_CC.normal_11 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_b11 as A1_INJ_b11 , INTHARM_A1_CC.skew_2 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_a2 as A1_INJ_a2 , INTHARM_A1_CC.skew_3 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_a3 as A1_INJ_a3 , INTHARM_A1_CC.skew_4 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_a4 as A1_INJ_a4 , INTHARM_A1_CC.skew_5 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_a5 as A1_INJ_a5 , INTHARM_A1_CC.skew_6 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_a6 as A1_INJ_a6 , INTHARM_A1_CC.skew_7 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_a7 as A1_INJ_a7 , INTHARM_A1_CC.skew_8 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_a8 as A1_INJ_a8 , INTHARM_A1_CC.skew_9 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_a9 as A1_INJ_a9 , INTHARM_A1_CC.skew_10 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_a10 as A1_INJ_a10 , INTHARM_A1_CC.skew_11 * 0.85 + MBCINFO_WC_OFFSET.A1_INJ_a11 as A1_INJ_a11 , TRANFCT_A1_CM.transfer_function + MBCINFO_WC_OFFSET.A1_EOI_TF as A1_EOI_TF , TRANFCT_A1_CM.field_length * 0.997 + MBCINFO_WC_OFFSET.A1_EOI_ML as A1_EOI_ML , ((TRANFCT_A1_CM.transfer_function + MBCINFO_WC_OFFSET.A1_EOI_TF) / MBCINFO_REF_FLD.A1_EOI_TF - 1) * 10000.0 as A1_EOI_b1, INTHARM_A1_CC.normal_2 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_b2 as A1_EOI_b2 , INTHARM_A1_CC.normal_3 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_b3 as A1_EOI_b3 , INTHARM_A1_CC.normal_4 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_b4 as A1_EOI_b4 , INTHARM_A1_CC.normal_5 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_b5 as A1_EOI_b5 , INTHARM_A1_CC.normal_6 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_b6 as A1_EOI_b6 , INTHARM_A1_CC.normal_7 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_b7 as A1_EOI_b7 , INTHARM_A1_CC.normal_8 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_b8 as A1_EOI_b8 , INTHARM_A1_CC.normal_9 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_b9 as A1_EOI_b9 , INTHARM_A1_CC.normal_10 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_b10 as A1_EOI_b10 , INTHARM_A1_CC.normal_11 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_b11 as A1_EOI_b11 , INTHARM_A1_CC.skew_2 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_a2 as A1_EOI_a2 , INTHARM_A1_CC.skew_3 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_a3 as A1_EOI_a3 , INTHARM_A1_CC.skew_4 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_a4 as A1_EOI_a4 , INTHARM_A1_CC.skew_5 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_a5 as A1_EOI_a5 , INTHARM_A1_CC.skew_6 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_a6 as A1_EOI_a6 , INTHARM_A1_CC.skew_7 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_a7 as A1_EOI_a7 , INTHARM_A1_CC.skew_8 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_a8 as A1_EOI_a8 , INTHARM_A1_CC.skew_9 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_a9 as A1_EOI_a9 , INTHARM_A1_CC.skew_10 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_a10 as A1_EOI_a10 , INTHARM_A1_CC.skew_11 * 0.85 + MBCINFO_WC_OFFSET.A1_EOI_a11 as A1_EOI_a11 , TRANFCT_A1_CM.transfer_function + MBCINFO_WC_OFFSET.A1_NOM_TF as A1_NOM_TF , TRANFCT_A1_CM.field_length * 0.997 + MBCINFO_WC_OFFSET.A1_NOM_ML as A1_NOM_ML , ((TRANFCT_A1_CM.transfer_function + MBCINFO_WC_OFFSET.A1_NOM_TF) / MBCINFO_REF_FLD.A1_NOM_TF - 1) * 10000.0 as A1_NOM_b1, INTHARM_A1_CC.normal_2 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_b2 as A1_NOM_b2 , INTHARM_A1_CC.normal_3 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_b3 as A1_NOM_b3 , INTHARM_A1_CC.normal_4 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_b4 as A1_NOM_b4 , INTHARM_A1_CC.normal_5 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_b5 as A1_NOM_b5 , INTHARM_A1_CC.normal_6 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_b6 as A1_NOM_b6 , INTHARM_A1_CC.normal_7 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_b7 as A1_NOM_b7 , INTHARM_A1_CC.normal_8 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_b8 as A1_NOM_b8 , INTHARM_A1_CC.normal_9 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_b9 as A1_NOM_b9 , INTHARM_A1_CC.normal_10 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_b10 as A1_NOM_b10 , INTHARM_A1_CC.normal_11 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_b11 as A1_NOM_b11 , INTHARM_A1_CC.skew_2 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_a2 as A1_NOM_a2 , INTHARM_A1_CC.skew_3 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_a3 as A1_NOM_a3 , INTHARM_A1_CC.skew_4 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_a4 as A1_NOM_a4 , INTHARM_A1_CC.skew_5 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_a5 as A1_NOM_a5 , INTHARM_A1_CC.skew_6 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_a6 as A1_NOM_a6 , INTHARM_A1_CC.skew_7 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_a7 as A1_NOM_a7 , INTHARM_A1_CC.skew_8 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_a8 as A1_NOM_a8 , INTHARM_A1_CC.skew_9 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_a9 as A1_NOM_a9 , INTHARM_A1_CC.skew_10 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_a10 as A1_NOM_a10 , INTHARM_A1_CC.skew_11 * 0.85 + MBCINFO_WC_OFFSET.A1_NOM_a11 as A1_NOM_a11 , TRANFCT_A2_CM.transfer_function + MBCINFO_WC_OFFSET.A2_INJ_TF as A2_INJ_TF , TRANFCT_A2_CM.field_length * 0.997 + MBCINFO_WC_OFFSET.A2_INJ_ML as A2_INJ_ML , ((TRANFCT_A2_CM.transfer_function + MBCINFO_WC_OFFSET.A2_INJ_TF) / MBCINFO_REF_FLD.A2_INJ_TF - 1) * 10000.0 as A2_INJ_b1, INTHARM_A2_CC.normal_2 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_b2 as A2_INJ_b2 , INTHARM_A2_CC.normal_3 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_b3 as A2_INJ_b3 , INTHARM_A2_CC.normal_4 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_b4 as A2_INJ_b4 , INTHARM_A2_CC.normal_5 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_b5 as A2_INJ_b5 , INTHARM_A2_CC.normal_6 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_b6 as A2_INJ_b6 , INTHARM_A2_CC.normal_7 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_b7 as A2_INJ_b7 , INTHARM_A2_CC.normal_8 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_b8 as A2_INJ_b8 , INTHARM_A2_CC.normal_9 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_b9 as A2_INJ_b9 , INTHARM_A2_CC.normal_10 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_b10 as A2_INJ_b10 , INTHARM_A2_CC.normal_11 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_b11 as A2_INJ_b11 , INTHARM_A2_CC.skew_2 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_a2 as A2_INJ_a2 , INTHARM_A2_CC.skew_3 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_a3 as A2_INJ_a3 , INTHARM_A2_CC.skew_4 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_a4 as A2_INJ_a4 , INTHARM_A2_CC.skew_5 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_a5 as A2_INJ_a5 , INTHARM_A2_CC.skew_6 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_a6 as A2_INJ_a6 , INTHARM_A2_CC.skew_7 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_a7 as A2_INJ_a7 , INTHARM_A2_CC.skew_8 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_a8 as A2_INJ_a8 , INTHARM_A2_CC.skew_9 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_a9 as A2_INJ_a9 , INTHARM_A2_CC.skew_10 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_a10 as A2_INJ_a10 , INTHARM_A2_CC.skew_11 * 0.85 + MBCINFO_WC_OFFSET.A2_INJ_a11 as A2_INJ_a11 , TRANFCT_A2_CM.transfer_function + MBCINFO_WC_OFFSET.A2_EOI_TF as A2_EOI_TF , TRANFCT_A2_CM.field_length * 0.997 + MBCINFO_WC_OFFSET.A2_EOI_ML as A2_EOI_ML , ((TRANFCT_A2_CM.transfer_function + MBCINFO_WC_OFFSET.A2_EOI_TF) / MBCINFO_REF_FLD.A2_EOI_TF - 1) * 10000.0 as A2_EOI_b1, INTHARM_A2_CC.normal_2 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_b2 as A2_EOI_b2 , INTHARM_A2_CC.normal_3 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_b3 as A2_EOI_b3 , INTHARM_A2_CC.normal_4 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_b4 as A2_EOI_b4 , INTHARM_A2_CC.normal_5 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_b5 as A2_EOI_b5 , INTHARM_A2_CC.normal_6 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_b6 as A2_EOI_b6 , INTHARM_A2_CC.normal_7 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_b7 as A2_EOI_b7 , INTHARM_A2_CC.normal_8 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_b8 as A2_EOI_b8 , INTHARM_A2_CC.normal_9 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_b9 as A2_EOI_b9 , INTHARM_A2_CC.normal_10 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_b10 as A2_EOI_b10 , INTHARM_A2_CC.normal_11 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_b11 as A2_EOI_b11 , INTHARM_A2_CC.skew_2 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_a2 as A2_EOI_a2 , INTHARM_A2_CC.skew_3 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_a3 as A2_EOI_a3 , INTHARM_A2_CC.skew_4 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_a4 as A2_EOI_a4 , INTHARM_A2_CC.skew_5 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_a5 as A2_EOI_a5 , INTHARM_A2_CC.skew_6 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_a6 as A2_EOI_a6 , INTHARM_A2_CC.skew_7 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_a7 as A2_EOI_a7 , INTHARM_A2_CC.skew_8 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_a8 as A2_EOI_a8 , INTHARM_A2_CC.skew_9 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_a9 as A2_EOI_a9 , INTHARM_A2_CC.skew_10 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_a10 as A2_EOI_a10 , INTHARM_A2_CC.skew_11 * 0.85 + MBCINFO_WC_OFFSET.A2_EOI_a11 as A2_EOI_a11 , TRANFCT_A2_CM.transfer_function + MBCINFO_WC_OFFSET.A2_NOM_TF as A2_NOM_TF , TRANFCT_A2_CM.field_length * 0.997 + MBCINFO_WC_OFFSET.A2_NOM_ML as A2_NOM_ML , ((TRANFCT_A2_CM.transfer_function + MBCINFO_WC_OFFSET.A2_NOM_TF) / MBCINFO_REF_FLD.A2_NOM_TF - 1) * 10000.0 as A2_NOM_b1, INTHARM_A2_CC.normal_2 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_b2 as A2_NOM_b2 , INTHARM_A2_CC.normal_3 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_b3 as A2_NOM_b3 , INTHARM_A2_CC.normal_4 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_b4 as A2_NOM_b4 , INTHARM_A2_CC.normal_5 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_b5 as A2_NOM_b5 , INTHARM_A2_CC.normal_6 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_b6 as A2_NOM_b6 , INTHARM_A2_CC.normal_7 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_b7 as A2_NOM_b7 , INTHARM_A2_CC.normal_8 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_b8 as A2_NOM_b8 , INTHARM_A2_CC.normal_9 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_b9 as A2_NOM_b9 , INTHARM_A2_CC.normal_10 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_b10 as A2_NOM_b10 , INTHARM_A2_CC.normal_11 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_b11 as A2_NOM_b11 , INTHARM_A2_CC.skew_2 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_a2 as A2_NOM_a2 , INTHARM_A2_CC.skew_3 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_a3 as A2_NOM_a3 , INTHARM_A2_CC.skew_4 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_a4 as A2_NOM_a4 , INTHARM_A2_CC.skew_5 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_a5 as A2_NOM_a5 , INTHARM_A2_CC.skew_6 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_a6 as A2_NOM_a6 , INTHARM_A2_CC.skew_7 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_a7 as A2_NOM_a7 , INTHARM_A2_CC.skew_8 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_a8 as A2_NOM_a8 , INTHARM_A2_CC.skew_9 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_a9 as A2_NOM_a9 , INTHARM_A2_CC.skew_10 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_a10 as A2_NOM_a10 , INTHARM_A2_CC.skew_11 * 0.85 + MBCINFO_WC_OFFSET.A2_NOM_a11 as A2_NOM_a11 from -- tst_all_warm_magnet_names x, (select magnet_name from v_f_t_function@mms_db union select magnet_name from v_f_int_harm@mms_db) x, -- mv_mbxsview_ccc mbxsview, (select magnet_name as cold_mass_name, substr(magnet_name,1,4) || '__' || substr(magnet_name,7,13) as collared_coil_name from v_f_int_harm@mms_db where magnet_state = 'cold mass' union select magnet_name as cold_mass_name, substr(magnet_name,1,4) || '__' || substr(magnet_name,7,13) as collared_coil_name from v_f_t_function@mms_db where magnet_state = 'cold mass') mbxsview, TST_TRANFCT_A1_CM TRANFCT_A1_CM, TST_TRANFCT_A2_CM TRANFCT_A2_CM, TST_INTHARM_A1_CC INTHARM_A1_CC, TST_INTHARM_A2_CC INTHARM_A2_CC, MBCINFO mbcinfo_ref_fld, MBCINFO mbcinfo_wc_offset where (x.magnet_name = mbxsview.cold_mass_name or x.magnet_name = mbxsview.collared_coil_name) -- or x.magnet_name = mbxsview.cryodipole_name) and x.magnet_name = TRANFCT_A1_CM.magnet_name(+) and x.magnet_name = TRANFCT_A2_CM.magnet_name(+) and mbxsview.collared_coil_name = INTHARM_A1_CC.magnet_name and mbxsview.collared_coil_name = INTHARM_A2_CC.magnet_name -- and substr(x.magnet_name,1,4)||'_WC_OFFSET' = mbcinfo_wc_offset.magnet_name and 'HCMB_WC_OFFSET' = mbcinfo_wc_offset.magnet_name -- and substr(x.magnet_name,1,4)||'_REF_FLD' = mbcinfo_ref_fld.magnet_name; and 'HCMB_REF_FLD' = mbcinfo_ref_fld.magnet_name;