get open bills that are <30, 30-60, 60-90, > 90 delinquent based on 2 dates

[gandolf989]

Use a CASE function to classify the bills, check it out in the fine Oracle® Database SQL Language Reference.

You should be able to select from a view within Forms 6i. So you need to get the query working as a view and select from the view.