AP Batch Control Report by Batch Name- Not Supported: Reserved For Future Use
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Batch Control Report by Batch Name
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
Description: Batch Control Report by Batch Name
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
Run
AP Batch Control Report by Batch Name- 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.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 | |
---|---|---|---|
Operating Unit |
|
LOV | |
Entered Date From |
|
Date | |
Entered Date To |
|
Date |