A330BIS

SELECT * FROM (SELECT B.desc_conto0 from CONTO_GERARCHIA_ABBI A 
INNER JOIN conto B
ON A.cod_conto = B.cod_conto
where A.COD_CONTO_ELEGER = '2100' or A.COD_CONTO_ELEGER = '2200'
and A.COD_CONTO_GERARCHIA = '010') AS U
UNION ALL SELECT '$ Value' AS U 
UNION ALL SELECT 'Calculation' AS U

SELECT * FROM (
select 01 as Num,'January' as Period union
select 02 as Num,'February' union
select 03 as Num,'March' union
select 04 as Num,'April' union
select 05 as Num,'May' union
select 06 as Num,'June' union
select 07 as Num,'July' union
select 08 as Num,'August' union
select 09 as Num,'September' union
select 10 as Num,'October' union
select 11 as Num,'November' union
select 12 as Num,'December' union
select 13 as Num,'Every Month'
) A 
ORDER BY NUM

SELECT "Year",
   "Month",
   "Entity",
   "GL_Account_ID",
   "GL_Account_Desc",
   "Master_Account",
   "Cost_Center",
   "Invoice_Number",
   "Invoice_Date",
   "Supplier",
   amount
FROM  (
       SELECT campo1 AS "Year",
          campo14 AS "Scenario",
          campo2 AS "Month",
          campo3 AS "Entity",
          campo4 AS "GL_Account_ID",
          campo15 AS "Master_Account",
          campo5 AS "GL_Account_Desc",
          campo6 AS "Cost_Center",
          campo7 AS "Product",
          campo8 AS "Customer",
          campo9 AS "Invoice_Number",
  				CASE WHEN LENGTH(campo10) > 0 THEN       
  					TO_CHAR(TO_DATE('01011900','MMDDYYYY')+TO_NUMBER(campo10,'99999')*INTERVAL '1 Day', 'MM/DD/YYYY')
  				ELSE ''
  				END AS "Invoice_Date",
          campo11 AS "Supplier",
          CAST (REPLACE(campo12,',','.') AS NUMERIC(20,2)) AS amount
       FROM  map_dati_trasformati
       WHERE cod_mappatura='05'
       AND  cod_import='010'
       AND  campo1='2018'
       AND  campo2='12'
       AND  campo3=${$entity(hierarchy("010")).code}
       AND  campo6=${$cust_dim1(hierarchy("010")).code}
       AND  campo7='PD_500'
       AND  campo8='CM_500'
       AND  campo15=${$account(hierarchy("010")).code}
       AND  campo14=${$scenario(hierarchy("$")).code}
) a
UNION ALL
SELECT 'Total',
   '',
   '',
   '',
   '',
   '',
   '',
   '',
   '',
   '',
   SUM(amount) AS amount
FROM  (
       SELECT CAST (REPLACE(campo12,',','.') AS NUMERIC(20,2)) AS amount
       FROM  map_dati_trasformati
       WHERE cod_mappatura='05'
       AND  cod_import='010'
       AND  campo1='2018'
       AND  campo2='12'
       AND  campo3=${$entity(hierarchy("010")).code}
       AND  campo6=${$cust_dim1(hierarchy("010")).code}
       AND  campo7='PD_500'
       AND  campo8='CM_500'
       AND  campo15=${$account(hierarchy("010")).code}
       AND  campo14=${$scenario(hierarchy("$")).code}
) a