--自定义报表查询
alter table UR_ARPT_UD add IS_SHOW_DETAIL varchar2(1) default '1';

--按钮
Insert into ur_sys_res
   (lang_type, mod_id, res_id, res_type, seq_no, org_name, disp_name, mark)
 select  'chi', mod_id, 'BTN_RETURN_SELECT', 'B', 895, '退回所选卡片', '退回所选卡片', '退回所选卡片'
 from ur_sys_menu m where mod_code='SYS_DATA_INPUT'
   and not exists (select * from ur_sys_res r where r.mod_id=m.mod_id and res_id='BTN_RETURN_SELECT');
 
Insert into ur_sys_res
   (lang_type, mod_id, res_id, res_type, seq_no, org_name, disp_name, mark)
 select  'chi', mod_id, 'BTN_RETURN_FOR_NEW', 'B', 897, '退回(仅允许新增卡片)', '退回(仅允许新增卡片)', '退回(仅允许新增卡片)'
 from ur_sys_menu m where mod_code='SYS_DATA_INPUT'
   and not exists (select * from ur_sys_res r where r.mod_id=m.mod_id and res_id='BTN_RETURN_FOR_NEW');
