select
inv.rtl_org_cd
, bu.bsns_unit_cd
, sku.rtl_sku_item_nbr
, inv.glbl_item_id
, inv.glbl_item_id_typ
FROM ddr_b_rtl_inv_item_day inv
, ddr_r_rtl_sku_item sku
, ddr_r_org_bsns_unit bu
WHERE inv.rtl_sku_item_id = sku.rtl_sku_item_id
AND inv.org_bsns_unit_id = bu.org_bsns_unit_id
GROUP BY bu.bsns_unit_cd
, inv.rtl_org_cd
, inv.glbl_item_id
, inv.glbl_item_id_typ
, sku.rtl_sku_item_nbr
SELECT
INV.RTL_ORG_CD
, BU.BSNS_UNIT_CD
, SKU.RTL_SKU_ITEM_NBR
, INV.GLBL_ITEM_ID
, INV.GLBL_ITEM_ID_TYP
FROM DDR_B_RTL_INV_ITEM_DAY INV
, DDR_R_RTL_SKU_ITEM SKU
, DDR_R_ORG_BSNS_UNIT BU
WHERE INV.RTL_SKU_ITEM_ID = SKU.RTL_SKU_ITEM_ID
AND INV.ORG_BSNS_UNIT_ID = BU.ORG_BSNS_UNIT_ID
GROUP BY BU.BSNS_UNIT_CD
, INV.RTL_ORG_CD
, INV.GLBL_ITEM_ID
, INV.GLBL_ITEM_ID_TYP
, SKU.RTL_SKU_ITEM_NBR
|
|
|