1 11:08:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 33, Scale = 0, Data = 一次性使用引流管(F26[腹腔引流管])
2 11:08:23 SQL Execute: ORACLE - select SF_XT_GETPYSM(?) SM from dual
3 11:08:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 33, Scale = 0, Data = 一次性使用引流管(F26[腹腔引流管])
4 11:08:24 SQL Execute: ORACLE - select SF_XT_GETWBSM(?) SM from dual
5 11:08:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000036895
6 11:08:36 SQL Execute: ORACLE - select G.SFXMID,G.ZLXMID,S.XMMC00,Z.ZLXMJC,Z.ZLXMBH,G.GXID00,Z.SFYXSQ,Z.DJ0000,Z.BZ0000,S.GJYLBM,Z.SFTY00,Z.TZRQ00,Z.QYRQ00
from XT_ZLSFGX G,VW_XM_ZLZD00 Z,BM_YYSFXM S
where G.ZLXMID=Z.ZLXMID and G.SFXMID=S.SFXMID
and G.SFXMID=?
7 11:08:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000036895
8 11:08:36 SQL Execute: ORACLE - select a.SFXMID, a.SFBZDJ, a.DJSFJE, a.DJBZ00, b.YYJC00 from BM_SFDJBZ a, XT_YYXX00 b
where a.SFBZDJ = b.SFBZDJ and b.SFBZDJ <> '0' and a.SFXMID = ?
9 11:08:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000036895
10 11:08:36 SQL Execute: ORACLE - select c.YYJC00, b.YBMC00, a.SFXMID, a.SFYP00, a.SFBZDJ, a.YBZXLB, a.DJSFSX from BM_YBDJSX a,IC_YBBRLB b,XT_YYXX00 c
where a.SFBZDJ = c.SFBZDJ and a.sfxmid=? and a.sfyp00='N' and c.SFBZDJ <> '0' and a.ybzxlb=b.ybzxlb and b.yblb00=b.ybzxlb
order by c.YYJC00
11 11:08:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000036895
12 11:08:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000036895
13 11:08:36 SQL Execute: ORACLE - select (select SCCJZW from BM_YPSCCJ where SCCJBH=B.SCCJBH) as SCCJZW,
(select GHDWMC from BM_YPGHDW where GHDWNM=B.GHDWNM) as GHDWMC,YPBM00,ypmc00,YPGG00,KCDW00,
LSJ000,TXM000,a.SFXMID,b.GJJ000,a.YPNM00,b.WZXH00,
(select MC0000 from BM_TYZD00 where ZDMC00='物资维护-物资属性' and LBBZ00='0' and BH0000=a.WZSX00 and rownum=1) as WZSXMC
from BM_WZQTXX a, BM_YD0000 b where a.YPNM00=b.YPNM00
and b.LBBH00='9' and a.SFXMID=?
union
select (select SCCJZW from BM_YPSCCJ where SCCJBH=B.SCCJBH) as SCCJZW,
(select GHDWMC from BM_YPGHDW where GHDWNM=B.GHDWNM) as GHDWMC,YPBM00,YPMC00,YPGG00,KCDW00,
LSJ000,TXM000,a.SFXMID,b.GJJ000,a.YPNM00,b.WZXH00,
(select MC0000 from BM_WZQTXX aa,BM_TYZD00 bb where aa.YPNM00=a.YPNM00 and bb.ZDMC00='物资维护-物资属性' and bb.LBBZ00='0' and bb.BH0000=aa.WZSX00 and rownum=1) as WZSXMC
from BM_WZSFDY a, BM_YD0000 b where a.YPNM00=b.YPNM00
and b.LBBH00='9' and a.SFXMID=?
14 11:08:38 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='材料价表项目可选项维护' and MC0000='门诊发票' and YXBZ00='1'
15 11:08:38 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='材料价表项目可选项维护' and MC0000='住院发票' and YXBZ00='1'
16 11:08:38 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='材料价表项目可选项维护' and MC0000='核算项目' and YXBZ00='1'
17 11:08:38 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='材料价表项目可选项维护' and MC0000='病案项目' and YXBZ00='1'
18 11:08:38 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='材料价表项目可选项维护' and MC0000='会计核算' and YXBZ00='1'
19 11:08:38 SQL Execute: ORACLE - select xmmc00 from BM_YYSFXM where bmgzid=1 and flag00='0' and TREEBH like '950009%'
20 11:08:38 SQL Execute: ORACLE - select XMNH00 from BM_YYSFXM where SFXMID=8000036895
21 11:08:38 SQL Execute: ORACLE - select LSCL00 from BM_YYSFXM where SFXMID=8000036895
22 11:08:38 SQL Execute: ORACLE - select BZ0000 from BM_YYSFXM where SFXMID=8000036895
23 11:08:38 SQL Execute: ORACLE - select FWCC00 from BM_YYSFXM where SFXMID=8000036895
24 11:08:38 SQL Execute: ORACLE - select JGGC00 from BM_YYSFXM where SFXMID=8000036895
25 11:08:38 SQL Execute: ORACLE - select zjbz00 from bm_yysfxm where TREEBH='950009000018' and BMGZID=1
26 11:08:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 950009000018
27 11:08:38 SQL Execute: ORACLE - select sfxmid from bm_yysfxm where BMGZID=1 and bh0000=?
28 11:08:38 SQL Execute: ORACLE - insert into BM_YBSFDY(SFXMID,SFYP00,YBZXLB,FBBH00,ZFBL00,ZYZFBL,YBLB00,SFYBXM,CJR000) select 8000036895,'N',a.YBZXLB,a.FBBH00,decode(a.FBBH00,1,1,3,1,MRZFBL),decode(a.FBBH00,1,1,3,1,ZYZFBL),decode(a.FBBH00,1,'2',3,'2',decode(MRZFBL,1,'2','0')),decode(a.FBBH00,1,'N',3,'N',decode(MRZFBL,1,'N','Y')),1913 from IC_YBBRLB a where a.YBLB00=a.YBZXLB and not exists (select 1 from BM_YBSFDY where SFXMID=8000036895 and FBBH00=a.FBBH00 and YBZXLB=a.YBZXLB and SFYP00='N')
29 11:08:38 SQL Data In: ORACLE - Rows affected = 0
30 11:08:38 SQL Execute: ORACLE - Commit
31 11:08:38 SQL Data In: ORACLE - Rows affected = 0
32 11:08:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000036895
33 11:08:38 SQL Execute: ORACLE - select 'Y' SFXZ00,b.ybmc00,a.FBBH00,a.SFXMID,a.SFYP00,a.YBZXLB,a.YBXMBH,a.YBXMMC XMMC00, a.ZFBL00,a.ZYZFBL,a.YBLB00,a.SFYBXM,a.ZYFPXM ZYFPMC,a.MZFPXM MZFPMC, DECODE(a.YBLB00,'0','医保项目','1','部分医保','2','非医保','3','非医保','非医保') YBLB, DECODE(a.SFYBXM,'Y','医保项目','N','非医保项目') SFXM00,a.YBBRLB,a.TZBZ00,a.PYSM00 YBPYSM,a.WBSM00 YBWBSM, a.YBMZFP,a.YBZYFP,a.XGRXM0,a.XGRQSJ,0 XGBZ00,decode(a.YBXMMC,'','N',a.BKEA96) BKEA96,a.BKEA96 BKEA961 from VW_BM_YBSFDYXMMCFP a,IC_YBBRLB b where a.sfxmid=? and a.sfyp00='N' and a.ybzxlb=b.ybzxlb and b.yblb00=b.ybzxlb and nvl(b.SFYX00,'1')='1' order by decode(a.fbbh00,3,0,a.fbbh00),b.YBMC00
34 11:08:38 SQL Execute: ORACLE - insert into BM_SFDJBZ(SFBZID, SFXMID, SFYP00, SFBZDJ) select SQ_BM_SFDJBZ_SFBZID.nextval, 8000036895, 'N', b.SFBZDJ from (select distinct SFBZDJ from XT_YYXX00) b where b.SFBZDJ <> '0' and not exists (select 1 from BM_SFDJBZ where SFXMID=8000036895 and SFBZDJ = b.SFBZDJ )
35 11:08:38 SQL Data In: ORACLE - Rows affected = 0
36 11:08:38 SQL Execute: ORACLE - Commit
37 11:08:38 SQL Data In: ORACLE - Rows affected = 0
38 11:08:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000036895
39 11:08:38 SQL Execute: ORACLE - select a.SFXMID, a.SFBZDJ, a.DJSFJE, a.DJBZ00 from BM_SFDJBZ a where a.SFBZDJ <> '0' and a.SFXMID = ?
40 11:08:38 SQL Execute: ORACLE - insert into BM_YBDJSX(DJSXID, SFXMID, SFYP00, SFBZDJ, YBZXLB) select SQ_BM_YBDJSX_DJSXID.nextval, 8000036895, 'N', c.SFBZDJ, b.YBZXLB from IC_YBBRLB b, (select distinct SFBZDJ from XT_YYXX00) c where b.YBLB00=b.YBZXLB and c.SFBZDJ <> '0' and not exists (select 1 from BM_YBDJSX where SFXMID=8000036895 )
41 11:08:38 SQL Data In: ORACLE - Rows affected = 0
42 11:08:38 SQL Execute: ORACLE - Commit
43 11:08:38 SQL Data In: ORACLE - Rows affected = 0
44 11:08:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000036895
45 11:08:38 SQL Execute: ORACLE - select a.SFXMID, a.SFBZDJ, a.DJSFSX, b.YBMC00, a.YBZXLB from BM_YBDJSX a,IC_YBBRLB b where a.SFYP00='N' and a.YBZXLB=b.YBZXLB and b.YBLB00=b.YBZXLB and a.SFBZDJ <> '0' and a.SFXMID = ? order by a.SFBZDJ
46 11:08:38 SQL Execute: ORACLE - select a.sfxmid,a.bmbh00,b.xmmc00,c.bmmc00,a.CZY000 from BM_CLSYKS a ,BM_YYSFXM b,BM_BMBM00 c where a.SFXMID = 8000036895 and a.BMBH00 = c.BMBH00 and a.sfxmid = b.sfxmid
47 11:08:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 26, Scale = 0, Data = 一次性使用引流管(200支/箱)
48 11:08:40 SQL Execute: ORACLE - select SF_XT_GETPYSM(?) SM from dual
49 11:08:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 26, Scale = 0, Data = 一次性使用引流管(200支/箱)
50 11:08:40 SQL Execute: ORACLE - select SF_XT_GETWBSM(?) SM from dual
51 11:08:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000041214
52 11:08:45 SQL Execute: ORACLE - select G.SFXMID,G.ZLXMID,S.XMMC00,Z.ZLXMJC,Z.ZLXMBH,G.GXID00,Z.SFYXSQ,Z.DJ0000,Z.BZ0000,S.GJYLBM,Z.SFTY00,Z.TZRQ00,Z.QYRQ00
from XT_ZLSFGX G,VW_XM_ZLZD00 Z,BM_YYSFXM S
where G.ZLXMID=Z.ZLXMID and G.SFXMID=S.SFXMID
and G.SFXMID=?
53 11:08:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000041214
54 11:08:45 SQL Execute: ORACLE - select a.SFXMID, a.SFBZDJ, a.DJSFJE, a.DJBZ00, b.YYJC00 from BM_SFDJBZ a, XT_YYXX00 b
where a.SFBZDJ = b.SFBZDJ and b.SFBZDJ <> '0' and a.SFXMID = ?
55 11:08:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000041214
56 11:08:45 SQL Execute: ORACLE - select c.YYJC00, b.YBMC00, a.SFXMID, a.SFYP00, a.SFBZDJ, a.YBZXLB, a.DJSFSX from BM_YBDJSX a,IC_YBBRLB b,XT_YYXX00 c
where a.SFBZDJ = c.SFBZDJ and a.sfxmid=? and a.sfyp00='N' and c.SFBZDJ <> '0' and a.ybzxlb=b.ybzxlb and b.yblb00=b.ybzxlb
order by c.YYJC00
57 11:08:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000041214
58 11:08:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000041214
59 11:08:45 SQL Execute: ORACLE - select (select SCCJZW from BM_YPSCCJ where SCCJBH=B.SCCJBH) as SCCJZW,
(select GHDWMC from BM_YPGHDW where GHDWNM=B.GHDWNM) as GHDWMC,YPBM00,ypmc00,YPGG00,KCDW00,
LSJ000,TXM000,a.SFXMID,b.GJJ000,a.YPNM00,b.WZXH00,
(select MC0000 from BM_TYZD00 where ZDMC00='物资维护-物资属性' and LBBZ00='0' and BH0000=a.WZSX00 and rownum=1) as WZSXMC
from BM_WZQTXX a, BM_YD0000 b where a.YPNM00=b.YPNM00
and b.LBBH00='9' and a.SFXMID=?
union
select (select SCCJZW from BM_YPSCCJ where SCCJBH=B.SCCJBH) as SCCJZW,
(select GHDWMC from BM_YPGHDW where GHDWNM=B.GHDWNM) as GHDWMC,YPBM00,YPMC00,YPGG00,KCDW00,
LSJ000,TXM000,a.SFXMID,b.GJJ000,a.YPNM00,b.WZXH00,
(select MC0000 from BM_WZQTXX aa,BM_TYZD00 bb where aa.YPNM00=a.YPNM00 and bb.ZDMC00='物资维护-物资属性' and bb.LBBZ00='0' and bb.BH0000=aa.WZSX00 and rownum=1) as WZSXMC
from BM_WZSFDY a, BM_YD0000 b where a.YPNM00=b.YPNM00
and b.LBBH00='9' and a.SFXMID=?
60 11:08:46 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='材料价表项目可选项维护' and MC0000='门诊发票' and YXBZ00='1'
61 11:08:46 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='材料价表项目可选项维护' and MC0000='住院发票' and YXBZ00='1'
62 11:08:46 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='材料价表项目可选项维护' and MC0000='核算项目' and YXBZ00='1'
63 11:08:46 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='材料价表项目可选项维护' and MC0000='病案项目' and YXBZ00='1'
64 11:08:46 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='材料价表项目可选项维护' and MC0000='会计核算' and YXBZ00='1'
65 11:08:46 SQL Execute: ORACLE - select xmmc00 from BM_YYSFXM where bmgzid=1 and flag00='0' and TREEBH like '950009%'
66 11:08:46 SQL Execute: ORACLE - select XMNH00 from BM_YYSFXM where SFXMID=8000041214
67 11:08:46 SQL Execute: ORACLE - select LSCL00 from BM_YYSFXM where SFXMID=8000041214
68 11:08:46 SQL Execute: ORACLE - select BZ0000 from BM_YYSFXM where SFXMID=8000041214
69 11:08:46 SQL Execute: ORACLE - select FWCC00 from BM_YYSFXM where SFXMID=8000041214
70 11:08:46 SQL Execute: ORACLE - select JGGC00 from BM_YYSFXM where SFXMID=8000041214
71 11:08:46 SQL Execute: ORACLE - select zjbz00 from bm_yysfxm where TREEBH='950009' and BMGZID=1
72 11:08:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 950009000021
73 11:08:46 SQL Execute: ORACLE - select sfxmid from bm_yysfxm where BMGZID=1 and bh0000=?
74 11:08:46 SQL Execute: ORACLE - insert into BM_YBSFDY(SFXMID,SFYP00,YBZXLB,FBBH00,ZFBL00,ZYZFBL,YBLB00,SFYBXM,CJR000) select 8000041214,'N',a.YBZXLB,a.FBBH00,decode(a.FBBH00,1,1,3,1,MRZFBL),decode(a.FBBH00,1,1,3,1,ZYZFBL),decode(a.FBBH00,1,'2',3,'2',decode(MRZFBL,1,'2','0')),decode(a.FBBH00,1,'N',3,'N',decode(MRZFBL,1,'N','Y')),1913 from IC_YBBRLB a where a.YBLB00=a.YBZXLB and not exists (select 1 from BM_YBSFDY where SFXMID=8000041214 and FBBH00=a.FBBH00 and YBZXLB=a.YBZXLB and SFYP00='N')
75 11:08:46 SQL Data In: ORACLE - Rows affected = 0
76 11:08:46 SQL Execute: ORACLE - Commit
77 11:08:46 SQL Data In: ORACLE - Rows affected = 0
78 11:08:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000041214
79 11:08:46 SQL Execute: ORACLE - select 'Y' SFXZ00,b.ybmc00,a.FBBH00,a.SFXMID,a.SFYP00,a.YBZXLB,a.YBXMBH,a.YBXMMC XMMC00, a.ZFBL00,a.ZYZFBL,a.YBLB00,a.SFYBXM,a.ZYFPXM ZYFPMC,a.MZFPXM MZFPMC, DECODE(a.YBLB00,'0','医保项目','1','部分医保','2','非医保','3','非医保','非医保') YBLB, DECODE(a.SFYBXM,'Y','医保项目','N','非医保项目') SFXM00,a.YBBRLB,a.TZBZ00,a.PYSM00 YBPYSM,a.WBSM00 YBWBSM, a.YBMZFP,a.YBZYFP,a.XGRXM0,a.XGRQSJ,0 XGBZ00,decode(a.YBXMMC,'','N',a.BKEA96) BKEA96,a.BKEA96 BKEA961 from VW_BM_YBSFDYXMMCFP a,IC_YBBRLB b where a.sfxmid=? and a.sfyp00='N' and a.ybzxlb=b.ybzxlb and b.yblb00=b.ybzxlb and nvl(b.SFYX00,'1')='1' order by decode(a.fbbh00,3,0,a.fbbh00),b.YBMC00
80 11:08:46 SQL Execute: ORACLE - insert into BM_SFDJBZ(SFBZID, SFXMID, SFYP00, SFBZDJ) select SQ_BM_SFDJBZ_SFBZID.nextval, 8000041214, 'N', b.SFBZDJ from (select distinct SFBZDJ from XT_YYXX00) b where b.SFBZDJ <> '0' and not exists (select 1 from BM_SFDJBZ where SFXMID=8000041214 and SFBZDJ = b.SFBZDJ )
81 11:08:46 SQL Data In: ORACLE - Rows affected = 0
82 11:08:46 SQL Execute: ORACLE - Commit
83 11:08:46 SQL Data In: ORACLE - Rows affected = 0
84 11:08:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000041214
85 11:08:46 SQL Execute: ORACLE - select a.SFXMID, a.SFBZDJ, a.DJSFJE, a.DJBZ00 from BM_SFDJBZ a where a.SFBZDJ <> '0' and a.SFXMID = ?
86 11:08:46 SQL Execute: ORACLE - insert into BM_YBDJSX(DJSXID, SFXMID, SFYP00, SFBZDJ, YBZXLB) select SQ_BM_YBDJSX_DJSXID.nextval, 8000041214, 'N', c.SFBZDJ, b.YBZXLB from IC_YBBRLB b, (select distinct SFBZDJ from XT_YYXX00) c where b.YBLB00=b.YBZXLB and c.SFBZDJ <> '0' and not exists (select 1 from BM_YBDJSX where SFXMID=8000041214 )
87 11:08:46 SQL Data In: ORACLE - Rows affected = 0
88 11:08:46 SQL Execute: ORACLE - Commit
89 11:08:46 SQL Data In: ORACLE - Rows affected = 0
90 11:08:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000041214
91 11:08:46 SQL Execute: ORACLE - select a.SFXMID, a.SFBZDJ, a.DJSFSX, b.YBMC00, a.YBZXLB from BM_YBDJSX a,IC_YBBRLB b where a.SFYP00='N' and a.YBZXLB=b.YBZXLB and b.YBLB00=b.YBZXLB and a.SFBZDJ <> '0' and a.SFXMID = ? order by a.SFBZDJ
92 11:08:46 SQL Execute: ORACLE - select a.sfxmid,a.bmbh00,b.xmmc00,c.bmmc00,a.CZY000 from BM_CLSYKS a ,BM_YYSFXM b,BM_BMBM00 c where a.SFXMID = 8000041214 and a.BMBH00 = c.BMBH00 and a.sfxmid = b.sfxmid
93 11:08:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 33, Scale = 0, Data = 一次性使用引流管(F26[腹腔引流管])
94 11:08:47 SQL Execute: ORACLE - select SF_XT_GETPYSM(?) SM from dual
95 11:08:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 33, Scale = 0, Data = 一次性使用引流管(F26[腹腔引流管])
96 11:08:47 SQL Execute: ORACLE - select SF_XT_GETWBSM(?) SM from dual
97 11:08:52 SQL Execute: ORACLE - select xmmc00,zfbl00,ypjx00,YPGG00,SCCJ00,XMBH00,YBBRLB,PYSM00,WBSM00,ybbz00 from VW_BM_YBSFXM_YBXM00 where (PYSM00 Like '%%') and ( (sfyx00='Y') and (flag00='1') and (FBBH00=3) and (ybzxlb='2') and (MZFPXM<>'01' and MZFPXM<>'02' and MZFPXM<>'03' ) ) and Rownum<=999
98 11:08:54 SQL Execute: ORACLE - select xmmc00,zfbl00,ypjx00,YPGG00,SCCJ00,XMBH00,YBBRLB,PYSM00,WBSM00,ybbz00 from VW_BM_YBSFXM_YBXM00 where (PYSM00 Like '%c1417140000000003819%') and ( (sfyx00='Y') and (flag00='1') and (FBBH00=3) and (ybzxlb='2') and (MZFPXM<>'01' and MZFPXM<>'02' and MZFPXM<>'03' ) ) and Rownum<=999
99 11:09:06 SQL Execute: ORACLE - select xmmc00,zfbl00,ypjx00,YPGG00,SCCJ00,XMBH00,YBBRLB,PYSM00,WBSM00,ybbz00 from VW_BM_YBSFXM_YBXM00 where (XMBHXX Like '%c1417140000000003819%') and ( (sfyx00='Y') and (flag00='1') and (FBBH00=3) and (ybzxlb='2') and (MZFPXM<>'01' and MZFPXM<>'02' and MZFPXM<>'03' ) ) and Rownum<=999
100 11:09:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3
101 11:09:11 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
102 11:09:11 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = C1417140000000003819
103 11:09:11 SQL Execute: ORACLE - select zyfpxm,zymc00,mzmc00,mzfpxm,zfbl00,ZYZFBL,sfybxm,yblb00,(select yblbmc from bm_yblb00 where yblb00=a.yblb00) yblbmc
from VW_BM_YBSFFPXMGL a
where FBBH00=? and ybzxlb=? and rtrim(ltrim(xmbh00))=?
104 11:09:17 SQL Execute: ORACLE - select aa.* from (
select a.XMBH00,a.XMMC00,a.BZ0000,a.ZFBL00,a.ZFBL00 ZYZFBL,a.SFYBXM,a.YBLB00,a.MZFPXM,a.ZYFPXM,a.YPGG00,1 XH0000 from BM_YBSFXM a where a.YBZXLB='4' and a.XMBH00='C1417140000000003819'
union all
select a.XMBH00,a.XMMC00,a.BZ0000,a.ZFBL00,a.ZFBL00 ZYZFBL,a.SFYBXM,a.YBLB00,a.MZFPXM,a.ZYFPXM,a.YPGG00,2 XH0000 from BM_YBSFXM a where a.YBZXLB='4' and a.XMBH00='700000000004'
) aa order by aa.XH0000
105 11:09:17 SQL Execute: ORACLE - select XMMC00 from BM_YBFPXM where YBZXLB='4' and BH0000='21'
106 11:09:17 SQL Execute: ORACLE - select XMMC00 from BM_YBFPXM where YBZXLB='4' and BH0000='21'
107 11:09:17 SQL Execute: ORACLE - select aa.* from (
select a.XMBH00,a.XMMC00,a.BZ0000,a.ZFBL00,a.ZFBL00 ZYZFBL,a.SFYBXM,a.YBLB00,a.MZFPXM,a.ZYFPXM,a.YPGG00,1 XH0000 from BM_YBSFXM a where a.YBZXLB='3' and a.XMBH00='C1417140000000003819'
union all
select a.XMBH00,a.XMMC00,a.BZ0000,a.ZFBL00,a.ZFBL00 ZYZFBL,a.SFYBXM,a.YBLB00,a.MZFPXM,a.ZYFPXM,a.YPGG00,2 XH0000 from BM_YBSFXM a where a.YBZXLB='3' and a.XMBH00='700000000004'
) aa order by aa.XH0000
108 11:09:17 SQL Execute: ORACLE - select XMMC00 from BM_YBFPXM where YBZXLB='3' and BH0000='21'
109 11:09:17 SQL Execute: ORACLE - select XMMC00 from BM_YBFPXM where YBZXLB='3' and BH0000='21'
110 11:09:17 SQL Execute: ORACLE - select aa.* from (
select a.XMBH00,a.XMMC00,a.BZ0000,a.ZFBL00,a.ZFBL00 ZYZFBL,a.SFYBXM,a.YBLB00,a.MZFPXM,a.ZYFPXM,a.YPGG00,1 XH0000 from BM_YBSFXM a where a.YBZXLB='@' and a.XMBH00='C1417140000000003819'
union all
select a.XMBH00,a.XMMC00,a.BZ0000,a.ZFBL00,a.ZFBL00 ZYZFBL,a.SFYBXM,a.YBLB00,a.MZFPXM,a.ZYFPXM,a.YPGG00,2 XH0000 from BM_YBSFXM a where a.YBZXLB='@' and a.XMBH00='700000000004'
) aa order by aa.XH0000
111 11:09:17 SQL Execute: ORACLE - select XMMC00 from BM_YBFPXM where YBZXLB='@' and BH0000='21'
112 11:09:17 SQL Execute: ORACLE - select XMMC00 from BM_YBFPXM where YBZXLB='@' and BH0000='21'
113 11:09:17 SQL Execute: ORACLE - select aa.* from (
select a.XMBH00,a.XMMC00,a.BZ0000,a.ZFBL00,a.ZFBL00 ZYZFBL,a.SFYBXM,a.YBLB00,a.MZFPXM,a.ZYFPXM,a.YPGG00,1 XH0000 from BM_YBSFXM a where a.YBZXLB='2' and a.XMBH00='C1417140000000003819'
union all
select a.XMBH00,a.XMMC00,a.BZ0000,a.ZFBL00,a.ZFBL00 ZYZFBL,a.SFYBXM,a.YBLB00,a.MZFPXM,a.ZYFPXM,a.YPGG00,2 XH0000 from BM_YBSFXM a where a.YBZXLB='2' and a.XMBH00='700000000004'
) aa order by aa.XH0000
114 11:09:17 SQL Execute: ORACLE - select XMMC00 from BM_YBFPXM where YBZXLB='2' and BH0000='13'
115 11:09:17 SQL Execute: ORACLE - select XMMC00 from BM_YBFPXM where YBZXLB='2' and BH0000='13'
116 11:09:17 SQL Execute: ORACLE - select aa.* from (
select a.XMBH00,a.XMMC00,a.BZ0000,a.ZFBL00,a.ZFBL00 ZYZFBL,a.SFYBXM,a.YBLB00,a.MZFPXM,a.ZYFPXM,a.YPGG00,1 XH0000 from BM_YBSFXM a where a.YBZXLB='1' and a.XMBH00='C1417140000000003819'
union all
select a.XMBH00,a.XMMC00,a.BZ0000,a.ZFBL00,a.ZFBL00 ZYZFBL,a.SFYBXM,a.YBLB00,a.MZFPXM,a.ZYFPXM,a.YPGG00,2 XH0000 from BM_YBSFXM a where a.YBZXLB='1' and a.XMBH00='700000000004'
) aa order by aa.XH0000
117 11:09:17 SQL Execute: ORACLE - select XMMC00 from BM_YBFPXM where YBZXLB='1' and BH0000='13'
118 11:09:17 SQL Execute: ORACLE - select XMMC00 from BM_YBFPXM where YBZXLB='1' and BH0000='13'
119 11:09:22 SQL Execute: ORACLE - select lengthb('') from dual
120 11:09:22 SQL Execute: ORACLE - select bh0000 from bm_yysfxm where ltrim(rtrim(bh0000))='950009000021' and bmgzid=1
121 11:09:49 SQL Execute: ORACLE - select lengthb('') from dual
122 11:09:49 SQL Execute: ORACLE - select bh0000 from bm_yysfxm where ltrim(rtrim(bh0000))='950009000021' and bmgzid=1
123 11:09:54 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL
124 11:09:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = U
125 11:09:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = L
126 11:09:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8000041214.000000
127 11:09:54 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
128 11:09:54 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 950009000021
129 11:09:54 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 33, Scale = 0, Data = 一次性使用引流管(F26[腹腔引流管])
130 11:09:54 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = ycxsyylgf2
131 11:09:54 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = gunwexitf2
132 11:09:54 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
133 11:09:54 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
134 11:09:54 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 15, Scale = 0, Data = F26[腹腔引流管]
135 11:09:54 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
136 11:09:54 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
137 11:09:54 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
138 11:09:54 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 根
139 11:09:54 SQL Data In: ORACLE - Param = 16, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15.000000
140 11:09:54 SQL Data In: ORACLE - Param = 17, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15.000000
141 11:09:54 SQL Data In: ORACLE - Param = 18, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
142 11:09:54 SQL Data In: ORACLE - Param = 19, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15.000000
143 11:09:54 SQL Data In: ORACLE - Param = 20, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15.000000
144 11:09:54 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 13
145 11:09:54 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 13
146 11:09:54 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20251218
147 11:09:54 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 48: :
148 11:09:54 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3
149 11:09:54 SQL Data In: ORACLE - Param = 26, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 130.000000
150 11:09:54 SQL Data In: ORACLE - Param = 27, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 124
151 11:09:54 SQL Data In: ORACLE - Param = 28, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
152 11:09:54 SQL Data In: ORACLE - Param = 29, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
153 11:09:54 SQL Data In: ORACLE - Param = 30, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 950009
154 11:09:54 SQL Data In: ORACLE - Param = 31, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
155 11:09:54 SQL Data In: ORACLE - Param = 32, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
156 11:09:54 SQL Data In: ORACLE - Param = 33, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
157 11:09:54 SQL Data In: ORACLE - Param = 34, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
158 11:09:54 SQL Data In: ORACLE - Param = 35, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 950009
159 11:09:54 SQL Data In: ORACLE - Param = 36, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000
160 11:09:54 SQL Data In: ORACLE - Param = 37, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 121
161 11:09:54 SQL Data In: ORACLE - Param = 38, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
162 11:09:54 SQL Data In: ORACLE - Param = 39, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
163 11:09:54 SQL Data In: ORACLE - Param = 40, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
164 11:09:54 SQL Data In: ORACLE - Param = 41, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
165 11:09:54 SQL Data In: ORACLE - Param = 42, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
166 11:09:54 SQL Data In: ORACLE - Param = 43, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
167 11:09:54 SQL Data In: ORACLE - Param = 44, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
168 11:09:54 SQL Data In: ORACLE - Param = 45, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
169 11:09:54 SQL Data In: ORACLE - Param = 46, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = C1417140000000003819
170 11:09:54 SQL Data In: ORACLE - Param = 47, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 一次性使用引流管
171 11:09:54 SQL Data In: ORACLE - Param = 48, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
172 11:09:54 SQL Data In: ORACLE - Param = 49, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
173 11:09:54 SQL Data In: ORACLE - Param = 50, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
174 11:09:54 SQL Data In: ORACLE - Param = 51, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
175 11:09:54 SQL Data In: ORACLE - Param = 52, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
176 11:09:54 SQL Data In: ORACLE - Param = 53, Name = , Type = fldZSTRING, Precision = 52, Scale = 0, Data = 0
177 11:09:54 SQL Execute: ORACLE - BEGIN "SP_XM_YYWHADD" (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?); END;
178 11:09:54 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
179 11:09:54 SQL Data In: ORACLE - Param = 2, Name = PSFYP00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
180 11:09:54 SQL Data In: ORACLE - Param = 3, Name = PSFXMID, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000041214
181 11:09:54 SQL Data In: ORACLE - Param = 4, Name = PFBBH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3
182 11:09:54 SQL Data In: ORACLE - Param = 5, Name = PYBZXLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4
183 11:09:54 SQL Data In: ORACLE - Param = 6, Name = PYBXMBH, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 700000000004
184 11:09:54 SQL Data In: ORACLE - Param = 7, Name = PZFBL00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
185 11:09:54 SQL Data In: ORACLE - Param = 8, Name = PSFYBXM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
186 11:09:54 SQL Data In: ORACLE - Param = 9, Name = PYBLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
187 11:09:54 SQL Data In: ORACLE - Param = 10, Name = PYBBRLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z
188 11:09:54 SQL Data In: ORACLE - Param = 11, Name = PYBMZFP, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 21
189 11:09:54 SQL Data In: ORACLE - Param = 12, Name = PYBZYFP, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 21
190 11:09:54 SQL Data In: ORACLE - Param = 13, Name = PZFJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
191 11:09:54 SQL Data In: ORACLE - Param = 14, Name = PJMBL00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
192 11:09:54 SQL Data In: ORACLE - Param = 15, Name = PJMJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
193 11:09:54 SQL Data In: ORACLE - Param = 16, Name = PSFSX00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
194 11:09:54 SQL Data In: ORACLE - Param = 17, Name = PYBBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
195 11:09:54 SQL Data In: ORACLE - Param = 18, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1913
196 11:09:54 SQL Data In: ORACLE - Param = 19, Name = PCZYKS0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 464
197 11:09:54 SQL Data In: ORACLE - Param = 20, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
198 11:09:54 SQL Data In: ORACLE - Param = 21, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
199 11:09:54 SQL Data In: ORACLE - Param = 22, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
200 11:09:54 SQL Data In: ORACLE - Param = 23, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
201 11:09:54 SQL Data In: ORACLE - Param = 24, Name = PZYZFBL, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
202 11:09:54 SQL Data In: ORACLE - Param = 25, Name = PBKEA96, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
203 11:09:54 SQL Execute: ORACLE - BEGIN "SP_BM_YBSFDY_EDIT" (POPFLAG => :POPFLAG,PSFYP00 => :PSFYP00,PSFXMID => :PSFXMID,PFBBH00 => :PFBBH00,PYBZXLB => :PYBZXLB,PYBXMBH => :PYBXMBH,PZFBL00 => :PZFBL00,PSFYBXM => :PSFYBXM,PYBLB00 => :PYBLB00,PYBBRLB => :PYBBRLB,PYBMZFP => :PYBMZFP,PYBZYFP => :PYBZYFP,PZFJE00 => :PZFJE00,PJMBL00 => :PJMBL00,PJMJE00 => :PJMJE00,PSFSX00 => :PSFSX00,PYBBZ00 => :PYBBZ00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PZYZFBL => :PZYZFBL,PBKEA96 => :PBKEA96); END;
204 11:09:54 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
205 11:09:54 SQL Data In: ORACLE - Param = 2, Name = PSFYP00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
206 11:09:54 SQL Data In: ORACLE - Param = 3, Name = PSFXMID, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000041214
207 11:09:54 SQL Data In: ORACLE - Param = 4, Name = PFBBH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3
208 11:09:54 SQL Data In: ORACLE - Param = 5, Name = PYBZXLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3
209 11:09:54 SQL Data In: ORACLE - Param = 6, Name = PYBXMBH, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 700000000004
210 11:09:54 SQL Data In: ORACLE - Param = 7, Name = PZFBL00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
211 11:09:54 SQL Data In: ORACLE - Param = 8, Name = PSFYBXM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
212 11:09:54 SQL Data In: ORACLE - Param = 9, Name = PYBLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
213 11:09:54 SQL Data In: ORACLE - Param = 10, Name = PYBBRLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z
214 11:09:54 SQL Data In: ORACLE - Param = 11, Name = PYBMZFP, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 21
215 11:09:54 SQL Data In: ORACLE - Param = 12, Name = PYBZYFP, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 21
216 11:09:54 SQL Data In: ORACLE - Param = 13, Name = PZFJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
217 11:09:54 SQL Data In: ORACLE - Param = 14, Name = PJMBL00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
218 11:09:54 SQL Data In: ORACLE - Param = 15, Name = PJMJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
219 11:09:54 SQL Data In: ORACLE - Param = 16, Name = PSFSX00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
220 11:09:54 SQL Data In: ORACLE - Param = 17, Name = PYBBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
221 11:09:54 SQL Data In: ORACLE - Param = 18, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1913
222 11:09:54 SQL Data In: ORACLE - Param = 19, Name = PCZYKS0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 464
223 11:09:54 SQL Data In: ORACLE - Param = 20, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
224 11:09:54 SQL Data In: ORACLE - Param = 21, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
225 11:09:54 SQL Data In: ORACLE - Param = 22, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
226 11:09:54 SQL Data In: ORACLE - Param = 23, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
227 11:09:54 SQL Data In: ORACLE - Param = 24, Name = PZYZFBL, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
228 11:09:54 SQL Data In: ORACLE - Param = 25, Name = PBKEA96, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
229 11:09:54 SQL Execute: ORACLE - BEGIN "SP_BM_YBSFDY_EDIT" (POPFLAG => :POPFLAG,PSFYP00 => :PSFYP00,PSFXMID => :PSFXMID,PFBBH00 => :PFBBH00,PYBZXLB => :PYBZXLB,PYBXMBH => :PYBXMBH,PZFBL00 => :PZFBL00,PSFYBXM => :PSFYBXM,PYBLB00 => :PYBLB00,PYBBRLB => :PYBBRLB,PYBMZFP => :PYBMZFP,PYBZYFP => :PYBZYFP,PZFJE00 => :PZFJE00,PJMBL00 => :PJMBL00,PJMJE00 => :PJMJE00,PSFSX00 => :PSFSX00,PYBBZ00 => :PYBBZ00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PZYZFBL => :PZYZFBL,PBKEA96 => :PBKEA96); END;
230 11:09:54 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
231 11:09:54 SQL Data In: ORACLE - Param = 2, Name = PSFYP00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
232 11:09:54 SQL Data In: ORACLE - Param = 3, Name = PSFXMID, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000041214
233 11:09:54 SQL Data In: ORACLE - Param = 4, Name = PFBBH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3
234 11:09:54 SQL Data In: ORACLE - Param = 5, Name = PYBZXLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = @
235 11:09:54 SQL Data In: ORACLE - Param = 6, Name = PYBXMBH, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 700000000004
236 11:09:54 SQL Data In: ORACLE - Param = 7, Name = PZFBL00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
237 11:09:54 SQL Data In: ORACLE - Param = 8, Name = PSFYBXM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
238 11:09:54 SQL Data In: ORACLE - Param = 9, Name = PYBLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7
239 11:09:54 SQL Data In: ORACLE - Param = 10, Name = PYBBRLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z
240 11:09:54 SQL Data In: ORACLE - Param = 11, Name = PYBMZFP, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 21
241 11:09:54 SQL Data In: ORACLE - Param = 12, Name = PYBZYFP, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 21
242 11:09:54 SQL Data In: ORACLE - Param = 13, Name = PZFJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
243 11:09:54 SQL Data In: ORACLE - Param = 14, Name = PJMBL00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
244 11:09:54 SQL Data In: ORACLE - Param = 15, Name = PJMJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
245 11:09:54 SQL Data In: ORACLE - Param = 16, Name = PSFSX00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
246 11:09:54 SQL Data In: ORACLE - Param = 17, Name = PYBBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
247 11:09:54 SQL Data In: ORACLE - Param = 18, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1913
248 11:09:54 SQL Data In: ORACLE - Param = 19, Name = PCZYKS0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 464
249 11:09:54 SQL Data In: ORACLE - Param = 20, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
250 11:09:54 SQL Data In: ORACLE - Param = 21, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
251 11:09:54 SQL Data In: ORACLE - Param = 22, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
252 11:09:54 SQL Data In: ORACLE - Param = 23, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
253 11:09:54 SQL Data In: ORACLE - Param = 24, Name = PZYZFBL, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
254 11:09:54 SQL Data In: ORACLE - Param = 25, Name = PBKEA96, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
255 11:09:54 SQL Execute: ORACLE - BEGIN "SP_BM_YBSFDY_EDIT" (POPFLAG => :POPFLAG,PSFYP00 => :PSFYP00,PSFXMID => :PSFXMID,PFBBH00 => :PFBBH00,PYBZXLB => :PYBZXLB,PYBXMBH => :PYBXMBH,PZFBL00 => :PZFBL00,PSFYBXM => :PSFYBXM,PYBLB00 => :PYBLB00,PYBBRLB => :PYBBRLB,PYBMZFP => :PYBMZFP,PYBZYFP => :PYBZYFP,PZFJE00 => :PZFJE00,PJMBL00 => :PJMBL00,PJMJE00 => :PJMJE00,PSFSX00 => :PSFSX00,PYBBZ00 => :PYBBZ00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PZYZFBL => :PZYZFBL,PBKEA96 => :PBKEA96); END;
256 11:09:54 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
257 11:09:54 SQL Data In: ORACLE - Param = 2, Name = PSFYP00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
258 11:09:54 SQL Data In: ORACLE - Param = 3, Name = PSFXMID, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000041214
259 11:09:54 SQL Data In: ORACLE - Param = 4, Name = PFBBH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3
260 11:09:54 SQL Data In: ORACLE - Param = 5, Name = PYBZXLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
261 11:09:54 SQL Data In: ORACLE - Param = 6, Name = PYBXMBH, Type = fldZSTRING, Precision = 20, Scale = 0, Data = C1417140000000003819
262 11:09:54 SQL Data In: ORACLE - Param = 7, Name = PZFBL00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 0.15
263 11:09:54 SQL Data In: ORACLE - Param = 8, Name = PSFYBXM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
264 11:09:54 SQL Data In: ORACLE - Param = 9, Name = PYBLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
265 11:09:54 SQL Data In: ORACLE - Param = 10, Name = PYBBRLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z
266 11:09:54 SQL Data In: ORACLE - Param = 11, Name = PYBMZFP, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 13
267 11:09:54 SQL Data In: ORACLE - Param = 12, Name = PYBZYFP, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 13
268 11:09:54 SQL Data In: ORACLE - Param = 13, Name = PZFJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
269 11:09:54 SQL Data In: ORACLE - Param = 14, Name = PJMBL00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
270 11:09:54 SQL Data In: ORACLE - Param = 15, Name = PJMJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
271 11:09:54 SQL Data In: ORACLE - Param = 16, Name = PSFSX00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
272 11:09:54 SQL Data In: ORACLE - Param = 17, Name = PYBBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
273 11:09:54 SQL Data In: ORACLE - Param = 18, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1913
274 11:09:54 SQL Data In: ORACLE - Param = 19, Name = PCZYKS0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 464
275 11:09:54 SQL Data In: ORACLE - Param = 20, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
276 11:09:54 SQL Data In: ORACLE - Param = 21, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
277 11:09:54 SQL Data In: ORACLE - Param = 22, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
278 11:09:54 SQL Data In: ORACLE - Param = 23, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
279 11:09:54 SQL Data In: ORACLE - Param = 24, Name = PZYZFBL, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 0.15
280 11:09:54 SQL Data In: ORACLE - Param = 25, Name = PBKEA96, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
281 11:09:54 SQL Execute: ORACLE - BEGIN "SP_BM_YBSFDY_EDIT" (POPFLAG => :POPFLAG,PSFYP00 => :PSFYP00,PSFXMID => :PSFXMID,PFBBH00 => :PFBBH00,PYBZXLB => :PYBZXLB,PYBXMBH => :PYBXMBH,PZFBL00 => :PZFBL00,PSFYBXM => :PSFYBXM,PYBLB00 => :PYBLB00,PYBBRLB => :PYBBRLB,PYBMZFP => :PYBMZFP,PYBZYFP => :PYBZYFP,PZFJE00 => :PZFJE00,PJMBL00 => :PJMBL00,PJMJE00 => :PJMJE00,PSFSX00 => :PSFSX00,PYBBZ00 => :PYBBZ00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PZYZFBL => :PZYZFBL,PBKEA96 => :PBKEA96); END;
282 11:09:54 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
283 11:09:54 SQL Data In: ORACLE - Param = 2, Name = PSFYP00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
284 11:09:54 SQL Data In: ORACLE - Param = 3, Name = PSFXMID, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000041214
285 11:09:54 SQL Data In: ORACLE - Param = 4, Name = PFBBH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3
286 11:09:54 SQL Data In: ORACLE - Param = 5, Name = PYBZXLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
287 11:09:54 SQL Data In: ORACLE - Param = 6, Name = PYBXMBH, Type = fldZSTRING, Precision = 20, Scale = 0, Data = C1417140000000003819
288 11:09:54 SQL Data In: ORACLE - Param = 7, Name = PZFBL00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 0.15
289 11:09:54 SQL Data In: ORACLE - Param = 8, Name = PSFYBXM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
290 11:09:54 SQL Data In: ORACLE - Param = 9, Name = PYBLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
291 11:09:54 SQL Data In: ORACLE - Param = 10, Name = PYBBRLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z
292 11:09:54 SQL Data In: ORACLE - Param = 11, Name = PYBMZFP, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 13
293 11:09:54 SQL Data In: ORACLE - Param = 12, Name = PYBZYFP, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 13
294 11:09:54 SQL Data In: ORACLE - Param = 13, Name = PZFJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
295 11:09:54 SQL Data In: ORACLE - Param = 14, Name = PJMBL00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
296 11:09:54 SQL Data In: ORACLE - Param = 15, Name = PJMJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
297 11:09:54 SQL Data In: ORACLE - Param = 16, Name = PSFSX00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
298 11:09:54 SQL Data In: ORACLE - Param = 17, Name = PYBBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
299 11:09:54 SQL Data In: ORACLE - Param = 18, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1913
300 11:09:54 SQL Data In: ORACLE - Param = 19, Name = PCZYKS0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 464
301 11:09:54 SQL Data In: ORACLE - Param = 20, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
302 11:09:54 SQL Data In: ORACLE - Param = 21, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
303 11:09:54 SQL Data In: ORACLE - Param = 22, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
304 11:09:54 SQL Data In: ORACLE - Param = 23, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
305 11:09:54 SQL Data In: ORACLE - Param = 24, Name = PZYZFBL, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 0.15
306 11:09:54 SQL Data In: ORACLE - Param = 25, Name = PBKEA96, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
307 11:09:54 SQL Execute: ORACLE - BEGIN "SP_BM_YBSFDY_EDIT" (POPFLAG => :POPFLAG,PSFYP00 => :PSFYP00,PSFXMID => :PSFXMID,PFBBH00 => :PFBBH00,PYBZXLB => :PYBZXLB,PYBXMBH => :PYBXMBH,PZFBL00 => :PZFBL00,PSFYBXM => :PSFYBXM,PYBLB00 => :PYBLB00,PYBBRLB => :PYBBRLB,PYBMZFP => :PYBMZFP,PYBZYFP => :PYBZYFP,PZFJE00 => :PZFJE00,PJMBL00 => :PJMBL00,PJMJE00 => :PJMJE00,PSFSX00 => :PSFSX00,PYBBZ00 => :PYBBZ00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PZYZFBL => :PZYZFBL,PBKEA96 => :PBKEA96); END;
308 11:09:54 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
309 11:09:54 SQL Data In: ORACLE - Param = 2, Name = PSFYP00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
310 11:09:54 SQL Data In: ORACLE - Param = 3, Name = PSFXMID, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000041214
311 11:09:54 SQL Data In: ORACLE - Param = 4, Name = PFBBH00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 14
312 11:09:54 SQL Data In: ORACLE - Param = 5, Name = PYBZXLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9
313 11:09:54 SQL Data In: ORACLE - Param = 6, Name = PYBXMBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
314 11:09:54 SQL Data In: ORACLE - Param = 7, Name = PZFBL00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
315 11:09:54 SQL Data In: ORACLE - Param = 8, Name = PSFYBXM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
316 11:09:54 SQL Data In: ORACLE - Param = 9, Name = PYBLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
317 11:09:54 SQL Data In: ORACLE - Param = 10, Name = PYBBRLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z
318 11:09:54 SQL Data In: ORACLE - Param = 11, Name = PYBMZFP, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
319 11:09:54 SQL Data In: ORACLE - Param = 12, Name = PYBZYFP, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
320 11:09:54 SQL Data In: ORACLE - Param = 13, Name = PZFJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
321 11:09:54 SQL Data In: ORACLE - Param = 14, Name = PJMBL00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
322 11:09:54 SQL Data In: ORACLE - Param = 15, Name = PJMJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
323 11:09:54 SQL Data In: ORACLE - Param = 16, Name = PSFSX00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
324 11:09:54 SQL Data In: ORACLE - Param = 17, Name = PYBBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
325 11:09:54 SQL Data In: ORACLE - Param = 18, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1913
326 11:09:54 SQL Data In: ORACLE - Param = 19, Name = PCZYKS0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 464
327 11:09:54 SQL Data In: ORACLE - Param = 20, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
328 11:09:54 SQL Data In: ORACLE - Param = 21, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
329 11:09:54 SQL Data In: ORACLE - Param = 22, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
330 11:09:54 SQL Data In: ORACLE - Param = 23, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
331 11:09:54 SQL Data In: ORACLE - Param = 24, Name = PZYZFBL, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
332 11:09:54 SQL Data In: ORACLE - Param = 25, Name = PBKEA96, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
333 11:09:54 SQL Execute: ORACLE - BEGIN "SP_BM_YBSFDY_EDIT" (POPFLAG => :POPFLAG,PSFYP00 => :PSFYP00,PSFXMID => :PSFXMID,PFBBH00 => :PFBBH00,PYBZXLB => :PYBZXLB,PYBXMBH => :PYBXMBH,PZFBL00 => :PZFBL00,PSFYBXM => :PSFYBXM,PYBLB00 => :PYBLB00,PYBBRLB => :PYBBRLB,PYBMZFP => :PYBMZFP,PYBZYFP => :PYBZYFP,PZFJE00 => :PZFJE00,PJMBL00 => :PJMBL00,PJMJE00 => :PJMJE00,PSFSX00 => :PSFSX00,PYBBZ00 => :PYBBZ00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PZYZFBL => :PZYZFBL,PBKEA96 => :PBKEA96); END;
334 11:09:54 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
335 11:09:54 SQL Data In: ORACLE - Param = 2, Name = PSFYP00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
336 11:09:54 SQL Data In: ORACLE - Param = 3, Name = PSFXMID, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000041214
337 11:09:54 SQL Data In: ORACLE - Param = 4, Name = PFBBH00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 15
338 11:09:54 SQL Data In: ORACLE - Param = 5, Name = PYBZXLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = J
339 11:09:54 SQL Data In: ORACLE - Param = 6, Name = PYBXMBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
340 11:09:54 SQL Data In: ORACLE - Param = 7, Name = PZFBL00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
341 11:09:54 SQL Data In: ORACLE - Param = 8, Name = PSFYBXM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
342 11:09:54 SQL Data In: ORACLE - Param = 9, Name = PYBLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
343 11:09:54 SQL Data In: ORACLE - Param = 10, Name = PYBBRLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z
344 11:09:54 SQL Data In: ORACLE - Param = 11, Name = PYBMZFP, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
345 11:09:54 SQL Data In: ORACLE - Param = 12, Name = PYBZYFP, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
346 11:09:54 SQL Data In: ORACLE - Param = 13, Name = PZFJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
347 11:09:54 SQL Data In: ORACLE - Param = 14, Name = PJMBL00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
348 11:09:54 SQL Data In: ORACLE - Param = 15, Name = PJMJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
349 11:09:54 SQL Data In: ORACLE - Param = 16, Name = PSFSX00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
350 11:09:54 SQL Data In: ORACLE - Param = 17, Name = PYBBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
351 11:09:54 SQL Data In: ORACLE - Param = 18, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1913
352 11:09:54 SQL Data In: ORACLE - Param = 19, Name = PCZYKS0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 464
353 11:09:54 SQL Data In: ORACLE - Param = 20, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
354 11:09:54 SQL Data In: ORACLE - Param = 21, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
355 11:09:54 SQL Data In: ORACLE - Param = 22, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
356 11:09:54 SQL Data In: ORACLE - Param = 23, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
357 11:09:54 SQL Data In: ORACLE - Param = 24, Name = PZYZFBL, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
358 11:09:54 SQL Data In: ORACLE - Param = 25, Name = PBKEA96, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
359 11:09:54 SQL Execute: ORACLE - BEGIN "SP_BM_YBSFDY_EDIT" (POPFLAG => :POPFLAG,PSFYP00 => :PSFYP00,PSFXMID => :PSFXMID,PFBBH00 => :PFBBH00,PYBZXLB => :PYBZXLB,PYBXMBH => :PYBXMBH,PZFBL00 => :PZFBL00,PSFYBXM => :PSFYBXM,PYBLB00 => :PYBLB00,PYBBRLB => :PYBBRLB,PYBMZFP => :PYBMZFP,PYBZYFP => :PYBZYFP,PZFJE00 => :PZFJE00,PJMBL00 => :PJMBL00,PJMJE00 => :PJMJE00,PSFSX00 => :PSFSX00,PYBBZ00 => :PYBBZ00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PZYZFBL => :PZYZFBL,PBKEA96 => :PBKEA96); END;
360 11:09:54 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
361 11:09:54 SQL Data In: ORACLE - Param = 2, Name = PSFYP00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
362 11:09:54 SQL Data In: ORACLE - Param = 3, Name = PSFXMID, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000041214
363 11:09:54 SQL Data In: ORACLE - Param = 4, Name = PFBBH00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 15
364 11:09:54 SQL Data In: ORACLE - Param = 5, Name = PYBZXLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = X
365 11:09:54 SQL Data In: ORACLE - Param = 6, Name = PYBXMBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
366 11:09:54 SQL Data In: ORACLE - Param = 7, Name = PZFBL00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
367 11:09:54 SQL Data In: ORACLE - Param = 8, Name = PSFYBXM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
368 11:09:54 SQL Data In: ORACLE - Param = 9, Name = PYBLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
369 11:09:54 SQL Data In: ORACLE - Param = 10, Name = PYBBRLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z
370 11:09:54 SQL Data In: ORACLE - Param = 11, Name = PYBMZFP, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
371 11:09:54 SQL Data In: ORACLE - Param = 12, Name = PYBZYFP, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
372 11:09:54 SQL Data In: ORACLE - Param = 13, Name = PZFJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
373 11:09:54 SQL Data In: ORACLE - Param = 14, Name = PJMBL00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
374 11:09:54 SQL Data In: ORACLE - Param = 15, Name = PJMJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
375 11:09:54 SQL Data In: ORACLE - Param = 16, Name = PSFSX00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
376 11:09:54 SQL Data In: ORACLE - Param = 17, Name = PYBBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
377 11:09:54 SQL Data In: ORACLE - Param = 18, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1913
378 11:09:54 SQL Data In: ORACLE - Param = 19, Name = PCZYKS0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 464
379 11:09:54 SQL Data In: ORACLE - Param = 20, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
380 11:09:54 SQL Data In: ORACLE - Param = 21, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
381 11:09:54 SQL Data In: ORACLE - Param = 22, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
382 11:09:54 SQL Data In: ORACLE - Param = 23, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
383 11:09:54 SQL Data In: ORACLE - Param = 24, Name = PZYZFBL, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
384 11:09:54 SQL Data In: ORACLE - Param = 25, Name = PBKEA96, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
385 11:09:54 SQL Execute: ORACLE - BEGIN "SP_BM_YBSFDY_EDIT" (POPFLAG => :POPFLAG,PSFYP00 => :PSFYP00,PSFXMID => :PSFXMID,PFBBH00 => :PFBBH00,PYBZXLB => :PYBZXLB,PYBXMBH => :PYBXMBH,PZFBL00 => :PZFBL00,PSFYBXM => :PSFYBXM,PYBLB00 => :PYBLB00,PYBBRLB => :PYBBRLB,PYBMZFP => :PYBMZFP,PYBZYFP => :PYBZYFP,PZFJE00 => :PZFJE00,PJMBL00 => :PJMBL00,PJMJE00 => :PJMJE00,PSFSX00 => :PSFSX00,PYBBZ00 => :PYBBZ00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PZYZFBL => :PZYZFBL,PBKEA96 => :PBKEA96); END;
386 11:09:54 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
387 11:09:54 SQL Data In: ORACLE - Param = 2, Name = PSFYP00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
388 11:09:54 SQL Data In: ORACLE - Param = 3, Name = PSFXMID, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000041214
389 11:09:54 SQL Data In: ORACLE - Param = 4, Name = PFBBH00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 16
390 11:09:54 SQL Data In: ORACLE - Param = 5, Name = PYBZXLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5
391 11:09:54 SQL Data In: ORACLE - Param = 6, Name = PYBXMBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
392 11:09:54 SQL Data In: ORACLE - Param = 7, Name = PZFBL00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
393 11:09:54 SQL Data In: ORACLE - Param = 8, Name = PSFYBXM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
394 11:09:54 SQL Data In: ORACLE - Param = 9, Name = PYBLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
395 11:09:54 SQL Data In: ORACLE - Param = 10, Name = PYBBRLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z
396 11:09:54 SQL Data In: ORACLE - Param = 11, Name = PYBMZFP, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
397 11:09:54 SQL Data In: ORACLE - Param = 12, Name = PYBZYFP, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
398 11:09:54 SQL Data In: ORACLE - Param = 13, Name = PZFJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
399 11:09:54 SQL Data In: ORACLE - Param = 14, Name = PJMBL00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
400 11:09:54 SQL Data In: ORACLE - Param = 15, Name = PJMJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
401 11:09:54 SQL Data In: ORACLE - Param = 16, Name = PSFSX00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
402 11:09:54 SQL Data In: ORACLE - Param = 17, Name = PYBBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
403 11:09:54 SQL Data In: ORACLE - Param = 18, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1913
404 11:09:54 SQL Data In: ORACLE - Param = 19, Name = PCZYKS0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 464
405 11:09:54 SQL Data In: ORACLE - Param = 20, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
406 11:09:54 SQL Data In: ORACLE - Param = 21, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
407 11:09:54 SQL Data In: ORACLE - Param = 22, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
408 11:09:54 SQL Data In: ORACLE - Param = 23, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
409 11:09:54 SQL Data In: ORACLE - Param = 24, Name = PZYZFBL, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
410 11:09:54 SQL Data In: ORACLE - Param = 25, Name = PBKEA96, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
411 11:09:54 SQL Execute: ORACLE - BEGIN "SP_BM_YBSFDY_EDIT" (POPFLAG => :POPFLAG,PSFYP00 => :PSFYP00,PSFXMID => :PSFXMID,PFBBH00 => :PFBBH00,PYBZXLB => :PYBZXLB,PYBXMBH => :PYBXMBH,PZFBL00 => :PZFBL00,PSFYBXM => :PSFYBXM,PYBLB00 => :PYBLB00,PYBBRLB => :PYBBRLB,PYBMZFP => :PYBMZFP,PYBZYFP => :PYBZYFP,PZFJE00 => :PZFJE00,PJMBL00 => :PJMBL00,PJMJE00 => :PJMJE00,PSFSX00 => :PSFSX00,PYBBZ00 => :PYBBZ00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PZYZFBL => :PZYZFBL,PBKEA96 => :PBKEA96); END;
412 11:09:54 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
413 11:09:54 SQL Data In: ORACLE - Param = 2, Name = PSFYP00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
414 11:09:54 SQL Data In: ORACLE - Param = 3, Name = PSFXMID, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000041214
415 11:09:54 SQL Data In: ORACLE - Param = 4, Name = PFBBH00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 24
416 11:09:54 SQL Data In: ORACLE - Param = 5, Name = PYBZXLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = c
417 11:09:54 SQL Data In: ORACLE - Param = 6, Name = PYBXMBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
418 11:09:54 SQL Data In: ORACLE - Param = 7, Name = PZFBL00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
419 11:09:54 SQL Data In: ORACLE - Param = 8, Name = PSFYBXM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
420 11:09:54 SQL Data In: ORACLE - Param = 9, Name = PYBLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
421 11:09:54 SQL Data In: ORACLE - Param = 10, Name = PYBBRLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z
422 11:09:54 SQL Data In: ORACLE - Param = 11, Name = PYBMZFP, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
423 11:09:54 SQL Data In: ORACLE - Param = 12, Name = PYBZYFP, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
424 11:09:54 SQL Data In: ORACLE - Param = 13, Name = PZFJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
425 11:09:54 SQL Data In: ORACLE - Param = 14, Name = PJMBL00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
426 11:09:54 SQL Data In: ORACLE - Param = 15, Name = PJMJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
427 11:09:54 SQL Data In: ORACLE - Param = 16, Name = PSFSX00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
428 11:09:54 SQL Data In: ORACLE - Param = 17, Name = PYBBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
429 11:09:54 SQL Data In: ORACLE - Param = 18, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1913
430 11:09:54 SQL Data In: ORACLE - Param = 19, Name = PCZYKS0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 464
431 11:09:54 SQL Data In: ORACLE - Param = 20, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
432 11:09:54 SQL Data In: ORACLE - Param = 21, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
433 11:09:54 SQL Data In: ORACLE - Param = 22, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
434 11:09:54 SQL Data In: ORACLE - Param = 23, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
435 11:09:54 SQL Data In: ORACLE - Param = 24, Name = PZYZFBL, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
436 11:09:54 SQL Data In: ORACLE - Param = 25, Name = PBKEA96, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
437 11:09:54 SQL Execute: ORACLE - BEGIN "SP_BM_YBSFDY_EDIT" (POPFLAG => :POPFLAG,PSFYP00 => :PSFYP00,PSFXMID => :PSFXMID,PFBBH00 => :PFBBH00,PYBZXLB => :PYBZXLB,PYBXMBH => :PYBXMBH,PZFBL00 => :PZFBL00,PSFYBXM => :PSFYBXM,PYBLB00 => :PYBLB00,PYBBRLB => :PYBBRLB,PYBMZFP => :PYBMZFP,PYBZYFP => :PYBZYFP,PZFJE00 => :PZFJE00,PJMBL00 => :PJMBL00,PJMJE00 => :PJMJE00,PSFSX00 => :PSFSX00,PYBBZ00 => :PYBBZ00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PZYZFBL => :PZYZFBL,PBKEA96 => :PBKEA96); END;
438 11:09:54 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
439 11:09:54 SQL Data In: ORACLE - Param = 2, Name = PSFYP00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
440 11:09:54 SQL Data In: ORACLE - Param = 3, Name = PSFXMID, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000041214
441 11:09:54 SQL Data In: ORACLE - Param = 4, Name = PFBBH00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 32
442 11:09:54 SQL Data In: ORACLE - Param = 5, Name = PYBZXLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = <
443 11:09:54 SQL Data In: ORACLE - Param = 6, Name = PYBXMBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
444 11:09:54 SQL Data In: ORACLE - Param = 7, Name = PZFBL00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
445 11:09:54 SQL Data In: ORACLE - Param = 8, Name = PSFYBXM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
446 11:09:54 SQL Data In: ORACLE - Param = 9, Name = PYBLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
447 11:09:54 SQL Data In: ORACLE - Param = 10, Name = PYBBRLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z
448 11:09:54 SQL Data In: ORACLE - Param = 11, Name = PYBMZFP, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
449 11:09:54 SQL Data In: ORACLE - Param = 12, Name = PYBZYFP, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
450 11:09:54 SQL Data In: ORACLE - Param = 13, Name = PZFJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
451 11:09:54 SQL Data In: ORACLE - Param = 14, Name = PJMBL00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
452 11:09:54 SQL Data In: ORACLE - Param = 15, Name = PJMJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
453 11:09:54 SQL Data In: ORACLE - Param = 16, Name = PSFSX00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
454 11:09:54 SQL Data In: ORACLE - Param = 17, Name = PYBBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
455 11:09:54 SQL Data In: ORACLE - Param = 18, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1913
456 11:09:54 SQL Data In: ORACLE - Param = 19, Name = PCZYKS0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 464
457 11:09:54 SQL Data In: ORACLE - Param = 20, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
458 11:09:54 SQL Data In: ORACLE - Param = 21, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
459 11:09:54 SQL Data In: ORACLE - Param = 22, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
460 11:09:54 SQL Data In: ORACLE - Param = 23, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
461 11:09:54 SQL Data In: ORACLE - Param = 24, Name = PZYZFBL, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
462 11:09:54 SQL Data In: ORACLE - Param = 25, Name = PBKEA96, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
463 11:09:54 SQL Execute: ORACLE - BEGIN "SP_BM_YBSFDY_EDIT" (POPFLAG => :POPFLAG,PSFYP00 => :PSFYP00,PSFXMID => :PSFXMID,PFBBH00 => :PFBBH00,PYBZXLB => :PYBZXLB,PYBXMBH => :PYBXMBH,PZFBL00 => :PZFBL00,PSFYBXM => :PSFYBXM,PYBLB00 => :PYBLB00,PYBBRLB => :PYBBRLB,PYBMZFP => :PYBMZFP,PYBZYFP => :PYBZYFP,PZFJE00 => :PZFJE00,PJMBL00 => :PJMBL00,PJMJE00 => :PJMJE00,PSFSX00 => :PSFSX00,PYBBZ00 => :PYBBZ00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PZYZFBL => :PZYZFBL,PBKEA96 => :PBKEA96); END;
464 11:09:54 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
465 11:09:54 SQL Data In: ORACLE - Param = 2, Name = PSFYP00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
466 11:09:54 SQL Data In: ORACLE - Param = 3, Name = PSFXMID, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000041214
467 11:09:54 SQL Data In: ORACLE - Param = 4, Name = PFBBH00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 99
468 11:09:54 SQL Data In: ORACLE - Param = 5, Name = PYBZXLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = t
469 11:09:54 SQL Data In: ORACLE - Param = 6, Name = PYBXMBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
470 11:09:54 SQL Data In: ORACLE - Param = 7, Name = PZFBL00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
471 11:09:54 SQL Data In: ORACLE - Param = 8, Name = PSFYBXM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
472 11:09:54 SQL Data In: ORACLE - Param = 9, Name = PYBLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
473 11:09:54 SQL Data In: ORACLE - Param = 10, Name = PYBBRLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z
474 11:09:54 SQL Data In: ORACLE - Param = 11, Name = PYBMZFP, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
475 11:09:54 SQL Data In: ORACLE - Param = 12, Name = PYBZYFP, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
476 11:09:54 SQL Data In: ORACLE - Param = 13, Name = PZFJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
477 11:09:54 SQL Data In: ORACLE - Param = 14, Name = PJMBL00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
478 11:09:54 SQL Data In: ORACLE - Param = 15, Name = PJMJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
479 11:09:54 SQL Data In: ORACLE - Param = 16, Name = PSFSX00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
480 11:09:54 SQL Data In: ORACLE - Param = 17, Name = PYBBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
481 11:09:54 SQL Data In: ORACLE - Param = 18, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1913
482 11:09:54 SQL Data In: ORACLE - Param = 19, Name = PCZYKS0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 464
483 11:09:54 SQL Data In: ORACLE - Param = 20, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
484 11:09:54 SQL Data In: ORACLE - Param = 21, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
485 11:09:54 SQL Data In: ORACLE - Param = 22, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
486 11:09:54 SQL Data In: ORACLE - Param = 23, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
487 11:09:54 SQL Data In: ORACLE - Param = 24, Name = PZYZFBL, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
488 11:09:54 SQL Data In: ORACLE - Param = 25, Name = PBKEA96, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
489 11:09:54 SQL Execute: ORACLE - BEGIN "SP_BM_YBSFDY_EDIT" (POPFLAG => :POPFLAG,PSFYP00 => :PSFYP00,PSFXMID => :PSFXMID,PFBBH00 => :PFBBH00,PYBZXLB => :PYBZXLB,PYBXMBH => :PYBXMBH,PZFBL00 => :PZFBL00,PSFYBXM => :PSFYBXM,PYBLB00 => :PYBLB00,PYBBRLB => :PYBBRLB,PYBMZFP => :PYBMZFP,PYBZYFP => :PYBZYFP,PZFJE00 => :PZFJE00,PJMBL00 => :PJMBL00,PJMJE00 => :PJMJE00,PSFSX00 => :PSFSX00,PYBBZ00 => :PYBBZ00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PZYZFBL => :PZYZFBL,PBKEA96 => :PBKEA96); END;
490 11:09:54 SQL Execute: ORACLE - Commit
491 11:09:54 SQL Data In: ORACLE - Rows affected = 0
492 11:09:54 SQL Execute: ORACLE - Commit
493 11:09:54 SQL Data In: ORACLE - Rows affected = 0
494 11:09:54 SQL Execute: ORACLE - select * from VW_BM_YYSFXMGL a where 1=1 and a.flag00 = '1' and a.bmgzid= 1 and a.TREEBH like '950009%' and a.BH0000 like '9%' and a.TZRQ00 is null order by a.TREEBH,a.bh0000
495 11:09:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000041214
496 11:09:55 SQL Execute: ORACLE - select G.SFXMID,G.ZLXMID,S.XMMC00,Z.ZLXMJC,Z.ZLXMBH,G.GXID00,Z.SFYXSQ,Z.DJ0000,Z.BZ0000,S.GJYLBM,Z.SFTY00,Z.TZRQ00,Z.QYRQ00
from XT_ZLSFGX G,VW_XM_ZLZD00 Z,BM_YYSFXM S
where G.ZLXMID=Z.ZLXMID and G.SFXMID=S.SFXMID
and G.SFXMID=?
497 11:09:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000041214
498 11:09:55 SQL Execute: ORACLE - select a.SFXMID, a.SFBZDJ, a.DJSFJE, a.DJBZ00, b.YYJC00 from BM_SFDJBZ a, XT_YYXX00 b
where a.SFBZDJ = b.SFBZDJ and b.SFBZDJ <> '0' and a.SFXMID = ?
499 11:09:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000041214
500 11:09:55 SQL Execute: ORACLE - select c.YYJC00, b.YBMC00, a.SFXMID, a.SFYP00, a.SFBZDJ, a.YBZXLB, a.DJSFSX from BM_YBDJSX a,IC_YBBRLB b,XT_YYXX00 c
where a.SFBZDJ = c.SFBZDJ and a.sfxmid=? and a.sfyp00='N' and c.SFBZDJ <> '0' and a.ybzxlb=b.ybzxlb and b.yblb00=b.ybzxlb
order by c.YYJC00
501 11:09:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000041214
502 11:09:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000041214
503 11:09:55 SQL Execute: ORACLE - select (select SCCJZW from BM_YPSCCJ where SCCJBH=B.SCCJBH) as SCCJZW,
(select GHDWMC from BM_YPGHDW where GHDWNM=B.GHDWNM) as GHDWMC,YPBM00,ypmc00,YPGG00,KCDW00,
LSJ000,TXM000,a.SFXMID,b.GJJ000,a.YPNM00,b.WZXH00,
(select MC0000 from BM_TYZD00 where ZDMC00='物资维护-物资属性' and LBBZ00='0' and BH0000=a.WZSX00 and rownum=1) as WZSXMC
from BM_WZQTXX a, BM_YD0000 b where a.YPNM00=b.YPNM00
and b.LBBH00='9' and a.SFXMID=?
union
select (select SCCJZW from BM_YPSCCJ where SCCJBH=B.SCCJBH) as SCCJZW,
(select GHDWMC from BM_YPGHDW where GHDWNM=B.GHDWNM) as GHDWMC,YPBM00,YPMC00,YPGG00,KCDW00,
LSJ000,TXM000,a.SFXMID,b.GJJ000,a.YPNM00,b.WZXH00,
(select MC0000 from BM_WZQTXX aa,BM_TYZD00 bb where aa.YPNM00=a.YPNM00 and bb.ZDMC00='物资维护-物资属性' and bb.LBBZ00='0' and bb.BH0000=aa.WZSX00 and rownum=1) as WZSXMC
from BM_WZSFDY a, BM_YD0000 b where a.YPNM00=b.YPNM00
and b.LBBH00='9' and a.SFXMID=?