17,377
社区成员
发帖
与我相关
我的任务
分享
SELECT B.SPCODE SPCODE
,B.BARCODE BARCODE
,B.NAME NAME
,C.FDBH FDBH
,SUM(C.XSJE) XSJE
,SUM(C.XSSL) XSSL
,SUM(T.JHCB) JHCB
FROM SKTXSJL L
,SKTXSJLC C
,SKTXSJLM M
,SPXX_JB B
,(SELECT SUM(P.JHSL * P.JHDJ) / SUM(P.JHSL) JHCB
,P.SP_ID
FROM SPFPCJC P
,KCPCXX K
WHERE P.KCPCH = K.KCPCH
AND TRUNC(K.JHSJ) >= TO_DATE('2020.01.01')
AND TRUNC(K.JHSJ) <= TO_DATE('2020.01.31')
GROUP BY P.SP_ID) T
WHERE (L.SKTNO = C.SKTNO)
AND (L.SKTNO = M.SKTNO)
AND (C.SP_ID = B.SP_ID)
AND (L.JLBH = C.JLBH)
AND (L.JLBH = M.JLBH)
AND
((M.SKFS = 29) AND (trunc(L.JYSJ) >= '2020.01.01' AND TRUNC(L.JYSJ) <= '2020.01.31'))
AND (C.SP_ID = T.SP_ID(+))
GROUP BY B.SPCODE
,B.BARCODE
,B.NAME
,C.FDBH;