FOrecast

SELECT *
  FROM (
select F.CD_USER
     , FD.CD_ITEM
     , CAST( F.NU_YEAR AS VARCHAR(4) ) + '01' AS NU_YEARMONTH
     , FD.VL_JANUARY AS VL_FORECAST
  from TFORECAST_DETAIL FD
     , TFORECAST F
 where F.CD_FORECAST = FD.CD_FORECAST
   and F.DC_STATUS = 'ACTIVE'
 union all
select F.CD_USER
     , FD.CD_ITEM
     , CAST( F.NU_YEAR AS VARCHAR(4) ) + '02' AS NU_YEARMONTH
     , FD.VL_FEBRUARY
  from TFORECAST_DETAIL FD
     , TFORECAST F
 where F.CD_FORECAST = FD.CD_FORECAST
   and F.DC_STATUS = 'ACTIVE'
 union all
select F.CD_USER
     , FD.CD_ITEM
     , CAST( F.NU_YEAR AS VARCHAR(4) ) + '03' AS NU_YEARMONTH
     , FD.VL_MARCH
  from TFORECAST_DETAIL FD
     , TFORECAST F
 where F.CD_FORECAST = FD.CD_FORECAST
   and F.DC_STATUS = 'ACTIVE'
 union all
select F.CD_USER
     , FD.CD_ITEM
     , CAST( F.NU_YEAR AS VARCHAR(4) ) + '04' AS NU_YEARMONTH
     , FD.VL_APRIL
  from TFORECAST_DETAIL FD
     , TFORECAST F
 where F.CD_FORECAST = FD.CD_FORECAST
   and F.DC_STATUS = 'ACTIVE'
 union all
select F.CD_USER
     , FD.CD_ITEM
     , CAST( F.NU_YEAR AS VARCHAR(4) ) + '05' AS NU_YEARMONTH
     , FD.VL_MAY
  from TFORECAST_DETAIL FD
     , TFORECAST F
 where F.CD_FORECAST = FD.CD_FORECAST
   and F.DC_STATUS = 'ACTIVE'
 union all
select F.CD_USER
     , FD.CD_ITEM
     , CAST( F.NU_YEAR AS VARCHAR(4) ) + '06' AS NU_YEARMONTH
     , FD.VL_JUNE
  from TFORECAST_DETAIL FD
     , TFORECAST F
 where F.CD_FORECAST = FD.CD_FORECAST
   and F.DC_STATUS = 'ACTIVE'
 union all
select F.CD_USER
     , FD.CD_ITEM
     , CAST( F.NU_YEAR AS VARCHAR(4) ) + '07' AS NU_YEARMONTH
     , FD.VL_JULY
  from TFORECAST_DETAIL FD
     , TFORECAST F
 where F.CD_FORECAST = FD.CD_FORECAST
   and F.DC_STATUS = 'ACTIVE'
 union all
select F.CD_USER
     , FD.CD_ITEM
     , CAST( F.NU_YEAR AS VARCHAR(4) ) + '08' AS NU_YEARMONTH
     , FD.VL_AUGUST
  from TFORECAST_DETAIL FD
     , TFORECAST F
 where F.CD_FORECAST = FD.CD_FORECAST
   and F.DC_STATUS = 'ACTIVE'
 union all
select F.CD_USER
     , FD.CD_ITEM
     , CAST( F.NU_YEAR AS VARCHAR(4) ) + '09' AS NU_YEARMONTH
     , FD.VL_SEPTEMBER
  from TFORECAST_DETAIL FD
     , TFORECAST F
 where F.CD_FORECAST = FD.CD_FORECAST
   and F.DC_STATUS = 'ACTIVE'
 union all
select F.CD_USER
     , FD.CD_ITEM
     , CAST( F.NU_YEAR AS VARCHAR(4) ) + '10' AS NU_YEARMONTH
     , FD.VL_OCTOBER
  from TFORECAST_DETAIL FD
     , TFORECAST F
 where F.CD_FORECAST = FD.CD_FORECAST
   and F.DC_STATUS = 'ACTIVE'
 union all
select F.CD_USER
     , FD.CD_ITEM
     , CAST( F.NU_YEAR AS VARCHAR(4) ) + '11' AS NU_YEARMONTH
     , FD.VL_NOVEMBER
  from TFORECAST_DETAIL FD
     , TFORECAST F
 where F.CD_FORECAST = FD.CD_FORECAST
   and F.DC_STATUS = 'ACTIVE'
 union all
select F.CD_USER
     , FD.CD_ITEM
     , CAST( F.NU_YEAR AS VARCHAR(4) ) + '12' AS NU_YEARMONTH
     , FD.VL_DECEMBER
  from TFORECAST_DETAIL FD
     , TFORECAST F
 where F.CD_FORECAST = FD.CD_FORECAST
   and F.DC_STATUS = 'ACTIVE'
) A
WHERE A.CD_ITEM = '00004'
  AND NU_YEARMONTH <= '201607'
  AND A.CD_USER = 1