eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
MATERIALIZED VIEW: APPS.FII_AP_MGT_KPI_MV

Source


SELECT /* 12.0: bug#4526784 */
	f.org_id,
	f.time_id,
	f.period_type_id,
	SUM(f.invoice_count_entered) invoice_count_entered,
	SUM(f.e_invoice_count) e_invoice_count,
	SUM(f.paid_amt_b) paid_amt_b,
	SUM(f.paid_amt_prim_g) paid_amt_prim_g,
	SUM(f.paid_amt_sec_g) paid_amt_sec_g,
	SUM(f.paid_invoice_amt_wtd_b) paid_invoice_amt_wtd_b,
	SUM(f.paid_invoice_amt_mtd_b) paid_invoice_amt_mtd_b,
	SUM(f.paid_invoice_amt_qtd_b) paid_invoice_amt_qtd_b,
	SUM(f.paid_invoice_amt_ytd_b) paid_invoice_amt_ytd_b,
	SUM(f.paid_invoice_amt_wtd_prim_g) paid_invoice_amt_wtd_prim_g,
	SUM(f.paid_invoice_amt_mtd_prim_g) paid_invoice_amt_mtd_prim_g,
	SUM(f.paid_invoice_amt_qtd_prim_g) paid_invoice_amt_qtd_prim_g,
	SUM(f.paid_invoice_amt_ytd_prim_g) paid_invoice_amt_ytd_prim_g,
	SUM(f.paid_invoice_amt_wtd_sec_g) paid_invoice_amt_wtd_sec_g,
	SUM(f.paid_invoice_amt_mtd_sec_g) paid_invoice_amt_mtd_sec_g,
	SUM(f.paid_invoice_amt_qtd_sec_g) paid_invoice_amt_qtd_sec_g,
	SUM(f.paid_invoice_amt_ytd_sec_g) paid_invoice_amt_ytd_sec_g,
	SUM(f.paid_inv_count_wtd) paid_inv_count_wtd,
	SUM(f.paid_inv_count_mtd) paid_inv_count_mtd,
	SUM(f.paid_inv_count_qtd) paid_inv_count_qtd,
	SUM(f.paid_inv_count_ytd) paid_inv_count_ytd,
  SUM(payment_count_wtd) payment_count_wtd,
  SUM(payment_count_mtd) payment_count_mtd,
  SUM(payment_count_qtd) payment_count_qtd,
  SUM(payment_count_ytd) payment_count_ytd,
	SUM(f.paid_on_time_amt_b) paid_on_time_amt_b,
	SUM(f.paid_on_time_amt_prim_g) paid_on_time_amt_prim_g,
	SUM(f.paid_on_time_amt_sec_g) paid_on_time_amt_sec_g,
	SUM(f.paid_late_amt_b) paid_late_amt_b,
	SUM(f.paid_late_amt_prim_g) paid_late_amt_prim_g,
	SUM(f.paid_late_amt_sec_g) paid_late_amt_sec_g,
	SUM(f.paid_dis_offered_wtd_b) paid_dis_offered_wtd_b,
	SUM(f.paid_dis_offered_mtd_b) paid_dis_offered_mtd_b,
	SUM(f.paid_dis_offered_qtd_b) paid_dis_offered_qtd_b,
	SUM(f.paid_dis_offered_ytd_b) paid_dis_offered_ytd_b,
	SUM(f.paid_dis_offered_wtd_prim_g) paid_dis_offered_wtd_prim_g,
	SUM(f.paid_dis_offered_mtd_prim_g) paid_dis_offered_mtd_prim_g,
	SUM(f.paid_dis_offered_qtd_prim_g) paid_dis_offered_qtd_prim_g,
	SUM(f.paid_dis_offered_ytd_prim_g) paid_dis_offered_ytd_prim_g,
	SUM(f.paid_dis_offered_wtd_sec_g) paid_dis_offered_wtd_sec_g,
	SUM(f.paid_dis_offered_mtd_sec_g) paid_dis_offered_mtd_sec_g,
	SUM(f.paid_dis_offered_qtd_sec_g) paid_dis_offered_qtd_sec_g,
	SUM(f.paid_dis_offered_ytd_sec_g) paid_dis_offered_ytd_sec_g,
	SUM(f.paid_dis_taken_b) paid_dis_taken_b,
	SUM(f.paid_dis_taken_prim_g) paid_dis_taken_prim_g,
	SUM(f.paid_dis_taken_sec_g) paid_dis_taken_sec_g,
	SUM(f.invoice_to_payment_days) invoice_to_payment_days,
	SUM(f.paid_on_time_count_wtd) paid_on_time_count_wtd,
	SUM(f.paid_on_time_count_mtd) paid_on_time_count_mtd,
	SUM(f.paid_on_time_count_qtd) paid_on_time_count_qtd,
	SUM(f.paid_on_time_count_ytd) paid_on_time_count_ytd,
	SUM(f.paid_late_count_wtd) paid_late_count_wtd,
	SUM(f.paid_late_count_mtd) paid_late_count_mtd,
	SUM(f.paid_late_count_qtd) paid_late_count_qtd,
	SUM(f.paid_late_count_ytd) paid_late_count_ytd
