1       14:54:56  SQL Prepare: ORACLE - Select t1.SCKBH0,t1.DCKBH0,t2.ckmc00 as sckmc0,t3.ckmc00 as dckmc0,t3.bmbh00, t4.bmmc00,t4.BH0000 from BM_CKDY00 t1,bm_ckbm00 t2, bm_ckbm00 t3, bm_bmbm00 t4 where t1.sckbh0=t2.ckbh00 and t3.bmbh00=t4.bmbh00 and t2.flag00='0' and t1.dckbh0=t3.ckbh00 and t2.bmbh00='33' and t1.SCKBH0='107'

2       14:54:56  SQL Execute: ORACLE - Select t1.SCKBH0,t1.DCKBH0,t2.ckmc00 as sckmc0,t3.ckmc00 as dckmc0,t3.bmbh00, t4.bmmc00,t4.BH0000 from BM_CKDY00 t1,bm_ckbm00 t2, bm_ckbm00 t3, bm_bmbm00 t4 where t1.sckbh0=t2.ckbh00 and t3.bmbh00=t4.bmbh00 and t2.flag00='0' and t1.dckbh0=t3.ckbh00 and t2.bmbh00='33' and t1.SCKBH0='107'

3       14:54:56  SQL Prepare: ORACLE - SELECT * FROM (  
SELECT A.*,C.CKBH00,C.CKMC00,SUBSTR(A.NL0000,1,16) NL0001,(SELECT LBMC00 FROM BM_GHLBB0 WHERE LBBH00=A.GHLB00) GHLBMC 
 FROM VW_YS_HZBR00 A,SF_YSGHHB B, bm_ckbm00 c where a.jzks00 in (33,33) and  a.dlxh00>0  
  and A.HZZT00='4'  and A.YSPBID=B.GHHBID and B.GHHZCK=C.CKBH00 and C.FLAG00='4' and A.JHCS00=0 
   union
      SELECT A. * , C.CKBH00, C.CKMC00, SUBSTR(A.NL0000, 1, 16) NL0001, (SELECT LBMC00 FROM BM_GHLBB0 WHERE LBBH00 = A.GHLB00) GHLBMC 
  FROM VW_YS_HZBR00 A, SF_YSGHHB B, bm_ckbm00 c where a.jzks00 in (33,33) and a.dlxh00 > 0
  and A.HZZT00 = '0' and A.YSPBID = B.GHHBID and B.GHHZCK = C.CKBH00 and C.FLAG00 = '4'
  and A.YSPBID in (SELECT H.YSPBID FROM VW_YS_HZBR00 H, SF_YSGHHB I, bm_ckbm00 K where H.JZKS00 in (33,33) and H.DLXH00 > 0
  and H.HZZT00 = '4' and H.YSPBID = I.GHHBID and I.GHHZCK = K.CKBH00 and K.FLAG00 = '4' AND H.JHCS00=0) 
  and A.DLXH00 in (SELECT min(E.DLXH00)FROM VW_YS_HZBR00 E, SF_YSGHHB F, BM_CKBM00 D WHERE E.JZKS00 in (33,33) and E.DLXH00 > 0
  and E.HZZT00 = '0' and E.YSPBID = F.GHHBID and F.GHHZCK = D.CKBH00 and D.FLAG00 = '4' and E.YSPBID = A.YSPBID)
  )  ORDER BY JZYS00, DLXH00

