[Home] [Help]
MATERIALIZED VIEW: APPS.DDR_SV_ITM_BU_ASSC_WK_MV
Source
select assoc.MFG_ORG_CD
, assoc.RTL_ORG_CD
, assoc.RTL_BSNS_UNIT_ID
, assoc.MFG_ITEM_ID
, assoc.RTL_ITEM_ID
, timehier.BSNS_WK_ID
, sum(assoc.TOTAL_BU_ITM_DAYS) as TOTAL_BU_ITM_DAYS
, count(assoc.TOTAL_BU_ITM_DAYS) as CNT_DAYS
, count(*) as CNT_TOTAL
from ddr_bs_itm_bu_assc_day_mv assoc
, ddr_r_base_day_dn_mv timehier
where timehier.clndr_cd = assoc.clndr_cd
and timehier.day_cd = assoc.day_cd
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_WK_ID