View: FII_AP_DISC_LOST_TOP_SUMMARY_V

Product:	FII - Financial Intelligence
Description:	FII_AP_DISC_LOST_TOP_SUMMARY_V is the view to support Payables Discount Lost Summary Drill Downs Portlet
Implementation/DBA Data:	APPS.FII_AP_DISC_LOST_TOP_SUMMARY_V

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
, COUNT(DISTINCT INVOICE_UNIQUE_IDENTIFIER) INVOICE_COUNT
, SUM(INVOICE_AMOUNT) INVOICE_AMOUNT
, SUM(DISCOUNT_LOST) DISCOUNT_LOST
FROM FII_AP_DISCOUNTS_SUMMARY
WHERE RECORD_TYPE = 'L' GROUP BY OPERATING_UNIT_PK_KEY
, OPERATING_UNIT_NAME
, TRADING_PARTNER_PK_KEY
, TRADING_PARTNER_NAME

Columns