20160114  11:45:20  parameters :LoginId=186645 :Remark= 
/*  */

20160114  11:45:20  update XT_MKDLRZ set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS'),BZ0000=BZ0000||';'||:Remark where DLID00=:LoginId
/*  */

20160114  11:45:17  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:45:17  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:45:14  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:45:14  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:45:10  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:45:10  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:45:07  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:45:07  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:45:03  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:45:03  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:59  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:59  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:56  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:56  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:52  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:52  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:49  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:49  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:45  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:45  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:41  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:41  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:38  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:38  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:34  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:34  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:31  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:30  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:27  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:27  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:23  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:23  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:20  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:20  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:16  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:16  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:14   select ZYID00,(BQ_BRTZXX.JLRQ00 || ' ' || substr(BQ_BRTZXX.JLSJ00,0,5) ) JLRQSJ,JLRQ00,JLSJ00  ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4000',TZNR00,null)))  clm4000 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4001',TZNR00,null)))  clm4001 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4002',TZNR00,null)))  clm4002 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4003',TZNR00,null)))  clm4003 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4004',TZNR00,null)))  clm4004 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4005',TZNR00,null)))  clm4005 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4006',TZNR00,null)))  clm4006 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4007',TZNR00,null)))  clm4007 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4008',TZNR00,null)))  clm4008 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4009',TZNR00,null)))  clm4009 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4010',TZNR00,null)))  clm4010 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4011',TZNR00,null)))  clm4011 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4012',TZNR00,null)))  clm4012 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4013',TZNR00,null)))  clm4013 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4014',TZNR00,null)))  clm4014 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4015',TZNR00,null)))  clm4015 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4019',TZNR00,null)))  clm4019 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4020',TZNR00,null)))  clm4020 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4022',TZNR00,null)))  clm4022 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4021',TZNR00,null)))  clm4021 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4023',TZNR00,null)))  clm4023 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4024',TZNR00,null)))  clm4024 ,BM_YGBM00.ZWXM00 ZWXM00,'black' Color  from BQ_BRTZXX   left join BQ_TZLB00 on BQ_TZLB00.TZLBID=BQ_BRTZXX.TZLBID   left join BM_YGBM00 on BM_YGBM00.YGBH00=BQ_BRTZXX.LRR000  where hldlb0='4' and zyid00 = 326866 group by JLRQ00,JLSJ00,ZYID00,ZWXM00 order by JLRQ00,JLSJ00
/*  */

20160114  11:44:14   select a.*,(select tzlbmc from bq_tzlb00 where tzlbid=a.tzlbid)TZLBMC From BQ_BRHLBT a where zyid00=326866 and tzlbid in(select tzlbid from bq_tzlb00 where hldlb0=4)
/*  */

20160114  11:44:14  select distinct BQ_BRTZXX.tzlbid ,bz0000 from BQ_BRTZXX left join BQ_TZLB00 on BQ_TZLB00.TZLBID=BQ_BRTZXX.TZLBID WHERE HLDLB0='4' and bz0000 is not null and ZYID00 = 326866
/*  */

20160114  11:44:14   select ZYID00,(BQ_BRTZXX.JLRQ00 || ' ' || substr(BQ_BRTZXX.JLSJ00,0,5) ) JLRQSJ,JLRQ00,JLSJ00  ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4000',TZNR00,null)))  clm4000 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4001',TZNR00,null)))  clm4001 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4002',TZNR00,null)))  clm4002 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4003',TZNR00,null)))  clm4003 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4004',TZNR00,null)))  clm4004 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4005',TZNR00,null)))  clm4005 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4006',TZNR00,null)))  clm4006 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4007',TZNR00,null)))  clm4007 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4008',TZNR00,null)))  clm4008 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4009',TZNR00,null)))  clm4009 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4010',TZNR00,null)))  clm4010 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4011',TZNR00,null)))  clm4011 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4012',TZNR00,null)))  clm4012 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4013',TZNR00,null)))  clm4013 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4014',TZNR00,null)))  clm4014 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4015',TZNR00,null)))  clm4015 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4019',TZNR00,null)))  clm4019 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4020',TZNR00,null)))  clm4020 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4022',TZNR00,null)))  clm4022 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4021',TZNR00,null)))  clm4021 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4023',TZNR00,null)))  clm4023 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4024',TZNR00,null)))  clm4024 ,BM_YGBM00.ZWXM00 ZWXM00,'black' Color  from BQ_BRTZXX   left join BQ_TZLB00 on BQ_TZLB00.TZLBID=BQ_BRTZXX.TZLBID   left join BM_YGBM00 on BM_YGBM00.YGBH00=BQ_BRTZXX.LRR000  where hldlb0='4' and zyid00 = 326866 group by JLRQ00,JLSJ00,ZYID00,ZWXM00 order by JLRQ00,JLSJ00
/*  */

