parameters :LoginId=186645 :Remark= 

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

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

 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

 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)

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

 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

 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

parameters :ZYID00=326866 :HLDLB0=4 

select * from BQ_HLDYJL where SFYX00='1' and ZYID00=:ZYID00 and HLDLB0=:HLDLB0  and YEXM00 is null order by DYPC00

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

 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

 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)

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

 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

 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

parameters :ZYID00=326866 :HLDLB0=4 

select * from BQ_HLDYJL where SFYX00='1' and ZYID00=:ZYID00 and HLDLB0=:HLDLB0  and YEXM00 is null order by DYPC00

select * from BQ_TZLB00 WHERE HLDLB0=4

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'

select  b.yszid0 from ZS_YSZMX0 b where b.ysbh00 = '255'