AP Check Payments to Suppliers (2)

SELECT 
	APC.bank_account_name bank_account_name
	,APC.check_number ||'/'||&GC_ATTRIBUTE_COL check_number
	,APC.check_date check_date
	,APC.future_pay_due_date due_date
	,APC.amount amount
	,APC.vendor_name vendor_name
	,APLC.displayed_field status
	,APC.cleared_date cleared_date
	,APC.cleared_amount cleared_amount
	,SUM(APC.amount) over () general_total
	,SYSDATE+ROUND((SUM((APC.future_pay_due_date-SYSDATE)
	 *APC.amount) over ())/(SUM(APC.amount) 
	 over ())  ) avg_mat_date	
FROM ap_checks  APC
     ,ap_lookup_codes APLC
	 ,ap_suppliers    APS
WHERE &GC_WHERE
AND APC.future_pay_due_date IS NOT NULL
AND APC.payment_method_code = 'CHECK'
AND APLC.lookup_type='CHECK STATE'
AND APC.status_lookup_code = APLC.lookup_code
AND APC.vendor_id= APS.vendor_id(+)
ORDER BY APC.future_pay_due_date