select assoc.MFG_ORG_CD
, assoc.RTL_ORG_CD
, assoc.RTL_BSNS_UNIT_ID
, assoc.MFG_ITEM_ID
, assoc.RTL_ITEM_ID
, timehier.BSNS_MNTH_ID
, sum(assoc.TOTAL_BU_ITM_DAYS) as TOTAL_BU_ITM_DAYS
, count(assoc.TOTAL_BU_ITM_DAYS) as CNT_WKS
, count(*) as CNT_TOTAL
from ddr_sv_itm_bu_assc_wk_mv assoc
, ddr_r_bsns_wk_dn_mv timehier
where timehier.bsns_wk_id = assoc.bsns_wk_id
group by assoc.MFG_ORG_CD
, assoc.RTL_ORG_CD
, assoc.RTL_BSNS_UNIT_ID
, assoc.MFG_ITEM_ID
, assoc.RTL_ITEM_ID
, timehier.BSNS_MNTH_ID
SELECT ASSOC.MFG_ORG_CD
, ASSOC.RTL_ORG_CD
, ASSOC.RTL_BSNS_UNIT_ID
, ASSOC.MFG_ITEM_ID
, ASSOC.RTL_ITEM_ID
, TIMEHIER.BSNS_MNTH_ID
, SUM(ASSOC.TOTAL_BU_ITM_DAYS) AS TOTAL_BU_ITM_DAYS
, COUNT(ASSOC.TOTAL_BU_ITM_DAYS) AS CNT_WKS
, COUNT(*) AS CNT_TOTAL
FROM DDR_SV_ITM_BU_ASSC_WK_MV ASSOC
, DDR_R_BSNS_WK_DN_MV TIMEHIER
WHERE TIMEHIER.BSNS_WK_ID = ASSOC.BSNS_WK_ID
GROUP BY ASSOC.MFG_ORG_CD
, ASSOC.RTL_ORG_CD
, ASSOC.RTL_BSNS_UNIT_ID
, ASSOC.MFG_ITEM_ID
, ASSOC.RTL_ITEM_ID
, TIMEHIER.BSNS_MNTH_ID
|
|
|