1       18:34:52  Log started for: 药库管理系统
2       18:34:52  SQL Prepare: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.11.22','3','appYP_YK.exe'||'+'||'药库管理系统','1047','39796' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@3307:242516CC697D53ABE5AADA29479AAB22' from dual

3       18:34:52  SQL Execute: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.11.22','3','appYP_YK.exe'||'+'||'药库管理系统','1047','39796' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@3307:242516CC697D53ABE5AADA29479AAB22' from dual

4       18:34:52  SQL Prepare: ORACLE - Commit

5       18:34:52  SQL Execute: ORACLE - Commit

6       18:34:53  SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

7       18:34:53  SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

8       18:34:53  SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

9       18:34:53  SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

10      18:34:53  SQL Prepare: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='3307' and CZBZ00 in ('1') 

11      18:34:53  SQL Execute: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='3307' and CZBZ00 in ('1') 

12      18:34:53  SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

13      18:34:53  SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

14      18:34:53  SQL Prepare: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.11.22','3','appYP_YK.exe'||'+'||'药库管理系统','991','24372' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@3307:07C379173E907CEA138970477025624E' from dual

15      18:34:53  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.11.22','3','appYP_YK.exe'||'+'||'药库管理系统','991','24372' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@3307:07C379173E907CEA138970477025624E' from dual

16      18:34:53  SQL Prepare: ORACLE - Commit

17      18:34:53  SQL Execute: ORACLE - Commit

18      18:34:53  SQL Prepare: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='3'

19      18:34:53  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='3'

20      18:34:53  SQL Prepare: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='3307' and CZBZ00 in ('1') 

21      18:34:53  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='3307' and CZBZ00 in ('1') 

22      18:34:53  SQL Prepare: ORACLE - Select SYSDATE from Dual

23      18:34:53  SQL Execute: ORACLE - Select SYSDATE from Dual

24      18:34:53  SQL Prepare: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

25      18:34:53  SQL Execute: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

26      18:34:53  SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

27      18:34:53  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

28      18:34:53  SQL Prepare: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='3'

29      18:34:53  SQL Execute: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='3'

30      18:34:53  SQL Prepare: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

31      18:34:53  SQL Execute: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

32      18:34:53  SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')
Order by SYBZ00

33      18:34:53  SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')
Order by SYBZ00

34      18:34:53  SQL Prepare: ORACLE -  Select a.BMMC00,a.BMBH00 from BM_BMBM00 a  
,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='3'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3307')) b
 where a.FLAG00='1'  
 and a.BMBH00=b.BMBH00 
 and  a.BMXZ00 in ('6')
 and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='3'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3307'))
 order by b.PLXH00,a.BH0000

35      18:34:53  SQL Execute: ORACLE -  Select a.BMMC00,a.BMBH00 from BM_BMBM00 a  
,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='3'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3307')) b
 where a.FLAG00='1'  
 and a.BMBH00=b.BMBH00 
 and  a.BMXZ00 in ('6')
 and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='3'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3307'))
 order by b.PLXH00,a.BH0000

36      18:34:53  SQL Prepare: ORACLE -  Select '0' as XTDM00 from dual where 
'3307'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'3' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3307'))
 union 
 select XTDM00 from VW_XT_YHMKQX A where XTDM00='3' and 
 YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3307') 

37      18:34:53  SQL Execute: ORACLE -  Select '0' as XTDM00 from dual where 
'3307'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'3' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3307'))
 union 
 select XTDM00 from VW_XT_YHMKQX A where XTDM00='3' and 
 YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3307') 

38      18:34:53  SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=337

39      18:34:53  SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=337

40      18:34:53  SQL Prepare: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

41      18:34:53  SQL Execute: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

42      18:34:53  SQL Prepare: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

43      18:34:53  SQL Execute: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

44      18:34:53  SQL Prepare: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

45      18:34:53  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

46      18:34:53  SQL Prepare: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

47      18:34:53  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

48      18:34:53  SQL Prepare: ORACLE -  select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 
 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where  AUDSID= userenv('SESSIONID'))

