AR Query for Disc 10g

Hi,

We have moved from 11 to R12 and I require to create a query in Disc 10g. Can someone help me with a query which will list me an "Amount Remaining" for all customers, which includes even receipts and all permutations & combinations. Basically in one go a user using this report should be able to view the true amount remaining for a customer. The query should satisfy all permutations & combinations.

I do know AR Payment schedule table and cash receipts table, others I am not aware and how to combine all to get the true/actual amount remainingfor all customers.