select catqtr.MFG_ORG_CD
, catqtr.MFG_ITEM_CLASS_ID
, timehier.BSNS_YR_ID
, sum(catqtr.NUM_MFG_SKU_ITEMS) as NUM_MFG_SKU_ITEMS
, timehier.YR_TIMESPN
, count(catqtr.NUM_MFG_SKU_ITEMS) as CNT_QTRS
, count(*) as CNT_TOTAL
from ddr_sv_cls_qtr_mv catqtr
, ddr_r_bsns_qtr_dn_mv timehier
where timehier.bsns_qtr_id = catqtr.bsns_qtr_id
group by catqtr.MFG_ORG_CD
, catqtr.MFG_ITEM_CLASS_ID
, timehier.BSNS_YR_ID
, timehier.YR_TIMESPN
SELECT CATQTR.MFG_ORG_CD
, CATQTR.MFG_ITEM_CLASS_ID
, TIMEHIER.BSNS_YR_ID
, SUM(CATQTR.NUM_MFG_SKU_ITEMS) AS NUM_MFG_SKU_ITEMS
, TIMEHIER.YR_TIMESPN
, COUNT(CATQTR.NUM_MFG_SKU_ITEMS) AS CNT_QTRS
, COUNT(*) AS CNT_TOTAL
FROM DDR_SV_CLS_QTR_MV CATQTR
, DDR_R_BSNS_QTR_DN_MV TIMEHIER
WHERE TIMEHIER.BSNS_QTR_ID = CATQTR.BSNS_QTR_ID
GROUP BY CATQTR.MFG_ORG_CD
, CATQTR.MFG_ITEM_CLASS_ID
, TIMEHIER.BSNS_YR_ID
, TIMEHIER.YR_TIMESPN
|
|
|