select catwk.MFG_ORG_CD
, catwk.MFG_ITEM_CLASS_ID
, timehier.BSNS_MNTH_ID
, sum(catwk.NUM_MFG_SKU_ITEMS) as NUM_MFG_SKU_ITEMS
, timehier.MNTH_TIMESPN
, count(catwk.NUM_MFG_SKU_ITEMS) as CNT_WKS
, count(*) as CNT_TOTAL
from ddr_sv_cls_wk_mv catwk
, ddr_r_bsns_wk_dn_mv timehier
where timehier.bsns_wk_id = catwk.bsns_wk_id
group by catwk.MFG_ORG_CD
, catwk.MFG_ITEM_CLASS_ID
, timehier.BSNS_MNTH_ID
, timehier.MNTH_TIMESPN
SELECT CATWK.MFG_ORG_CD
, CATWK.MFG_ITEM_CLASS_ID
, TIMEHIER.BSNS_MNTH_ID
, SUM(CATWK.NUM_MFG_SKU_ITEMS) AS NUM_MFG_SKU_ITEMS
, TIMEHIER.MNTH_TIMESPN
, COUNT(CATWK.NUM_MFG_SKU_ITEMS) AS CNT_WKS
, COUNT(*) AS CNT_TOTAL
FROM DDR_SV_CLS_WK_MV CATWK
, DDR_R_BSNS_WK_DN_MV TIMEHIER
WHERE TIMEHIER.BSNS_WK_ID = CATWK.BSNS_WK_ID
GROUP BY CATWK.MFG_ORG_CD
, CATWK.MFG_ITEM_CLASS_ID
, TIMEHIER.BSNS_MNTH_ID
, TIMEHIER.MNTH_TIMESPN
|
|
|