Oracle Forms - Accounts Checklist

select '  '||name, regno,course, scheme ,current_sem,sl_no,bill_no,sem,bill_date,        '  '||particulars,
amount ,actual_fee,balance,cheque
from (
select y.name name,x.bill_date,x.bill_no, x.sem,
rank() over (partition by x.bill_date order by x.bill_no) as sl_no,
x.particulars,x.amount,x.regno,
y.course,
x.cheque cheque,
decode (y.current_sem,'I','I','II','I','III','II','IV','II','V','III','VI','III')  current_sem,
y.scheme,
X.ACTUAL_FEE actual_fee,X.BALANCE balance
from tb_billing x, tb_personal y
where x.regno = y.regno (+)
and x.bill_date = :Enter_Bill_date
)
 order by bill_date desc,bill_no