1       15:20:23  SQL Prepare: ORACLE - BEGIN "SP_YF_YPSLRKQR" (P_YPQLDH => :P_YPQLDH,P_YFBMBH => :P_YFBMBH,P_QRRBH0 => :P_QRRBH0,P_YPRKDH => :P_YPRKDH); END;
2       15:20:23  SQL Data In: ORACLE - Param = 1, Name = P_YPQLDH, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 60280423
3       15:20:23  SQL Data In: ORACLE - Param = 2, Name = P_YFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 91.000000
4       15:20:23  SQL Data In: ORACLE - Param = 3, Name = P_QRRBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60389.000000
5       15:20:23  SQL Data In: ORACLE - Param = 4, Name = P_YPRKDH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
6       15:20:23  SQL Execute: ORACLE - BEGIN "SP_YF_YPSLRKQR" (P_YPQLDH => :P_YPQLDH,P_YFBMBH => :P_YFBMBH,P_QRRBH0 => :P_QRRBH0,P_YPRKDH => :P_YPRKDH); END;
7       15:20:23  SQL Prepare: ORACLE - Commit

8       15:20:23  SQL Execute: ORACLE - Commit

9       15:20:23  SQL Data In: ORACLE - Rows affected = 0
10      15:20:23  SQL Prepare: ORACLE - BEGIN "SP_YF_YPCFZDCL" (P_YFBMBH => :P_YFBMBH,P_RKDH00 => :P_RKDH00,P_QRR000 => :P_QRR000); END;
11      15:20:23  SQL Data In: ORACLE - Param = 1, Name = P_YFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 91.000000
12      15:20:23  SQL Data In: ORACLE - Param = 2, Name = P_RKDH00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 60320571
13      15:20:23  SQL Data In: ORACLE - Param = 3, Name = P_QRR000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60389.000000
14      15:20:23  SQL Execute: ORACLE - BEGIN "SP_YF_YPCFZDCL" (P_YFBMBH => :P_YFBMBH,P_RKDH00 => :P_RKDH00,P_QRR000 => :P_QRR000); END;
15      15:20:24  SQL Prepare: ORACLE - Commit

16      15:20:24  SQL Execute: ORACLE - Commit

17      15:20:24  SQL Data In: ORACLE - Rows affected = 0
18      15:20:24  SQL Prepare: ORACLE - select * from YK_YPQLMX
WHERE YPQLDH=:1
  AND CXBZ00='Z'
ORDER BY YPQLPC

19      15:20:24  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 60280423
20      15:20:24  SQL Execute: ORACLE - select * from YK_YPQLMX
WHERE YPQLDH=?
  AND CXBZ00='Z'
ORDER BY YPQLPC

21      15:20:24  SQL Prepare: ORACLE - Commit

22      15:20:24  SQL Execute: ORACLE - Commit

23      15:20:24  SQL Data In: ORACLE - Rows affected = 0
24      15:20:25  SQL Prepare: ORACLE - select DISTINCT '1' SFXZ00,Q.YPQLDH,B.ZWXM00,Q.QLRQ00,QRRQ00 
from YK_YPQLD0 Q,BM_YGBM00 B,YK_YPQLMX X  
where Q.CKQXBH=:1     AND Q.QLZT00='1' 
  AND Q.QRRQ00>=:2  AND Q.QRRQ00<=:3 
 AND Q.YPQLDH=X.YPQLDH    AND X.CXBZ00='Z' 
 AND Q.LYRBH0=B.YGBH00(+) 

25      15:20:25  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 91.000000
26      15:20:25  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140801
27      15:20:25  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140815
28      15:20:25  SQL Execute: ORACLE - select DISTINCT '1' SFXZ00,Q.YPQLDH,B.ZWXM00,Q.QLRQ00,QRRQ00 
from YK_YPQLD0 Q,BM_YGBM00 B,YK_YPQLMX X  
where Q.CKQXBH=?     AND Q.QLZT00='1' 
  AND Q.QRRQ00>=?  AND Q.QRRQ00<=? 
 AND Q.YPQLDH=X.YPQLDH    AND X.CXBZ00='Z' 
 AND Q.LYRBH0=B.YGBH00(+) 

29      15:20:25  SQL Prepare: ORACLE - select * from YK_YPQLMX
WHERE YPQLDH=:1
  AND CXBZ00='Z'
ORDER BY YPQLPC

30      15:20:25  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
31      15:20:25  SQL Execute: ORACLE - select * from YK_YPQLMX
WHERE YPQLDH=?
  AND CXBZ00='Z'
ORDER BY YPQLPC

32      15:20:25  SQL Prepare: ORACLE - select * from YK_YPQLMX
WHERE YPQLDH=:1
  AND CXBZ00='Z'
ORDER BY YPQLPC

33      15:20:25  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
34      15:20:25  SQL Execute: ORACLE - select * from YK_YPQLMX
WHERE YPQLDH=?
  AND CXBZ00='Z'
ORDER BY YPQLPC

35      15:20:25  SQL Prepare: ORACLE - select * from YK_YPQLMX
WHERE YPQLDH=:1
  AND CXBZ00='Z'
ORDER BY YPQLPC

36      15:20:25  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
37      15:20:25  SQL Execute: ORACLE - select * from YK_YPQLMX
WHERE YPQLDH=?
  AND CXBZ00='Z'
ORDER BY YPQLPC

38      15:20:25  SQL Prepare: ORACLE - select * from YK_YPQLMX
WHERE YPQLDH=:1
  AND CXBZ00='Z'
ORDER BY YPQLPC

39      15:20:25  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
40      15:20:25  SQL Execute: ORACLE - select * from YK_YPQLMX
WHERE YPQLDH=?
  AND CXBZ00='Z'
ORDER BY YPQLPC

41      15:20:25  SQL Prepare: ORACLE - select * from YK_YPQLMX
WHERE YPQLDH=:1
  AND CXBZ00='Z'
ORDER BY YPQLPC

42      15:20:25  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
43      15:20:25  SQL Execute: ORACLE - select * from YK_YPQLMX
WHERE YPQLDH=?
  AND CXBZ00='Z'
ORDER BY YPQLPC

44      15:21:55  Log started for: SQL Navigator for Oracle