FROM (
SELECT
	a.org_id,
	a.time_id,
	a.period_type_id,
	a.invoice_count_entered invoice_count_entered,
	a.e_invoice_count e_invoice_count,
	0 paid_amt_b,
	0 paid_amt_prim_g,
	0 paid_amt_sec_g,
	0 paid_invoice_amt_wtd_b,
	0 paid_invoice_amt_mtd_b,
	0 paid_invoice_amt_qtd_b,
	0 paid_invoice_amt_ytd_b,
	0 paid_invoice_amt_wtd_prim_g,
	0 paid_invoice_amt_mtd_prim_g,
	0 paid_invoice_amt_qtd_prim_g,
	0 paid_invoice_amt_ytd_prim_g,
	0 paid_invoice_amt_wtd_sec_g,
	0 paid_invoice_amt_mtd_sec_g,
	0 paid_invoice_amt_qtd_sec_g,
	0 paid_invoice_amt_ytd_sec_g,
	0 paid_inv_count_wtd,
	0 paid_inv_count_mtd,
	0 paid_inv_count_qtd,
	0 paid_inv_count_ytd,
  0 payment_count_wtd,
  0 payment_count_mtd,
  0 payment_count_qtd,
  0 payment_count_ytd,
	0 paid_on_time_amt_b,
	0 paid_on_time_amt_prim_g,
	0 paid_on_time_amt_sec_g,
	0 paid_late_amt_b,
	0 paid_late_amt_prim_g,
	0 paid_late_amt_sec_g,
	0 paid_dis_offered_wtd_b,
	0 paid_dis_offered_mtd_b,
	0 paid_dis_offered_qtd_b,
	0 paid_dis_offered_ytd_b,
	0 paid_dis_offered_wtd_prim_g,
	0 paid_dis_offered_mtd_prim_g,
	0 paid_dis_offered_qtd_prim_g,
	0 paid_dis_offered_ytd_prim_g,
	0 paid_dis_offered_wtd_sec_g,
	0 paid_dis_offered_mtd_sec_g,
	0 paid_dis_offered_qtd_sec_g,
	0 paid_dis_offered_ytd_sec_g,
	0 paid_dis_taken_b,
	0 paid_dis_taken_prim_g,
	0 paid_dis_taken_sec_g,
	0 invoice_to_payment_days,
	0 paid_on_time_count_wtd,
	0 paid_on_time_count_mtd,
	0 paid_on_time_count_qtd,
	0 paid_on_time_count_ytd,
	0 paid_late_count_wtd,
	0 paid_late_count_mtd,
	0 paid_late_count_qtd,
	0 paid_late_count_ytd
FROM fii_ap_ivaty_xb_mv a
WHERE a.gid = 4
UNION ALL
SELECT
   b.org_id,
   b.time_id,
   b.period_type_id,
   0 invoice_count_entered,
   0 e_invoice_count,
   b.paid_amt_b paid_amt_b,
   b.paid_amt_prim_g paid_amt_prim_g,
   b.paid_amt_sec_g paid_amt_sec_g,
   b.paid_invoice_amt_wtd_b paid_invoice_amt_wtd_b,
   b.paid_invoice_amt_mtd_b paid_invoice_amt_mtd_b,
   b.paid_invoice_amt_qtd_b paid_invoice_amt_qtd_b,
   b.paid_invoice_amt_ytd_b paid_invoice_amt_ytd_b,
   b.paid_invoice_amt_wtd_prim_g paid_invoice_amt_wtd_prim_g,
   b.paid_invoice_amt_mtd_prim_g paid_invoice_amt_mtd_prim_g,
   b.paid_invoice_amt_qtd_prim_g paid_invoice_amt_qtd_prim_g,
   b.paid_invoice_amt_ytd_prim_g paid_invoice_amt_ytd_prim_g,
   b.paid_invoice_amt_wtd_sec_g paid_invoice_amt_wtd_sec_g,
   b.paid_invoice_amt_mtd_sec_g paid_invoice_amt_mtd_sec_g,
   b.paid_invoice_amt_qtd_sec_g paid_invoice_amt_qtd_sec_g,
   b.paid_invoice_amt_ytd_sec_g paid_invoice_amt_ytd_sec_g,
   b.paid_inv_count_wtd paid_inv_count_wtd,
   b.paid_inv_count_mtd paid_inv_count_mtd,
   b.paid_inv_count_qtd paid_inv_count_qtd,
   b.paid_inv_count_ytd paid_inv_count_ytd,
   b.payment_count_wtd,
   b.payment_count_mtd,
   b.payment_count_qtd,
   b.payment_count_ytd,
   b.paid_on_time_amt_b paid_on_time_amt_b,
   b.paid_on_time_amt_prim_g paid_on_time_amt_prim_g,
   b.paid_on_time_amt_sec_g paid_on_time_amt_sec_g,
   b.paid_late_amt_b paid_late_amt_b,
   b.paid_late_amt_prim_g paid_late_amt_prim_g,
   b.paid_late_amt_sec_g paid_late_amt_sec_g,
   b.paid_dis_offered_wtd_b paid_dis_offered_wtd_b,
   b.paid_dis_offered_mtd_b paid_dis_offered_mtd_b,
   b.paid_dis_offered_qtd_b paid_dis_offered_qtd_b,
   b.paid_dis_offered_ytd_b paid_dis_offered_ytd_b,
   b.paid_dis_offered_wtd_prim_g paid_dis_offered_wtd_prim_g,
   b.paid_dis_offered_mtd_prim_g paid_dis_offered_mtd_prim_g,
   b.paid_dis_offered_qtd_prim_g paid_dis_offered_qtd_prim_g,
   b.paid_dis_offered_ytd_prim_g paid_dis_offered_ytd_prim_g,
   b.paid_dis_offered_wtd_sec_g paid_dis_offered_wtd_sec_g,
   b.paid_dis_offered_mtd_sec_g paid_dis_offered_mtd_sec_g,
   b.paid_dis_offered_qtd_sec_g paid_dis_offered_qtd_sec_g,
   b.paid_dis_offered_ytd_sec_g paid_dis_offered_ytd_sec_g,
   b.paid_dis_taken_b paid_dis_taken_b,
   b.paid_dis_taken_prim_g paid_dis_taken_prim_g,
   b.paid_dis_taken_sec_g paid_dis_taken_sec_g,
   b.invoice_to_payment_days invoice_to_payment_days,
   0 paid_on_time_count_wtd,
   0 paid_on_time_count_mtd,
   0 paid_on_time_count_qtd,
   0 paid_on_time_count_ytd,
   0 paid_late_count_wtd,
   0 paid_late_count_mtd,
   0 paid_late_count_qtd,
   0 paid_late_count_ytd
FROM fii_ap_paid_xb_mv b
WHERE b.gid = 4
UNION ALL
SELECT
   c.org_id,
   c.time_id,
   c.period_type_id,
   0 invoice_count_entered,
   0 e_invoice_count,
   0 paid_amt_b,
   0 paid_amt_prim_g,
   0 paid_amt_sec_g,
   0 paid_invoice_amt_wtd_b,
   0 paid_invoice_amt_mtd_b,
   0 paid_invoice_amt_qtd_b,
   0 paid_invoice_amt_ytd_b,
   0 paid_invoice_amt_wtd_prim_g,
   0 paid_invoice_amt_mtd_prim_g,
   0 paid_invoice_amt_qtd_prim_g,
   0 paid_invoice_amt_ytd_prim_g,
   0 paid_invoice_amt_wtd_sec_g,
   0 paid_invoice_amt_mtd_sec_g,
   0 paid_invoice_amt_qtd_sec_g,
   0 paid_invoice_amt_ytd_sec_g,
   0 paid_inv_count_wtd,
   0 paid_inv_count_mtd,
   0 paid_inv_count_qtd,
   0 paid_inv_count_ytd,
   0 payment_count_wtd,
   0 payment_count_mtd,
   0 payment_count_qtd,
   0 payment_count_ytd,
   0 paid_on_time_amt_b,
   0 paid_on_time_amt_prim_g,
   0 paid_on_time_amt_sec_g,
   0 paid_late_amt_b,
   0 paid_late_amt_prim_g,
   0 paid_late_amt_sec_g,
   0 paid_dis_offered_wtd_b,
   0 paid_dis_offered_mtd_b,
   0 paid_dis_offered_qtd_b,
   0 paid_dis_offered_ytd_b,
   0 paid_dis_offered_wtd_prim_g,
   0 paid_dis_offered_mtd_prim_g,
   0 paid_dis_offered_qtd_prim_g,
   0 paid_dis_offered_ytd_prim_g,
   0 paid_dis_offered_wtd_sec_g,
   0 paid_dis_offered_mtd_sec_g,
   0 paid_dis_offered_qtd_sec_g,
   0 paid_dis_offered_ytd_sec_g,
   0 paid_dis_taken_b,
   0 paid_dis_taken_prim_g,
   0 paid_dis_taken_sec_g,
   0 invoice_to_payment_days,
   c.paid_on_time_count_wtd paid_on_time_count_wtd,
   c.paid_on_time_count_mtd paid_on_time_count_mtd,
   c.paid_on_time_count_qtd paid_on_time_count_qtd,
   c.paid_on_time_count_ytd paid_on_time_count_ytd,
   c.paid_late_count_wtd paid_late_count_wtd,
   c.paid_late_count_mtd paid_late_count_mtd,
   c.paid_late_count_qtd paid_late_count_qtd,
   c.paid_late_count_ytd paid_late_count_ytd
FROM FII_AP_PAYOL_XB_MV c
WHERE c.gid = 4
) f
group by f.org_id, f.time_id, f.period_type_id