select mfghier.MFG_ORG_CD
, timehier.CLNDR_CD
, mfghier.MFG_ITEM_CLASS_ID
, timehier.DAY_CD
, count(*) as NUM_MFG_SKU_ITEMS
from ddr_r_mfg_item_sku_dn_mv mfghier
, ddr_r_base_day_dn_mv timehier
where timehier.mfg_org_cd = mfghier.mfg_org_cd
and timehier.clndr_cd = CONCAT(mfghier.mfg_org_cd, '-BSNS')
and timehier.clndr_dt between mfghier.eff_from_dt and mfghier.eff_to_dt
group by mfghier.MFG_ORG_CD
, timehier.CLNDR_CD
, mfghier.MFG_ITEM_CLASS_ID
, timehier.DAY_CD
SELECT MFGHIER.MFG_ORG_CD
, TIMEHIER.CLNDR_CD
, MFGHIER.MFG_ITEM_CLASS_ID
, TIMEHIER.DAY_CD
, COUNT(*) AS NUM_MFG_SKU_ITEMS
FROM DDR_R_MFG_ITEM_SKU_DN_MV MFGHIER
, DDR_R_BASE_DAY_DN_MV TIMEHIER
WHERE TIMEHIER.MFG_ORG_CD = MFGHIER.MFG_ORG_CD
AND TIMEHIER.CLNDR_CD = CONCAT(MFGHIER.MFG_ORG_CD
, '-BSNS')
AND TIMEHIER.CLNDR_DT BETWEEN MFGHIER.EFF_FROM_DT
AND MFGHIER.EFF_TO_DT
GROUP BY MFGHIER.MFG_ORG_CD
, TIMEHIER.CLNDR_CD
, MFGHIER.MFG_ITEM_CLASS_ID
, TIMEHIER.DAY_CD
|
|
|