1       08:39:02  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

2       08:39:02  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

3       08:39:02  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

4       08:39:02  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

5       08:39:02  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

6       08:39:02  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

7       08:39:02  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

8       08:39:02  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

9       08:39:02  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

10      08:39:02  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

11      08:39:02  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

12      08:39:02  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

13      08:39:02  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

14      08:39:02  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

15      08:39:02  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

16      08:39:02  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

17      08:39:02  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

18      08:39:02  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

19      08:39:02  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

20      08:39:02  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

21      08:39:03  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

22      08:39:03  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

23      08:39:03  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

24      08:39:03  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

25      08:39:03  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

26      08:39:03  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

27      08:39:03  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

28      08:39:03  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

29      08:39:03  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

30      08:39:03  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

31      08:39:03  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

32      08:39:03  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

33      08:39:03  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

34      08:39:03  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

35      08:39:03  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

36      08:39:03  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

37      08:39:03  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

38      08:39:03  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

39      08:39:03  SQL Prepare: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

40      08:39:03  SQL Execute: ORACLE - select *  from  vw_sf_wjzcf where BRID00='4685199' AND  GHH000='24143296'   

41      08:39:03  SQL Prepare: ORACLE - select b.GHQXBZ from sf_brxxb0 a,BM_GHLBB0 b where a.GHLB00=b.LBBH00 AND GHH000 = :1

42      08:39:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 24143296    
43      08:39:03  SQL Execute: ORACLE - select b.GHQXBZ from sf_brxxb0 a,BM_GHLBB0 b where a.GHLB00=b.LBBH00 AND GHH000 = ?

44      08:39:03  SQL Prepare: ORACLE -  select  a.YBID00,a.YBKH00,a.yblb00,b.sfxnh0 from  bm_brxxb0 a,ic_ybbrlb b  where a.fbbh00=b.fbbh00 and a.yblb00=b.yblb00 and a.BRID00 = :1

45      08:39:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
46      08:39:03  SQL Execute: ORACLE -  select  a.YBID00,a.YBKH00,a.yblb00,b.sfxnh0 from  bm_brxxb0 a,ic_ybbrlb b  where a.fbbh00=b.fbbh00 and a.yblb00=b.yblb00 and a.BRID00 = ?

47      08:39:03  SQL Prepare: ORACLE - select  *  from  BM_PJLYQK  where PJLXBM = 1
 and  PJSYR0=:1
 and  SYBZ00 = 'Y'

48      08:39:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1372.000000
49      08:39:03  SQL Execute: ORACLE - select  *  from  BM_PJLYQK  where PJLXBM = 1
 and  PJSYR0=?
 and  SYBZ00 = 'Y'

50      08:39:03  SQL Prepare: ORACLE - select a.*  from VW_SF_BRXX00 a where 1=1
 and a.brid00=:1

51      08:39:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
52      08:39:03  SQL Execute: ORACLE - select a.*  from VW_SF_BRXX00 a where 1=1
 and a.brid00=?

53      08:39:03  SQL Prepare: ORACLE -  select * from  VW_SF_BRGH00 A where 1=1
 and brid00=:1 
 and GHID00=:2

54      08:39:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
55      08:39:03  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 52882828.000000
56      08:39:03  SQL Execute: ORACLE -  select * from  VW_SF_BRGH00 A where 1=1
 and brid00=? 
 and GHID00=?

57      08:39:03  SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

58      08:39:03  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

59      08:39:03  SQL Prepare: ORACLE - select * from VW_SF_BRZHXX where jflbid = 1 and brid00=:1

60      08:39:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
61      08:39:03  SQL Execute: ORACLE - select * from VW_SF_BRZHXX where jflbid = 1 and brid00=?

62      08:39:03  SQL Prepare: ORACLE -  select a.djlsh0,a.zldccf,a.cfyjbz from vw_sf_wjzcf a where a.BRID00 = :1
 and cfyjbz = '0' 
  and  A.GHH000 = :2

63      08:39:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
64      08:39:03  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 24143296    
65      08:39:03  SQL Execute: ORACLE -  select a.djlsh0,a.zldccf,a.cfyjbz from vw_sf_wjzcf a where a.BRID00 = ?
 and cfyjbz = '0' 
  and  A.GHH000 = ?

66      08:39:03  SQL Prepare: ORACLE -  select a.djlsh0,a.zldccf,a.cfyjbz from vw_sf_wjzcf a where a.BRID00 = :1
 and cfyjbz = '1' 
  and  A.GHH000 = :2

67      08:39:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
68      08:39:03  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 24143296    
69      08:39:03  SQL Execute: ORACLE -  select a.djlsh0,a.zldccf,a.cfyjbz from vw_sf_wjzcf a where a.BRID00 = ?
 and cfyjbz = '1' 
  and  A.GHH000 = ?

