Below is the link which is used for Payments Aging Report Sql Query:
http://windows7bugs.wordpress.com/2013/03/06/oracle-application-r12-7-buckets-supplier-aging-sql/
http://windows7bugs.wordpress.com/2013/03/06/oracle-application-r12-7-buckets-supplier-aging-sql/