select
operating_unit_id,
inventory_org_id,
sum(transacted_qty) total_quantity,
transaction_date,
mtl_disposition_code,
category_id,
category_set_id,
inv_geography_type,
inv_geography_id,
sum(recovery_value) recovery_value,
sum(processing_cost) processing_cost,
sum(recovery_value - processing_cost) recovery_profit,
currency_code
from CSD_RETURNS_BI_MTL_TXNS_F
group by
operating_unit_id,
inventory_org_id,
currency_code,
category_id,
category_set_id,
inv_geography_type,
inv_geography_id,
mtl_disposition_code,
transaction_date
SELECT
OPERATING_UNIT_ID
,
INVENTORY_ORG_ID
,
SUM(TRANSACTED_QTY) TOTAL_QUANTITY
,
TRANSACTION_DATE
,
MTL_DISPOSITION_CODE
,
CATEGORY_ID
,
CATEGORY_SET_ID
,
INV_GEOGRAPHY_TYPE
,
INV_GEOGRAPHY_ID
,
SUM(RECOVERY_VALUE) RECOVERY_VALUE
,
SUM(PROCESSING_COST) PROCESSING_COST
,
SUM(RECOVERY_VALUE - PROCESSING_COST) RECOVERY_PROFIT
,
CURRENCY_CODE
FROM CSD_RETURNS_BI_MTL_TXNS_F
GROUP BY
OPERATING_UNIT_ID
,
INVENTORY_ORG_ID
,
CURRENCY_CODE
,
CATEGORY_ID
,
CATEGORY_SET_ID
,
INV_GEOGRAPHY_TYPE
,
INV_GEOGRAPHY_ID
,
MTL_DISPOSITION_CODE
,
TRANSACTION_DATE
|
|
|