[Home] [Help]
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
Name |
OPERATING_UNIT_PK_KEY |
OPERATING_UNIT_NAME |
DISCOUNT_AT_RISK |
DISCOUNT_LOST |