4       14:54:56  SQL Execute: ORACLE - SELECT * FROM (  
SELECT A.*,C.CKBH00,C.CKMC00,SUBSTR(A.NL0000,1,16) NL0001,(SELECT LBMC00 FROM BM_GHLBB0 WHERE LBBH00=A.GHLB00) GHLBMC 
 FROM VW_YS_HZBR00 A,SF_YSGHHB B, bm_ckbm00 c where a.jzks00 in (33,33) and  a.dlxh00>0  
  and A.HZZT00='4'  and A.YSPBID=B.GHHBID and B.GHHZCK=C.CKBH00 and C.FLAG00='4' and A.JHCS00=0 
   union
      SELECT A. * , C.CKBH00, C.CKMC00, SUBSTR(A.NL0000, 1, 16) NL0001, (SELECT LBMC00 FROM BM_GHLBB0 WHERE LBBH00 = A.GHLB00) GHLBMC 
  FROM VW_YS_HZBR00 A, SF_YSGHHB B, bm_ckbm00 c where a.jzks00 in (33,33) and a.dlxh00 > 0
  and A.HZZT00 = '0' and A.YSPBID = B.GHHBID and B.GHHZCK = C.CKBH00 and C.FLAG00 = '4'
  and A.YSPBID in (SELECT H.YSPBID FROM VW_YS_HZBR00 H, SF_YSGHHB I, bm_ckbm00 K where H.JZKS00 in (33,33) and H.DLXH00 > 0
  and H.HZZT00 = '4' and H.YSPBID = I.GHHBID and I.GHHZCK = K.CKBH00 and K.FLAG00 = '4' AND H.JHCS00=0) 
  and A.DLXH00 in (SELECT min(E.DLXH00)FROM VW_YS_HZBR00 E, SF_YSGHHB F, BM_CKBM00 D WHERE E.JZKS00 in (33,33) and E.DLXH00 > 0
  and E.HZZT00 = '0' and E.YSPBID = F.GHHBID and F.GHHZCK = D.CKBH00 and D.FLAG00 = '4' and E.YSPBID = A.YSPBID)
  )  ORDER BY JZYS00, DLXH00

5       14:54:56  SQL Error: ORACLE - ORA-00918: 未明确定义列

6       14:54:56  SQL Error: ORACLE - Unmapped SQL Error Code: 918
7       14:54:56  SQL Data In: ORACLE - Rows affected = 0
8       14:54:57  SQL Prepare: ORACLE - Select t1.SCKBH0,t1.DCKBH0,t2.ckmc00 as sckmc0,t3.ckmc00 as dckmc0,t3.bmbh00, t4.bmmc00,t4.BH0000 from BM_CKDY00 t1,bm_ckbm00 t2, bm_ckbm00 t3, bm_bmbm00 t4 where t1.sckbh0=t2.ckbh00 and t3.bmbh00=t4.bmbh00 and t2.flag00='0' and t1.dckbh0=t3.ckbh00 and t2.bmbh00='33' and t1.SCKBH0='107'

9       14:54:57  SQL Execute: ORACLE - Select t1.SCKBH0,t1.DCKBH0,t2.ckmc00 as sckmc0,t3.ckmc00 as dckmc0,t3.bmbh00, t4.bmmc00,t4.BH0000 from BM_CKDY00 t1,bm_ckbm00 t2, bm_ckbm00 t3, bm_bmbm00 t4 where t1.sckbh0=t2.ckbh00 and t3.bmbh00=t4.bmbh00 and t2.flag00='0' and t1.dckbh0=t3.ckbh00 and t2.bmbh00='33' and t1.SCKBH0='107'

10      14:54:57  SQL Prepare: ORACLE - SELECT * FROM (  
SELECT A.*,C.CKBH00,C.CKMC00,SUBSTR(A.NL0000,1,16) NL0001,(SELECT LBMC00 FROM BM_GHLBB0 WHERE LBBH00=A.GHLB00) GHLBMC 
 FROM VW_YS_HZBR00 A,SF_YSGHHB B, bm_ckbm00 c where a.jzks00 in (33,33) and  a.dlxh00>0  
  and A.HZZT00='4'  and A.YSPBID=B.GHHBID and B.GHHZCK=C.CKBH00 and C.FLAG00='4' and A.JHCS00=0 
   union
      SELECT A. * , C.CKBH00, C.CKMC00, SUBSTR(A.NL0000, 1, 16) NL0001, (SELECT LBMC00 FROM BM_GHLBB0 WHERE LBBH00 = A.GHLB00) GHLBMC 
  FROM VW_YS_HZBR00 A, SF_YSGHHB B, bm_ckbm00 c where a.jzks00 in (33,33) and a.dlxh00 > 0
  and A.HZZT00 = '0' and A.YSPBID = B.GHHBID and B.GHHZCK = C.CKBH00 and C.FLAG00 = '4'
  and A.YSPBID in (SELECT H.YSPBID FROM VW_YS_HZBR00 H, SF_YSGHHB I, bm_ckbm00 K where H.JZKS00 in (33,33) and H.DLXH00 > 0
  and H.HZZT00 = '4' and H.YSPBID = I.GHHBID and I.GHHZCK = K.CKBH00 and K.FLAG00 = '4' AND H.JHCS00=0) 
  and A.DLXH00 in (SELECT min(E.DLXH00)FROM VW_YS_HZBR00 E, SF_YSGHHB F, BM_CKBM00 D WHERE E.JZKS00 in (33,33) and E.DLXH00 > 0
  and E.HZZT00 = '0' and E.YSPBID = F.GHHBID and F.GHHZCK = D.CKBH00 and D.FLAG00 = '4' and E.YSPBID = A.YSPBID)
  )  ORDER BY JZYS00, DLXH00

