select catmnth.MFG_ORG_CD
, catmnth.MFG_ITEM_CLASS_ID
, timehier.BSNS_QTR_ID
, sum(catmnth.NUM_MFG_SKU_ITEMS) as NUM_MFG_SKU_ITEMS
, timehier.QTR_TIMESPN
, count(catmnth.NUM_MFG_SKU_ITEMS) as CNT_MNTHS
, count(*) as CNT_TOTAL
from ddr_sv_cls_mnth_mv catmnth
, ddr_r_bsns_mnth_dn_mv timehier
where timehier.bsns_mnth_id = catmnth.bsns_mnth_id
group by catmnth.MFG_ORG_CD
, catmnth.MFG_ITEM_CLASS_ID
, timehier.BSNS_QTR_ID
, timehier.QTR_TIMESPN
SELECT CATMNTH.MFG_ORG_CD
, CATMNTH.MFG_ITEM_CLASS_ID
, TIMEHIER.BSNS_QTR_ID
, SUM(CATMNTH.NUM_MFG_SKU_ITEMS) AS NUM_MFG_SKU_ITEMS
, TIMEHIER.QTR_TIMESPN
, COUNT(CATMNTH.NUM_MFG_SKU_ITEMS) AS CNT_MNTHS
, COUNT(*) AS CNT_TOTAL
FROM DDR_SV_CLS_MNTH_MV CATMNTH
, DDR_R_BSNS_MNTH_DN_MV TIMEHIER
WHERE TIMEHIER.BSNS_MNTH_ID = CATMNTH.BSNS_MNTH_ID
GROUP BY CATMNTH.MFG_ORG_CD
, CATMNTH.MFG_ITEM_CLASS_ID
, TIMEHIER.BSNS_QTR_ID
, TIMEHIER.QTR_TIMESPN
|
|
|