VIEW: APPS.DDR_SV_ITM_BU_ASSC_WK_MV#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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