AP Check Payments to Suppliers

➜ Back to Library
Description
Categories: BI Publisher
Application: Payables
Source: AP Check Payments to Suppliers
Short Name: APCHECKPAYSUPRPT
DB package: AP_CHECK_PAYMT_SUPP_RPT_PKG
Run AP Check Payments to Suppliers and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Vendor Number From 
 
 LOV Oracle
Vendor Number To 
 
 LOV Oracle
From Check Date 
 
 Date
To Check Date 
 
 Date
From Check Due Date 
 
 Date
To Check Due Date 
 
 Date
Check Currency 
 
 LOV Oracle
Check Status 
 
 LOV Oracle
Download
Related Blitz Reports
AP Withholding Tax by Invoice IGI CIS2007 Subcontractor Verification Status IGI CIS2007 Registered Supplier Listing AP Invoices and Lines AP Supplier Statement JA Third Party Detail Trial Balance with Contra Accounts JE Israeli Withholding Tax Summary/Detail AP Invoice History Report- Not Supported: Reserved For Future Use JE Polish Supplier Statement- Not Supported: Reserved For Future Use
Blitz Report™

Blitz Report™ provides multiple benefits: