[load_grdList]
SELECT 
	m.den_no as den_no,
	m.hasei_ymd as hasei_ymd,
	(case
		when ':hasei_ymd_fr'||':hasei_ymd_to' = ''
		then '指定なし'
		else substr(':hasei_ymd_fr', 1, 4) || '年' || substr(':hasei_ymd_fr', 5, 2)|| '月' || substr(':hasei_ymd_fr', 7, 2) || '日'||'　〜　'|| substr(':hasei_ymd_to', 1, 4) || '年' || substr(':hasei_ymd_to', 5, 2)|| '月'|| substr(':hasei_ymd_to', 7, 2) || '日'  
	end) as hasei_ymd_s,
	sagyo_den_no as sagyo_den_no,
	tok_cd,
	tok_nm as tok_nm,
	hin_no,
	f1.han_name as hin_no_nm,
--	clr_cd,
	m.clr_cd ||m.clr_nm as clr_cd,
	clr_nm,
	size,
	f2.han_name as size_nm,
	disc_kbn,
	f3.han_name as disc_kbn_nm,
	furyo_kbn,
	f4.han_name as furyo_kbn_nm,
	furyo_uti_kbn,
	f5.han_name as furyo_uti_kbn_nm,
	furyo_syo_kbn,
	f6.han_name as furyo_syo_kbn_nm,
	furyo_pls as furyo_pls,
	sag_tan_cd,
	tt.tan_nm as sagyo_nm,
	furyo_res_cd,
	furyo_res as furyo_res,
	res_dtl as res_dtl,
	biko as biko,
	t.tan_cd,
	t.tan_nm as tan_nm,
	m.del_flg,
	m.cre_id,
	m.cre_time,
	m.upd_id,
	m.upd_time
