AR Automatic Receipt Batch Management

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