select
operating_unit_id,
inventory_org_id,
inventory_item_id,
sum(received_quantity) total_received_quantity,
primary_uom_code,
transaction_date,
return_stream_code,
sum(received_weight) total_received_weight,
weight_uom_code,
sum(received_value) total_received_value,
currency_code,
category_id,
category_set_id,
ship_geography_type,
ship_geography_id,
customer_type
from CSD_RETURNS_BI_RCV_TXNS_F
group by
inventory_item_id,
primary_uom_code,
inventory_org_id,
transaction_date,
return_stream_code,
operating_unit_id,
weight_uom_code,
currency_code,
category_id,
category_set_id,
ship_geography_type,
ship_geography_id,
customer_type
SELECT
OPERATING_UNIT_ID
,
INVENTORY_ORG_ID
,
INVENTORY_ITEM_ID
,
SUM(RECEIVED_QUANTITY) TOTAL_RECEIVED_QUANTITY
,
PRIMARY_UOM_CODE
,
TRANSACTION_DATE
,
RETURN_STREAM_CODE
,
SUM(RECEIVED_WEIGHT) TOTAL_RECEIVED_WEIGHT
,
WEIGHT_UOM_CODE
,
SUM(RECEIVED_VALUE) TOTAL_RECEIVED_VALUE
,
CURRENCY_CODE
,
CATEGORY_ID
,
CATEGORY_SET_ID
,
SHIP_GEOGRAPHY_TYPE
,
SHIP_GEOGRAPHY_ID
,
CUSTOMER_TYPE
FROM CSD_RETURNS_BI_RCV_TXNS_F
GROUP BY
INVENTORY_ITEM_ID
,
PRIMARY_UOM_CODE
,
INVENTORY_ORG_ID
,
TRANSACTION_DATE
,
RETURN_STREAM_CODE
,
OPERATING_UNIT_ID
,
WEIGHT_UOM_CODE
,
CURRENCY_CODE
,
CATEGORY_ID
,
CATEGORY_SET_ID
,
SHIP_GEOGRAPHY_TYPE
,
SHIP_GEOGRAPHY_ID
,
CUSTOMER_TYPE
|
|
|