70      08:39:03  SQL Prepare: ORACLE -  select  YJDJH0  from  YJ_YW0000  where yjfzh0 is null and brid00=:1 and  yjdjh0 = 111544182
 union  all 
 select  YJDJH0  from  YJ_YW0000  where yjfzh0 is not null  and brid00=:2 
 and  yjfzh0  in ( select  yjfzh0  from  yj_yw0000  where brid00=:3 and  yjdjh0 = 111544182)

71      08:39:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
72      08:39:03  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
73      08:39:03  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
74      08:39:03  SQL Execute: ORACLE -  select  YJDJH0  from  YJ_YW0000  where yjfzh0 is null and brid00=? and  yjdjh0 = 111544182
 union  all 
 select  YJDJH0  from  YJ_YW0000  where yjfzh0 is not null  and brid00=? 
 and  yjfzh0  in ( select  yjfzh0  from  yj_yw0000  where brid00=? and  yjdjh0 = 111544182)

75      08:39:03  SQL Prepare: ORACLE -  select  *  from  VW_SF_YJYWMX  where yjfzh0 is null and brid00=:1  and  yjdjh0 = 111544182
 union all 
 select  *  from  VW_SF_YJYWMX  where yjfzh0 is not null  and brid00=:2  
 and  yjfzh0  in ( select  yjfzh0  from  yj_yw0000  where  brid00=:3  and  yjdjh0 = 111544182)

76      08:39:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
77      08:39:03  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
78      08:39:03  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
79      08:39:03  SQL Execute: ORACLE -  select  *  from  VW_SF_YJYWMX  where yjfzh0 is null and brid00=?  and  yjdjh0 = 111544182
 union all 
 select  *  from  VW_SF_YJYWMX  where yjfzh0 is not null  and brid00=?  
 and  yjfzh0  in ( select  yjfzh0  from  yj_yw0000  where  brid00=?  and  yjdjh0 = 111544182)

80      08:39:03  SQL Prepare: ORACLE -  select  YJDJH0  from  YJ_YW0000  where yjfzh0 is null and brid00=:1 and  yjdjh0 = 111544184
 union  all 
 select  YJDJH0  from  YJ_YW0000  where yjfzh0 is not null  and brid00=:2 
 and  yjfzh0  in ( select  yjfzh0  from  yj_yw0000  where brid00=:3 and  yjdjh0 = 111544184)

81      08:39:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
82      08:39:03  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
83      08:39:03  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
84      08:39:03  SQL Execute: ORACLE -  select  YJDJH0  from  YJ_YW0000  where yjfzh0 is null and brid00=? and  yjdjh0 = 111544184
 union  all 
 select  YJDJH0  from  YJ_YW0000  where yjfzh0 is not null  and brid00=? 
 and  yjfzh0  in ( select  yjfzh0  from  yj_yw0000  where brid00=? and  yjdjh0 = 111544184)

85      08:39:03  SQL Prepare: ORACLE -  select  *  from  VW_SF_YJYWMX  where yjfzh0 is null and brid00=:1  and  yjdjh0 = 111544184
 union all 
 select  *  from  VW_SF_YJYWMX  where yjfzh0 is not null  and brid00=:2  
 and  yjfzh0  in ( select  yjfzh0  from  yj_yw0000  where  brid00=:3  and  yjdjh0 = 111544184)

86      08:39:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
87      08:39:03  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
88      08:39:03  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
89      08:39:03  SQL Execute: ORACLE -  select  *  from  VW_SF_YJYWMX  where yjfzh0 is null and brid00=?  and  yjdjh0 = 111544184
 union all 
 select  *  from  VW_SF_YJYWMX  where yjfzh0 is not null  and brid00=?  
 and  yjfzh0  in ( select  yjfzh0  from  yj_yw0000  where  brid00=?  and  yjdjh0 = 111544184)

90      08:39:03  SQL Prepare: ORACLE -  select  YJDJH0  from  YJ_YW0000  where yjfzh0 is null and brid00=:1 and  yjdjh0 = 111544186
 union  all 
 select  YJDJH0  from  YJ_YW0000  where yjfzh0 is not null  and brid00=:2 
 and  yjfzh0  in ( select  yjfzh0  from  yj_yw0000  where brid00=:3 and  yjdjh0 = 111544186)

91      08:39:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
92      08:39:03  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
93      08:39:03  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4685199.000000
94      08:39:03  SQL Execute: ORACLE -  select  YJDJH0  from  YJ_YW0000  where yjfzh0 is null and brid00=? and  yjdjh0 = 111544186
 union  all 
 select  YJDJH0  from  YJ_YW0000  where yjfzh0 is not null  and brid00=? 
 and  yjfzh0  in ( select  yjfzh0  from  yj_yw0000  where brid00=? and  yjdjh0 = 111544186)