49      18:34:53  SQL Execute: ORACLE -  select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 
 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where  AUDSID= userenv('SESSIONID'))

50      18:34:53  SQL Prepare: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(3364915,337,'西药库-2','3',nvl('74315526',' '),'192.168.11.22#991:24372@appYP_YK.exe+药库管理系统',12)

51      18:34:53  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(3364915,337,'西药库-2','3',nvl('74315526',' '),'192.168.11.22#991:24372@appYP_YK.exe+药库管理系统',12)

52      18:34:53  SQL Prepare: ORACLE - Commit

53      18:34:53  SQL Execute: ORACLE - Commit

54      18:34:53  SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 12

55      18:34:53  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 12

56      18:34:53  SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137'

57      18:34:53  SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137'

58      18:34:53  SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

59      18:34:53  SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

60      18:34:53  SQL Prepare: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.11.22'

61      18:34:53  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.11.22'

62      18:34:53  SQL Prepare: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

63      18:34:53  SQL Execute: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

64      18:34:53  SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
12 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

65      18:34:53  SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
12 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

66      18:34:53  SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 

67      18:34:53  SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 

68      18:34:53  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 

69      18:34:53  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 

70      18:34:54  SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='337' and name00='SYSTEMSKIN'

71      18:34:54  SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='337' and name00='SYSTEMSKIN'

72      18:34:54  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

73      18:34:54  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

74      18:34:54  SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='3') and YXQ000>='20121231'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',12,' )>0 )

75      18:34:54  SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='3') and YXQ000>='20121231'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',12,' )>0 )

76      18:34:54  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

77      18:34:54  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

78      18:34:54  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

79      18:34:54  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

80      18:34:54  SQL Prepare: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=12

81      18:34:54  SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=12

82      18:34:54  SQL Prepare: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YK_%' AND STATUS<>'VALID'

83      18:34:54  SQL Execute: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YK_%' AND STATUS<>'VALID'

84      18:34:54  SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YK_%' AND STATUS='VALID'

85      18:34:54  SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YK_%' AND STATUS='VALID'

86      18:34:54  SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME= 'TR_BM_YD0000_BFUPDDET' AND STATUS='VALID'

87      18:34:54  SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME= 'TR_BM_YD0000_BFUPDDET' AND STATUS='VALID'

88      18:34:54  SQL Prepare: ORACLE - select TRIGGER_NAME from user_triggers
 where  TRIGGER_NAME LIKE 'TR_YK_%' AND STATUS<>'ENABLED'

89      18:34:54  SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers
 where  TRIGGER_NAME LIKE 'TR_YK_%' AND STATUS<>'ENABLED'

90      18:34:54  SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_triggers
 where TRIGGER_NAME='TR_BM_YD0000_BFUPDDET' AND STATUS='ENABLED'

91      18:34:54  SQL Execute: ORACLE - select Count(*) as TR_NUM from user_triggers
 where TRIGGER_NAME='TR_BM_YD0000_BFUPDDET' AND STATUS='ENABLED'

92      18:34:54  SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 like 'YK_%' or NAME00 like 'YF_%' or NAME00 like 'ZS_%'

93      18:34:54  SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 like 'YK_%' or NAME00 like 'YF_%' or NAME00 like 'ZS_%'

94      18:34:54  SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00=337

95      18:34:54  SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=337

96      18:34:54  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='3' and (( 
337= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=337 and XTDM00='3'))) 

97      18:34:54  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='3' and (( 
337= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=337 and XTDM00='3'))) 

98      18:34:54  SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '3$%' and A.XTDM00='3' and trim(A.MKDM00)='3$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00

99      18:34:54  SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '3$%' and A.XTDM00='3' and trim(A.MKDM00)='3$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00

100     18:34:54  SQL Prepare: ORACLE - select count(*)  from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where  A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((337= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=337 and XTDM00='0 '))) 

101     18:34:54  SQL Execute: ORACLE - select count(*)  from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where  A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((337= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=337 and XTDM00='0 '))) 

102     18:34:54  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

103     18:34:54  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

