[Home] [Help]
View: FII_AP_DISC_AVAL_TOP_SUMMARY_V
Product: | FII - Financial Intelligence (Obsolete) |
Description: | FII_AP_DISC_AVAL_TOP_SUMMARY_V is the view to support Payables Discount Available Summary Drill Downs Portlet |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT OPERATING_UNIT_PK_KEY OPERATING_UNIT_PK_KEY
, OPERATING_UNIT_NAME OPERATING_UNIT_NAME
, TRADING_PARTNER_PK_KEY TRADING_PARTNER_PK_KEY
, TRADING_PARTNER_NAME TRADING_PARTNER_NAME
, SUM(INVOICE_AMOUNT) INVOICE_AMOUNT
, COUNT(DISTINCT INVOICE_UNIQUE_IDENTIFIER) INVOICE_COUNT
, SUM(DISCOUNT_AVAILABLE) DISCOUNT_AVAILABLE
FROM FII_AP_DISCOUNTS_SUMMARY
WHERE RECORD_TYPE = 'R' GROUP BY OPERATING_UNIT_PK_KEY
, OPERATING_UNIT_NAME
, TRADING_PARTNER_PK_KEY
, TRADING_PARTNER_NAME
Columns
Name |
OPERATING_UNIT_PK_KEY |
OPERATING_UNIT_NAME |
TRADING_PARTNER_PK_KEY |
TRADING_PARTNER_NAME |
INVOICE_AMOUNT |
INVOICE_COUNT |
DISCOUNT_AVAILABLE |