select * from XMBL_EM_DBBACK where f_djbh='DB01201612270013'

select * from flow_task_list where biz_djbh='DB01201612270015' order by op_time desc

select * from SYS_OBJECTs where obj_id= 'YKT_ZZJG';

 

select * from sys_objects where obj_id='PX_CJBT_HH'

select * from sys_objcols where obj_id='PX_CJBT_HH';

SELECT * FROM PX_DJLX;

select * from sys_objects where obj_id='TEST111 '

select * from sys_objcols;

select * from sys_model A WHERE MDL_ID LIKE '%CJGL%';

select * from px_cjbt_hh;

select * from PX_CJBT_HH ;

SELECT * FROM SYS_MDL_BH_MOM_CJGL_HH 查询单据编号生成规则表的编号

 

 select * from TESTZYPX_9999.SYS_MDL_VAL where MDL_ID='MOM_CJGL_HH ';

select * from flow_status_list for update 查询当前的流程状态

delete from flow_status_list where flow_id='PX_CJGL'