104     18:34:54  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 
337= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=337 and XTDM00='+ '))) 

105     18:34:54  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 
337= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=337 and XTDM00='+ '))) 

106     18:34:54  SQL Prepare: ORACLE - SELECT LBMC00 FROM BM_YPLB00 where LBBH00='3' 

107     18:34:54  SQL Execute: ORACLE - SELECT LBMC00 FROM BM_YPLB00 where LBBH00='3' 

108     18:34:54  SQL Prepare: ORACLE - SELECT 'X' FROM VW_YK_YPKCXX 
 WHERE YKBMBH=12
 AND KCSL00<KCXX00 

109     18:34:54  SQL Execute: ORACLE - SELECT 'X' FROM VW_YK_YPKCXX 
 WHERE YKBMBH=12
 AND KCSL00<KCXX00 

110     18:34:56  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 

111     18:34:56  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 

112     18:34:59  SQL Prepare: ORACLE - select FYBZ00 from BM_BMBM00
 where BMBH00=12

113     18:34:59  SQL Execute: ORACLE - select FYBZ00 from BM_BMBM00
 where BMBH00=12

114     18:34:59  SQL Prepare: ORACLE - select D.YPPDPC from YK_YPPD00 D,YK_YPPCPD P
 where  D.YPPDPC=P.YPPDPC and YKBMBH=12
  AND   D.SFQR00='N'

115     18:34:59  SQL Execute: ORACLE - select D.YPPDPC from YK_YPPD00 D,YK_YPPCPD P
 where  D.YPPDPC=P.YPPDPC and YKBMBH=12
  AND   D.SFQR00='N'

116     18:34:59  SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=337 and BMBH00=12
 and DLXTMC='药库管理系统' and CTMC00='frmYK_YPZLPD'

117     18:34:59  SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=337 and BMBH00=12
 and DLXTMC='药库管理系统' and CTMC00='frmYK_YPZLPD'

118     18:34:59  SQL Prepare: ORACLE - select LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00 from XT_ZDYLXS where YGBH00=337 and BMBH00=12
 and DLXTMC='药库管理系统' and CTMC00='frmYK_YPZLPD' and DBGRIN='DBGridEh1' order by LS0000

119     18:34:59  SQL Execute: ORACLE - select LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00 from XT_ZDYLXS where YGBH00=337 and BMBH00=12
 and DLXTMC='药库管理系统' and CTMC00='frmYK_YPZLPD' and DBGRIN='DBGridEh1' order by LS0000

120     18:34:59  SQL Prepare: ORACLE - SELECT P.YPPDPC,P.PDRQ00,P.PDLB00,P.LBBH00,P.JXBH00,P.YLBH00
 FROM YK_YPPD00 P
 WHERE  P.YKBMBH=12
 and P.SFQR00='N'

121     18:34:59  SQL Execute: ORACLE - SELECT P.YPPDPC,P.PDRQ00,P.PDLB00,P.LBBH00,P.JXBH00,P.YLBH00
 FROM YK_YPPD00 P
 WHERE  P.YKBMBH=12
 and P.SFQR00='N'

122     18:34:59  SQL Prepare: ORACLE - select x.*,d.YPBM00,d.PYSM00,d.WBSM00,d.K2J000,
round(x.ZMSL00*x.ZHL000/d.K2J000,3) ZMSLKC,
round(x.YKSL00*x.ZHL000/d.K2J000,3) YKSLKC,
round(x.SJSL00*x.ZHL000/d.K2J000,3) SJSLKC,d.mzfydw,d.m2j000,d.ypmlbz
from yk_yppdmx x,bm_yd0000 d
where x.YPPDPC=:1 and x.YPNM00=d.YPNM00
order by x.PDXH00,x.YPBM00

123     18:34:59  SQL Execute: ORACLE - select x.*,d.YPBM00,d.PYSM00,d.WBSM00,d.K2J000,
round(x.ZMSL00*x.ZHL000/d.K2J000,3) ZMSLKC,
round(x.YKSL00*x.ZHL000/d.K2J000,3) YKSLKC,
round(x.SJSL00*x.ZHL000/d.K2J000,3) SJSLKC,d.mzfydw,d.m2j000,d.ypmlbz
from yk_yppdmx x,bm_yd0000 d
where x.YPPDPC=? and x.YPNM00=d.YPNM00
order by x.PDXH00,x.YPBM00

