[selectRecords]
select
	'1' as kbn, 
	case t.cat_cd
	when '1' then
	case uh.tok_tan
	when '' then '御中'
	else ''
	end
	when '2' then '様'
	else '御中'
	end as keisyou,
	case uh.tok_tan
	when '' then ''
	else '様'
	end as keisyou2,
	uh.den_no,
	(1+um.row_no) as row_no,
	trunc((row_no)/15) as row_page,
	(trunc((row_no)/15)+1) as page1,
	sm2.pege_m,
	(trunc((row_no)/15)+1)||'/'||sm2.pege_m as page_c,
	to_char(to_date(uh.input_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as input_ymd,
	case uh.syori_ymd
	when '' then ''
	else to_char(to_date(uh.syori_ymd, 'YYYYMMDD'), 'yyyy/mm/dd')
	end as syori_ymd,
	uh.zeinuki_gaku,
	uh.zei_gaku,
	uh.tok_tan,
	uh.zeikomi_gaku,
	uh.biko1 as u_biko1,
	uh.biko1 as u_biko1,
	um.hin_cd,
	replace(um.hin_nm,chr(10),'')as hin_nm,
	um.tok_hacyu_no,
	--um.suryo,
	case uh.jucyu_flg
	when '0' then um.kei_suryo
	else um.kei_jucyu_su
	end as suryo,
	um.tanka,
	um.kingaku,
	--case uh.jucyu_flg
	--when '1' then um.kingaku
	--else um.zeinuki_gaku
	--end as kingaku,
	case um.nonyu_ymd
	when '' then ''
	else to_char(to_date(um.nonyu_ymd, 'YYYYMMDD'), 'yyyy/mm/dd')
	end as nonyu_ymd,
	uh.tok_cd,
	uh.nonyu_nm as n_tok_nm,
	t.tok_nm,
	'〒'||substr(replace(t.zip_no,'-',''),1,3)||'-'||substr(replace(t.zip_no,'-',''),4,6) as yubin_no, 
	'〒'||substr(replace(uh.nonyu_zip_no,'-',''),1,3)||'-'||substr(replace(uh.nonyu_zip_no,'-',''),4,6) as n_yubin_no, 
	--'〒'||substr(replace(t.zip_no,'-',''),1,3)||'-'||substr(replace(t.zip_no,'-',''),4,6) as yubin_no,
	--'〒'||substr(replace(uh.nonyu_zip_no,'-',''),1,3)||'-'||substr(replace(uh.nonyu_zip_no,'-',''),4,6) as yubin_no, -- :取得元修正　2017.12.26 KSP K.takahashi
	coalesce(cast(um.jucyu_no as varchar(10)),'')||'-'|| coalesce (cast(um.row_no as varchar(10)),'') as jucyu_row_no,
	t.addr1,
	t.addr2,
	t.addr3,
	t.addr4,
	--uh.nonyu_addr1 as addr1,
	--uh.nonyu_addr2 as addr2,
	--uh.nonyu_addr3 as addr3,
	--uh.nonyu_addr4 as addr4,
	coalesce(t.addr3,'')||coalesce(t.addr4,'') as addr3_4,
	--coalesce(uh.nonyu_addr3,'')||coalesce(uh.nonyu_addr4,'') as n_addr3_4,
	t.tori_cond,
	t.biko1,
	t.biko2,
	t.biko3,
	t.biko4,
	uh.nonyu_tel_no as n_tel_no,
	t.tel_no as tel_no, --t.tel_no, :取得元修正　2017.12.26 KSP K.takahashi 
	uh.nonyu_nm,
	'〒'||substr(replace(nonyu_zip_no,'-',''),1,3)||'-'||substr(replace(nonyu_zip_no,'-',''),4,6) as nonyu_yubin_no,
	uh.nonyu_addr1,
	uh.nonyu_addr2,
	uh.nonyu_addr3,
	uh.nonyu_addr4,
	uh.nonyu_tan,
	tan.tan_nm,
	coalesce(t.cat_cd,'1') as tok_dm,
	h.tani as tan,
	h.bante as bante,
	um.tani_suryo as havy,
	--2017.09.30 KSP K.Takahashi 項目変更 kosu →　suryo
	--um.kosu as ryou,
	--um.suryo as ryou,
	case uh.jucyu_flg
	when '0' then um.suryo
	else um.jucyu_su
	end as ryou,
	um.bante as bante,
	um.htanka as teika,
	um.meisai_biko as biko_m
	, j.mst_kbn
	, j.han_cd
	, j.han_name
	, j.koumoku1
	, j.koumoku2
	, j.koumoku3
	, j.koumoku4
	, j.koumoku5
	, j.koumoku6
	, j.koumoku7
	, j.koumoku8
	, j.koumoku9
from t_uri uh
left join m_tanto tan on(uh.tan_cd = tan.tan_cd)
left join m_tokui t on(uh.tok_cd = t.tok_cd)
left join t_uri_m um on(uh.den_no = um.den_no)
left join m_hin h on(um.hin_cd = h.hin_cd)
left join m_hanyo j on (j.mst_kbn='90' and j.han_cd='jisya')
left join (select um2.den_no,max(trunc((row_no)/15)+1) as pege_m from t_uri_m um2 group by um2.den_no) sm2 on sm2.den_no = uh.den_no
where 1 = 1
and uh.jucyu_flg = 0
and uh.del_flg = 0
and ((uh.syori_ymd >= '&1') or ('&1' = ''))
and ((uh.syori_ymd <= '&2') or ('&2' = ''))
and ((cast(uh.den_no as char(6)) = '&3') or ('&3' = ''))
and ((uh.tok_cd = '&4') or ('&4' = ''))
and ((um.hin_nm like '%&5%') or ('&5' = ''))
union all select
	'2' as kbn, 
	case t.cat_cd
	when '1' then
	case uh.tok_tan
	when '' then '御中'
	else ''
	end
	when '2' then '様'
	else '御中'
	end as keisyou,
	case uh.tok_tan
	when '' then ''
	else '様'
	end as keisyou2,
	uh.den_no,
	(1+um.row_no) as row_no,
	trunc((row_no)/15) as row_page,
	(trunc((row_no)/15)+1) as page1,
	sm2.pege_m,
	(trunc((row_no)/15)+1)||'/'||sm2.pege_m as page_c,
	to_char(to_date(uh.input_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as input_ymd,
	case uh.syori_ymd
	when '' then ''
	else to_char(to_date(uh.syori_ymd, 'YYYYMMDD'), 'yyyy/mm/dd')
	end as syori_ymd,
	uh.zeinuki_gaku,
	uh.zei_gaku,
	uh.tok_tan,
	uh.zeikomi_gaku,
	uh.biko1 as u_biko1,
	uh.biko1 as u_biko1,
	um.hin_cd,
	replace(um.hin_nm,chr(10),'')as hin_nm,
	um.tok_hacyu_no,
	--um.suryo,
	case uh.jucyu_flg
	when '0' then um.kei_suryo
	else um.kei_jucyu_su
	end as suryo,
	um.tanka,
	um.kingaku,
	--case uh.jucyu_flg
	--when '1' then um.kingaku
	--else um.zeinuki_gaku
	--end as kingaku,
	case um.nonyu_ymd
	when '' then ''
	else to_char(to_date(um.nonyu_ymd, 'YYYYMMDD'), 'yyyy/mm/dd')
	end as nonyu_ymd,
	uh.tok_cd,
	uh.nonyu_nm as n_tok_nm,
	t.tok_nm,
	'〒'||substr(replace(t.zip_no,'-',''),1,3)||'-'||substr(replace(t.zip_no,'-',''),4,6) as yubin_no, 
	'〒'||substr(replace(uh.nonyu_zip_no,'-',''),1,3)||'-'||substr(replace(uh.nonyu_zip_no,'-',''),4,6) as n_yubin_no, 
	--'〒'||substr(replace(t.zip_no,'-',''),1,3)||'-'||substr(replace(t.zip_no,'-',''),4,6) as yubin_no,
	--'〒'||substr(replace(uh.nonyu_zip_no,'-',''),1,3)||'-'||substr(replace(uh.nonyu_zip_no,'-',''),4,6) as yubin_no, -- :取得元修正　2017.12.26 KSP K.takahashi
	coalesce(cast(um.jucyu_no as varchar(10)),'')||'-'|| coalesce (cast(um.row_no as varchar(10)),'') as jucyu_row_no,
	t.addr1,
	t.addr2,
	t.addr3,
	t.addr4,
	--uh.nonyu_addr1 as addr1,
	--uh.nonyu_addr2 as addr2,
	--uh.nonyu_addr3 as addr3,
	--uh.nonyu_addr4 as addr4,
	coalesce(t.addr3,'')||coalesce(t.addr4,'') as addr3_4,
	--coalesce(uh.nonyu_addr3,'')||coalesce(uh.nonyu_addr4,'') as n_addr3_4,
	t.tori_cond,
	t.biko1,
	t.biko2,
	t.biko3,
	t.biko4,
	uh.nonyu_tel_no as n_tel_no,
	t.tel_no as tel_no,  --t.tel_no, :取得元修正　2017.12.26 KSP K.takahashi 
	uh.nonyu_nm,
	'〒'||substr(nonyu_zip_no,1,3)||'-'||substr(nonyu_zip_no,4,7) as nonyu_yubin_no,
	uh.nonyu_addr1,
	uh.nonyu_addr2,
	uh.nonyu_addr3,
	uh.nonyu_addr4,
	uh.nonyu_tan,
	tan.tan_nm,
	coalesce(t.cat_cd,'1') as tok_dm,
	h.tani as tan,
	h.bante as bante,
	um.tani_suryo as havy,
	--2017.09.30 KSP K.Takahashi 項目変更 kosu →　suryo
	--um.kosu as ryou,
	case uh.jucyu_flg
	when '0' then um.suryo
	else um.jucyu_su
	end as ryou,
	um.bante as bante,
	um.htanka as teika,
	um.meisai_biko as biko_m
	, j.mst_kbn
	, j.han_cd
	, j.han_name
	, j.koumoku1
	, j.koumoku2
	, j.koumoku3
	, j.koumoku4
	, j.koumoku5
	, j.koumoku6
	, j.koumoku7
	, j.koumoku8
	, j.koumoku9
from t_uri uh
left join m_tanto tan on(uh.tan_cd = tan.tan_cd)
left join m_tokui t on(uh.tok_cd = t.tok_cd)
left join t_uri_m um on(uh.den_no = um.den_no)
left join m_hin h on(um.hin_cd = h.hin_cd)
left join m_hanyo j on (j.mst_kbn='90' and j.han_cd='jisya')
left join (select um2.den_no,max(trunc((row_no)/15)+1) as pege_m from t_uri_m um2 group by um2.den_no) sm2 on sm2.den_no = uh.den_no
where 1 = 1
and uh.jucyu_flg = 0
and uh.del_flg = 0
and ((uh.syori_ymd >= '&1') or ('&1' = ''))
and ((uh.syori_ymd <= '&2') or ('&2' = ''))
and ((cast(uh.den_no as char(6)) = '&3') or ('&3' = ''))
and ((uh.tok_cd = '&4') or ('&4' = ''))
and ((um.hin_nm like '%&5%') or ('&5' = ''))
order by den_no,kbn,row_no;