Need help with the AR query: Need a SQL query to retreive receipt details by customers and transacti

Hello Gurus,

  I need help creating a sql query to retrieve customer wise receipt details with the count of the transaction numbers which are applied on that receipt, along with the applied amount and adjustments that are made on the receipts. We use oracle 11i , please help generating this as we have to provide this details to the auditors. I thank you very much in advance.

thanks,

Veena