VIEW: APPS.FII_AP_OPEN_PAYMT_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,
        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

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
, 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