SELECT operating_unit_pk_key OPERATING_UNIT_PK_KEY,
operating_unit_name OPERATING_UNIT_NAME,
sum(discount_available) DISCOUNT_AT_RISK,
sum(discount_lost) DISCOUNT_LOST
FROM fii_ap_discounts_summary
GROUP BY operating_unit_pk_key,
operating_unit_name
SELECT OPERATING_UNIT_PK_KEY OPERATING_UNIT_PK_KEY
,
OPERATING_UNIT_NAME OPERATING_UNIT_NAME
,
SUM(DISCOUNT_AVAILABLE) DISCOUNT_AT_RISK
,
SUM(DISCOUNT_LOST) DISCOUNT_LOST
FROM FII_AP_DISCOUNTS_SUMMARY
GROUP BY OPERATING_UNIT_PK_KEY
,
OPERATING_UNIT_NAME
|
|
|