[load_grdList]
SELECT 
  uri.den_no
, uri.mitsumori_no
, uri.syori_ymd
, uri.tok_nm
--, h2.koumoku5 as furikikan_s
--, um.hin_nm
, uri.title1
, uri.nonyu_nm
, tan1.tan_nm as tan_nm
, tan2.tan_nm as sekkei_tan_nm
, tan3.tan_nm as eigyou_tan_nm
, um.row_no
, um.hin_nm
, um.meisai_biko
, um.jucyu_su
, um.tani
FROM t_uri uri
left join m_tokui tk on (uri.tok_cd = tk.tok_cd)
left join m_hanyo h1 on (h1.mst_kbn = '01' and h1.han_cd = uri.prc_sts)
left join m_tanto tan1 on (tan1.tan_cd = uri.tan_cd)
left join m_tanto tan2 on (tan2.tan_cd = uri.sekkei_tan_cd)
left join m_tanto tan3 on (tan3.tan_cd = uri.eigyou_tan_cd)
--left join t_uri_m um on (um.den_no = uri.den_no and um.row_no = 0)
left join t_uri_m um on (um.den_no = uri.den_no and um.orow_no is null)
left join t_uri_m um2 on (um2.den_no = uri.den_no and um2.orow_no is null and um2.hin_cd = '99')
left join
(select den_no
	, sum(uri_su) as gokei_uri_su
	, sum(jucyu_su) as gokei_jucyu_su
	from t_uri_m
	where orow_no is null
	group by den_no) as jucyu
