아직 초보라서 구문 분석부터 하려 합니다.

회사의 소스를 보다 보니...

아래와 같이 이해가 안가는 부분이 있어 도움을 받을수 있을가해서 문의 드립니다.

숫자 "0" 부분의 어디 부분과 관계가 있는지 도무지 모르겠네요....

부탁 드립니다.

       0 AS CS_110_WIP_CNT,
      0 AS CS_120_WIP_CNT,
      0 AS CS_120_IQC_CNT,

select  ROW_NUMBER() OVER(ORDER BY o.tlt_grp1 ,  o.tlt_grp2,o.tlt_grp3,o.tlt_grp4 ASC)  AS '번호', 
          o.tlt_grp1 as '품목그룹',
          isnull(o.tlt_grp2, '')   as '제조번호',
          isnull(o.tlt_grp3, '')   as 'LOT#', 
          isnull(o.tlt_grp4, '')   as '품목코드',
  
  SUM(o.CS_110_WIP_cnt)   as 'MM품(오더량-생산량)',
  SUM(o.CS_120_WIP_cnt)   as 'Aging(MM량-Aging)',
  SUM(o.CS_120_IQC_cnt)   as 'IQC(Aging)대기',
  
  SUM(o.CS_220_WIP_cnt)   as '금도금(반출-반입)',
  SUM(o.CS_220_IQC_cnt)   as '금도금검사대기',
 
  SUM(o.CS_330_WIP_cnt)  as '절단대기(쇼트-절단)',
  SUM(o.CS_340_WIP_cnt)  as '선별대기(절단-1차)',
  SUM(o.CS_340_OQC_cnt)  as 'OQC(절단품)대기',

  SUM(o.CS_410_WIP_cnt)  as '후가공(오더량-생산량)',
  SUM(o.CS_410_OQC_cnt)  as 'OQC(후가공)대기',
  
  SUM(o.CS_510_WIP_cnt)  as '3차선별(오더량-생산량)'   
from   
(

   select                          e.item_group_nm     AS tlt_grp1,
                                      x.PRODT_ORDER_NO    as tlt_grp2, 
                                      X.LOT_NO            AS tlt_grp3,
                                      A.ITEM_CD           as tlt_grp4,
                                      0                             AS CS_110_WIP_CNT,
                                      0                             AS CS_120_WIP_CNT,
                                      0                             AS CS_120_IQC_CNT,
                                      0                             AS CS_220_WIP_CNT,
                                      0                             AS CS_220_IQC_CNT,
                                      0                            AS CS_330_WIP_CNT,
                                      0                            AS CS_340_WIP_CNT,
                                      0                            AS CS_340_OQC_CNT,
                                      0                            AS CS_410_WIP_CNT,
                                      0                            AS CS_410_OQC_CNT,
                                      0                            AS CS_510_WIP_CNT
   
   from (
     select  C.PRODT_ORDER_NO,C.LOT_NO,C.OPR_NO,                                             
       
      SUM(CASE c.opr_no WHEN '110' THEN (CASE  c.REPORT_TYPE WHEN 'G' THEN c.PROD_QTY_IN_ORDER_UNIT ELSE 0 END) ELSE 0 END) as CS_110_good_cnt,
      SUM(CASE c.opr_no WHEN '110' THEN (CASE  c.REPORT_TYPE WHEN 'B' THEN c.PROD_QTY_IN_ORDER_UNIT ELSE 0 END) ELSE 0 END) as CS_110_bad_cnt