11      14:54:57  SQL Execute: ORACLE - SELECT * FROM (  
SELECT A.*,C.CKBH00,C.CKMC00,SUBSTR(A.NL0000,1,16) NL0001,(SELECT LBMC00 FROM BM_GHLBB0 WHERE LBBH00=A.GHLB00) GHLBMC 
 FROM VW_YS_HZBR00 A,SF_YSGHHB B, bm_ckbm00 c where a.jzks00 in (33,33) and  a.dlxh00>0  
  and A.HZZT00='4'  and A.YSPBID=B.GHHBID and B.GHHZCK=C.CKBH00 and C.FLAG00='4' and A.JHCS00=0 
   union
      SELECT A. * , C.CKBH00, C.CKMC00, SUBSTR(A.NL0000, 1, 16) NL0001, (SELECT LBMC00 FROM BM_GHLBB0 WHERE LBBH00 = A.GHLB00) GHLBMC 
  FROM VW_YS_HZBR00 A, SF_YSGHHB B, bm_ckbm00 c where a.jzks00 in (33,33) and a.dlxh00 > 0
  and A.HZZT00 = '0' and A.YSPBID = B.GHHBID and B.GHHZCK = C.CKBH00 and C.FLAG00 = '4'
  and A.YSPBID in (SELECT H.YSPBID FROM VW_YS_HZBR00 H, SF_YSGHHB I, bm_ckbm00 K where H.JZKS00 in (33,33) and H.DLXH00 > 0
  and H.HZZT00 = '4' and H.YSPBID = I.GHHBID and I.GHHZCK = K.CKBH00 and K.FLAG00 = '4' AND H.JHCS00=0) 
  and A.DLXH00 in (SELECT min(E.DLXH00)FROM VW_YS_HZBR00 E, SF_YSGHHB F, BM_CKBM00 D WHERE E.JZKS00 in (33,33) and E.DLXH00 > 0
  and E.HZZT00 = '0' and E.YSPBID = F.GHHBID and F.GHHZCK = D.CKBH00 and D.FLAG00 = '4' and E.YSPBID = A.YSPBID)
  )  ORDER BY JZYS00, DLXH00

12      14:54:57  SQL Error: ORACLE - ORA-00918: 未明确定义列

13      14:54:57  SQL Error: ORACLE - Unmapped SQL Error Code: 918
14      14:54:57  SQL Data In: ORACLE - Rows affected = 0
15      14:54:58  SQL Prepare: ORACLE - Select t1.SCKBH0,t1.DCKBH0,t2.ckmc00 as sckmc0,t3.ckmc00 as dckmc0,t3.bmbh00, t4.bmmc00,t4.BH0000 from BM_CKDY00 t1,bm_ckbm00 t2, bm_ckbm00 t3, bm_bmbm00 t4 where t1.sckbh0=t2.ckbh00 and t3.bmbh00=t4.bmbh00 and t2.flag00='0' and t1.dckbh0=t3.ckbh00 and t2.bmbh00='33' and t1.SCKBH0='107'

16      14:54:58  SQL Execute: ORACLE - Select t1.SCKBH0,t1.DCKBH0,t2.ckmc00 as sckmc0,t3.ckmc00 as dckmc0,t3.bmbh00, t4.bmmc00,t4.BH0000 from BM_CKDY00 t1,bm_ckbm00 t2, bm_ckbm00 t3, bm_bmbm00 t4 where t1.sckbh0=t2.ckbh00 and t3.bmbh00=t4.bmbh00 and t2.flag00='0' and t1.dckbh0=t3.ckbh00 and t2.bmbh00='33' and t1.SCKBH0='107'