FROM t_furyo m
LEFT JOIN m_tanto t ON (m.cre_id =  t.tan_cd)
LEFT JOIN m_tanto tt ON (m.sag_tan_cd =  tt.tan_cd)
LEFT JOIN v_hanyo_all f1 ON (m.hin_no = f1.han_cd and f1.mst_kbn = '21R')
LEFT JOIN v_hanyo_all f2 ON (m.size = f2.han_cd and f2.mst_kbn = '20')
LEFT JOIN v_hanyo_all f3 ON (m.disc_kbn = f3.han_cd and f3.mst_kbn = '15')
LEFT JOIN v_hanyo_all f4 ON (m.furyo_kbn = f4.han_cd and f4.mst_kbn = '13')
LEFT JOIN v_hanyo_all f5 ON (m.furyo_kbn = f5.koumoku1 and m.furyo_uti_kbn = f5.koumoku2 and f5.mst_kbn = '27')
LEFT JOIN v_hanyo_all f6 ON (m.furyo_syo_kbn = f6.han_cd and f6.mst_kbn = '28')
WHERE 1 = 1
AND ((m.den_no = fnc_to_number(':den_no')) or ('' = ':den_no'))
AND ((m.sagyo_den_no = fnc_to_number(':sagyo_den_no')) or ('' = ':sagyo_den_no'))
AND (('' = ':hasei_ymd_fr') or (m.hasei_ymd >= ':hasei_ymd_fr'))
AND (('' = ':hasei_ymd_to') or (m.hasei_ymd <= ':hasei_ymd_to'))
AND ((m.tok_cd = ':tok_cd') or (':tok_cd' = ''))
AND ((m.cre_id = ':tan_cd') or (':tan_cd' = ''))
--AND ((t.tan_cd like '%:tan_cd%') or (':tan_cd' = ''))
AND ((m.hin_no = ':hin_no') or (':hin_no' = ''))
AND ((m.clr_cd = ':clr_cd') or (':clr_cd' = ''))
AND ((m.size = ':size') or (':size' = ''))
AND ((m.disc_kbn = ':disc_kbn') or (':disc_kbn' = ''))
AND ((m.furyo_kbn = ':furyo_kbn') or (':furyo_kbn' = ''))
AND ((m.furyo_uti_kbn = ':furyo_uti_kbn') or (':furyo_uti_kbn' = ''))
AND ((m.furyo_syo_kbn = ':furyo_syo_kbn') or (':furyo_syo_kbn' = ''))
AND ((m.furyo_pls like '%:furyo_pls%') or ('' = ':furyo_pls'))
AND ((m.sag_tan_cd = ':sag_tan_cd') or ('' = ':sag_tan_cd'))
AND ((m.furyo_res_cd = ':furyo_res_cd') or (':furyo_res_cd' = ''))
AND ((m.res_dtl like '%:res_dtl%') or ('' = ':res_dtl'))
AND ((m.biko like '%:biko%') or ('' = ':biko'))
AND (m.del_flg = 0)
order by den_no desc,hasei_ymd desc
--order by :order
[selectRecords]
SELECT
	m.den_no,
	m.furyo_kbn,
	f4.han_name as furyo_kbn_nm,
	m.furyo_uti_kbn,
	f5.han_name as furyo_uti_kbn_nm,
	m.furyo_syo_kbn,
	f6.han_name as furyo_syo_kbn_nm,
	to_char(to_date(m.hasei_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as hasei_ymd,
	(case
		when '&2'||'&3' = ''
		then '指定なし'
		else substr('&2', 1, 4) || '年' || substr('&2', 5, 2)|| substr('&2', 7, 2) || '日'||'　〜　'|| substr('&3', 1, 4) || '年' || substr('&3', 5, 2)|| substr('&3', 7, 2) || '日' 
	end) as hasei_ymd_s,
	m.sagyo_den_no,
	m.tok_cd,
	m.tok_nm,
	t.tan_cd,
	t.tan_nm,
	m.disc_kbn,
	f3.han_name as disc_kbn_nm,
	m.hin_no as hin_no,
	f1.han_name as hin_no_nm,
	m.clr_cd as clr_cd,
	m.clr_nm,
	m.size,
	f2.han_name as size_nm,
	m.furyo_pls,
	m.sag_tan_cd as sag_tan_cd,
	tt.tan_nm as sagyo_nm,
	m.furyo_res_cd,
	m.furyo_res as furyo_res,
	m.res_dtl as res_dtl,
	m.biko as biko,
	m.del_flg,
	m.cre_id,
	m.cre_time,
	m.upd_id,
	m.upd_time
FROM t_furyo m
LEFT JOIN m_tanto t ON (m.cre_id =  t.tan_cd)
LEFT JOIN m_tanto tt ON (m.sag_tan_cd =  tt.tan_cd)
LEFT JOIN v_hanyo_all f1 ON (m.hin_no = f1.han_cd and f1.mst_kbn = '21R')
LEFT JOIN v_hanyo_all f2 ON (m.size = f2.han_cd and f2.mst_kbn = '20')
LEFT JOIN v_hanyo_all f3 ON (m.disc_kbn = f3.han_cd and f3.mst_kbn = '15')
LEFT JOIN v_hanyo_all f4 ON (m.furyo_kbn = f4.han_cd and f4.mst_kbn = '13')
LEFT JOIN v_hanyo_all f5 ON (m.furyo_kbn = f5.koumoku1 and m.furyo_uti_kbn = f5.koumoku2 and f5.mst_kbn = '27')
LEFT JOIN v_hanyo_all f6 ON (m.furyo_syo_kbn = f6.han_cd and f6.mst_kbn = '28')
WHERE 1 = 1
AND ((m.den_no = fnc_to_number('&1')) or ('' = '&1'))
AND (('' = '&2') or (m.hasei_ymd >= '&2'))
AND (('' = '&3') or (m.hasei_ymd <= '&3'))
AND ((m.sagyo_den_no = fnc_to_number('&4')) or ('' = '&4'))
AND ((t.tan_cd = '&5') or ('&5' = ''))
AND ((m.tok_cd = '&6') or ('&6' = ''))
--AND ((m.tok_nm = '&7') or ('&7' = ''))
AND ((m.hin_no = '&8') or ('&8' = ''))
AND ((m.clr_cd = '&9') or ('&9' = ''))
--AND ((m.clr_nm = '&10') or ('&10' = ''))
AND ((m.size = '&11') or ('&11' = ''))
AND ((m.disc_kbn = '&12') or ('&12' = ''))
AND ((m.furyo_kbn = '&13') or ('&13' = ''))
AND ((m.furyo_pls like '%&14%') or ('' = '&14'))
AND ((m.sag_tan_cd = '&15') or ('' = '&15'))
AND ((m.furyo_res_cd = '&16') or ('&16' = ''))
--AND ((m.furyo_res = '&17') or ('&17' = ''))
AND ((m.res_dtl like '%&18%') or ('' = '&18'))
AND ((m.biko like '%&19%') or ('' = '&19'))
AND ((m.furyo_uti_kbn like '%&20%') or ('' = '&20'))
AND ((m.furyo_syo_kbn like '%&21%') or ('' = '&21'))
AND (m.del_flg = 0)
order by den_no desc,hasei_ymd desc