******************/

SELECT  ab.org_id,
        ab.name,
        ab.batch_applied_status ,
        ab.batch_date,
        count(*)
FROM AR_PAYMENT_SCHEDULES_ALL aps,  ar_batches_all ab
WHERE 1=1
 —-   uncomment this optional clause for faster response
 —-   and to_char(ab.batch_date,’DD-MON-YYYY’) >= ‘01-JAN-2008′
AND ab.batch_applied_status NOT IN ( ‘COMPLETED_APPROVAL’,‘PROCESSED’,‘COMPLETED_FORMAT’)
AND ab.type=‘CREATION’
AND aps.selected_for_receipt_batch_id = ab.batch_id
GROUP BY ab.org_id,ab.name,ab.batch_applied_status,ab.batch_date;