17      14:54:58  SQL Prepare: ORACLE - SELECT * FROM (  
SELECT A.*,C.CKBH00,C.CKMC00,SUBSTR(A.NL0000,1,16) NL0001,(SELECT LBMC00 FROM BM_GHLBB0 WHERE LBBH00=A.GHLB00) GHLBMC 
 FROM VW_YS_HZBR00 A,SF_YSGHHB B, bm_ckbm00 c where a.jzks00 in (33,33) and  a.dlxh00>0  
  and A.HZZT00='4'  and A.YSPBID=B.GHHBID and B.GHHZCK=C.CKBH00 and C.FLAG00='4' and A.JHCS00=0 
   union
      SELECT A. * , C.CKBH00, C.CKMC00, SUBSTR(A.NL0000, 1, 16) NL0001, (SELECT LBMC00 FROM BM_GHLBB0 WHERE LBBH00 = A.GHLB00) GHLBMC 
  FROM VW_YS_HZBR00 A, SF_YSGHHB B, bm_ckbm00 c where a.jzks00 in (33,33) and a.dlxh00 > 0
  and A.HZZT00 = '0' and A.YSPBID = B.GHHBID and B.GHHZCK = C.CKBH00 and C.FLAG00 = '4'
  and A.YSPBID in (SELECT H.YSPBID FROM VW_YS_HZBR00 H, SF_YSGHHB I, bm_ckbm00 K where H.JZKS00 in (33,33) and H.DLXH00 > 0
  and H.HZZT00 = '4' and H.YSPBID = I.GHHBID and I.GHHZCK = K.CKBH00 and K.FLAG00 = '4' AND H.JHCS00=0) 
  and A.DLXH00 in (SELECT min(E.DLXH00)FROM VW_YS_HZBR00 E, SF_YSGHHB F, BM_CKBM00 D WHERE E.JZKS00 in (33,33) and E.DLXH00 > 0
  and E.HZZT00 = '0' and E.YSPBID = F.GHHBID and F.GHHZCK = D.CKBH00 and D.FLAG00 = '4' and E.YSPBID = A.YSPBID)
  )  ORDER BY JZYS00, DLXH00

18      14:54:58  SQL Execute: ORACLE - SELECT * FROM (  
SELECT A.*,C.CKBH00,C.CKMC00,SUBSTR(A.NL0000,1,16) NL0001,(SELECT LBMC00 FROM BM_GHLBB0 WHERE LBBH00=A.GHLB00) GHLBMC 
 FROM VW_YS_HZBR00 A,SF_YSGHHB B, bm_ckbm00 c where a.jzks00 in (33,33) and  a.dlxh00>0  
  and A.HZZT00='4'  and A.YSPBID=B.GHHBID and B.GHHZCK=C.CKBH00 and C.FLAG00='4' and A.JHCS00=0 
   union
      SELECT A. * , C.CKBH00, C.CKMC00, SUBSTR(A.NL0000, 1, 16) NL0001, (SELECT LBMC00 FROM BM_GHLBB0 WHERE LBBH00 = A.GHLB00) GHLBMC 
  FROM VW_YS_HZBR00 A, SF_YSGHHB B, bm_ckbm00 c where a.jzks00 in (33,33) and a.dlxh00 > 0
  and A.HZZT00 = '0' and A.YSPBID = B.GHHBID and B.GHHZCK = C.CKBH00 and C.FLAG00 = '4'
  and A.YSPBID in (SELECT H.YSPBID FROM VW_YS_HZBR00 H, SF_YSGHHB I, bm_ckbm00 K where H.JZKS00 in (33,33) and H.DLXH00 > 0
  and H.HZZT00 = '4' and H.YSPBID = I.GHHBID and I.GHHZCK = K.CKBH00 and K.FLAG00 = '4' AND H.JHCS00=0) 
  and A.DLXH00 in (SELECT min(E.DLXH00)FROM VW_YS_HZBR00 E, SF_YSGHHB F, BM_CKBM00 D WHERE E.JZKS00 in (33,33) and E.DLXH00 > 0
  and E.HZZT00 = '0' and E.YSPBID = F.GHHBID and F.GHHZCK = D.CKBH00 and D.FLAG00 = '4' and E.YSPBID = A.YSPBID)
  )  ORDER BY JZYS00, DLXH00

19      14:54:58  SQL Error: ORACLE - ORA-00918: 未明确定义列

20      14:54:58  SQL Error: ORACLE - Unmapped SQL Error Code: 918
21      14:54:58  SQL Data In: ORACLE - Rows affected = 0