1       11:12:00  SQL Prepare: ORACLE - Select * from (select BMMC00,BH0000,PYSM00,WBSM00,BMBH00 from vw_SB_BMBM00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=100

2       11:12:00  SQL Execute: ORACLE - Select * from (select BMMC00,BH0000,PYSM00,WBSM00,BMBH00 from vw_SB_BMBM00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=100

3       11:13:27  SQL Prepare: ORACLE - Select * from (select BMMC00,BH0000,PYSM00,WBSM00,BMBH00 from vw_SB_BMBM00 where (PYSM00 Like :1) Order By Instrb(PYSM00,'h'),PYSM00) where Rownum<=100

4       11:13:27  SQL Execute: ORACLE - Select * from (select BMMC00,BH0000,PYSM00,WBSM00,BMBH00 from vw_SB_BMBM00 where (PYSM00 Like ?) Order By Instrb(PYSM00,'h'),PYSM00) where Rownum<=100

5       11:13:27  SQL Prepare: ORACLE - Select * from (select BMMC00,BH0000,PYSM00,WBSM00,BMBH00 from vw_SB_BMBM00 where (PYSM00 Like :1) Order By Instrb(PYSM00,'hl'),PYSM00) where Rownum<=100

6       11:13:27  SQL Execute: ORACLE - Select * from (select BMMC00,BH0000,PYSM00,WBSM00,BMBH00 from vw_SB_BMBM00 where (PYSM00 Like ?) Order By Instrb(PYSM00,'hl'),PYSM00) where Rownum<=100

7       11:13:27  SQL Prepare: ORACLE - Select * from (select BMMC00,BH0000,PYSM00,WBSM00,BMBH00 from vw_SB_BMBM00 where (PYSM00 Like :1) Order By Instrb(PYSM00,'hlb'),PYSM00) where Rownum<=100

8       11:13:27  SQL Execute: ORACLE - Select * from (select BMMC00,BH0000,PYSM00,WBSM00,BMBH00 from vw_SB_BMBM00 where (PYSM00 Like ?) Order By Instrb(PYSM00,'hlb'),PYSM00) where Rownum<=100

9       11:13:29  SQL Prepare: ORACLE - Select * from (select ZWXM00,XB0000,XKH000,YGBH00,PYSM00,WBSM00 from vw_SB_YGBM00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=100

10      11:13:29  SQL Execute: ORACLE - Select * from (select ZWXM00,XB0000,XKH000,YGBH00,PYSM00,WBSM00 from vw_SB_YGBM00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=100

11      11:13:29  SQL Prepare: ORACLE - Select * from (select ZWXM00,XB0000,XKH000,YGBH00,PYSM00,WBSM00 from vw_SB_YGBM00 where (PYSM00 Like :1) Order By Instrb(PYSM00,'n'),PYSM00) where Rownum<=100

12      11:13:29  SQL Execute: ORACLE - Select * from (select ZWXM00,XB0000,XKH000,YGBH00,PYSM00,WBSM00 from vw_SB_YGBM00 where (PYSM00 Like ?) Order By Instrb(PYSM00,'n'),PYSM00) where Rownum<=100

13      11:13:30  SQL Prepare: ORACLE - Select * from (select ZWXM00,XB0000,XKH000,YGBH00,PYSM00,WBSM00 from vw_SB_YGBM00 where (PYSM00 Like :1) Order By Instrb(PYSM00,'nc'),PYSM00) where Rownum<=100

14      11:13:30  SQL Execute: ORACLE - Select * from (select ZWXM00,XB0000,XKH000,YGBH00,PYSM00,WBSM00 from vw_SB_YGBM00 where (PYSM00 Like ?) Order By Instrb(PYSM00,'nc'),PYSM00) where Rownum<=100

15      11:13:30  SQL Prepare: ORACLE - Select * from (select ZWXM00,XB0000,XKH000,YGBH00,PYSM00,WBSM00 from vw_SB_YGBM00 where (PYSM00 Like :1) Order By Instrb(PYSM00,'nch'),PYSM00) where Rownum<=100

16      11:13:30  SQL Execute: ORACLE - Select * from (select ZWXM00,XB0000,XKH000,YGBH00,PYSM00,WBSM00 from vw_SB_YGBM00 where (PYSM00 Like ?) Order By Instrb(PYSM00,'nch'),PYSM00) where Rownum<=100

17      11:13:33  SQL Prepare: ORACLE - Select * from (select BMMC00,BH0000,PYSM00,WBSM00,BMBH00 from vw_SB_BMBM00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=100

18      11:13:33  SQL Execute: ORACLE - Select * from (select BMMC00,BH0000,PYSM00,WBSM00,BMBH00 from vw_SB_BMBM00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=100

19      11:13:34  SQL Prepare: ORACLE - Select * from (select BMMC00,BH0000,PYSM00,WBSM00,BMBH00 from vw_SB_BMBM00 where (PYSM00 Like :1) Order By Instrb(PYSM00,'n'),PYSM00) where Rownum<=100

20      11:13:34  SQL Execute: ORACLE - Select * from (select BMMC00,BH0000,PYSM00,WBSM00,BMBH00 from vw_SB_BMBM00 where (PYSM00 Like ?) Order By Instrb(PYSM00,'n'),PYSM00) where Rownum<=100

21      11:13:35  SQL Prepare: ORACLE - Select * from (select BMMC00,BH0000,PYSM00,WBSM00,BMBH00 from vw_SB_BMBM00 where (PYSM00 Like :1) Order By Instrb(PYSM00,'nk'),PYSM00) where Rownum<=100

22      11:13:35  SQL Execute: ORACLE - Select * from (select BMMC00,BH0000,PYSM00,WBSM00,BMBH00 from vw_SB_BMBM00 where (PYSM00 Like ?) Order By Instrb(PYSM00,'nk'),PYSM00) where Rownum<=100

23      11:13:37  SQL Prepare: ORACLE - Select * from (select ZWXM00,XB0000,XKH000,YGBH00,PYSM00,WBSM00 from vw_SB_YGBM00 where (PYSM00 Like :1) Order By PYSM00) where Rownum<=100

24      11:13:37  SQL Execute: ORACLE - Select * from (select ZWXM00,XB0000,XKH000,YGBH00,PYSM00,WBSM00 from vw_SB_YGBM00 where (PYSM00 Like ?) Order By PYSM00) where Rownum<=100

25      11:13:39  SQL Prepare: ORACLE - Select * from (select ZWXM00,XB0000,XKH000,YGBH00,PYSM00,WBSM00 from vw_SB_YGBM00 where (PYSM00 Like :1) Order By Instrb(PYSM00,'j'),PYSM00) where Rownum<=100

26      11:13:39  SQL Execute: ORACLE - Select * from (select ZWXM00,XB0000,XKH000,YGBH00,PYSM00,WBSM00 from vw_SB_YGBM00 where (PYSM00 Like ?) Order By Instrb(PYSM00,'j'),PYSM00) where Rownum<=100

27      11:13:39  SQL Prepare: ORACLE - Select * from (select ZWXM00,XB0000,XKH000,YGBH00,PYSM00,WBSM00 from vw_SB_YGBM00 where (PYSM00 Like :1) Order By Instrb(PYSM00,'jx'),PYSM00) where Rownum<=100

28      11:13:39  SQL Execute: ORACLE - Select * from (select ZWXM00,XB0000,XKH000,YGBH00,PYSM00,WBSM00 from vw_SB_YGBM00 where (PYSM00 Like ?) Order By Instrb(PYSM00,'jx'),PYSM00) where Rownum<=100

29      11:13:40  SQL Prepare: ORACLE - Select * from (select ZWXM00,XB0000,XKH000,YGBH00,PYSM00,WBSM00 from vw_SB_YGBM00 where (PYSM00 Like :1) Order By Instrb(PYSM00,'jxl'),PYSM00) where Rownum<=100

30      11:13:40  SQL Execute: ORACLE - Select * from (select ZWXM00,XB0000,XKH000,YGBH00,PYSM00,WBSM00 from vw_SB_YGBM00 where (PYSM00 Like ?) Order By Instrb(PYSM00,'jxl'),PYSM00) where Rownum<=100

31      11:13:41  SQL Prepare: ORACLE - Select * from (select SBMC00,DAH000,GG0000,XH0000,SL0000,JLDW00,DJ0000,PYSM00,WBSM00,DAXXID,SBID00,HTH000,FPH000,FPRQ00,GHDWID,FJBZ00,RCMXID,BMMC00,RZRQ00,BGR000,SSBM00 from vw_SB_DBDA00 where (PYSM00 Like :1) and( CFDD00=135 and CKBH00=118 )  Order By PYSM00) where Rownum<=100

32      11:13:41  SQL Execute: ORACLE - Select * from (select SBMC00,DAH000,GG0000,XH0000,SL0000,JLDW00,DJ0000,PYSM00,WBSM00,DAXXID,SBID00,HTH000,FPH000,FPRQ00,GHDWID,FJBZ00,RCMXID,BMMC00,RZRQ00,BGR000,SSBM00 from vw_SB_DBDA00 where (PYSM00 Like ?) and( CFDD00=135 and CKBH00=118 )  Order By PYSM00) where Rownum<=100

33      11:14:01  SQL Prepare: ORACLE - Select * from (select SBMC00,DAH000,GG0000,XH0000,SL0000,JLDW00,DJ0000,PYSM00,WBSM00,DAXXID,SBID00,HTH000,FPH000,FPRQ00,GHDWID,FJBZ00,RCMXID,BMMC00,RZRQ00,BGR000,SSBM00 from vw_SB_DBDA00 where (PYSM00 Like :1) and( CFDD00=135 and CKBH00=118 )  Order By PYSM00) where Rownum<=100

34      11:14:01  SQL Execute: ORACLE - Select * from (select SBMC00,DAH000,GG0000,XH0000,SL0000,JLDW00,DJ0000,PYSM00,WBSM00,DAXXID,SBID00,HTH000,FPH000,FPRQ00,GHDWID,FJBZ00,RCMXID,BMMC00,RZRQ00,BGR000,SSBM00 from vw_SB_DBDA00 where (PYSM00 Like ?) and( CFDD00=135 and CKBH00=118 )  Order By PYSM00) where Rownum<=100