View: FII_AP_OPEN_PAYMT_SUMMARY_V

Product:	FII - Financial Intelligence
Description:	FII_AP_OPEN_PAYMT_SUMMARY_V is the view to support Payables Open Payments Summary Drill Downs Portlet
Implementation/DBA Data:	APPS.FII_AP_OPEN_PAYMT_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(SCH_PAYMENT_ID) PAYMENT_COUNT
, SUM(OPEN_PAYMENT_AMOUNT) PAYMENT_AMOUNT
, AVG(DAYS_OUTSTANDING) AVG_DAYS_OUTSTANDING
, SUM(DAYS_OUTSTANDING * OPEN_PAYMENT_AMOUNT)/SUM(OPEN_PAYMENT_AMOUNT) WT_DAYS_OUTSTANDING
FROM FII_AP_TRANS_BACKLOG_SUMMARY GROUP BY OPERATING_UNIT_PK_KEY
, OPERATING_UNIT_NAME
, TRADING_PARTNER_PK_KEY
, TRADING_PARTNER_NAME

Columns