VIEW: APPS.FII_AP_DISC_AVAL_TOP_SUMMARY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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