select
operating_unit_id,
inventory_org_id,
inventory_item_id,
sum(transacted_qty) total_transacted_quantity,
primary_uom_code,
transaction_date,
mtl_disposition_code,
sum(transacted_weight) total_transacted_weight,
weight_uom_code,
category_id,
category_set_id,
inv_geography_type,
inv_geography_id
from CSD_RETURNS_BI_MTL_TXNS_F
group by
transaction_date,
operating_unit_id,
inventory_org_id,
inventory_item_id,
primary_uom_code,
mtl_disposition_code,
weight_uom_code,
category_id,
category_set_id,
inv_geography_type,
inv_geography_id
SELECT
OPERATING_UNIT_ID
,
INVENTORY_ORG_ID
,
INVENTORY_ITEM_ID
,
SUM(TRANSACTED_QTY) TOTAL_TRANSACTED_QUANTITY
,
PRIMARY_UOM_CODE
,
TRANSACTION_DATE
,
MTL_DISPOSITION_CODE
,
SUM(TRANSACTED_WEIGHT) TOTAL_TRANSACTED_WEIGHT
,
WEIGHT_UOM_CODE
,
CATEGORY_ID
,
CATEGORY_SET_ID
,
INV_GEOGRAPHY_TYPE
,
INV_GEOGRAPHY_ID
FROM CSD_RETURNS_BI_MTL_TXNS_F
GROUP BY
TRANSACTION_DATE
,
OPERATING_UNIT_ID
,
INVENTORY_ORG_ID
,
INVENTORY_ITEM_ID
,
PRIMARY_UOM_CODE
,
MTL_DISPOSITION_CODE
,
WEIGHT_UOM_CODE
,
CATEGORY_ID
,
CATEGORY_SET_ID
,
INV_GEOGRAPHY_TYPE
,
INV_GEOGRAPHY_ID
|
|
|