124     18:35:13  SQL Prepare: ORACLE - Select * from YK_YPPD00
 where YPPDPC=5995
 and SFQR00='N'

125     18:35:13  SQL Execute: ORACLE - Select * from YK_YPPD00
 where YPPDPC=5995
 and SFQR00='N'

126     18:35:13  SQL Prepare: ORACLE - commit

127     18:35:13  SQL Execute: ORACLE - commit

128     18:35:17  SQL Prepare: ORACLE - select FYBZ00 from BM_BMBM00
 where BMBH00=12

129     18:35:17  SQL Execute: ORACLE - select FYBZ00 from BM_BMBM00
 where BMBH00=12

130     18:35:17  SQL Prepare: ORACLE - select D.YPPDPC from YK_YPPD00 D,YK_YPPCPD P
 where  D.YPPDPC=P.YPPDPC and YKBMBH=12
  AND   D.SFQR00='N'

131     18:35:17  SQL Execute: ORACLE - select D.YPPDPC from YK_YPPD00 D,YK_YPPCPD P
 where  D.YPPDPC=P.YPPDPC and YKBMBH=12
  AND   D.SFQR00='N'

132     18:35:17  SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=337 and BMBH00=12
 and DLXTMC='药库管理系统' and CTMC00='frmYK_YPZLPD'

133     18:35:17  SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=337 and BMBH00=12
 and DLXTMC='药库管理系统' and CTMC00='frmYK_YPZLPD'

134     18:35:17  SQL Prepare: ORACLE - select LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00 from XT_ZDYLXS where YGBH00=337 and BMBH00=12
 and DLXTMC='药库管理系统' and CTMC00='frmYK_YPZLPD' and DBGRIN='DBGridEh1' order by LS0000

135     18:35:17  SQL Execute: ORACLE - select LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00 from XT_ZDYLXS where YGBH00=337 and BMBH00=12
 and DLXTMC='药库管理系统' and CTMC00='frmYK_YPZLPD' and DBGRIN='DBGridEh1' order by LS0000

136     18:35:17  SQL Prepare: ORACLE - SELECT P.YPPDPC,P.PDRQ00,P.PDLB00,P.LBBH00,P.JXBH00,P.YLBH00
 FROM YK_YPPD00 P
 WHERE  P.YKBMBH=12
 and P.SFQR00='N'

137     18:35:17  SQL Execute: ORACLE - SELECT P.YPPDPC,P.PDRQ00,P.PDLB00,P.LBBH00,P.JXBH00,P.YLBH00
 FROM YK_YPPD00 P
 WHERE  P.YKBMBH=12
 and P.SFQR00='N'

138     18:35:17  SQL Prepare: ORACLE - select x.*,d.YPBM00,d.PYSM00,d.WBSM00,d.K2J000,
round(x.ZMSL00*x.ZHL000/d.K2J000,3) ZMSLKC,
round(x.YKSL00*x.ZHL000/d.K2J000,3) YKSLKC,
round(x.SJSL00*x.ZHL000/d.K2J000,3) SJSLKC,d.mzfydw,d.m2j000,d.ypmlbz
from yk_yppdmx x,bm_yd0000 d
where x.YPPDPC=:1 and x.YPNM00=d.YPNM00
order by x.PDXH00,x.YPBM00

139     18:35:17  SQL Execute: ORACLE - select x.*,d.YPBM00,d.PYSM00,d.WBSM00,d.K2J000,
round(x.ZMSL00*x.ZHL000/d.K2J000,3) ZMSLKC,
round(x.YKSL00*x.ZHL000/d.K2J000,3) YKSLKC,
round(x.SJSL00*x.ZHL000/d.K2J000,3) SJSLKC,d.mzfydw,d.m2j000,d.ypmlbz
from yk_yppdmx x,bm_yd0000 d
where x.YPPDPC=? and x.YPNM00=d.YPNM00
order by x.PDXH00,x.YPBM00

