View: FII_AP_DISC_TOP_SUMMARY_V

Product:	FII - Financial Intelligence
Description:	FII_AP_DISC_TOP_SUMMARY_V is the view to support Payment Discount Opportunities Portlet
Implementation/DBA Data:	APPS.FII_AP_DISC_TOP_SUMMARY_V

View Text

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

Columns