select distinct t1.cust_id, t1.cust_nm, t2.cont_id, t2.stat_id, (select min(bala_value) from cust_bala_info t3 where t3.cust_id=t2.cust_id and t3.cont_id=t2.cont_id and t3.stat_id=t2.stat_id and t3.acct_id=300) loan, decode(nvl((select min(bala_value) from cust_bala_info t3 where t3.cust_id=t2.cust_id and t3.cont_id=t2.cont_id and t3.stat_id=t2.stat_id and t3.acct_id=2300),0) ,0 ,(select min(bala_value) from cust_bala_info t3 where t3.cust_id=t2.cust_id and t3.cont_id=t2.cont_id and t3.stat_id=t2.stat_id and t3.acct_id=2381) ,(select min(bala_value) from cust_bala_info t3 where t3.cust_id=t2.cust_id and t3.cont_id=t2.cont_id and t3.stat_id=t2.stat_id and t3.acct_id=2300)) vehicles from cust_info t1,cust_bala_info t2 where t1.cust_id=t2.cust_id;
t1.cust_id,
t1.cust_nm,
t2.cont_id,
t2.stat_id,
(select min(bala_value) from cust_bala_info t3 where t3.cust_id=t2.cust_id and t3.cont_id=t2.cont_id and t3.stat_id=t2.stat_id and t3.acct_id=300) loan,
decode(nvl((select min(bala_value) from cust_bala_info t3 where t3.cust_id=t2.cust_id and t3.cont_id=t2.cont_id and t3.stat_id=t2.stat_id and t3.acct_id=2300),0)
,0
,(select min(bala_value) from cust_bala_info t3 where t3.cust_id=t2.cust_id and t3.cont_id=t2.cont_id and t3.stat_id=t2.stat_id and t3.acct_id=2381)
,(select min(bala_value) from cust_bala_info t3 where t3.cust_id=t2.cust_id and t3.cont_id=t2.cont_id and t3.stat_id=t2.stat_id and t3.acct_id=2300)) vehicles
from cust_info t1,cust_bala_info t2
where t1.cust_id=t2.cust_id;