AP Batch Control Report by Entered By- Not Supported: Reserved For Future Use

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Batch Control Report by Entered By
Application: Payables
Source: Batch Control Report by Entered By (XML) - Not Supported: Reserved For Future Use
Short Name: APXBCOEB_XML
DB package: AP_APXBCOEB_XMLP_PKG
Run AP Batch Control Report by Entered By- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT 	B.batch_name C_BATCH_NAME, 
	B.batch_date C_BATCH_DATE, 
	U.user_name C_USER_NAME,
	nvl(B.invoice_currency_code, SP.base_currency_code)
	C_CURRENCY, 
	nvl(B.control_invoice_count, 0) C_CONTROL_COUNT, 
	count(*) C_INVOICE_COUNT,
	nvl(B.control_invoice_total, 0) C_CONTROL_TOTAL, 
                  	SUM(I.invoice_amount) C_INVOICE_TOTAL,  
	to_number(nvl(B.control_invoice_count, 0) - count(*) )
	C_VARIANCE_COUNT,
		to_number(nvl(B.control_invoice_total, 0)
	- SUM(I.invoice_amount))
	C_VARIANCE_TOTAL
FROM 	fnd_user_view U, ap_invoices I, ap_batches_all B, 
	ap_system_parameters SP
WHERE 	B.batch_id = I.batch_id
AND 	B.created_by = U.user_id
AND 	B.batch_date between :p_start_date and :p_end_date
GROUP BY B.batch_name, B.batch_date, U.user_name,
	 B.control_invoice_count, B.control_invoice_total,
	 nvl(B.invoice_currency_code, SP.base_currency_code)
ORDER BY  U.user_name, B.batch_date, UPPER(B.batch_name)
Parameter Name SQL text Validation
Operating Unit 
 
 LOV
Entered Date From 
 
 Date
Entered Date To 
 
 Date
Download
Related Blitz Reports
GL Account Analysis GL Account Analysis (Distributions) AP Batch Control Report by Batch Name- Not Supported: Reserved For Future Use FND Attached Documents CAC Invoice Price Variance AP Invoices and Lines INV Intercompany Invoice Reconciliation AP Cash Requirement - draft XXT OF: PO Headers and Lines
Blitz Report™

Blitz Report™ provides multiple benefits: