oracle 视图 case when,求优化 多个 case when视图优化

CREATE OR REPLACE VIEW V_GAL_IMP_YB_B0001_0724 AS

SELECT id,nd,mo,km_code,km_name,ylj, sum(ylj) over(partition by nd,id order by mo) nlj from (select A.ID,a.nd,a.MO,a.KM_CODE,a.KM_NAME,

(case

WHEN A.ID='0001' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE (S.KMDM like '101%' OR S.KMDM like '103%' ) AND KMDM NOT like '10301%' AND KMDM NOT like '10306%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0002' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '101%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0003' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE (S.KMDM like '1010101%' OR S.KMDM like '1010102%' ) and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0004' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010101%' and s.nd=a.ND and s.mo=a.MO )

---

WHEN A.ID='0014' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE (S.KMDM LIKE '101010150%' OR

KMDM LIKE '101010122%' OR

KMDM LIKE '101010125%' OR

KMDM LIKE '101010126%' OR

KMDM LIKE '101010127%' OR

KMDM LIKE '101010128%' OR

KMDM LIKE '101010129%') and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0018' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010201%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0021' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010104%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0023' THEN (SELECT SUM (YLJ) FROM V_SSSR_BB001 S WHERE (S.KMDM LIKE '1010102%' OR S.KMDM LIKE '1010202%') AND S.nd=A.ND AND S.MO

=A.MO )

WHEN A.ID='0024' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010102%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0025' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010202%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0028' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE (S.KMDM like '1010103%' OR S.KMDM like '1010203%') and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0029' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010203%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0030' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010103%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0033' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010105%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0034' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE (S.KMDM like '1010301%' OR S.KMDM like '1010302%' OR S.KMDM like '1010303%' OR S.KMDM like '1010304%' OR S.KMDM like '1010305%' OR S.KMDM like '1010320%' OR S.KMDM like '1010329%')

and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0035' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010301%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0036' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010302%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0037' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010303%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0038' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010304%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0039' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010305%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0040' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010306%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0041' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010320%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0042' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010329%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0043' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE (S.KMDM like '10104%' AND S.KMDM NOT like '1010443%' AND S.KMDM NOT like '1010443%' ) and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0044' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE (KMDM LIKE '1010401%' OR KMDM LIKE'1010402%' OR KMDM LIKE'1010403%' OR KMDM LIKE'1010404%' OR KMDM LIKE'1010405%' OR KMDM LIKE'1010406%' OR KMDM LIKE'1010407%' OR KMDM LIKE'1010408%' OR KMDM LIKE'1010409%' OR KMDM LIKE'1010410%' OR KMDM LIKE'1010411%' OR KMDM LIKE'1010412%' OR KMDM LIKE'1010413%' OR KMDM LIKE'1010414%' OR KMDM LIKE'1010415%' OR KMDM LIKE'1010416%')

and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0045' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010417%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0047' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010418%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0048' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010419%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0049' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010420%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0050' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010421%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0051' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010422%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0052' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010423%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0053' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010424%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0054' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010425%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0055' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010426%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0056' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010427%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0057' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010428%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0058' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010429%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0059' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010430%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0060' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010431%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0061' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010432%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0062' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010433%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0063' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010434%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0064' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010435%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0065' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010436%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0066' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010439%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0067' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010440%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0068' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010441%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0069' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010442%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0070' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010443%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0071' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010444%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0072' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010445%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0073' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010446%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0074' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010447%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0075' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010449%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0076' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010450%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0077' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '10105%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0078' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE (KMDM LIKE '1010517%' OR KMDM LIKE'1010501%' OR KMDM LIKE'1010502%' OR KMDM LIKE'1010503%' OR KMDM LIKE'1010504%' OR KMDM LIKE'1010505%' OR KMDM LIKE'1010506%' OR KMDM LIKE'1010507%' OR KMDM LIKE'1010508%' OR KMDM LIKE'1010509%' OR KMDM LIKE'1010510%' OR KMDM LIKE'1010511%' OR KMDM LIKE'1010512%' OR KMDM LIKE'1010413%' OR KMDM LIKE'1010514%' OR KMDM LIKE'1010515%' OR KMDM LIKE'1010416%') and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0079' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010517%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0080' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010518%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0081' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010519%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0082' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010520%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0083' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010521%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0084' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010522%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0085' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010523%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0086' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010524%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0087' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010525%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0088' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010526%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0089' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010527%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0090' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010528%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0091' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010529%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0092' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010530%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0093' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010531%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0094' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010532%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0095' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010533%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0096' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010534%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0097' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010535%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0098' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010536%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0099' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010599%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0100' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '10106%' and s.nd=a.ND and s.mo=a.MO )

----

WHEN A.ID='0102' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '10107%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0103' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '10109%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0104' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010918%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0105' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010921%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0106' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1010922%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0107' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '10110%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0108' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '10111%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0109' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1011101%' and s.nd=a.ND and s.mo=a.MO )

---

WHEN A.ID='0110' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '10112%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0111' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '10113%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0112' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '10114%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0113' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '10115%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0114' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '10116%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0115' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '10117%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0116' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '10118%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0117' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '10119%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0118' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '10120%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0119' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '10199%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0120' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103%' AND S.KMDM NOT like '10301%' AND S.KMDM NOT LIKE '10306%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0121' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '10302%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0122' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030201%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0123' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030202%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0125' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030203%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0129' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030205%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0130' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030210%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0131' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030211%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0132' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030212%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0133' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030213%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0134' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030215%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0138' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030299%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0141' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '10304%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0142' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030401%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0143' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030402%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0144' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030403%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0145' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030405%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0146' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030408%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0147' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030411%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0148' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030416%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0149' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030424%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0150' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030427%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0151' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030432%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0152' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030433%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0153' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030435%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0154' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030444%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0155' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030446%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0156' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030447%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0157' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030449%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0158' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030450%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0159' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030451%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0160' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030452%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0161' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030453%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0162' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE (KMDM like '1030404%' OR KMDM like '1030406%' OR KMDM like '1030407%' OR KMDM like '1030409%' OR KMDM like '1030410%' OR KMDM like '1030412%' OR KMDM like '1030413%' OR KMDM like '1030414%' OR KMDM like '1030415%' OR KMDM like '1030417%' OR KMDM like '1030418%' OR KMDM like '1030419%' OR KMDM like '1030420%' OR KMDM like '1030421%' OR KMDM like '1030422%' OR KMDM like '1030423%' OR KMDM like '1030425%' OR KMDM like '1030426%' OR KMDM like '1030428%' OR KMDM like '1030429%' OR KMDM like '1030430%' OR KMDM like '1030431%' OR KMDM like '1030434%' OR KMDM like '1030436%' OR KMDM like '1030437%' OR KMDM like '1030438%' OR KMDM like '1030439%' OR KMDM like '1030440%' OR KMDM like '1030441%' OR KMDM like '1030442%' OR KMDM like '1030443%' OR KMDM like '1030445%' OR KMDM like '1030448%' OR KMDM like '1030454%' OR KMDM like '1030455%' OR KMDM like '1030456%' OR KMDM like '1030457%' OR KMDM like '1030458%' OR KMDM like '1030459%' OR KMDM like '1030460%' OR KMDM like '1030461%' OR KMDM like '1030462%' OR KMDM like '1030488%' OR KMDM like '1030499%') and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0163' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '10305%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0164' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030501%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0178' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE (KMDM LIKE '103050105%' OR KMDM LIKE '103050112%' OR KMDM LIKE '103050113%' OR KMDM LIKE '103050117%' OR KMDM LIKE '103050118%' OR KMDM LIKE '103050119%' OR KMDM LIKE '103050120%' OR KMDM LIKE '103050121%' OR KMDM LIKE '103050122%'OR KMDM LIKE '103050199%') and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0179' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030502%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0180' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030503%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0181' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030509%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID BETWEEN '0182' AND '0199' THEN 0

----

