create view VRFC_plan_s_ATV as SELECT
  sum(Table__3.`de_s_fc_qty`) S_FC_QTY,
  Table__3.`item_desc`,
  Table__3.`item_mc_name`,
  Table__3.`item_hfg`,
  Table__3.`item_div_adj`,
  Table__3.`plan_name`,
  Table__3.`plan_date`,
  Table__3.`plan_type`,
  Table__3.`item_pl`,
  Table__3.`item_pl_desc`,
  Table__3.`production_cal_month`,
  Table__3.`production_fsc_year`,
  Table__3.`production_fsc_year_desc`,
  Table__3.`production_cur_month_flag`,
  Table__3.`production_time_month_offset`
FROM  `dwhsc_sop_sc_hub`.`biz_mdl_demands`  Table__3
WHERE
  (
   Table__3.`plan_type`  IN  ( 'PM','month'  )
   AND
   Table__3.`production_time_month_offset`  IN  ( 0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24  )
   AND
   Table__3.`production_cal_month_desc`  IN  ( '2020-01','2020-02','2020-03','2020-04','2020-05','2020-06','2020-07','2020-08','2020-09','2020-10','2020-11','2020-12','2021-01','2021-02','2021-03','2021-04','2021-05','2021-06','2021-07','2021-08','2021-09','2021-10','2021-11','2021-12','2022-01','2022-02','2022-03','2022-04','2022-05','2022-06','2022-07','2022-08','2022-09','2022-10'  )
   AND
   Table__3.`item_mc_name`  IN  ( 'AMERICAN AXLE','APTIV','ASENTEC','AUTOLIV','BCS LUXSHARE','BMW','BORGWARNER','BOSCH','BROSE','BWI','BYD','CONTINENTAL','CUMMINS','DANA TM4','DENSO','EBERSPAECHER','ERAE','GMK','HARMAN','HELLA','HITACHI','HUF ELECTRONICS','HYUNDAI','IMI','JOHN DEERE','JOYNEXT','KEBODA','KIMBALL','KOSTAL','LEAR','MAGNA','MAHLE','MANDO','MARELLI','MAXLINEAR','MITSUBISHI ELECTRIC','MSL CIRCUITS','NEXTEER','NICHIA','NIDEC','NIK','NIO','PREH','RENAULT','SCHAEFFLER','SCHWEIZER ELECTRONIC','SENSATA','SIAPM','SIIX','SUMITOMO ELECTRIC','THYSSENKRUPP PRESTA','VALEO','VALEO SIEMENS JV','VEONEER','VISTEON','VITESCO','WEBASTO','YAZAKI','ZF','ZOLLNER'  )
   AND
   Table__3.`item_div_adj`  IN  ( 'ATV'  )
   AND
   Table__3.`plan_name`  LIKE  '%PM%'
  )
GROUP BY
  Table__3.`item_desc`, 
  Table__3.`item_mc_name`, 
  Table__3.`item_hfg`, 
  Table__3.`item_div_adj`, 
  Table__3.`plan_name`, 
  Table__3.`plan_date`, 
  Table__3.`plan_type`, 
  Table__3.`item_pl`, 
  Table__3.`item_pl_desc`, 
  Table__3.`production_cal_month`, 
  Table__3.`production_fsc_year`, 
  Table__3.`production_fsc_year_desc`, 
  Table__3.`production_cur_month_flag`, 
  Table__3.`production_time_month_offset`