(SELECT min(seq_no)
from stcontractcoll
where contract_no=$P{contract_no} and coll_type='3' and item_status=1 )) as coll2,
(SELECT ft_getmbname(coop_id,member_no) from mbmembmaster where member_no=refcoll_no) as refname
from stcontractcoll
where contract_no=$P{contract_no} and coll_type='3' and item_status=1
and seq_no=(SELECT min(seq_no)
from stcontractcoll
where contract_no=$P{contract_no} and coll_type='3' and item_status=1 )
order by coll_code]]>