AP Check Payments to Suppliers

Description
Categories: BI Publisher, Financials, Procurement
Application: Payables
Source: AP Check Payments to Suppliers
Short Name: APCHECKPAYSUPRPT
DB package: AP_CHECK_PAYMT_SUPP_RPT_PKG
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
Parameter Name SQL text Validation
Check Status
 
LOV Oracle
Check Currency
 
LOV Oracle
To Check Due Date
 
Date
From Check Due Date
 
Date
To Check Date
 
Date
From Check Date
 
Date
Vendor Number To
 
LOV Oracle
Vendor Number From
 
LOV Oracle
Ask a question