[selectRecords]
select
  um.den_no
, um.row_no
--, um.hin_cd
, um.hin_nm
, COALESCE(um.jucyu_su,0) - COALESCE(um.uri_su,0) as jucyu_zan
, '��' || um.jucyu_su as jucyu_su
, um.tanka
, um.nonyu_ymd
, uh.tok_nm
, um.tok_hacyu_no
, hin.hin_cd as chin_cd
, hin.hin_nm as chin_nm
, hin.tanka as ctanka
, mset.set_su as set_su
, round(hin.tanka * mset.set_su) as kingaku
from w_basr0110 w 
inner join t_uri uh on w.den_no = uh.den_no
inner join t_uri_m um on (um.den_no = uh.den_no)
left join m_tokui tk on (uh.tok_cd = tk.tok_cd)
left join m_sethin mset on (um.hin_cd = mset.hin_cd)
left join m_hin hin on (mset.chin_cd = hin.hin_cd)
WHERE 1 = 1
and w.s_id = &1
;

[dele]
and uh.jucyu_flg = 1
and ((uh.den_no = fnc_to_number('&1')) or ('' = '&1'))
and (('' = '&2') or (uh.syori_ymd >= '&2'))
and (('' = '&3') or (uh.syori_ymd <= '&3'))
and (('' = '&4') or (um.nonyu_ymd >= '&4'))
and (('' = '&5') or (um.nonyu_ymd <= '&5'))
and (('' = '&6') or (uh.tok_cd = '&6'))
and ((uh.tok_nm like '%&7%') or ('' = '%&7%'))
and ((uh.biko1 like '%&8%' or uh.biko2 like '%&8%') or ('' = '&8'))
and (('' = '&9') or (COALESCE(um.jucyu_su,0) - COALESCE(um.uri_su,0) > 0))
order by um.nonyu_ymd, uh.syori_ymd, um.den_no, um.row_no