20160114  11:44:14   select ZYID00,(BQ_BRTZXX.JLRQ00 || ' ' || substr(BQ_BRTZXX.JLSJ00,0,5) ) JLRQSJ,JLRQ00,JLSJ00  ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4000',TZNR00,null)))  clm4000 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4001',TZNR00,null)))  clm4001 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4002',TZNR00,null)))  clm4002 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4003',TZNR00,null)))  clm4003 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4004',TZNR00,null)))  clm4004 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4005',TZNR00,null)))  clm4005 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4006',TZNR00,null)))  clm4006 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4007',TZNR00,null)))  clm4007 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4008',TZNR00,null)))  clm4008 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4009',TZNR00,null)))  clm4009 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4010',TZNR00,null)))  clm4010 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4011',TZNR00,null)))  clm4011 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4012',TZNR00,null)))  clm4012 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4013',TZNR00,null)))  clm4013 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4014',TZNR00,null)))  clm4014 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4015',TZNR00,null)))  clm4015 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4019',TZNR00,null)))  clm4019 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4020',TZNR00,null)))  clm4020 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4022',TZNR00,null)))  clm4022 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4021',TZNR00,null)))  clm4021 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4023',TZNR00,null)))  clm4023 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4024',TZNR00,null)))  clm4024 ,BM_YGBM00.ZWXM00 ZWXM00,'black' Color  from BQ_BRTZXX   left join BQ_TZLB00 on BQ_TZLB00.TZLBID=BQ_BRTZXX.TZLBID   left join BM_YGBM00 on BM_YGBM00.YGBH00=BQ_BRTZXX.LRR000  where hldlb0='4' and zyid00 = 326866 group by JLRQ00,JLSJ00,ZYID00,ZWXM00 order by JLRQ00,JLSJ00
/*  */

20160114  11:44:14  parameters :ZYID00=326866 :HLDLB0=4 
/*  */

20160114  11:44:14  select * from BQ_HLDYJL where SFYX00='1' and ZYID00=:ZYID00 and HLDLB0=:HLDLB0  and YEXM00 is null order by DYPC00
/*  */

20160114  11:44:13  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:13  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:09  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:09  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:06  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:06  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:05   select ZYID00,(BQ_BRTZXX.JLRQ00 || ' ' || substr(BQ_BRTZXX.JLSJ00,0,5) ) JLRQSJ,JLRQ00,JLSJ00  ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4000',TZNR00,null)))  clm4000 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4001',TZNR00,null)))  clm4001 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4002',TZNR00,null)))  clm4002 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4003',TZNR00,null)))  clm4003 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4004',TZNR00,null)))  clm4004 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4005',TZNR00,null)))  clm4005 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4006',TZNR00,null)))  clm4006 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4007',TZNR00,null)))  clm4007 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4008',TZNR00,null)))  clm4008 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4009',TZNR00,null)))  clm4009 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4010',TZNR00,null)))  clm4010 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4011',TZNR00,null)))  clm4011 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4012',TZNR00,null)))  clm4012 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4013',TZNR00,null)))  clm4013 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4014',TZNR00,null)))  clm4014 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4015',TZNR00,null)))  clm4015 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4019',TZNR00,null)))  clm4019 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4020',TZNR00,null)))  clm4020 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4022',TZNR00,null)))  clm4022 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4021',TZNR00,null)))  clm4021 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4023',TZNR00,null)))  clm4023 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4024',TZNR00,null)))  clm4024 ,BM_YGBM00.ZWXM00 ZWXM00,'black' Color  from BQ_BRTZXX   left join BQ_TZLB00 on BQ_TZLB00.TZLBID=BQ_BRTZXX.TZLBID   left join BM_YGBM00 on BM_YGBM00.YGBH00=BQ_BRTZXX.LRR000  where hldlb0='4' and zyid00 = 326866 group by JLRQ00,JLSJ00,ZYID00,ZWXM00 order by JLRQ00,JLSJ00
/*  */

20160114  11:44:05   select a.*,(select tzlbmc from bq_tzlb00 where tzlbid=a.tzlbid)TZLBMC From BQ_BRHLBT a where zyid00=326866 and tzlbid in(select tzlbid from bq_tzlb00 where hldlb0=4)
/*  */

