AR Automatic Receipt Batch Management

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Automatic Receipt Batch Management Report
Application: Receivables
Source: Automatic Receipt Batch Management Report (XML)
Short Name: ARXAPRCB_XML
DB package: AR_ARXAPRCB_XMLP_PKG
Run AR Automatic Receipt Batch Management and other Oracle EBS reports with Blitz Report™ on our demo environment
select
           decode(batch.batch_applied_status,
                              'COMPLETED_CREATION', 1,
                              'COMPLETED_APPROVAL',2,
                              'STARTED_CREATION',       3,
                              'STARTED_APPROVAL',      4,
                              'STARTED_FORMAT',           5,
                              10)   status_order, 
           lc.meaning                              batch_status,
           batch.name                             batch_name,
           batch.batch_date                   batch_date,
           batch.media_reference          reference,
           mtd.name                                 pmt_method,
           batch.gl_date                          gl_date,
           batch.currency_code             currency_code_A,
           batch.batch_applied_status  batch_applied_status,
           batch.batch_id                         batch_id, 
	AR_ARXAPRCB_XMLP_PKG.amountformula(batch.batch_applied_status, batch.batch_id) amount, 
	batch.currency_code dummy_currency_code
from   ar_batches                 batch,
           ar_receipt_methods mtd,
           ar_lookups                 lc,
           ar_receipt_classes    class
where batch.batch_applied_status = 
                     nvl(:P_STATUS,  batch.batch_applied_status)
and     batch.batch_applied_status != 'COMPLETED_FORMAT'
and     batch.receipt_method_id      = mtd.receipt_method_id
and     batch.batch_applied_status = lc.lookup_code
and     lc.lookup_type                        = 'BATCH_APPLIED_STATUS'
and     batch.type                               = 'CREATION'
and     class.receipt_class_id           =  mtd.receipt_class_id
and     decode(batch.batch_applied_status,
                         'COMPLETED_APPROVAL', class.confirm_flag,
                         'Y') = 'Y'
order by
	8, 1, 2, 3, 4, 5, 6, 7
Parameter Name SQL text Validation
Operating Unit 
 
 LOV
Status 
 
 LOV Oracle
Download
Related Blitz Reports
AR Receipts Awaiting Bank Clearance AR Transactions Awaiting Consolidation AR Receipts Awaiting Remittance AR Bills Receivable Remittance Batch Management CE Cleared Transactions AR Remittance Batch Management AR Notes Receivable AR Reversed Notes Receivable AR Transactions and Lines
Blitz Report™

Blitz Report™ provides multiple benefits: