MATERIALIZED VIEW: APPS.DDR_SV_ITM_BU_ASSC_QTR_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_QTR_ID
,      sum(assoc.TOTAL_BU_ITM_DAYS) as TOTAL_BU_ITM_DAYS
,      count(assoc.TOTAL_BU_ITM_DAYS) as CNT_MNTHS
,      count(*) as CNT_TOTAL
from   ddr_sv_itm_bu_assc_mnth_mv    assoc
,      ddr_r_bsns_mnth_dn_mv         timehier
where timehier.bsns_mnth_id = assoc.bsns_mnth_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_QTR_ID