select x.sl_no,x.regno,y.name,upper(y.address) address,Y.DOTE_REGNO,
decode (y.course,
'CIVIL', 'Diploma in Civil Engineering',
'DME','Diploma in Mechanical Engineering',
'EEE','Diploma in Electrical & Electronics Engineering',
'ECE' ,'Diploma in Electronics & Communication Engineering',
'CSE','Diploma in Computer Engineering') course,
y.current_sem current_sem,y.scheme,
x.sem,
--' '||x.particula
' '||DECODE (Y.CATEGORY,'SC',(DECODE(x.particulars,'SEM_FEE','MISC_FEE',X.PARTICULARS)),X.PARTICULARS) PARTICULARS,
x.bill_no,x.bill_date,
x.actual_fee,x.amount,x.balance,x.created_by,x.created_on,x.parity
from
tb_billing x,
tb_personal y
where x.regno = y.regno
AND X.bill_date = :Today_Receipt
--and x.bill_no = 14475
order by x.parity
Previous Article
