1 2 3 4 5 6 7 8 9 10 11 12 13 14 | e.g: CREATE OR REPLACE VIEW V_WF_TODOLIST AS select c.process_def_id, c.process_def_name, a.action_def_id, a.work_item_id, a.bae007, a.action_def_name, a.state, a.pre_wi_id, a.work_type, a.operid, a.x_oprator_ids, b.process_key_info, to_char(to_date(a.start_time, 'yyyymmddhh24miss'),'yyyy-mm-dd hh24:mi:ss') as start_time, to_char(to_date(a.complete_time,'yyyymmddhh24miss'),'yyyy-mm-dd hh24:mi:ss') as complete_time, a.filter_opr, a.memo,a.bae002,a.bae003, a.bae006,c.x_action_def_ids from wf_work_item a, wf_process_instance b, wf_action_def c where a.action_def_id = c.action_def_id and b.process_def_id = c.process_def_id and a.bae007 = b.bae007 and a.state in('0','2') |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | CREATE OR REPLACE VIEW V_WF_TODOLIST AS select c.process_def_id, c.process_def_name, a.action_def_id, a.work_item_id, a.bae007, a.action_def_name, a.state, a.pre_wi_id, a.work_type, a.operid, a.x_oprator_ids, b.process_key_info, to_char(to_date(a.start_time, 'yyyymmddhh24miss'),'yyyy-mm-dd hh24:mi:ss') as start_time_0, to_char(to_date(a.complete_time,'yyyymmddhh24miss'),'yyyy-mm-dd hh24:mi:ss') as complete_time_0, a.filter_opr, a.memo,a.bae002,a.bae003, a.bae006,c.x_action_def_ids from wf_work_item a, wf_process_instance b, wf_action_def c where a.action_def_id = c.action_def_id and b.process_def_id = c.process_def_id and a.bae007 = b.bae007 and a.state in('0','2') |
1 2 3 4 5 6 7 8 9 10 | CREATE OR REPLACE VIEW V_FW_BLANK_BULLETIN as select id, bae001, operunitid, operunittype, unitsubtype, ifergency, title, content, digest, duetime, validto, aae100, bae006, bae002, bae003, id as colid, substr(digest,1,20) as digest2 from fw_bulletin where duetime <= to_char(sysdate,'yyyymmddhh24miss') and (to_char(validto) >= to_char(sysdate,'yyyymmddhh24miss') or validto is null) and aae100 ='1' order by ifergency desc, id desc, duetime desc |
1 2 3 4 5 6 7 8 9 10 11 12 | CREATE OR REPLACE VIEW V_FW_BLANK_BULLETIN as select * from (select id, bae001, operunitid, operunittype, unitsubtype, ifergency, title, content, digest, duetime, validto, aae100, bae006, bae002, bae003, id as colid, substr(digest,1,20) as digest2 from fw_bulletin where duetime <= to_char(sysdate,'yyyymmddhh24miss') and (to_char(validto) >= to_char(sysdate,'yyyymmddhh24miss') or validto is null) and aae100 ='1' order by ifergency desc, id desc, duetime desc) |
欢迎光临 度量快速开发平台-专业、快速的软件定制快开平台 (http://p.delit.cn/) | Powered by Discuz! X3.2 |