WHEN A.ID='0200' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '10307%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0201' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030701%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0202' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030702%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0203' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030703%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0204' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030704%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0205' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030705%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0206' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103070501%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0207' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103070502%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0208' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103070503%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0209' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM LIKE '103070599%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0210' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030706%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0211' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030707%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0212' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030708%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0213' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030799%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0214' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '10399%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0215' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1039901%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0216' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103990101%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0217' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103990102%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0218' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103990103%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0219' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1039902%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0220' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1039903%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0221' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1039904%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0222' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1039905%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0223' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1039906%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0224' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1039907%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0225' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1039908%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0226' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1039909%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0227' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103990901%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0228' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103990902%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0229' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1039911%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0230' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1039912%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0231' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1039913%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0232' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1039960%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0233' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE ( KMDM like '1039999%' OR KMDM like '1039998%') and s.nd=a.ND and s.mo=a.MO )

------

WHEN A.ID='0234' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '10301%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0235' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030102%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0236' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030103%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0237' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030106%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0238' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030110%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0239' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030112%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0240' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030114%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0241' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030115%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0242' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030118%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0243' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030119%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0244' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030121%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0245' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030126%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0246' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030127%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0247' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030129%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0248' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030131%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0249' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030133%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0250' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030135%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0251' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030136%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0252' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030137%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0253' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030138%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0254' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030139%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0255' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030142%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0256' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030143%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0257' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103014301%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0258' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103014302%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0259' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103014303%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0260' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103014304%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0261' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103014305%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0262' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103014399%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0263' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030144%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0264' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030146%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0265' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030147%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0266' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030148%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0267' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103014801%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0268' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103014802%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0269' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103014803%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0270' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103014804%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0271' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103014805%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0272' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103014898%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0273' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103014899%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0274' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030149%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0275' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030150%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0276' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030152%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0277' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030153%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0278' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030154%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0279' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030155%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0280' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103015501%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0281' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103015502%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0282' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030156%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0283' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030157%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0284' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030158%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0285' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103015801%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0286' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103015802%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0287' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103015803%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0288' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030159%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0289' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030160%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0290' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030166%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0291' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030168%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0292' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030170%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0293' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030171%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0294' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030172%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0295' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030173%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0296' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030174%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0297' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030175%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0298' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030199%' and s.nd=a.ND and s.mo=a.MO )

------

WHEN A.ID='0299' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '10306%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0300' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030601%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0301' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060102%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0302' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060103%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0303' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060104%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0304' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060105%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0305' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060106%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0306' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060107%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0307' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060108%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0308' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060109%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0309' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060112%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0310' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060113%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0311' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060114%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0312' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060115%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0313' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060116%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0314' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060117%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0315' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060118%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0316' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060119%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0317' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060120%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0318' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060121%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0319' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060122%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0320' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060123%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0321' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060124%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0322' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060125%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0323' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060126%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0324' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060127%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0325' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060128%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0326' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060129%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0327' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060130%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0328' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060131%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0329' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060132%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0330' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060133%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0331' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060198%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0332' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030602%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0333' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060202%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0334' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060203%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0335' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060298%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0336' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030603%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0337' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060301%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0338' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060304%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0339' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060305%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0340' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060306%' and s.nd=a.ND and s.mo=a.MO )

---0341 修改~~~

WHEN A.ID='0341' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060398%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0342' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030604%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0343' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060401%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0344' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060402%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0345' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '103060498%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0346' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '1030698%' and s.nd=a.ND and s.mo=a.MO )

----

WHEN A.ID='0347' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '105%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0348' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '10501%' and s.nd=a.ND and s.mo=a.MO )

WHEN A.ID='0349' THEN (SELECT SUM(YLJ) FROM V_SSSR_BB001 S WHERE S.KMDM like '10502%' and s.nd=a.ND and s.mo=a.MO )

ELSE NVL(SUM(NVL(YLJ, 0)),0)

END) YLJ

from (SELECT A.ID,A.ND,A.MO, A.KM_CODE, A.KM_NAME,

NVL(SUM(NVL(B.YLJ, 0)),0) YLJ

FROM GAL_IMP_YB_2013_KM A

LEFT JOIN V_SSSR_BB001 B ON A.KM_CODE = B.KMDM AND A.ND = B.nd AND A.MO = B.mo

GROUP BY A.ND, A.MO, A.ID, A.KM_CODE, A.KM_NAME) A

GROUP BY A.ID,A.ND,A.MO,A.KM_CODE,A.KM_NAME);