140     18:35:47  SQL Prepare: ORACLE - Select * from YK_YPPD00
 where YPPDPC=5995
 and SFQR00='N'

141     18:35:47  SQL Execute: ORACLE - Select * from YK_YPPD00
 where YPPDPC=5995
 and SFQR00='N'

142     18:35:47  SQL Prepare: ORACLE - update yk_yppdmx
set
  SJSL00 = :1,
  YKSL00 = :2,
  BZ0000 = :3
where
  YPPDPC = :4 and
  YPNM00 = :5 and 
  PDDJ00 = :6

143     18:35:47  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

144     18:35:47  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

145     18:35:47  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

146     18:35:47  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

147     18:35:47  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

148     18:35:47  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

149     18:35:47  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

150     18:35:47  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

151     18:35:47  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

152     18:35:47  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

153     18:35:47  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

154     18:35:47  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

155     18:35:47  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

156     18:35:47  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

157     18:35:47  SQL Prepare: ORACLE - commit

158     18:35:47  SQL Execute: ORACLE - commit

159     18:36:24  SQL Prepare: ORACLE - Select * from YK_YPPD00
 where YPPDPC=5995
 and SFQR00='N'

160     18:36:24  SQL Execute: ORACLE - Select * from YK_YPPD00
 where YPPDPC=5995
 and SFQR00='N'

161     18:36:24  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

162     18:36:24  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

163     18:36:24  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

164     18:36:24  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

165     18:36:24  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

166     18:36:24  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

167     18:36:24  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

168     18:36:24  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

169     18:36:24  SQL Prepare: ORACLE - commit

170     18:36:24  SQL Execute: ORACLE - commit

171     18:36:59  SQL Prepare: ORACLE - Select * from YK_YPPD00
 where YPPDPC=5995
 and SFQR00='N'

172     18:36:59  SQL Execute: ORACLE - Select * from YK_YPPD00
 where YPPDPC=5995
 and SFQR00='N'

173     18:36:59  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

174     18:36:59  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

175     18:36:59  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

176     18:36:59  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

177     18:36:59  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

178     18:36:59  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

179     18:36:59  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

180     18:36:59  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

181     18:36:59  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

182     18:36:59  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

183     18:36:59  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

184     18:36:59  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

185     18:36:59  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

186     18:36:59  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

187     18:36:59  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

188     18:36:59  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

189     18:36:59  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

190     18:36:59  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

191     18:36:59  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

192     18:36:59  SQL Prepare: ORACLE - commit

193     18:36:59  SQL Execute: ORACLE - commit

194     18:38:12  SQL Prepare: ORACLE - Select * from YK_YPPD00
 where YPPDPC=5995
 and SFQR00='N'

195     18:38:12  SQL Execute: ORACLE - Select * from YK_YPPD00
 where YPPDPC=5995
 and SFQR00='N'

196     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

197     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

198     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

199     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

200     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

201     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

202     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

203     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

204     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

205     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

206     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

207     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

208     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

209     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

210     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

211     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

212     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

213     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

214     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

215     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

216     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

217     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

218     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

219     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

220     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

221     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

222     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

223     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

224     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

225     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

226     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

227     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

228     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

229     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

230     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

231     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

232     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

233     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

234     18:38:12  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

235     18:38:12  SQL Prepare: ORACLE - rollback

236     18:38:12  SQL Execute: ORACLE - rollback

237     18:38:16  SQL Prepare: ORACLE - Select * from YK_YPPD00
 where YPPDPC=5995
 and SFQR00='N'

238     18:38:16  SQL Execute: ORACLE - Select * from YK_YPPD00
 where YPPDPC=5995
 and SFQR00='N'

239     18:38:16  SQL Execute: ORACLE - update yk_yppdmx
set
  SJSL00 = ?,
  YKSL00 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ?

240     18:38:16  SQL Prepare: ORACLE - rollback

241     18:38:16  SQL Execute: ORACLE - rollback