AP Batch Control Report by Batch Name - draft

Description
Categories: BI Publisher, Financials, Procurement
Application: Payables
Source: Batch Control Report by Batch Name (XML) - Not Supported: Reserved For Future Use
Short Name: APXBCOBN_XML
DB package: AP_APXBCOBN_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.last_updated_by = U.user_id
AND 	trunc (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 UPPER(B.batch_name), B.batch_date
Parameter Name SQL text Validation
Ledger
 
Entered Date To
 
Date
Entered Date From
 
Date