AP Batch Control Report by Entered By - draft

Description
Categories: BI Publisher, Financials, Procurement
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
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 NameSQL textValidation
Ledger
 
Entered Date To
 
Date
Entered Date From
 
Date