SELECT * 
FROM ((SELECT a.PROD_ID_A, a.CUST_ID_A, a.GEO_ID_A, a.TIME_ID_A, a.FACT_AMT_2_CORR_LOW_A, a.FACT_AMT_2_CORR_HIG_A, a.SKU_FACT_AMT_2_A, a.FACT_AMT_2_INDEX_A, a.FACT_AMT_2_INDEX_STATUS_A FROM pp_np_cmp_cn_amt2_lm_v a
UNION
SELECT b.PROD_ID_C, b.CUST_ID_C, b.GEO_ID_C, b.TIME_ID_C, b.FACT_AMT_2_CORR_LOW_C, b.FACT_AMT_2_CORR_HIG_C, b.SKU_FACT_AMT_2_C, b.FACT_AMT_2_INDEX_C, b.FACT_AMT_2_INDEX_STATUS_C FROM pp_np_cmp_cn_amt2_l3m_v b)
UNION
(SELECT c.PROD_ID_E, c.CUST_ID_E, c.GEO_ID_E, c.TIME_ID_E, c.FACT_AMT_2_CORR_LOW_E, c.FACT_AMT_2_CORR_HIG_E, c.SKU_FACT_AMT_2_E, c.FACT_AMT_2_INDEX_E, c.FACT_AMT_2_INDEX_STATUS_E FROM pp_np_cmp_cn_amt2_l6m_v c
UNION
SELECT d.PROD_ID_G, d.CUST_ID_G, d.GEO_ID_G, d.TIME_ID_G, d.FACT_AMT_2_CORR_LOW_G, d.FACT_AMT_2_CORR_HIG_G, d.SKU_FACT_AMT_2_G, d.FACT_AMT_2_INDEX_G, d.FACT_AMT_2_INDEX_STATUS_G FROM pp_np_cmp_cn_amt2_fytd_v d));

select * from ...
UNION
select * from ...
UNION
...