1       15:22:04  SQL Execute: ORACLE - SELECT DWID00 FROM TJ_BRXXB0 WHERE GHID00 = (SELECT GHID00 FROM SF_BRXXB0 WHERE GHH000 = '1778441' AND ROWNUM = 1)

2       15:22:04  SQL Execute: ORACLE - select a.ghid00 from tj_brxxb0 a,sf_brxxb0 b where a.grghid=b.ghid00 and b.ghh000='1778441'

3       15:22:04  SQL Execute: ORACLE -  SELECT * FROM VW_TJ_BRXXB0 WHERE GHID00>0
 AND GHID00=(select ghid00 from sf_brxxb0 where ghh000='1778441')

4       15:22:04  SQL Execute: ORACLE - select GRGHID from TJ_BRXXB0 where GHID00=2187737

5       15:22:04  SQL Data In: ORACLE - Param = 1, Name = PGHID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2187737
6       15:22:04  SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1057.000000
7       15:22:04  SQL Data In: ORACLE - Param = 3, Name = PCZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 管理员
8       15:22:04  SQL Data In: ORACLE - Param = 4, Name = PYYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 220035
9       15:22:04  SQL Execute: ORACLE - BEGIN "SP_TJ_INSTJ_TJBG00" (PGHID00 => :PGHID00,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PYYID00 => :PYYID00); END;
10      15:22:05  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2187737
11      15:22:05  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2187737
12      15:22:05  SQL Execute: ORACLE - select lpad(ksbh00,5,' ')||zlxmid ksxmid,zlxmid,nvl(yjdjh0,0) yjdjh0,ksbh00,zlxmjc,xh0000,lbbh00,bgys00,CKSBH0 from (select mc0000 zlxmjc,a.ksbh00,xh0000,0 zlxmid,0 yjdjh0,DECODE(LX0000,'2','4','0') lbbh00,a.bgys00,A.CKSBH0 from tj_kslb00 a,(select distinct ksbh00,zlxmid,yjdjh0 from tj_tjbg00 where ghid00=?) b where a.ksbh00=b.ksbh00 union select zlxmjc zlxmjc,b.ksbh00,c.xh0000,a.zlxmid,b.yjdjh0,TO_CHAR(a.lbbh00) LBBH00,c.bgys00,C.CKSBH0 from bm_zlzd00 a,tj_kslb00 c,(select distinct ksbh00,zlxmid,yjdjh0 from tj_tjbg00 where ghid00=?) b where a.zlxmid=b.zlxmid and b.ksbh00=c.ksbh00 AND A.ZLXMID IN (SELECT ZLXMID FROM TJ_ZHXM00 WHERE SFYX00 = 'Y') ) where 1=1 
 and ksbh00 in (select ksbh00 from tj_kslb00 where LX0000<>'3')
 order by xh0000,ksbh00,zlxmid, yjdjh0 

13      15:22:05  SQL Execute: ORACLE - select GHID00,TJJL00,TJJY00,ZJYS00,ZJYSXM,BGRQ00,FCRQ00,CZY000,CZYXM0 from VW_TJ_BRXXB0 where GHID00='2187737'

14      15:22:05  SQL Execute: ORACLE - SELECT "ID0000", "DWID00", "BRID00", "GHID00", "GHH000", "ICD900", "JBMC00", "JY0000" FROM "VW_TJ_TJJYB0" WHERE ((("DWID00") = ('0')) AND (("BRID00") = ('1595486'))) AND (("GHID00") = ('2187737'))
15      15:22:05  SQL Execute: ORACLE - select * from TJ_JKZJG0 where ghid00=2187737

16      15:22:05  SQL Execute: ORACLE - select yjdjh0,a.zlxmid,b.zlxmjc,b.lbbh00,xmzt00,SL0000,DECODE(XMZT00,'0','已申请','1','已计价','2','已收费','3','已执行','6','已作废','7','已退费','D','已取消') XMZTMC from TJ_YJDJH0 a,bm_zlzd00 b  where a.zlxmid=b.zlxmid and xmzt00 in('0','1','2','6','D') and (not exists (select 'y' from yj_yw0000 c where c.cxdjh0=a.yjdjh0)) and ((a.cxdjh0=0) or (a.cxdjh0 is null)) and (ghid00='2187737' or ghid00='')