on (uri.jucyu_no = jucyu.den_no)
left join m_hanyo h2 on (h2.mst_kbn = '09' and h2.han_cd = tk.furikikan)
WHERE 1 = 1
and um.orow_no is null
and um.hin_cd != '99'
and uri.del_flg = 0
and uri.mitsumori_flg = 1
and uri.syori_ymd != ''
--and ((uri.mitsumori_no like '%:mitsumori_no%') or ('' = ':mitsumori_no'))
and (upper(replace(replace(replace(uri.mitsumori_no,' ',''),'-',''),'　','')) LIKE upper(replace(replace(replace('%:mitsumori_no%',' ',''),'-',''),'　','')) or (':mitsumori_no' = ''))
and (('' = ':syori_ymd_fr') or (uri.syori_ymd >= ':syori_ymd_fr'))
and (('' = ':syori_ymd_to') or (uri.syori_ymd <= ':syori_ymd_to'))
--and (('' = ':prc_sts') or (uri.prc_sts = ':prc_sts'))
and (('' = ':tok_cd') or (uri.tok_cd = ':tok_cd'))
and (('' = ':tan_cd') or (uri.tan_cd = ':tan_cd'))
and (('' = ':sekkei_tan_cd') or (uri.sekkei_tan_cd = ':sekkei_tan_cd'))
and (('' = ':eigyou_tan_cd') or (uri.eigyou_tan_cd = ':eigyou_tan_cd'))
--ユニット名
and (upper(replace(replace(replace(um.meisai_biko,' ',''),'-',''),'　','')) LIKE upper(replace(replace(replace('%:meisai_biko%',' ',''),'-',''),'　','')) or (':meisai_biko' = ''))
--納入場所
and (upper(replace(replace(replace(uri.nonyu_nm,' ',''),'-',''),'　','')) LIKE upper(replace(replace(replace('%:nonyu_nm%',' ',''),'-',''),'　','')) or (':nonyu_nm' = ''))
--and ((um.hin_nm like '%:hin_nm%') or ('' = ':hin_nm'))
and (upper(replace(replace(replace(um.hin_nm,' ',''),'-',''),'　','')) LIKE upper(replace(replace(replace('%:hin_nm%',' ',''),'-',''),'　','')) or (':hin_nm' = ''))
--and ((tk.tok_nm like '%:tok_nm%') or ('' = ':tok_nm'))
and (upper(replace(replace(replace(tk.tok_nm,' ',''),'-',''),'　','')) LIKE upper(replace(replace(replace('%:tok_nm%',' ',''),'-',''),'　','')) or (':tok_nm' = ''))
--and ((uri.title1 like '%:title1%') or ('' = ':title1'))
and (upper(replace(replace(replace(uri.title1,' ',''),'-',''),'　','')) LIKE upper(replace(replace(replace('%:title1%',' ',''),'-',''),'　','')) or (':title1' = ''))
--and ((uri.biko1 like '%:biko1%' or uri.biko2 like '%:biko1%') or ('' = ':biko1'))
and ((upper(replace(replace(replace(uri.biko1,' ',''),'-',''),'　','')) LIKE upper(replace(replace(replace('%:biko1%',' ',''),'-',''),'　','')) or upper(replace(replace(replace(uri.biko2,' ',''),'-',''),'　','')) LIKE upper(replace(replace(replace('%:biko2%',' ',''),'-',''),'　',''))) or (':biko1' = ''))
--and (upper(replace(replace(um.hin_nm,' ',''),'-','')) LIKE upper(replace(replace('%:hin_nm%',' ',''),'-','')) or (':hin_nm' = ''))
--and ((um.hosoku1 like '%:hosoku1%' or um.hosoku2 like '%:hosoku1%') or ('' = ':hosoku1'))
and ((upper(replace(replace(replace(um.hosoku1,' ',''),'-',''),'　','')) LIKE upper(replace(replace(replace('%:hosoku1%',' ',''),'-',''),'　','')) or upper(replace(replace(replace(um.hosoku2,' ',''),'-',''),'　','')) LIKE upper(replace(replace(replace('%:hosoku1%',' ',''),'-',''),'　',''))) or (':hosoku1' = ''))
--and ((uri.biko1 like '%:all_serch%' or uri.biko2 like '%:all_serch%' or um.hosoku1 like '%:all_serch%' or um.hosoku2 like '%:all_serch%' or um.hin_nm like '%:all_serch%' or uri.title1 like '%:all_serch%'or uri.title2 like '%:all_serch%') or ('' = ':all_serch')) 
and (upper(replace(replace(replace(uri.biko1,' ',''),'-',''),'　','')) LIKE upper(replace(replace(replace('%:all_serch%',' ',''),'-',''),'　',''))
or upper(replace(replace(replace(uri.biko2,' ',''),'-',''),'　','')) LIKE upper(replace(replace(replace('%:all_serch%',' ',''),'-',''),'　',''))
or upper(replace(replace(replace(uri.biko3,' ',''),'-',''),'　','')) LIKE upper(replace(replace(replace('%:all_serch%',' ',''),'-',''),'　',''))
or upper(replace(replace(replace(uri.biko4,' ',''),'-',''),'　','')) LIKE upper(replace(replace(replace('%:all_serch%',' ',''),'-',''),'　',''))
or upper(replace(replace(replace(uri.biko5,' ',''),'-',''),'　','')) LIKE upper(replace(replace(replace('%:all_serch%',' ',''),'-',''),'　',''))
or upper(replace(replace(replace(uri.biko6,' ',''),'-',''),'　','')) LIKE upper(replace(replace(replace('%:all_serch%',' ',''),'-',''),'　',''))
or upper(replace(replace(replace(uri.title1,' ',''),'-',''),'　','')) LIKE upper(replace(replace(replace('%:all_serch%',' ',''),'-',''),'　',''))
or upper(replace(replace(replace(uri.title2,' ',''),'-',''),'　','')) LIKE upper(replace(replace(replace('%:all_serch%',' ',''),'-',''),'　',''))
or upper(replace(replace(replace(um.hosoku1,' ',''),'-',''),'　','')) LIKE upper(replace(replace(replace('%:all_serch%',' ',''),'-',''),'　',''))
or upper(replace(replace(replace(um.hosoku2,' ',''),'-',''),'　','')) LIKE upper(replace(replace(replace('%:all_serch%',' ',''),'-',''),'　',''))
or upper(replace(replace(replace(tk.tok_nm,' ',''),'-',''),'　','')) LIKE upper(replace(replace(replace('%:all_serch%',' ',''),'-',''),'　',''))

or upper(replace(replace(replace(um.hin_nm,' ',''),'-',''),'　','')) LIKE upper(replace(replace(replace('%:all_serch%',' ',''),'-',''),'　',''))
or (':all_serch' = ''))

and ((':nk_cond' != '0') or (uri.keshi_flg = 0))
and ((':nk_cond' != '1') or (uri.keshi_flg = 1))
--and ((uri.den_no = fnc_to_number(':den_no')) or ('' = ':den_no'))
--and (('' = ':tori_kbn') or (tk.tok_cd is not null and tk.tori_kbn = ':tori_kbn'))

order by uri.syori_ymd desc, uri.den_no desc