20160114  11:44:05  select distinct BQ_BRTZXX.tzlbid ,bz0000 from BQ_BRTZXX left join BQ_TZLB00 on BQ_TZLB00.TZLBID=BQ_BRTZXX.TZLBID WHERE HLDLB0='4' and bz0000 is not null and ZYID00 = 326866
/*  */

20160114  11:44:05   select ZYID00,(BQ_BRTZXX.JLRQ00 || ' ' || substr(BQ_BRTZXX.JLSJ00,0,5) ) JLRQSJ,JLRQ00,JLSJ00  ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4000',TZNR00,null)))  clm4000 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4001',TZNR00,null)))  clm4001 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4002',TZNR00,null)))  clm4002 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4003',TZNR00,null)))  clm4003 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4004',TZNR00,null)))  clm4004 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4005',TZNR00,null)))  clm4005 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4006',TZNR00,null)))  clm4006 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4007',TZNR00,null)))  clm4007 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4008',TZNR00,null)))  clm4008 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4009',TZNR00,null)))  clm4009 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4010',TZNR00,null)))  clm4010 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4011',TZNR00,null)))  clm4011 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4012',TZNR00,null)))  clm4012 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4013',TZNR00,null)))  clm4013 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4014',TZNR00,null)))  clm4014 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4015',TZNR00,null)))  clm4015 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4019',TZNR00,null)))  clm4019 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4020',TZNR00,null)))  clm4020 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4022',TZNR00,null)))  clm4022 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4021',TZNR00,null)))  clm4021 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4023',TZNR00,null)))  clm4023 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4024',TZNR00,null)))  clm4024 ,BM_YGBM00.ZWXM00 ZWXM00,'black' Color  from BQ_BRTZXX   left join BQ_TZLB00 on BQ_TZLB00.TZLBID=BQ_BRTZXX.TZLBID   left join BM_YGBM00 on BM_YGBM00.YGBH00=BQ_BRTZXX.LRR000  where hldlb0='4' and zyid00 = 326866 group by JLRQ00,JLSJ00,ZYID00,ZWXM00 order by JLRQ00,JLSJ00
/*  */

20160114  11:44:05   select ZYID00,(BQ_BRTZXX.JLRQ00 || ' ' || substr(BQ_BRTZXX.JLSJ00,0,5) ) JLRQSJ,JLRQ00,JLSJ00  ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4000',TZNR00,null)))  clm4000 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4001',TZNR00,null)))  clm4001 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4002',TZNR00,null)))  clm4002 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4003',TZNR00,null)))  clm4003 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4004',TZNR00,null)))  clm4004 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4005',TZNR00,null)))  clm4005 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4006',TZNR00,null)))  clm4006 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4007',TZNR00,null)))  clm4007 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4008',TZNR00,null)))  clm4008 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4009',TZNR00,null)))  clm4009 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4010',TZNR00,null)))  clm4010 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4011',TZNR00,null)))  clm4011 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4012',TZNR00,null)))  clm4012 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4013',TZNR00,null)))  clm4013 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4014',TZNR00,null)))  clm4014 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4015',TZNR00,null)))  clm4015 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4019',TZNR00,null)))  clm4019 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4020',TZNR00,null)))  clm4020 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4022',TZNR00,null)))  clm4022 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4021',TZNR00,null)))  clm4021 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4023',TZNR00,null)))  clm4023 ,to_char(max(DECODE(bq_brtzxx.TZLBID,'4024',TZNR00,null)))  clm4024 ,BM_YGBM00.ZWXM00 ZWXM00,'black' Color  from BQ_BRTZXX   left join BQ_TZLB00 on BQ_TZLB00.TZLBID=BQ_BRTZXX.TZLBID   left join BM_YGBM00 on BM_YGBM00.YGBH00=BQ_BRTZXX.LRR000  where hldlb0='4' and zyid00 = 326866 group by JLRQ00,JLSJ00,ZYID00,ZWXM00 order by JLRQ00,JLSJ00
/*  */

20160114  11:44:05  parameters :ZYID00=326866 :HLDLB0=4 
/*  */

20160114  11:44:05  select * from BQ_HLDYJL where SFYX00='1' and ZYID00=:ZYID00 and HLDLB0=:HLDLB0  and YEXM00 is null order by DYPC00
/*  */

20160114  11:44:05  select * from BQ_TZLB00 WHERE HLDLB0=4
/*  */

20160114  11:44:02  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */

20160114  11:44:02  select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'
/*  */