826 08:57:00 SQL Data Out: ORACLE - Column = 4, Name = RCKID0, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 23206.000000 827 08:57:00 SQL Data Out: ORACLE - Column = 5, Name = RKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 21000007 828 08:57:00 SQL Data Out: ORACLE - Column = 6, Name = CKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 13000006 829 08:57:00 SQL Data Out: ORACLE - Column = 7, Name = DAXXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 28529.000000 830 08:57:00 SQL Data Out: ORACLE - Column = 8, Name = DAH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 905000210003 831 08:57:00 SQL Data Out: ORACLE - Column = 9, Name = HTH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 832 08:57:00 SQL Data Out: ORACLE - Column = 10, Name = FPH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 11272396 833 08:57:00 SQL Data Out: ORACLE - Column = 11, Name = FPRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 834 08:57:00 SQL Data Out: ORACLE - Column = 12, Name = JLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 835 08:57:00 SQL Data Out: ORACLE - Column = 13, Name = FJBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 836 08:57:00 SQL Data Out: ORACLE - Column = 14, Name = SYBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 837 08:57:00 SQL Data Out: ORACLE - Column = 15, Name = SBID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 31401.000000 838 08:57:00 SQL Data Out: ORACLE - Column = 16, Name = ZWPM00, Type = fldZSTRING, Precision = 52, Scale = 0, Data = 二门书柜 839 08:57:00 SQL Data Out: ORACLE - Column = 17, Name = YWPM00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 840 08:57:00 SQL Data Out: ORACLE - Column = 18, Name = CJID00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 5401.000000 841 08:57:00 SQL Data Out: ORACLE - Column = 19, Name = CJMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 长乐吴航吉祥家具商场 842 08:57:00 SQL Data Out: ORACLE - Column = 20, Name = SCCJID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = NULL 843 08:57:00 SQL Data Out: ORACLE - Column = 21, Name = SCCJMC, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 844 08:57:00 SQL Data Out: ORACLE - Column = 22, Name = QGKS00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = NULL 845 08:57:00 SQL Data Out: ORACLE - Column = 23, Name = QGKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 846 08:57:00 SQL Data Out: ORACLE - Column = 24, Name = GG0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 847 08:57:00 SQL Data Out: ORACLE - Column = 25, Name = XH0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 848 08:57:00 SQL Data Out: ORACLE - Column = 26, Name = SL0000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 1.000000 849 08:57:00 SQL Data Out: ORACLE - Column = 27, Name = JLDW00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 架 850 08:57:00 SQL Data Out: ORACLE - Column = 28, Name = DJ0000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 780.000000 851 08:57:00 SQL Data Out: ORACLE - Column = 29, Name = ZJE000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 780.000000 852 08:57:00 SQL Data Out: ORACLE - Column = 30, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 853 08:57:00 SQL Data Out: ORACLE - Column = 31, Name = CXMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 854 08:57:00 SQL Data Out: ORACLE - Column = 32, Name = BZ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 855 08:57:00 SQL Data Out: ORACLE - Column = 33, Name = RZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 856 08:57:00 SQL Data Out: ORACLE - Column = 34, Name = RCLXMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 正常出库 857 08:57:00 SQL Data Out: ORACLE - Column = 35, Name = SBBH00, Type = fldZSTRING, Precision = 24, Scale = 0, Data = 90500021 858 08:57:00 SQL Data Out: ORACLE - Column = 36, Name = CCBH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 859 08:57:00 SQL Data Out: ORACLE - Column = 1, Name = ZFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 860 08:57:00 SQL Data Out: ORACLE - Column = 2, Name = RCMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 10613.000000 861 08:57:00 SQL Data Out: ORACLE - Column = 3, Name = FJMXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 862 08:57:00 SQL Data Out: ORACLE - Column = 4, Name = RCKID0, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 23206.000000 863 08:57:00 SQL Data Out: ORACLE - Column = 5, Name = RKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 21000007 864 08:57:00 SQL Data Out: ORACLE - Column = 6, Name = CKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 13000006 865 08:57:00 SQL Data Out: ORACLE - Column = 7, Name = DAXXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 28530.000000 866 08:57:00 SQL Data Out: ORACLE - Column = 8, Name = DAH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 905000220001 867 08:57:00 SQL Data Out: ORACLE - Column = 9, Name = HTH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 868 08:57:00 SQL Data Out: ORACLE - Column = 10, Name = FPH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 11272396 869 08:57:00 SQL Data Out: ORACLE - Column = 11, Name = FPRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 870 08:57:00 SQL Data Out: ORACLE - Column = 12, Name = JLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 871 08:57:00 SQL Data Out: ORACLE - Column = 13, Name = FJBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 872 08:57:00 SQL Data Out: ORACLE - Column = 14, Name = SYBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 873 08:57:00 SQL Data Out: ORACLE - Column = 15, Name = SBID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 31901.000000 874 08:57:00 SQL Data Out: ORACLE - Column = 16, Name = ZWPM00, Type = fldZSTRING, Precision = 52, Scale = 0, Data = 三门书柜 875 08:57:00 SQL Data Out: ORACLE - Column = 17, Name = YWPM00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 876 08:57:00 SQL Data Out: ORACLE - Column = 18, Name = CJID00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 5401.000000 877 08:57:00 SQL Data Out: ORACLE - Column = 19, Name = CJMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 长乐吴航吉祥家具商场 878 08:57:00 SQL Data Out: ORACLE - Column = 20, Name = SCCJID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 879 08:57:00 SQL Data Out: ORACLE - Column = 21, Name = SCCJMC, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 880 08:57:00 SQL Data Out: ORACLE - Column = 22, Name = QGKS00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 881 08:57:00 SQL Data Out: ORACLE - Column = 23, Name = QGKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 882 08:57:00 SQL Data Out: ORACLE - Column = 24, Name = GG0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 883 08:57:00 SQL Data Out: ORACLE - Column = 25, Name = XH0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 884 08:57:00 SQL Data Out: ORACLE - Column = 26, Name = SL0000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 1.000000 885 08:57:00 SQL Data Out: ORACLE - Column = 27, Name = JLDW00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 架 886 08:57:00 SQL Data Out: ORACLE - Column = 28, Name = DJ0000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 950.000000 887 08:57:00 SQL Data Out: ORACLE - Column = 29, Name = ZJE000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 950.000000 888 08:57:00 SQL Data Out: ORACLE - Column = 30, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 889 08:57:00 SQL Data Out: ORACLE - Column = 31, Name = CXMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 0.000000 890 08:57:00 SQL Data Out: ORACLE - Column = 32, Name = BZ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 891 08:57:00 SQL Data Out: ORACLE - Column = 33, Name = RZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 892 08:57:00 SQL Data Out: ORACLE - Column = 34, Name = RCLXMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 正常出库 893 08:57:00 SQL Data Out: ORACLE - Column = 35, Name = SBBH00, Type = fldZSTRING, Precision = 24, Scale = 0, Data = 90500022 894 08:57:00 SQL Data Out: ORACLE - Column = 36, Name = CCBH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 895 08:57:00 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 896 08:57:00 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 897 08:57:00 SQL Data Out: ORACLE - Column = 1, Name = ZFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 898 08:57:00 SQL Data Out: ORACLE - Column = 2, Name = RCMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 10612.000000 899 08:57:00 SQL Data Out: ORACLE - Column = 3, Name = FJMXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 900 08:57:00 SQL Data Out: ORACLE - Column = 4, Name = RCKID0, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 23206.000000 901 08:57:00 SQL Data Out: ORACLE - Column = 5, Name = RKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 21000007 902 08:57:00 SQL Data Out: ORACLE - Column = 6, Name = CKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 13000006 903 08:57:00 SQL Data Out: ORACLE - Column = 7, Name = DAXXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 28529.000000 904 08:57:00 SQL Data Out: ORACLE - Column = 8, Name = DAH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 905000210003 905 08:57:00 SQL Data Out: ORACLE - Column = 9, Name = HTH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 906 08:57:00 SQL Data Out: ORACLE - Column = 10, Name = FPH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 11272396 907 08:57:00 SQL Data Out: ORACLE - Column = 11, Name = FPRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 908 08:57:00 SQL Data Out: ORACLE - Column = 12, Name = JLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 909 08:57:00 SQL Data Out: ORACLE - Column = 13, Name = FJBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 910 08:57:00 SQL Data Out: ORACLE - Column = 14, Name = SYBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 911 08:57:00 SQL Data Out: ORACLE - Column = 15, Name = SBID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 31401.000000 912 08:57:00 SQL Data Out: ORACLE - Column = 16, Name = ZWPM00, Type = fldZSTRING, Precision = 52, Scale = 0, Data = 二门书柜 913 08:57:00 SQL Data Out: ORACLE - Column = 17, Name = YWPM00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 914 08:57:00 SQL Data Out: ORACLE - Column = 18, Name = CJID00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 5401.000000 915 08:57:00 SQL Data Out: ORACLE - Column = 19, Name = CJMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 长乐吴航吉祥家具商场 916 08:57:00 SQL Data Out: ORACLE - Column = 20, Name = SCCJID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = NULL 917 08:57:00 SQL Data Out: ORACLE - Column = 21, Name = SCCJMC, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 918 08:57:00 SQL Data Out: ORACLE - Column = 22, Name = QGKS00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = NULL 919 08:57:00 SQL Data Out: ORACLE - Column = 23, Name = QGKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 920 08:57:00 SQL Data Out: ORACLE - Column = 24, Name = GG0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 921 08:57:00 SQL Data Out: ORACLE - Column = 25, Name = XH0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 922 08:57:00 SQL Data Out: ORACLE - Column = 26, Name = SL0000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 1.000000 923 08:57:00 SQL Data Out: ORACLE - Column = 27, Name = JLDW00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 架 924 08:57:00 SQL Data Out: ORACLE - Column = 28, Name = DJ0000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 780.000000 925 08:57:00 SQL Data Out: ORACLE - Column = 29, Name = ZJE000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 780.000000 926 08:57:00 SQL Data Out: ORACLE - Column = 30, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 927 08:57:00 SQL Data Out: ORACLE - Column = 31, Name = CXMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 928 08:57:00 SQL Data Out: ORACLE - Column = 32, Name = BZ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 929 08:57:00 SQL Data Out: ORACLE - Column = 33, Name = RZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 930 08:57:00 SQL Data Out: ORACLE - Column = 34, Name = RCLXMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 正常出库 931 08:57:00 SQL Data Out: ORACLE - Column = 35, Name = SBBH00, Type = fldZSTRING, Precision = 24, Scale = 0, Data = 90500021 932 08:57:00 SQL Data Out: ORACLE - Column = 36, Name = CCBH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 933 08:57:00 SQL Data Out: ORACLE - Column = 1, Name = ZFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 934 08:57:00 SQL Data Out: ORACLE - Column = 2, Name = RCMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 10613.000000 935 08:57:00 SQL Data Out: ORACLE - Column = 3, Name = FJMXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 936 08:57:00 SQL Data Out: ORACLE - Column = 4, Name = RCKID0, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 23206.000000 937 08:57:00 SQL Data Out: ORACLE - Column = 5, Name = RKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 21000007 938 08:57:00 SQL Data Out: ORACLE - Column = 6, Name = CKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 13000006 939 08:57:00 SQL Data Out: ORACLE - Column = 7, Name = DAXXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 28530.000000 940 08:57:00 SQL Data Out: ORACLE - Column = 8, Name = DAH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 905000220001 941 08:57:00 SQL Data Out: ORACLE - Column = 9, Name = HTH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 942 08:57:00 SQL Data Out: ORACLE - Column = 10, Name = FPH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 11272396 943 08:57:00 SQL Data Out: ORACLE - Column = 11, Name = FPRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 944 08:57:00 SQL Data Out: ORACLE - Column = 12, Name = JLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 945 08:57:00 SQL Data Out: ORACLE - Column = 13, Name = FJBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 946 08:57:00 SQL Data Out: ORACLE - Column = 14, Name = SYBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 947 08:57:00 SQL Data Out: ORACLE - Column = 15, Name = SBID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 31901.000000 948 08:57:00 SQL Data Out: ORACLE - Column = 16, Name = ZWPM00, Type = fldZSTRING, Precision = 52, Scale = 0, Data = 三门书柜 949 08:57:00 SQL Data Out: ORACLE - Column = 17, Name = YWPM00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 950 08:57:00 SQL Data Out: ORACLE - Column = 18, Name = CJID00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 5401.000000 951 08:57:00 SQL Data Out: ORACLE - Column = 19, Name = CJMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 长乐吴航吉祥家具商场 952 08:57:00 SQL Data Out: ORACLE - Column = 20, Name = SCCJID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 953 08:57:00 SQL Data Out: ORACLE - Column = 21, Name = SCCJMC, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 954 08:57:00 SQL Data Out: ORACLE - Column = 22, Name = QGKS00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 955 08:57:00 SQL Data Out: ORACLE - Column = 23, Name = QGKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 956 08:57:00 SQL Data Out: ORACLE - Column = 24, Name = GG0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 957 08:57:00 SQL Data Out: ORACLE - Column = 25, Name = XH0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 958 08:57:00 SQL Data Out: ORACLE - Column = 26, Name = SL0000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 1.000000 959 08:57:00 SQL Data Out: ORACLE - Column = 27, Name = JLDW00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 架 960 08:57:00 SQL Data Out: ORACLE - Column = 28, Name = DJ0000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 950.000000 961 08:57:00 SQL Data Out: ORACLE - Column = 29, Name = ZJE000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 950.000000 962 08:57:00 SQL Data Out: ORACLE - Column = 30, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 963 08:57:00 SQL Data Out: ORACLE - Column = 31, Name = CXMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 0.000000 964 08:57:00 SQL Data Out: ORACLE - Column = 32, Name = BZ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 965 08:57:00 SQL Data Out: ORACLE - Column = 33, Name = RZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 966 08:57:00 SQL Data Out: ORACLE - Column = 34, Name = RCLXMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 正常出库 967 08:57:00 SQL Data Out: ORACLE - Column = 35, Name = SBBH00, Type = fldZSTRING, Precision = 24, Scale = 0, Data = 90500022 968 08:57:00 SQL Data Out: ORACLE - Column = 36, Name = CCBH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 969 08:57:56 SQL Prepare: ORACLE - BEGIN "SP_SB_CKDSH" (AS_RCKID0 => :AS_RCKID0,AS_SHR000 => :AS_SHR000,AS_SHKS00 => :AS_SHKS00,RS_CWMS00 => :RS_CWMS00); END; 970 08:57:56 SQL Execute: ORACLE - BEGIN "SP_SB_CKDSH" (AS_RCKID0 => :AS_RCKID0,AS_SHR000 => :AS_SHR000,AS_SHKS00 => :AS_SHKS00,RS_CWMS00 => :RS_CWMS00); END; 971 08:57:56 SQL Prepare: ORACLE - Rollback 972 08:57:56 SQL Execute: ORACLE - Rollback 973 08:57:56 SQL Prepare: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='175' and DJRQ00>='20091001' and DJRQ00<='20100112' and LXID00='5' and SHBZ00='1' order by RCKID0 974 08:57:56 SQL Execute: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='175' and DJRQ00>='20091001' and DJRQ00<='20100112' and LXID00='5' and SHBZ00='1' order by RCKID0 975 08:57:56 SQL Data Out: ORACLE - Column = 1, Name = RCKID0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 23206.000000 976 08:57:56 SQL Data Out: ORACLE - Column = 2, Name = RCKDH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 13000006 977 08:57:56 SQL Data Out: ORACLE - Column = 3, Name = LXID00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 5.000000 978 08:57:56 SQL Data Out: ORACLE - Column = 4, Name = RCLXMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 正常出库 979 08:57:56 SQL Data Out: ORACLE - Column = 5, Name = DJLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 980 08:57:56 SQL Data Out: ORACLE - Column = 6, Name = JSBM00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 981 08:57:56 SQL Data Out: ORACLE - Column = 7, Name = BGY000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 809.000000 982 08:57:56 SQL Data Out: ORACLE - Column = 8, Name = BGYXM0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 郑建诗 983 08:57:56 SQL Data Out: ORACLE - Column = 9, Name = SYBM00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 175.000000 984 08:57:56 SQL Data Out: ORACLE - Column = 10, Name = SYBMMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 总务科 985 08:57:56 SQL Data Out: ORACLE - Column = 11, Name = CKBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 175.000000 986 08:57:56 SQL Data Out: ORACLE - Column = 12, Name = CKMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 总务科 987 08:57:56 SQL Data Out: ORACLE - Column = 13, Name = HJJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 988 08:57:56 SQL Data Out: ORACLE - Column = 14, Name = CBR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 809.000000 989 08:57:56 SQL Data Out: ORACLE - Column = 15, Name = CBRXM0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 郑建诗 990 08:57:56 SQL Data Out: ORACLE - Column = 16, Name = YSR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 991 08:57:56 SQL Data Out: ORACLE - Column = 17, Name = YSRXM0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 992 08:57:56 SQL Data Out: ORACLE - Column = 18, Name = LRR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 897.000000 993 08:57:56 SQL Data Out: ORACLE - Column = 19, Name = LRRXM0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 林峰 994 08:57:56 SQL Data Out: ORACLE - Column = 20, Name = DJRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20091012 995 08:57:56 SQL Data Out: ORACLE - Column = 21, Name = DJSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 14:21:59 996 08:57:56 SQL Data Out: ORACLE - Column = 22, Name = SHKS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 997 08:57:56 SQL Data Out: ORACLE - Column = 23, Name = SHKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 998 08:57:56 SQL Data Out: ORACLE - Column = 24, Name = SHR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 999 08:57:56 SQL Data Out: ORACLE - Column = 25, Name = SHRXM0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1000 08:57:56 SQL Data Out: ORACLE - Column = 26, Name = SHRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1001 08:57:56 SQL Data Out: ORACLE - Column = 27, Name = SHSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1002 08:57:56 SQL Data Out: ORACLE - Column = 28, Name = ZWSHRQ, Type = fldZSTRING, Precision = 22, Scale = 0, Data = 年月日 1003 08:57:56 SQL Data Out: ORACLE - Column = 29, Name = SHBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1004 08:57:56 SQL Data Out: ORACLE - Column = 30, Name = JDBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1005 08:57:56 SQL Data Out: ORACLE - Column = 31, Name = BZ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1006 08:57:56 SQL Data Out: ORACLE - Column = 32, Name = RZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1007 08:57:56 SQL Data Out: ORACLE - Column = 33, Name = CJID00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1008 08:57:56 SQL Data Out: ORACLE - Column = 34, Name = CJMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 1009 08:57:56 SQL Data Out: ORACLE - Column = 35, Name = YHZH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1010 08:57:56 SQL Data Out: ORACLE - Column = 36, Name = KHYH00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1011 08:57:56 SQL Data Out: ORACLE - Column = 37, Name = SFZFCG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 1012 08:57:56 SQL Data Out: ORACLE - Column = 38, Name = DYFKTZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 1013 08:57:56 SQL Data Out: ORACLE - Column = 39, Name = QRRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1014 08:57:56 SQL Data Out: ORACLE - Column = 40, Name = QRSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1015 08:57:56 SQL Data Out: ORACLE - Column = 41, Name = QRR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1016 08:57:56 SQL Data Out: ORACLE - Column = 42, Name = CGFS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1017 08:57:56 SQL Data Out: ORACLE - Column = 43, Name = RCKBZ0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1018 08:57:56 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1019 08:57:56 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1020 08:57:56 SQL Data Out: ORACLE - Column = 1, Name = ZFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1021 08:57:56 SQL Data Out: ORACLE - Column = 2, Name = RCMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 10612.000000 1022 08:57:56 SQL Data Out: ORACLE - Column = 3, Name = FJMXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1023 08:57:56 SQL Data Out: ORACLE - Column = 4, Name = RCKID0, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 23206.000000 1024 08:57:56 SQL Data Out: ORACLE - Column = 5, Name = RKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 21000007 1025 08:57:56 SQL Data Out: ORACLE - Column = 6, Name = CKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 13000006 1026 08:57:56 SQL Data Out: ORACLE - Column = 7, Name = DAXXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 28529.000000 1027 08:57:56 SQL Data Out: ORACLE - Column = 8, Name = DAH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 905000210003 1028 08:57:56 SQL Data Out: ORACLE - Column = 9, Name = HTH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1029 08:57:56 SQL Data Out: ORACLE - Column = 10, Name = FPH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 11272396 1030 08:57:56 SQL Data Out: ORACLE - Column = 11, Name = FPRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1031 08:57:56 SQL Data Out: ORACLE - Column = 12, Name = JLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1032 08:57:56 SQL Data Out: ORACLE - Column = 13, Name = FJBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1033 08:57:56 SQL Data Out: ORACLE - Column = 14, Name = SYBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1034 08:57:56 SQL Data Out: ORACLE - Column = 15, Name = SBID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 31401.000000 1035 08:57:56 SQL Data Out: ORACLE - Column = 16, Name = ZWPM00, Type = fldZSTRING, Precision = 52, Scale = 0, Data = 二门书柜 1036 08:57:56 SQL Data Out: ORACLE - Column = 17, Name = YWPM00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1037 08:57:56 SQL Data Out: ORACLE - Column = 18, Name = CJID00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 5401.000000 1038 08:57:56 SQL Data Out: ORACLE - Column = 19, Name = CJMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 长乐吴航吉祥家具商场 1039 08:57:56 SQL Data Out: ORACLE - Column = 20, Name = SCCJID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = NULL 1040 08:57:56 SQL Data Out: ORACLE - Column = 21, Name = SCCJMC, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 1041 08:57:56 SQL Data Out: ORACLE - Column = 22, Name = QGKS00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = NULL 1042 08:57:56 SQL Data Out: ORACLE - Column = 23, Name = QGKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1043 08:57:56 SQL Data Out: ORACLE - Column = 24, Name = GG0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1044 08:57:56 SQL Data Out: ORACLE - Column = 25, Name = XH0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1045 08:57:56 SQL Data Out: ORACLE - Column = 26, Name = SL0000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 1.000000 1046 08:57:56 SQL Data Out: ORACLE - Column = 27, Name = JLDW00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 架 1047 08:57:56 SQL Data Out: ORACLE - Column = 28, Name = DJ0000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 780.000000 1048 08:57:56 SQL Data Out: ORACLE - Column = 29, Name = ZJE000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 780.000000 1049 08:57:56 SQL Data Out: ORACLE - Column = 30, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 1050 08:57:56 SQL Data Out: ORACLE - Column = 31, Name = CXMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 1051 08:57:56 SQL Data Out: ORACLE - Column = 32, Name = BZ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1052 08:57:56 SQL Data Out: ORACLE - Column = 33, Name = RZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1053 08:57:56 SQL Data Out: ORACLE - Column = 34, Name = RCLXMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 正常出库 1054 08:57:56 SQL Data Out: ORACLE - Column = 35, Name = SBBH00, Type = fldZSTRING, Precision = 24, Scale = 0, Data = 90500021 1055 08:57:56 SQL Data Out: ORACLE - Column = 36, Name = CCBH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1056 08:57:56 SQL Data Out: ORACLE - Column = 1, Name = ZFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1057 08:57:56 SQL Data Out: ORACLE - Column = 2, Name = RCMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 10613.000000 1058 08:57:56 SQL Data Out: ORACLE - Column = 3, Name = FJMXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1059 08:57:56 SQL Data Out: ORACLE - Column = 4, Name = RCKID0, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 23206.000000 1060 08:57:56 SQL Data Out: ORACLE - Column = 5, Name = RKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 21000007 1061 08:57:56 SQL Data Out: ORACLE - Column = 6, Name = CKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 13000006 1062 08:57:56 SQL Data Out: ORACLE - Column = 7, Name = DAXXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 28530.000000 1063 08:57:56 SQL Data Out: ORACLE - Column = 8, Name = DAH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 905000220001 1064 08:57:56 SQL Data Out: ORACLE - Column = 9, Name = HTH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1065 08:57:56 SQL Data Out: ORACLE - Column = 10, Name = FPH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 11272396 1066 08:57:56 SQL Data Out: ORACLE - Column = 11, Name = FPRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 1067 08:57:56 SQL Data Out: ORACLE - Column = 12, Name = JLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1068 08:57:56 SQL Data Out: ORACLE - Column = 13, Name = FJBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1069 08:57:56 SQL Data Out: ORACLE - Column = 14, Name = SYBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1070 08:57:56 SQL Data Out: ORACLE - Column = 15, Name = SBID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 31901.000000 1071 08:57:56 SQL Data Out: ORACLE - Column = 16, Name = ZWPM00, Type = fldZSTRING, Precision = 52, Scale = 0, Data = 三门书柜 1072 08:57:56 SQL Data Out: ORACLE - Column = 17, Name = YWPM00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 1073 08:57:56 SQL Data Out: ORACLE - Column = 18, Name = CJID00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 5401.000000 1074 08:57:56 SQL Data Out: ORACLE - Column = 19, Name = CJMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 长乐吴航吉祥家具商场 1075 08:57:56 SQL Data Out: ORACLE - Column = 20, Name = SCCJID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1076 08:57:56 SQL Data Out: ORACLE - Column = 21, Name = SCCJMC, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 1077 08:57:56 SQL Data Out: ORACLE - Column = 22, Name = QGKS00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1078 08:57:56 SQL Data Out: ORACLE - Column = 23, Name = QGKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1079 08:57:56 SQL Data Out: ORACLE - Column = 24, Name = GG0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1080 08:57:56 SQL Data Out: ORACLE - Column = 25, Name = XH0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1081 08:57:56 SQL Data Out: ORACLE - Column = 26, Name = SL0000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 1.000000 1082 08:57:56 SQL Data Out: ORACLE - Column = 27, Name = JLDW00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 架 1083 08:57:56 SQL Data Out: ORACLE - Column = 28, Name = DJ0000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 950.000000 1084 08:57:56 SQL Data Out: ORACLE - Column = 29, Name = ZJE000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 950.000000 1085 08:57:56 SQL Data Out: ORACLE - Column = 30, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 1086 08:57:56 SQL Data Out: ORACLE - Column = 31, Name = CXMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 0.000000 1087 08:57:56 SQL Data Out: ORACLE - Column = 32, Name = BZ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1088 08:57:56 SQL Data Out: ORACLE - Column = 33, Name = RZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 1089 08:57:56 SQL Data Out: ORACLE - Column = 34, Name = RCLXMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 正常出库 1090 08:57:56 SQL Data Out: ORACLE - Column = 35, Name = SBBH00, Type = fldZSTRING, Precision = 24, Scale = 0, Data = 90500022 1091 08:57:56 SQL Data Out: ORACLE - Column = 36, Name = CCBH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1092 08:57:56 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1093 08:57:56 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1094 08:57:56 SQL Data Out: ORACLE - Column = 1, Name = ZFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1095 08:57:56 SQL Data Out: ORACLE - Column = 2, Name = RCMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 10612.000000 1096 08:57:56 SQL Data Out: ORACLE - Column = 3, Name = FJMXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1097 08:57:56 SQL Data Out: ORACLE - Column = 4, Name = RCKID0, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 23206.000000 1098 08:57:56 SQL Data Out: ORACLE - Column = 5, Name = RKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 21000007 1099 08:57:56 SQL Data Out: ORACLE - Column = 6, Name = CKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 13000006 1100 08:57:56 SQL Data Out: ORACLE - Column = 7, Name = DAXXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 28529.000000 1101 08:57:56 SQL Data Out: ORACLE - Column = 8, Name = DAH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 905000210003 1102 08:57:56 SQL Data Out: ORACLE - Column = 9, Name = HTH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1103 08:57:56 SQL Data Out: ORACLE - Column = 10, Name = FPH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 11272396 1104 08:57:56 SQL Data Out: ORACLE - Column = 11, Name = FPRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1105 08:57:56 SQL Data Out: ORACLE - Column = 12, Name = JLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1106 08:57:56 SQL Data Out: ORACLE - Column = 13, Name = FJBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1107 08:57:56 SQL Data Out: ORACLE - Column = 14, Name = SYBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1108 08:57:56 SQL Data Out: ORACLE - Column = 15, Name = SBID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 31401.000000 1109 08:57:56 SQL Data Out: ORACLE - Column = 16, Name = ZWPM00, Type = fldZSTRING, Precision = 52, Scale = 0, Data = 二门书柜 1110 08:57:56 SQL Data Out: ORACLE - Column = 17, Name = YWPM00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1111 08:57:56 SQL Data Out: ORACLE - Column = 18, Name = CJID00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 5401.000000 1112 08:57:56 SQL Data Out: ORACLE - Column = 19, Name = CJMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 长乐吴航吉祥家具商场 1113 08:57:56 SQL Data Out: ORACLE - Column = 20, Name = SCCJID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = NULL 1114 08:57:56 SQL Data Out: ORACLE - Column = 21, Name = SCCJMC, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 1115 08:57:56 SQL Data Out: ORACLE - Column = 22, Name = QGKS00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = NULL 1116 08:57:56 SQL Data Out: ORACLE - Column = 23, Name = QGKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1117 08:57:56 SQL Data Out: ORACLE - Column = 24, Name = GG0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1118 08:57:56 SQL Data Out: ORACLE - Column = 25, Name = XH0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1119 08:57:56 SQL Data Out: ORACLE - Column = 26, Name = SL0000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 1.000000 1120 08:57:56 SQL Data Out: ORACLE - Column = 27, Name = JLDW00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 架 1121 08:57:56 SQL Data Out: ORACLE - Column = 28, Name = DJ0000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 780.000000 1122 08:57:56 SQL Data Out: ORACLE - Column = 29, Name = ZJE000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 780.000000 1123 08:57:56 SQL Data Out: ORACLE - Column = 30, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 1124 08:57:56 SQL Data Out: ORACLE - Column = 31, Name = CXMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 1125 08:57:56 SQL Data Out: ORACLE - Column = 32, Name = BZ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1126 08:57:56 SQL Data Out: ORACLE - Column = 33, Name = RZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1127 08:57:56 SQL Data Out: ORACLE - Column = 34, Name = RCLXMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 正常出库 1128 08:57:56 SQL Data Out: ORACLE - Column = 35, Name = SBBH00, Type = fldZSTRING, Precision = 24, Scale = 0, Data = 90500021 1129 08:57:56 SQL Data Out: ORACLE - Column = 36, Name = CCBH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1130 08:57:56 SQL Data Out: ORACLE - Column = 1, Name = ZFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1131 08:57:56 SQL Data Out: ORACLE - Column = 2, Name = RCMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 10613.000000 1132 08:57:56 SQL Data Out: ORACLE - Column = 3, Name = FJMXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1133 08:57:56 SQL Data Out: ORACLE - Column = 4, Name = RCKID0, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 23206.000000 1134 08:57:56 SQL Data Out: ORACLE - Column = 5, Name = RKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 21000007 1135 08:57:56 SQL Data Out: ORACLE - Column = 6, Name = CKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 13000006 1136 08:57:56 SQL Data Out: ORACLE - Column = 7, Name = DAXXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 28530.000000 1137 08:57:56 SQL Data Out: ORACLE - Column = 8, Name = DAH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 905000220001 1138 08:57:56 SQL Data Out: ORACLE - Column = 9, Name = HTH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1139 08:57:56 SQL Data Out: ORACLE - Column = 10, Name = FPH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 11272396 1140 08:57:56 SQL Data Out: ORACLE - Column = 11, Name = FPRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 1141 08:57:56 SQL Data Out: ORACLE - Column = 12, Name = JLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1142 08:57:56 SQL Data Out: ORACLE - Column = 13, Name = FJBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1143 08:57:56 SQL Data Out: ORACLE - Column = 14, Name = SYBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1144 08:57:56 SQL Data Out: ORACLE - Column = 15, Name = SBID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 31901.000000 1145 08:57:56 SQL Data Out: ORACLE - Column = 16, Name = ZWPM00, Type = fldZSTRING, Precision = 52, Scale = 0, Data = 三门书柜 1146 08:57:56 SQL Data Out: ORACLE - Column = 17, Name = YWPM00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 1147 08:57:56 SQL Data Out: ORACLE - Column = 18, Name = CJID00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 5401.000000 1148 08:57:56 SQL Data Out: ORACLE - Column = 19, Name = CJMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 长乐吴航吉祥家具商场 1149 08:57:56 SQL Data Out: ORACLE - Column = 20, Name = SCCJID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1150 08:57:56 SQL Data Out: ORACLE - Column = 21, Name = SCCJMC, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 1151 08:57:56 SQL Data Out: ORACLE - Column = 22, Name = QGKS00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1152 08:57:56 SQL Data Out: ORACLE - Column = 23, Name = QGKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1153 08:57:56 SQL Data Out: ORACLE - Column = 24, Name = GG0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1154 08:57:56 SQL Data Out: ORACLE - Column = 25, Name = XH0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1155 08:57:56 SQL Data Out: ORACLE - Column = 26, Name = SL0000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 1.000000 1156 08:57:56 SQL Data Out: ORACLE - Column = 27, Name = JLDW00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 架 1157 08:57:56 SQL Data Out: ORACLE - Column = 28, Name = DJ0000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 950.000000 1158 08:57:56 SQL Data Out: ORACLE - Column = 29, Name = ZJE000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 950.000000 1159 08:57:56 SQL Data Out: ORACLE - Column = 30, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 1160 08:57:56 SQL Data Out: ORACLE - Column = 31, Name = CXMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 0.000000 1161 08:57:56 SQL Data Out: ORACLE - Column = 32, Name = BZ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1162 08:57:56 SQL Data Out: ORACLE - Column = 33, Name = RZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 1163 08:57:56 SQL Data Out: ORACLE - Column = 34, Name = RCLXMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 正常出库 1164 08:57:56 SQL Data Out: ORACLE - Column = 35, Name = SBBH00, Type = fldZSTRING, Precision = 24, Scale = 0, Data = 90500022 1165 08:57:56 SQL Data Out: ORACLE - Column = 36, Name = CCBH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1166 08:57:56 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1167 08:57:56 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1168 08:57:56 SQL Data Out: ORACLE - Column = 1, Name = ZFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1169 08:57:56 SQL Data Out: ORACLE - Column = 2, Name = RCMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 10612.000000 1170 08:57:56 SQL Data Out: ORACLE - Column = 3, Name = FJMXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1171 08:57:56 SQL Data Out: ORACLE - Column = 4, Name = RCKID0, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 23206.000000 1172 08:57:56 SQL Data Out: ORACLE - Column = 5, Name = RKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 21000007 1173 08:57:56 SQL Data Out: ORACLE - Column = 6, Name = CKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 13000006 1174 08:57:56 SQL Data Out: ORACLE - Column = 7, Name = DAXXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 28529.000000 1175 08:57:56 SQL Data Out: ORACLE - Column = 8, Name = DAH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 905000210003 1176 08:57:56 SQL Data Out: ORACLE - Column = 9, Name = HTH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1177 08:57:56 SQL Data Out: ORACLE - Column = 10, Name = FPH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 11272396 1178 08:57:56 SQL Data Out: ORACLE - Column = 11, Name = FPRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1179 08:57:56 SQL Data Out: ORACLE - Column = 12, Name = JLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1180 08:57:56 SQL Data Out: ORACLE - Column = 13, Name = FJBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1181 08:57:56 SQL Data Out: ORACLE - Column = 14, Name = SYBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1182 08:57:56 SQL Data Out: ORACLE - Column = 15, Name = SBID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 31401.000000 1183 08:57:56 SQL Data Out: ORACLE - Column = 16, Name = ZWPM00, Type = fldZSTRING, Precision = 52, Scale = 0, Data = 二门书柜 1184 08:57:56 SQL Data Out: ORACLE - Column = 17, Name = YWPM00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1185 08:57:56 SQL Data Out: ORACLE - Column = 18, Name = CJID00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 5401.000000 1186 08:57:56 SQL Data Out: ORACLE - Column = 19, Name = CJMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 长乐吴航吉祥家具商场 1187 08:57:56 SQL Data Out: ORACLE - Column = 20, Name = SCCJID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = NULL 1188 08:57:56 SQL Data Out: ORACLE - Column = 21, Name = SCCJMC, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 1189 08:57:56 SQL Data Out: ORACLE - Column = 22, Name = QGKS00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = NULL 1190 08:57:56 SQL Data Out: ORACLE - Column = 23, Name = QGKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1191 08:57:56 SQL Data Out: ORACLE - Column = 24, Name = GG0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1192 08:57:56 SQL Data Out: ORACLE - Column = 25, Name = XH0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1193 08:57:56 SQL Data Out: ORACLE - Column = 26, Name = SL0000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 1.000000 1194 08:57:56 SQL Data Out: ORACLE - Column = 27, Name = JLDW00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 架 1195 08:57:56 SQL Data Out: ORACLE - Column = 28, Name = DJ0000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 780.000000 1196 08:57:56 SQL Data Out: ORACLE - Column = 29, Name = ZJE000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 780.000000 1197 08:57:56 SQL Data Out: ORACLE - Column = 30, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 1198 08:57:56 SQL Data Out: ORACLE - Column = 31, Name = CXMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 1199 08:57:56 SQL Data Out: ORACLE - Column = 32, Name = BZ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1200 08:57:56 SQL Data Out: ORACLE - Column = 33, Name = RZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1201 08:57:56 SQL Data Out: ORACLE - Column = 34, Name = RCLXMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 正常出库 1202 08:57:56 SQL Data Out: ORACLE - Column = 35, Name = SBBH00, Type = fldZSTRING, Precision = 24, Scale = 0, Data = 90500021 1203 08:57:56 SQL Data Out: ORACLE - Column = 36, Name = CCBH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1204 08:57:56 SQL Data Out: ORACLE - Column = 1, Name = ZFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1205 08:57:56 SQL Data Out: ORACLE - Column = 2, Name = RCMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 10613.000000 1206 08:57:56 SQL Data Out: ORACLE - Column = 3, Name = FJMXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1207 08:57:56 SQL Data Out: ORACLE - Column = 4, Name = RCKID0, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 23206.000000 1208 08:57:56 SQL Data Out: ORACLE - Column = 5, Name = RKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 21000007 1209 08:57:56 SQL Data Out: ORACLE - Column = 6, Name = CKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 13000006 1210 08:57:56 SQL Data Out: ORACLE - Column = 7, Name = DAXXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 28530.000000 1211 08:57:56 SQL Data Out: ORACLE - Column = 8, Name = DAH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 905000220001 1212 08:57:56 SQL Data Out: ORACLE - Column = 9, Name = HTH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1213 08:57:56 SQL Data Out: ORACLE - Column = 10, Name = FPH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 11272396 1214 08:57:56 SQL Data Out: ORACLE - Column = 11, Name = FPRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 1215 08:57:56 SQL Data Out: ORACLE - Column = 12, Name = JLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1216 08:57:56 SQL Data Out: ORACLE - Column = 13, Name = FJBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1217 08:57:56 SQL Data Out: ORACLE - Column = 14, Name = SYBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1218 08:57:56 SQL Data Out: ORACLE - Column = 15, Name = SBID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 31901.000000 1219 08:57:56 SQL Data Out: ORACLE - Column = 16, Name = ZWPM00, Type = fldZSTRING, Precision = 52, Scale = 0, Data = 三门书柜 1220 08:57:56 SQL Data Out: ORACLE - Column = 17, Name = YWPM00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 1221 08:57:56 SQL Data Out: ORACLE - Column = 18, Name = CJID00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 5401.000000 1222 08:57:56 SQL Data Out: ORACLE - Column = 19, Name = CJMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 长乐吴航吉祥家具商场 1223 08:57:56 SQL Data Out: ORACLE - Column = 20, Name = SCCJID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1224 08:57:56 SQL Data Out: ORACLE - Column = 21, Name = SCCJMC, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 1225 08:57:56 SQL Data Out: ORACLE - Column = 22, Name = QGKS00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1226 08:57:56 SQL Data Out: ORACLE - Column = 23, Name = QGKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1227 08:57:56 SQL Data Out: ORACLE - Column = 24, Name = GG0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1228 08:57:56 SQL Data Out: ORACLE - Column = 25, Name = XH0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1229 08:57:56 SQL Data Out: ORACLE - Column = 26, Name = SL0000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 1.000000 1230 08:57:56 SQL Data Out: ORACLE - Column = 27, Name = JLDW00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 架 1231 08:57:56 SQL Data Out: ORACLE - Column = 28, Name = DJ0000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 950.000000 1232 08:57:56 SQL Data Out: ORACLE - Column = 29, Name = ZJE000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 950.000000 1233 08:57:56 SQL Data Out: ORACLE - Column = 30, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 1234 08:57:56 SQL Data Out: ORACLE - Column = 31, Name = CXMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 0.000000 1235 08:57:56 SQL Data Out: ORACLE - Column = 32, Name = BZ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1236 08:57:56 SQL Data Out: ORACLE - Column = 33, Name = RZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 1237 08:57:56 SQL Data Out: ORACLE - Column = 34, Name = RCLXMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 正常出库 1238 08:57:56 SQL Data Out: ORACLE - Column = 35, Name = SBBH00, Type = fldZSTRING, Precision = 24, Scale = 0, Data = 90500022 1239 08:57:56 SQL Data Out: ORACLE - Column = 36, Name = CCBH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1240 08:57:56 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1241 08:57:56 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1242 08:57:57 SQL Data Out: ORACLE - Column = 1, Name = ZFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1243 08:57:57 SQL Data Out: ORACLE - Column = 2, Name = RCMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 10612.000000 1244 08:57:57 SQL Data Out: ORACLE - Column = 3, Name = FJMXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1245 08:57:57 SQL Data Out: ORACLE - Column = 4, Name = RCKID0, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 23206.000000 1246 08:57:57 SQL Data Out: ORACLE - Column = 5, Name = RKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 21000007 1247 08:57:57 SQL Data Out: ORACLE - Column = 6, Name = CKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 13000006 1248 08:57:57 SQL Data Out: ORACLE - Column = 7, Name = DAXXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 28529.000000 1249 08:57:57 SQL Data Out: ORACLE - Column = 8, Name = DAH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 905000210003 1250 08:57:57 SQL Data Out: ORACLE - Column = 9, Name = HTH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1251 08:57:57 SQL Data Out: ORACLE - Column = 10, Name = FPH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 11272396 1252 08:57:57 SQL Data Out: ORACLE - Column = 11, Name = FPRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1253 08:57:57 SQL Data Out: ORACLE - Column = 12, Name = JLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1254 08:57:57 SQL Data Out: ORACLE - Column = 13, Name = FJBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1255 08:57:57 SQL Data Out: ORACLE - Column = 14, Name = SYBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1256 08:57:57 SQL Data Out: ORACLE - Column = 15, Name = SBID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 31401.000000 1257 08:57:57 SQL Data Out: ORACLE - Column = 16, Name = ZWPM00, Type = fldZSTRING, Precision = 52, Scale = 0, Data = 二门书柜 1258 08:57:57 SQL Data Out: ORACLE - Column = 17, Name = YWPM00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1259 08:57:57 SQL Data Out: ORACLE - Column = 18, Name = CJID00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 5401.000000 1260 08:57:57 SQL Data Out: ORACLE - Column = 19, Name = CJMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 长乐吴航吉祥家具商场 1261 08:57:57 SQL Data Out: ORACLE - Column = 20, Name = SCCJID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = NULL 1262 08:57:57 SQL Data Out: ORACLE - Column = 21, Name = SCCJMC, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 1263 08:57:57 SQL Data Out: ORACLE - Column = 22, Name = QGKS00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = NULL 1264 08:57:57 SQL Data Out: ORACLE - Column = 23, Name = QGKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1265 08:57:57 SQL Data Out: ORACLE - Column = 24, Name = GG0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1266 08:57:57 SQL Data Out: ORACLE - Column = 25, Name = XH0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1267 08:57:57 SQL Data Out: ORACLE - Column = 26, Name = SL0000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 1.000000 1268 08:57:57 SQL Data Out: ORACLE - Column = 27, Name = JLDW00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 架 1269 08:57:57 SQL Data Out: ORACLE - Column = 28, Name = DJ0000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 780.000000 1270 08:57:57 SQL Data Out: ORACLE - Column = 29, Name = ZJE000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 780.000000 1271 08:57:57 SQL Data Out: ORACLE - Column = 30, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 1272 08:57:57 SQL Data Out: ORACLE - Column = 31, Name = CXMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 1273 08:57:57 SQL Data Out: ORACLE - Column = 32, Name = BZ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1274 08:57:57 SQL Data Out: ORACLE - Column = 33, Name = RZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1275 08:57:57 SQL Data Out: ORACLE - Column = 34, Name = RCLXMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 正常出库 1276 08:57:57 SQL Data Out: ORACLE - Column = 35, Name = SBBH00, Type = fldZSTRING, Precision = 24, Scale = 0, Data = 90500021 1277 08:57:57 SQL Data Out: ORACLE - Column = 36, Name = CCBH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1278 08:57:57 SQL Data Out: ORACLE - Column = 1, Name = ZFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1279 08:57:57 SQL Data Out: ORACLE - Column = 2, Name = RCMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 10613.000000 1280 08:57:57 SQL Data Out: ORACLE - Column = 3, Name = FJMXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1281 08:57:57 SQL Data Out: ORACLE - Column = 4, Name = RCKID0, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 23206.000000 1282 08:57:57 SQL Data Out: ORACLE - Column = 5, Name = RKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 21000007 1283 08:57:57 SQL Data Out: ORACLE - Column = 6, Name = CKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 13000006 1284 08:57:57 SQL Data Out: ORACLE - Column = 7, Name = DAXXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 28530.000000 1285 08:57:57 SQL Data Out: ORACLE - Column = 8, Name = DAH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 905000220001 1286 08:57:57 SQL Data Out: ORACLE - Column = 9, Name = HTH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1287 08:57:57 SQL Data Out: ORACLE - Column = 10, Name = FPH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 11272396 1288 08:57:57 SQL Data Out: ORACLE - Column = 11, Name = FPRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 1289 08:57:57 SQL Data Out: ORACLE - Column = 12, Name = JLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1290 08:57:57 SQL Data Out: ORACLE - Column = 13, Name = FJBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1291 08:57:57 SQL Data Out: ORACLE - Column = 14, Name = SYBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1292 08:57:57 SQL Data Out: ORACLE - Column = 15, Name = SBID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 31901.000000 1293 08:57:57 SQL Data Out: ORACLE - Column = 16, Name = ZWPM00, Type = fldZSTRING, Precision = 52, Scale = 0, Data = 三门书柜 1294 08:57:57 SQL Data Out: ORACLE - Column = 17, Name = YWPM00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 1295 08:57:57 SQL Data Out: ORACLE - Column = 18, Name = CJID00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 5401.000000 1296 08:57:57 SQL Data Out: ORACLE - Column = 19, Name = CJMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 长乐吴航吉祥家具商场 1297 08:57:57 SQL Data Out: ORACLE - Column = 20, Name = SCCJID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1298 08:57:57 SQL Data Out: ORACLE - Column = 21, Name = SCCJMC, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 1299 08:57:57 SQL Data Out: ORACLE - Column = 22, Name = QGKS00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1300 08:57:57 SQL Data Out: ORACLE - Column = 23, Name = QGKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1301 08:57:57 SQL Data Out: ORACLE - Column = 24, Name = GG0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1302 08:57:57 SQL Data Out: ORACLE - Column = 25, Name = XH0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1303 08:57:57 SQL Data Out: ORACLE - Column = 26, Name = SL0000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 1.000000 1304 08:57:57 SQL Data Out: ORACLE - Column = 27, Name = JLDW00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 架 1305 08:57:57 SQL Data Out: ORACLE - Column = 28, Name = DJ0000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 950.000000 1306 08:57:57 SQL Data Out: ORACLE - Column = 29, Name = ZJE000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 950.000000 1307 08:57:57 SQL Data Out: ORACLE - Column = 30, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 1308 08:57:57 SQL Data Out: ORACLE - Column = 31, Name = CXMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 0.000000 1309 08:57:57 SQL Data Out: ORACLE - Column = 32, Name = BZ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1310 08:57:57 SQL Data Out: ORACLE - Column = 33, Name = RZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 1311 08:57:57 SQL Data Out: ORACLE - Column = 34, Name = RCLXMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 正常出库 1312 08:57:57 SQL Data Out: ORACLE - Column = 35, Name = SBBH00, Type = fldZSTRING, Precision = 24, Scale = 0, Data = 90500022 1313 08:57:57 SQL Data Out: ORACLE - Column = 36, Name = CCBH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1314 08:57:57 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1315 08:57:57 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1316 08:57:57 SQL Data Out: ORACLE - Column = 1, Name = ZFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1317 08:57:57 SQL Data Out: ORACLE - Column = 2, Name = RCMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 10612.000000 1318 08:57:57 SQL Data Out: ORACLE - Column = 3, Name = FJMXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1319 08:57:57 SQL Data Out: ORACLE - Column = 4, Name = RCKID0, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 23206.000000 1320 08:57:57 SQL Data Out: ORACLE - Column = 5, Name = RKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 21000007 1321 08:57:57 SQL Data Out: ORACLE - Column = 6, Name = CKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 13000006 1322 08:57:57 SQL Data Out: ORACLE - Column = 7, Name = DAXXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 28529.000000 1323 08:57:57 SQL Data Out: ORACLE - Column = 8, Name = DAH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 905000210003 1324 08:57:57 SQL Data Out: ORACLE - Column = 9, Name = HTH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1325 08:57:57 SQL Data Out: ORACLE - Column = 10, Name = FPH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 11272396 1326 08:57:57 SQL Data Out: ORACLE - Column = 11, Name = FPRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1327 08:57:57 SQL Data Out: ORACLE - Column = 12, Name = JLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1328 08:57:57 SQL Data Out: ORACLE - Column = 13, Name = FJBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1329 08:57:57 SQL Data Out: ORACLE - Column = 14, Name = SYBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1330 08:57:57 SQL Data Out: ORACLE - Column = 15, Name = SBID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 31401.000000 1331 08:57:57 SQL Data Out: ORACLE - Column = 16, Name = ZWPM00, Type = fldZSTRING, Precision = 52, Scale = 0, Data = 二门书柜 1332 08:57:57 SQL Data Out: ORACLE - Column = 17, Name = YWPM00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1333 08:57:57 SQL Data Out: ORACLE - Column = 18, Name = CJID00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 5401.000000 1334 08:57:57 SQL Data Out: ORACLE - Column = 19, Name = CJMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 长乐吴航吉祥家具商场 1335 08:57:57 SQL Data Out: ORACLE - Column = 20, Name = SCCJID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = NULL 1336 08:57:57 SQL Data Out: ORACLE - Column = 21, Name = SCCJMC, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 1337 08:57:57 SQL Data Out: ORACLE - Column = 22, Name = QGKS00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = NULL 1338 08:57:57 SQL Data Out: ORACLE - Column = 23, Name = QGKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1339 08:57:57 SQL Data Out: ORACLE - Column = 24, Name = GG0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1340 08:57:57 SQL Data Out: ORACLE - Column = 25, Name = XH0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1341 08:57:57 SQL Data Out: ORACLE - Column = 26, Name = SL0000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 1.000000 1342 08:57:57 SQL Data Out: ORACLE - Column = 27, Name = JLDW00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 架 1343 08:57:57 SQL Data Out: ORACLE - Column = 28, Name = DJ0000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 780.000000 1344 08:57:57 SQL Data Out: ORACLE - Column = 29, Name = ZJE000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 780.000000 1345 08:57:57 SQL Data Out: ORACLE - Column = 30, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 1346 08:57:57 SQL Data Out: ORACLE - Column = 31, Name = CXMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 1347 08:57:57 SQL Data Out: ORACLE - Column = 32, Name = BZ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1348 08:57:57 SQL Data Out: ORACLE - Column = 33, Name = RZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1349 08:57:57 SQL Data Out: ORACLE - Column = 34, Name = RCLXMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 正常出库 1350 08:57:57 SQL Data Out: ORACLE - Column = 35, Name = SBBH00, Type = fldZSTRING, Precision = 24, Scale = 0, Data = 90500021 1351 08:57:57 SQL Data Out: ORACLE - Column = 36, Name = CCBH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1352 08:57:57 SQL Data Out: ORACLE - Column = 1, Name = ZFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1353 08:57:57 SQL Data Out: ORACLE - Column = 2, Name = RCMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 10613.000000 1354 08:57:57 SQL Data Out: ORACLE - Column = 3, Name = FJMXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1355 08:57:57 SQL Data Out: ORACLE - Column = 4, Name = RCKID0, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 23206.000000 1356 08:57:57 SQL Data Out: ORACLE - Column = 5, Name = RKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 21000007 1357 08:57:57 SQL Data Out: ORACLE - Column = 6, Name = CKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 13000006 1358 08:57:57 SQL Data Out: ORACLE - Column = 7, Name = DAXXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 28530.000000 1359 08:57:57 SQL Data Out: ORACLE - Column = 8, Name = DAH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 905000220001 1360 08:57:57 SQL Data Out: ORACLE - Column = 9, Name = HTH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1361 08:57:57 SQL Data Out: ORACLE - Column = 10, Name = FPH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 11272396 1362 08:57:57 SQL Data Out: ORACLE - Column = 11, Name = FPRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 1363 08:57:57 SQL Data Out: ORACLE - Column = 12, Name = JLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1364 08:57:57 SQL Data Out: ORACLE - Column = 13, Name = FJBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1365 08:57:57 SQL Data Out: ORACLE - Column = 14, Name = SYBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1366 08:57:57 SQL Data Out: ORACLE - Column = 15, Name = SBID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 31901.000000 1367 08:57:57 SQL Data Out: ORACLE - Column = 16, Name = ZWPM00, Type = fldZSTRING, Precision = 52, Scale = 0, Data = 三门书柜 1368 08:57:57 SQL Data Out: ORACLE - Column = 17, Name = YWPM00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 1369 08:57:57 SQL Data Out: ORACLE - Column = 18, Name = CJID00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 5401.000000 1370 08:57:57 SQL Data Out: ORACLE - Column = 19, Name = CJMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 长乐吴航吉祥家具商场 1371 08:57:57 SQL Data Out: ORACLE - Column = 20, Name = SCCJID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1372 08:57:57 SQL Data Out: ORACLE - Column = 21, Name = SCCJMC, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 1373 08:57:57 SQL Data Out: ORACLE - Column = 22, Name = QGKS00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1374 08:57:57 SQL Data Out: ORACLE - Column = 23, Name = QGKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1375 08:57:57 SQL Data Out: ORACLE - Column = 24, Name = GG0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1376 08:57:57 SQL Data Out: ORACLE - Column = 25, Name = XH0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1377 08:57:57 SQL Data Out: ORACLE - Column = 26, Name = SL0000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 1.000000 1378 08:57:57 SQL Data Out: ORACLE - Column = 27, Name = JLDW00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 架 1379 08:57:57 SQL Data Out: ORACLE - Column = 28, Name = DJ0000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 950.000000 1380 08:57:57 SQL Data Out: ORACLE - Column = 29, Name = ZJE000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 950.000000 1381 08:57:57 SQL Data Out: ORACLE - Column = 30, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 1382 08:57:57 SQL Data Out: ORACLE - Column = 31, Name = CXMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 0.000000 1383 08:57:57 SQL Data Out: ORACLE - Column = 32, Name = BZ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1384 08:57:57 SQL Data Out: ORACLE - Column = 33, Name = RZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 1385 08:57:57 SQL Data Out: ORACLE - Column = 34, Name = RCLXMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 正常出库 1386 08:57:57 SQL Data Out: ORACLE - Column = 35, Name = SBBH00, Type = fldZSTRING, Precision = 24, Scale = 0, Data = 90500022 1387 08:57:57 SQL Data Out: ORACLE - Column = 36, Name = CCBH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1388 08:58:33 SQL Prepare: ORACLE - BEGIN "SP_SB_CKDSH" (AS_RCKID0 => :AS_RCKID0,AS_SHR000 => :AS_SHR000,AS_SHKS00 => :AS_SHKS00,RS_CWMS00 => :RS_CWMS00); END; 1389 08:58:33 SQL Execute: ORACLE - BEGIN "SP_SB_CKDSH" (AS_RCKID0 => :AS_RCKID0,AS_SHR000 => :AS_SHR000,AS_SHKS00 => :AS_SHKS00,RS_CWMS00 => :RS_CWMS00); END; 1390 08:58:34 SQL Prepare: ORACLE - Rollback 1391 08:58:34 SQL Execute: ORACLE - Rollback 1392 08:58:34 SQL Prepare: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='175' and DJRQ00>='20091001' and DJRQ00<='20100112' and LXID00='5' and SHBZ00='1' order by RCKID0 1393 08:58:34 SQL Execute: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='175' and DJRQ00>='20091001' and DJRQ00<='20100112' and LXID00='5' and SHBZ00='1' order by RCKID0 1394 08:58:34 SQL Data Out: ORACLE - Column = 1, Name = RCKID0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 23206.000000 1395 08:58:34 SQL Data Out: ORACLE - Column = 2, Name = RCKDH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 13000006 1396 08:58:34 SQL Data Out: ORACLE - Column = 3, Name = LXID00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 5.000000 1397 08:58:34 SQL Data Out: ORACLE - Column = 4, Name = RCLXMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 正常出库 1398 08:58:34 SQL Data Out: ORACLE - Column = 5, Name = DJLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 1399 08:58:34 SQL Data Out: ORACLE - Column = 6, Name = JSBM00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1400 08:58:34 SQL Data Out: ORACLE - Column = 7, Name = BGY000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 809.000000 1401 08:58:34 SQL Data Out: ORACLE - Column = 8, Name = BGYXM0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 郑建诗 1402 08:58:34 SQL Data Out: ORACLE - Column = 9, Name = SYBM00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 175.000000 1403 08:58:34 SQL Data Out: ORACLE - Column = 10, Name = SYBMMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 总务科 1404 08:58:34 SQL Data Out: ORACLE - Column = 11, Name = CKBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 175.000000 1405 08:58:34 SQL Data Out: ORACLE - Column = 12, Name = CKMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 总务科 1406 08:58:34 SQL Data Out: ORACLE - Column = 13, Name = HJJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 1407 08:58:34 SQL Data Out: ORACLE - Column = 14, Name = CBR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 809.000000 1408 08:58:34 SQL Data Out: ORACLE - Column = 15, Name = CBRXM0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 郑建诗 1409 08:58:34 SQL Data Out: ORACLE - Column = 16, Name = YSR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1410 08:58:34 SQL Data Out: ORACLE - Column = 17, Name = YSRXM0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1411 08:58:34 SQL Data Out: ORACLE - Column = 18, Name = LRR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 897.000000 1412 08:58:34 SQL Data Out: ORACLE - Column = 19, Name = LRRXM0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 林峰 1413 08:58:34 SQL Data Out: ORACLE - Column = 20, Name = DJRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20091012 1414 08:58:34 SQL Data Out: ORACLE - Column = 21, Name = DJSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 14:21:59 1415 08:58:34 SQL Data Out: ORACLE - Column = 22, Name = SHKS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1416 08:58:34 SQL Data Out: ORACLE - Column = 23, Name = SHKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1417 08:58:34 SQL Data Out: ORACLE - Column = 24, Name = SHR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1418 08:58:34 SQL Data Out: ORACLE - Column = 25, Name = SHRXM0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1419 08:58:34 SQL Data Out: ORACLE - Column = 26, Name = SHRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1420 08:58:34 SQL Data Out: ORACLE - Column = 27, Name = SHSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1421 08:58:34 SQL Data Out: ORACLE - Column = 28, Name = ZWSHRQ, Type = fldZSTRING, Precision = 22, Scale = 0, Data = 年月日 1422 08:58:34 SQL Data Out: ORACLE - Column = 29, Name = SHBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1423 08:58:34 SQL Data Out: ORACLE - Column = 30, Name = JDBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1424 08:58:34 SQL Data Out: ORACLE - Column = 31, Name = BZ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1425 08:58:34 SQL Data Out: ORACLE - Column = 32, Name = RZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1426 08:58:34 SQL Data Out: ORACLE - Column = 33, Name = CJID00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1427 08:58:34 SQL Data Out: ORACLE - Column = 34, Name = CJMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 1428 08:58:34 SQL Data Out: ORACLE - Column = 35, Name = YHZH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1429 08:58:34 SQL Data Out: ORACLE - Column = 36, Name = KHYH00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1430 08:58:34 SQL Data Out: ORACLE - Column = 37, Name = SFZFCG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 1431 08:58:34 SQL Data Out: ORACLE - Column = 38, Name = DYFKTZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 1432 08:58:34 SQL Data Out: ORACLE - Column = 39, Name = QRRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1433 08:58:34 SQL Data Out: ORACLE - Column = 40, Name = QRSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1434 08:58:34 SQL Data Out: ORACLE - Column = 41, Name = QRR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1435 08:58:34 SQL Data Out: ORACLE - Column = 42, Name = CGFS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 1436 08:58:34 SQL Data Out: ORACLE - Column = 43, Name = RCKBZ0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1437 08:58:34 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1438 08:58:34 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1439 08:58:34 SQL Data Out: ORACLE - Column = 1, Name = ZFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1440 08:58:34 SQL Data Out: ORACLE - Column = 2, Name = RCMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 10612.000000 1441 08:58:34 SQL Data Out: ORACLE - Column = 3, Name = FJMXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1442 08:58:34 SQL Data Out: ORACLE - Column = 4, Name = RCKID0, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 23206.000000 1443 08:58:34 SQL Data Out: ORACLE - Column = 5, Name = RKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 21000007 1444 08:58:34 SQL Data Out: ORACLE - Column = 6, Name = CKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 13000006 1445 08:58:34 SQL Data Out: ORACLE - Column = 7, Name = DAXXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 28529.000000 1446 08:58:34 SQL Data Out: ORACLE - Column = 8, Name = DAH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 905000210003 1447 08:58:34 SQL Data Out: ORACLE - Column = 9, Name = HTH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1448 08:58:34 SQL Data Out: ORACLE - Column = 10, Name = FPH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 11272396 1449 08:58:34 SQL Data Out: ORACLE - Column = 11, Name = FPRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1450 08:58:34 SQL Data Out: ORACLE - Column = 12, Name = JLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1451 08:58:34 SQL Data Out: ORACLE - Column = 13, Name = FJBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1452 08:58:34 SQL Data Out: ORACLE - Column = 14, Name = SYBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1453 08:58:34 SQL Data Out: ORACLE - Column = 15, Name = SBID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 31401.000000 1454 08:58:34 SQL Data Out: ORACLE - Column = 16, Name = ZWPM00, Type = fldZSTRING, Precision = 52, Scale = 0, Data = 二门书柜 1455 08:58:34 SQL Data Out: ORACLE - Column = 17, Name = YWPM00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1456 08:58:34 SQL Data Out: ORACLE - Column = 18, Name = CJID00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 5401.000000 1457 08:58:34 SQL Data Out: ORACLE - Column = 19, Name = CJMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 长乐吴航吉祥家具商场 1458 08:58:34 SQL Data Out: ORACLE - Column = 20, Name = SCCJID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = NULL 1459 08:58:34 SQL Data Out: ORACLE - Column = 21, Name = SCCJMC, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 1460 08:58:34 SQL Data Out: ORACLE - Column = 22, Name = QGKS00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = NULL 1461 08:58:34 SQL Data Out: ORACLE - Column = 23, Name = QGKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1462 08:58:34 SQL Data Out: ORACLE - Column = 24, Name = GG0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1463 08:58:34 SQL Data Out: ORACLE - Column = 25, Name = XH0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1464 08:58:34 SQL Data Out: ORACLE - Column = 26, Name = SL0000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 1.000000 1465 08:58:34 SQL Data Out: ORACLE - Column = 27, Name = JLDW00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 架 1466 08:58:34 SQL Data Out: ORACLE - Column = 28, Name = DJ0000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 780.000000 1467 08:58:34 SQL Data Out: ORACLE - Column = 29, Name = ZJE000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 780.000000 1468 08:58:34 SQL Data Out: ORACLE - Column = 30, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 1469 08:58:34 SQL Data Out: ORACLE - Column = 31, Name = CXMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 1470 08:58:34 SQL Data Out: ORACLE - Column = 32, Name = BZ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1471 08:58:34 SQL Data Out: ORACLE - Column = 33, Name = RZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1472 08:58:34 SQL Data Out: ORACLE - Column = 34, Name = RCLXMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 正常出库 1473 08:58:34 SQL Data Out: ORACLE - Column = 35, Name = SBBH00, Type = fldZSTRING, Precision = 24, Scale = 0, Data = 90500021 1474 08:58:34 SQL Data Out: ORACLE - Column = 36, Name = CCBH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1475 08:58:34 SQL Data Out: ORACLE - Column = 1, Name = ZFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1476 08:58:34 SQL Data Out: ORACLE - Column = 2, Name = RCMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 10613.000000 1477 08:58:34 SQL Data Out: ORACLE - Column = 3, Name = FJMXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1478 08:58:34 SQL Data Out: ORACLE - Column = 4, Name = RCKID0, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 23206.000000 1479 08:58:34 SQL Data Out: ORACLE - Column = 5, Name = RKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 21000007 1480 08:58:34 SQL Data Out: ORACLE - Column = 6, Name = CKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 13000006 1481 08:58:34 SQL Data Out: ORACLE - Column = 7, Name = DAXXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 28530.000000 1482 08:58:34 SQL Data Out: ORACLE - Column = 8, Name = DAH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 905000220001 1483 08:58:34 SQL Data Out: ORACLE - Column = 9, Name = HTH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1484 08:58:34 SQL Data Out: ORACLE - Column = 10, Name = FPH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 11272396 1485 08:58:34 SQL Data Out: ORACLE - Column = 11, Name = FPRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 1486 08:58:34 SQL Data Out: ORACLE - Column = 12, Name = JLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1487 08:58:34 SQL Data Out: ORACLE - Column = 13, Name = FJBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1488 08:58:34 SQL Data Out: ORACLE - Column = 14, Name = SYBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1489 08:58:34 SQL Data Out: ORACLE - Column = 15, Name = SBID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 31901.000000 1490 08:58:34 SQL Data Out: ORACLE - Column = 16, Name = ZWPM00, Type = fldZSTRING, Precision = 52, Scale = 0, Data = 三门书柜 1491 08:58:34 SQL Data Out: ORACLE - Column = 17, Name = YWPM00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 1492 08:58:34 SQL Data Out: ORACLE - Column = 18, Name = CJID00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 5401.000000 1493 08:58:34 SQL Data Out: ORACLE - Column = 19, Name = CJMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 长乐吴航吉祥家具商场 1494 08:58:34 SQL Data Out: ORACLE - Column = 20, Name = SCCJID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1495 08:58:34 SQL Data Out: ORACLE - Column = 21, Name = SCCJMC, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 1496 08:58:34 SQL Data Out: ORACLE - Column = 22, Name = QGKS00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1497 08:58:34 SQL Data Out: ORACLE - Column = 23, Name = QGKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1498 08:58:34 SQL Data Out: ORACLE - Column = 24, Name = GG0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1499 08:58:34 SQL Data Out: ORACLE - Column = 25, Name = XH0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1500 08:58:34 SQL Data Out: ORACLE - Column = 26, Name = SL0000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 1.000000 1501 08:58:34 SQL Data Out: ORACLE - Column = 27, Name = JLDW00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 架 1502 08:58:34 SQL Data Out: ORACLE - Column = 28, Name = DJ0000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 950.000000 1503 08:58:34 SQL Data Out: ORACLE - Column = 29, Name = ZJE000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 950.000000 1504 08:58:34 SQL Data Out: ORACLE - Column = 30, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 1505 08:58:34 SQL Data Out: ORACLE - Column = 31, Name = CXMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 0.000000 1506 08:58:34 SQL Data Out: ORACLE - Column = 32, Name = BZ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1507 08:58:34 SQL Data Out: ORACLE - Column = 33, Name = RZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 1508 08:58:34 SQL Data Out: ORACLE - Column = 34, Name = RCLXMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 正常出库 1509 08:58:34 SQL Data Out: ORACLE - Column = 35, Name = SBBH00, Type = fldZSTRING, Precision = 24, Scale = 0, Data = 90500022 1510 08:58:34 SQL Data Out: ORACLE - Column = 36, Name = CCBH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1511 08:58:34 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1512 08:58:34 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1513 08:58:34 SQL Data Out: ORACLE - Column = 1, Name = ZFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1514 08:58:34 SQL Data Out: ORACLE - Column = 2, Name = RCMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 10612.000000 1515 08:58:34 SQL Data Out: ORACLE - Column = 3, Name = FJMXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1516 08:58:34 SQL Data Out: ORACLE - Column = 4, Name = RCKID0, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 23206.000000 1517 08:58:34 SQL Data Out: ORACLE - Column = 5, Name = RKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 21000007 1518 08:58:34 SQL Data Out: ORACLE - Column = 6, Name = CKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 13000006 1519 08:58:34 SQL Data Out: ORACLE - Column = 7, Name = DAXXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 28529.000000 1520 08:58:34 SQL Data Out: ORACLE - Column = 8, Name = DAH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 905000210003 1521 08:58:34 SQL Data Out: ORACLE - Column = 9, Name = HTH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1522 08:58:34 SQL Data Out: ORACLE - Column = 10, Name = FPH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 11272396 1523 08:58:34 SQL Data Out: ORACLE - Column = 11, Name = FPRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1524 08:58:34 SQL Data Out: ORACLE - Column = 12, Name = JLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1525 08:58:34 SQL Data Out: ORACLE - Column = 13, Name = FJBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1526 08:58:34 SQL Data Out: ORACLE - Column = 14, Name = SYBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1527 08:58:34 SQL Data Out: ORACLE - Column = 15, Name = SBID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 31401.000000 1528 08:58:34 SQL Data Out: ORACLE - Column = 16, Name = ZWPM00, Type = fldZSTRING, Precision = 52, Scale = 0, Data = 二门书柜 1529 08:58:34 SQL Data Out: ORACLE - Column = 17, Name = YWPM00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1530 08:58:34 SQL Data Out: ORACLE - Column = 18, Name = CJID00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 5401.000000 1531 08:58:34 SQL Data Out: ORACLE - Column = 19, Name = CJMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 长乐吴航吉祥家具商场 1532 08:58:34 SQL Data Out: ORACLE - Column = 20, Name = SCCJID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = NULL 1533 08:58:34 SQL Data Out: ORACLE - Column = 21, Name = SCCJMC, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 1534 08:58:34 SQL Data Out: ORACLE - Column = 22, Name = QGKS00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = NULL 1535 08:58:34 SQL Data Out: ORACLE - Column = 23, Name = QGKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1536 08:58:34 SQL Data Out: ORACLE - Column = 24, Name = GG0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1537 08:58:34 SQL Data Out: ORACLE - Column = 25, Name = XH0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1538 08:58:34 SQL Data Out: ORACLE - Column = 26, Name = SL0000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 1.000000 1539 08:58:34 SQL Data Out: ORACLE - Column = 27, Name = JLDW00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 架 1540 08:58:34 SQL Data Out: ORACLE - Column = 28, Name = DJ0000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 780.000000 1541 08:58:34 SQL Data Out: ORACLE - Column = 29, Name = ZJE000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 780.000000 1542 08:58:34 SQL Data Out: ORACLE - Column = 30, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 1543 08:58:34 SQL Data Out: ORACLE - Column = 31, Name = CXMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 1544 08:58:34 SQL Data Out: ORACLE - Column = 32, Name = BZ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1545 08:58:34 SQL Data Out: ORACLE - Column = 33, Name = RZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1546 08:58:34 SQL Data Out: ORACLE - Column = 34, Name = RCLXMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 正常出库 1547 08:58:34 SQL Data Out: ORACLE - Column = 35, Name = SBBH00, Type = fldZSTRING, Precision = 24, Scale = 0, Data = 90500021 1548 08:58:34 SQL Data Out: ORACLE - Column = 36, Name = CCBH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1549 08:58:34 SQL Data Out: ORACLE - Column = 1, Name = ZFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1550 08:58:34 SQL Data Out: ORACLE - Column = 2, Name = RCMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 10613.000000 1551 08:58:34 SQL Data Out: ORACLE - Column = 3, Name = FJMXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1552 08:58:34 SQL Data Out: ORACLE - Column = 4, Name = RCKID0, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 23206.000000 1553 08:58:34 SQL Data Out: ORACLE - Column = 5, Name = RKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 21000007 1554 08:58:34 SQL Data Out: ORACLE - Column = 6, Name = CKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 13000006 1555 08:58:34 SQL Data Out: ORACLE - Column = 7, Name = DAXXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 28530.000000 1556 08:58:34 SQL Data Out: ORACLE - Column = 8, Name = DAH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 905000220001 1557 08:58:34 SQL Data Out: ORACLE - Column = 9, Name = HTH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1558 08:58:34 SQL Data Out: ORACLE - Column = 10, Name = FPH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 11272396 1559 08:58:34 SQL Data Out: ORACLE - Column = 11, Name = FPRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 1560 08:58:34 SQL Data Out: ORACLE - Column = 12, Name = JLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1561 08:58:34 SQL Data Out: ORACLE - Column = 13, Name = FJBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1562 08:58:34 SQL Data Out: ORACLE - Column = 14, Name = SYBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1563 08:58:34 SQL Data Out: ORACLE - Column = 15, Name = SBID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 31901.000000 1564 08:58:34 SQL Data Out: ORACLE - Column = 16, Name = ZWPM00, Type = fldZSTRING, Precision = 52, Scale = 0, Data = 三门书柜 1565 08:58:34 SQL Data Out: ORACLE - Column = 17, Name = YWPM00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 1566 08:58:34 SQL Data Out: ORACLE - Column = 18, Name = CJID00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 5401.000000 1567 08:58:34 SQL Data Out: ORACLE - Column = 19, Name = CJMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 长乐吴航吉祥家具商场 1568 08:58:34 SQL Data Out: ORACLE - Column = 20, Name = SCCJID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1569 08:58:34 SQL Data Out: ORACLE - Column = 21, Name = SCCJMC, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 1570 08:58:34 SQL Data Out: ORACLE - Column = 22, Name = QGKS00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1571 08:58:34 SQL Data Out: ORACLE - Column = 23, Name = QGKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1572 08:58:34 SQL Data Out: ORACLE - Column = 24, Name = GG0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1573 08:58:34 SQL Data Out: ORACLE - Column = 25, Name = XH0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1574 08:58:34 SQL Data Out: ORACLE - Column = 26, Name = SL0000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 1.000000 1575 08:58:34 SQL Data Out: ORACLE - Column = 27, Name = JLDW00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 架 1576 08:58:34 SQL Data Out: ORACLE - Column = 28, Name = DJ0000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 950.000000 1577 08:58:34 SQL Data Out: ORACLE - Column = 29, Name = ZJE000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 950.000000 1578 08:58:34 SQL Data Out: ORACLE - Column = 30, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 1579 08:58:34 SQL Data Out: ORACLE - Column = 31, Name = CXMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 0.000000 1580 08:58:34 SQL Data Out: ORACLE - Column = 32, Name = BZ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1581 08:58:34 SQL Data Out: ORACLE - Column = 33, Name = RZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 1582 08:58:34 SQL Data Out: ORACLE - Column = 34, Name = RCLXMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 正常出库 1583 08:58:34 SQL Data Out: ORACLE - Column = 35, Name = SBBH00, Type = fldZSTRING, Precision = 24, Scale = 0, Data = 90500022 1584 08:58:34 SQL Data Out: ORACLE - Column = 36, Name = CCBH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1585 08:58:34 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1586 08:58:34 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1587 08:58:34 SQL Data Out: ORACLE - Column = 1, Name = ZFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1588 08:58:34 SQL Data Out: ORACLE - Column = 2, Name = RCMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 10612.000000 1589 08:58:34 SQL Data Out: ORACLE - Column = 3, Name = FJMXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1590 08:58:34 SQL Data Out: ORACLE - Column = 4, Name = RCKID0, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 23206.000000 1591 08:58:34 SQL Data Out: ORACLE - Column = 5, Name = RKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 21000007 1592 08:58:34 SQL Data Out: ORACLE - Column = 6, Name = CKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 13000006 1593 08:58:34 SQL Data Out: ORACLE - Column = 7, Name = DAXXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 28529.000000 1594 08:58:34 SQL Data Out: ORACLE - Column = 8, Name = DAH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 905000210003 1595 08:58:34 SQL Data Out: ORACLE - Column = 9, Name = HTH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1596 08:58:34 SQL Data Out: ORACLE - Column = 10, Name = FPH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 11272396 1597 08:58:34 SQL Data Out: ORACLE - Column = 11, Name = FPRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1598 08:58:34 SQL Data Out: ORACLE - Column = 12, Name = JLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1599 08:58:34 SQL Data Out: ORACLE - Column = 13, Name = FJBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1600 08:58:34 SQL Data Out: ORACLE - Column = 14, Name = SYBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1601 08:58:34 SQL Data Out: ORACLE - Column = 15, Name = SBID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 31401.000000 1602 08:58:34 SQL Data Out: ORACLE - Column = 16, Name = ZWPM00, Type = fldZSTRING, Precision = 52, Scale = 0, Data = 二门书柜 1603 08:58:34 SQL Data Out: ORACLE - Column = 17, Name = YWPM00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1604 08:58:34 SQL Data Out: ORACLE - Column = 18, Name = CJID00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 5401.000000 1605 08:58:34 SQL Data Out: ORACLE - Column = 19, Name = CJMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 长乐吴航吉祥家具商场 1606 08:58:34 SQL Data Out: ORACLE - Column = 20, Name = SCCJID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = NULL 1607 08:58:34 SQL Data Out: ORACLE - Column = 21, Name = SCCJMC, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 1608 08:58:34 SQL Data Out: ORACLE - Column = 22, Name = QGKS00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = NULL 1609 08:58:34 SQL Data Out: ORACLE - Column = 23, Name = QGKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1610 08:58:34 SQL Data Out: ORACLE - Column = 24, Name = GG0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1611 08:58:34 SQL Data Out: ORACLE - Column = 25, Name = XH0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1612 08:58:34 SQL Data Out: ORACLE - Column = 26, Name = SL0000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 1.000000 1613 08:58:34 SQL Data Out: ORACLE - Column = 27, Name = JLDW00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 架 1614 08:58:34 SQL Data Out: ORACLE - Column = 28, Name = DJ0000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 780.000000 1615 08:58:34 SQL Data Out: ORACLE - Column = 29, Name = ZJE000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 780.000000 1616 08:58:34 SQL Data Out: ORACLE - Column = 30, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 1617 08:58:34 SQL Data Out: ORACLE - Column = 31, Name = CXMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 1618 08:58:34 SQL Data Out: ORACLE - Column = 32, Name = BZ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1619 08:58:34 SQL Data Out: ORACLE - Column = 33, Name = RZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1620 08:58:34 SQL Data Out: ORACLE - Column = 34, Name = RCLXMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 正常出库 1621 08:58:34 SQL Data Out: ORACLE - Column = 35, Name = SBBH00, Type = fldZSTRING, Precision = 24, Scale = 0, Data = 90500021 1622 08:58:34 SQL Data Out: ORACLE - Column = 36, Name = CCBH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1623 08:58:34 SQL Data Out: ORACLE - Column = 1, Name = ZFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1624 08:58:34 SQL Data Out: ORACLE - Column = 2, Name = RCMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 10613.000000 1625 08:58:34 SQL Data Out: ORACLE - Column = 3, Name = FJMXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1626 08:58:34 SQL Data Out: ORACLE - Column = 4, Name = RCKID0, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 23206.000000 1627 08:58:34 SQL Data Out: ORACLE - Column = 5, Name = RKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 21000007 1628 08:58:34 SQL Data Out: ORACLE - Column = 6, Name = CKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 13000006 1629 08:58:34 SQL Data Out: ORACLE - Column = 7, Name = DAXXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 28530.000000 1630 08:58:34 SQL Data Out: ORACLE - Column = 8, Name = DAH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 905000220001 1631 08:58:34 SQL Data Out: ORACLE - Column = 9, Name = HTH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1632 08:58:34 SQL Data Out: ORACLE - Column = 10, Name = FPH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 11272396 1633 08:58:34 SQL Data Out: ORACLE - Column = 11, Name = FPRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 1634 08:58:34 SQL Data Out: ORACLE - Column = 12, Name = JLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1635 08:58:34 SQL Data Out: ORACLE - Column = 13, Name = FJBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1636 08:58:34 SQL Data Out: ORACLE - Column = 14, Name = SYBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1637 08:58:34 SQL Data Out: ORACLE - Column = 15, Name = SBID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 31901.000000 1638 08:58:34 SQL Data Out: ORACLE - Column = 16, Name = ZWPM00, Type = fldZSTRING, Precision = 52, Scale = 0, Data = 三门书柜 1639 08:58:34 SQL Data Out: ORACLE - Column = 17, Name = YWPM00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 1640 08:58:34 SQL Data Out: ORACLE - Column = 18, Name = CJID00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 5401.000000 1641 08:58:34 SQL Data Out: ORACLE - Column = 19, Name = CJMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 长乐吴航吉祥家具商场 1642 08:58:34 SQL Data Out: ORACLE - Column = 20, Name = SCCJID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1643 08:58:34 SQL Data Out: ORACLE - Column = 21, Name = SCCJMC, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 1644 08:58:34 SQL Data Out: ORACLE - Column = 22, Name = QGKS00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1645 08:58:34 SQL Data Out: ORACLE - Column = 23, Name = QGKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1646 08:58:34 SQL Data Out: ORACLE - Column = 24, Name = GG0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1647 08:58:34 SQL Data Out: ORACLE - Column = 25, Name = XH0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1648 08:58:34 SQL Data Out: ORACLE - Column = 26, Name = SL0000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 1.000000 1649 08:58:34 SQL Data Out: ORACLE - Column = 27, Name = JLDW00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 架 1650 08:58:34 SQL Data Out: ORACLE - Column = 28, Name = DJ0000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 950.000000 1651 08:58:34 SQL Data Out: ORACLE - Column = 29, Name = ZJE000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 950.000000 1652 08:58:34 SQL Data Out: ORACLE - Column = 30, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 1653 08:58:34 SQL Data Out: ORACLE - Column = 31, Name = CXMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 0.000000 1654 08:58:34 SQL Data Out: ORACLE - Column = 32, Name = BZ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1655 08:58:34 SQL Data Out: ORACLE - Column = 33, Name = RZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 1656 08:58:34 SQL Data Out: ORACLE - Column = 34, Name = RCLXMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 正常出库 1657 08:58:34 SQL Data Out: ORACLE - Column = 35, Name = SBBH00, Type = fldZSTRING, Precision = 24, Scale = 0, Data = 90500022 1658 08:58:34 SQL Data Out: ORACLE - Column = 36, Name = CCBH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1659 08:58:34 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1660 08:58:34 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1661 08:58:35 SQL Data Out: ORACLE - Column = 1, Name = ZFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1662 08:58:35 SQL Data Out: ORACLE - Column = 2, Name = RCMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 10612.000000 1663 08:58:35 SQL Data Out: ORACLE - Column = 3, Name = FJMXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1664 08:58:35 SQL Data Out: ORACLE - Column = 4, Name = RCKID0, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 23206.000000 1665 08:58:35 SQL Data Out: ORACLE - Column = 5, Name = RKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 21000007 1666 08:58:35 SQL Data Out: ORACLE - Column = 6, Name = CKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 13000006 1667 08:58:35 SQL Data Out: ORACLE - Column = 7, Name = DAXXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 28529.000000 1668 08:58:35 SQL Data Out: ORACLE - Column = 8, Name = DAH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 905000210003 1669 08:58:35 SQL Data Out: ORACLE - Column = 9, Name = HTH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1670 08:58:35 SQL Data Out: ORACLE - Column = 10, Name = FPH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 11272396 1671 08:58:35 SQL Data Out: ORACLE - Column = 11, Name = FPRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1672 08:58:35 SQL Data Out: ORACLE - Column = 12, Name = JLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1673 08:58:35 SQL Data Out: ORACLE - Column = 13, Name = FJBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1674 08:58:35 SQL Data Out: ORACLE - Column = 14, Name = SYBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1675 08:58:35 SQL Data Out: ORACLE - Column = 15, Name = SBID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 31401.000000 1676 08:58:35 SQL Data Out: ORACLE - Column = 16, Name = ZWPM00, Type = fldZSTRING, Precision = 52, Scale = 0, Data = 二门书柜 1677 08:58:35 SQL Data Out: ORACLE - Column = 17, Name = YWPM00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1678 08:58:35 SQL Data Out: ORACLE - Column = 18, Name = CJID00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 5401.000000 1679 08:58:35 SQL Data Out: ORACLE - Column = 19, Name = CJMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 长乐吴航吉祥家具商场 1680 08:58:35 SQL Data Out: ORACLE - Column = 20, Name = SCCJID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = NULL 1681 08:58:35 SQL Data Out: ORACLE - Column = 21, Name = SCCJMC, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 1682 08:58:35 SQL Data Out: ORACLE - Column = 22, Name = QGKS00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = NULL 1683 08:58:35 SQL Data Out: ORACLE - Column = 23, Name = QGKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1684 08:58:35 SQL Data Out: ORACLE - Column = 24, Name = GG0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1685 08:58:35 SQL Data Out: ORACLE - Column = 25, Name = XH0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1686 08:58:35 SQL Data Out: ORACLE - Column = 26, Name = SL0000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 1.000000 1687 08:58:35 SQL Data Out: ORACLE - Column = 27, Name = JLDW00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 架 1688 08:58:35 SQL Data Out: ORACLE - Column = 28, Name = DJ0000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 780.000000 1689 08:58:35 SQL Data Out: ORACLE - Column = 29, Name = ZJE000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 780.000000 1690 08:58:35 SQL Data Out: ORACLE - Column = 30, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 1691 08:58:35 SQL Data Out: ORACLE - Column = 31, Name = CXMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 1692 08:58:35 SQL Data Out: ORACLE - Column = 32, Name = BZ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1693 08:58:35 SQL Data Out: ORACLE - Column = 33, Name = RZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1694 08:58:35 SQL Data Out: ORACLE - Column = 34, Name = RCLXMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 正常出库 1695 08:58:35 SQL Data Out: ORACLE - Column = 35, Name = SBBH00, Type = fldZSTRING, Precision = 24, Scale = 0, Data = 90500021 1696 08:58:35 SQL Data Out: ORACLE - Column = 36, Name = CCBH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1697 08:58:35 SQL Data Out: ORACLE - Column = 1, Name = ZFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1698 08:58:35 SQL Data Out: ORACLE - Column = 2, Name = RCMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 10613.000000 1699 08:58:35 SQL Data Out: ORACLE - Column = 3, Name = FJMXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1700 08:58:35 SQL Data Out: ORACLE - Column = 4, Name = RCKID0, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 23206.000000 1701 08:58:35 SQL Data Out: ORACLE - Column = 5, Name = RKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 21000007 1702 08:58:35 SQL Data Out: ORACLE - Column = 6, Name = CKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 13000006 1703 08:58:35 SQL Data Out: ORACLE - Column = 7, Name = DAXXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 28530.000000 1704 08:58:35 SQL Data Out: ORACLE - Column = 8, Name = DAH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 905000220001 1705 08:58:35 SQL Data Out: ORACLE - Column = 9, Name = HTH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1706 08:58:35 SQL Data Out: ORACLE - Column = 10, Name = FPH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 11272396 1707 08:58:35 SQL Data Out: ORACLE - Column = 11, Name = FPRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 1708 08:58:35 SQL Data Out: ORACLE - Column = 12, Name = JLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1709 08:58:35 SQL Data Out: ORACLE - Column = 13, Name = FJBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1710 08:58:35 SQL Data Out: ORACLE - Column = 14, Name = SYBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1711 08:58:35 SQL Data Out: ORACLE - Column = 15, Name = SBID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 31901.000000 1712 08:58:35 SQL Data Out: ORACLE - Column = 16, Name = ZWPM00, Type = fldZSTRING, Precision = 52, Scale = 0, Data = 三门书柜 1713 08:58:35 SQL Data Out: ORACLE - Column = 17, Name = YWPM00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 1714 08:58:35 SQL Data Out: ORACLE - Column = 18, Name = CJID00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 5401.000000 1715 08:58:35 SQL Data Out: ORACLE - Column = 19, Name = CJMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 长乐吴航吉祥家具商场 1716 08:58:35 SQL Data Out: ORACLE - Column = 20, Name = SCCJID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1717 08:58:35 SQL Data Out: ORACLE - Column = 21, Name = SCCJMC, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 1718 08:58:35 SQL Data Out: ORACLE - Column = 22, Name = QGKS00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1719 08:58:35 SQL Data Out: ORACLE - Column = 23, Name = QGKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1720 08:58:35 SQL Data Out: ORACLE - Column = 24, Name = GG0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1721 08:58:35 SQL Data Out: ORACLE - Column = 25, Name = XH0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1722 08:58:35 SQL Data Out: ORACLE - Column = 26, Name = SL0000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 1.000000 1723 08:58:35 SQL Data Out: ORACLE - Column = 27, Name = JLDW00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 架 1724 08:58:35 SQL Data Out: ORACLE - Column = 28, Name = DJ0000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 950.000000 1725 08:58:35 SQL Data Out: ORACLE - Column = 29, Name = ZJE000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 950.000000 1726 08:58:35 SQL Data Out: ORACLE - Column = 30, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 1727 08:58:35 SQL Data Out: ORACLE - Column = 31, Name = CXMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 0.000000 1728 08:58:35 SQL Data Out: ORACLE - Column = 32, Name = BZ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1729 08:58:35 SQL Data Out: ORACLE - Column = 33, Name = RZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 1730 08:58:35 SQL Data Out: ORACLE - Column = 34, Name = RCLXMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 正常出库 1731 08:58:35 SQL Data Out: ORACLE - Column = 35, Name = SBBH00, Type = fldZSTRING, Precision = 24, Scale = 0, Data = 90500022 1732 08:58:35 SQL Data Out: ORACLE - Column = 36, Name = CCBH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1733 08:58:35 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1734 08:58:35 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1735 08:58:35 SQL Data Out: ORACLE - Column = 1, Name = ZFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1736 08:58:35 SQL Data Out: ORACLE - Column = 2, Name = RCMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 10612.000000 1737 08:58:35 SQL Data Out: ORACLE - Column = 3, Name = FJMXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1738 08:58:35 SQL Data Out: ORACLE - Column = 4, Name = RCKID0, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 23206.000000 1739 08:58:35 SQL Data Out: ORACLE - Column = 5, Name = RKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 21000007 1740 08:58:35 SQL Data Out: ORACLE - Column = 6, Name = CKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 13000006 1741 08:58:35 SQL Data Out: ORACLE - Column = 7, Name = DAXXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 28529.000000 1742 08:58:35 SQL Data Out: ORACLE - Column = 8, Name = DAH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 905000210003 1743 08:58:35 SQL Data Out: ORACLE - Column = 9, Name = HTH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1744 08:58:35 SQL Data Out: ORACLE - Column = 10, Name = FPH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 11272396 1745 08:58:35 SQL Data Out: ORACLE - Column = 11, Name = FPRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1746 08:58:35 SQL Data Out: ORACLE - Column = 12, Name = JLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1747 08:58:35 SQL Data Out: ORACLE - Column = 13, Name = FJBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1748 08:58:35 SQL Data Out: ORACLE - Column = 14, Name = SYBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1749 08:58:35 SQL Data Out: ORACLE - Column = 15, Name = SBID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 31401.000000 1750 08:58:35 SQL Data Out: ORACLE - Column = 16, Name = ZWPM00, Type = fldZSTRING, Precision = 52, Scale = 0, Data = 二门书柜 1751 08:58:35 SQL Data Out: ORACLE - Column = 17, Name = YWPM00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1752 08:58:35 SQL Data Out: ORACLE - Column = 18, Name = CJID00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 5401.000000 1753 08:58:35 SQL Data Out: ORACLE - Column = 19, Name = CJMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 长乐吴航吉祥家具商场 1754 08:58:35 SQL Data Out: ORACLE - Column = 20, Name = SCCJID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = NULL 1755 08:58:35 SQL Data Out: ORACLE - Column = 21, Name = SCCJMC, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 1756 08:58:35 SQL Data Out: ORACLE - Column = 22, Name = QGKS00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = NULL 1757 08:58:35 SQL Data Out: ORACLE - Column = 23, Name = QGKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1758 08:58:35 SQL Data Out: ORACLE - Column = 24, Name = GG0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1759 08:58:35 SQL Data Out: ORACLE - Column = 25, Name = XH0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1760 08:58:35 SQL Data Out: ORACLE - Column = 26, Name = SL0000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 1.000000 1761 08:58:35 SQL Data Out: ORACLE - Column = 27, Name = JLDW00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 架 1762 08:58:35 SQL Data Out: ORACLE - Column = 28, Name = DJ0000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 780.000000 1763 08:58:35 SQL Data Out: ORACLE - Column = 29, Name = ZJE000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 780.000000 1764 08:58:35 SQL Data Out: ORACLE - Column = 30, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 1765 08:58:35 SQL Data Out: ORACLE - Column = 31, Name = CXMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 1766 08:58:35 SQL Data Out: ORACLE - Column = 32, Name = BZ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 1767 08:58:35 SQL Data Out: ORACLE - Column = 33, Name = RZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 1768 08:58:35 SQL Data Out: ORACLE - Column = 34, Name = RCLXMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 正常出库 1769 08:58:35 SQL Data Out: ORACLE - Column = 35, Name = SBBH00, Type = fldZSTRING, Precision = 24, Scale = 0, Data = 90500021 1770 08:58:35 SQL Data Out: ORACLE - Column = 36, Name = CCBH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 1771 08:58:35 SQL Data Out: ORACLE - Column = 1, Name = ZFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1772 08:58:35 SQL Data Out: ORACLE - Column = 2, Name = RCMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 10613.000000 1773 08:58:35 SQL Data Out: ORACLE - Column = 3, Name = FJMXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1774 08:58:35 SQL Data Out: ORACLE - Column = 4, Name = RCKID0, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 23206.000000 1775 08:58:35 SQL Data Out: ORACLE - Column = 5, Name = RKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 21000007 1776 08:58:35 SQL Data Out: ORACLE - Column = 6, Name = CKDH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 13000006 1777 08:58:35 SQL Data Out: ORACLE - Column = 7, Name = DAXXID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 28530.000000 1778 08:58:35 SQL Data Out: ORACLE - Column = 8, Name = DAH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 905000220001 1779 08:58:35 SQL Data Out: ORACLE - Column = 9, Name = HTH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1780 08:58:35 SQL Data Out: ORACLE - Column = 10, Name = FPH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 11272396 1781 08:58:35 SQL Data Out: ORACLE - Column = 11, Name = FPRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 1782 08:58:35 SQL Data Out: ORACLE - Column = 12, Name = JLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1783 08:58:35 SQL Data Out: ORACLE - Column = 13, Name = FJBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1784 08:58:35 SQL Data Out: ORACLE - Column = 14, Name = SYBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1785 08:58:35 SQL Data Out: ORACLE - Column = 15, Name = SBID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 31901.000000 1786 08:58:35 SQL Data Out: ORACLE - Column = 16, Name = ZWPM00, Type = fldZSTRING, Precision = 52, Scale = 0, Data = 三门书柜 1787 08:58:35 SQL Data Out: ORACLE - Column = 17, Name = YWPM00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 1788 08:58:35 SQL Data Out: ORACLE - Column = 18, Name = CJID00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 5401.000000 1789 08:58:35 SQL Data Out: ORACLE - Column = 19, Name = CJMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 长乐吴航吉祥家具商场 1790 08:58:35 SQL Data Out: ORACLE - Column = 20, Name = SCCJID, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1791 08:58:35 SQL Data Out: ORACLE - Column = 21, Name = SCCJMC, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 1792 08:58:35 SQL Data Out: ORACLE - Column = 22, Name = QGKS00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 1793 08:58:35 SQL Data Out: ORACLE - Column = 23, Name = QGKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1794 08:58:35 SQL Data Out: ORACLE - Column = 24, Name = GG0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1795 08:58:35 SQL Data Out: ORACLE - Column = 25, Name = XH0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1796 08:58:35 SQL Data Out: ORACLE - Column = 26, Name = SL0000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 1.000000 1797 08:58:35 SQL Data Out: ORACLE - Column = 27, Name = JLDW00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 架 1798 08:58:35 SQL Data Out: ORACLE - Column = 28, Name = DJ0000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 950.000000 1799 08:58:35 SQL Data Out: ORACLE - Column = 29, Name = ZJE000, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 950.000000 1800 08:58:35 SQL Data Out: ORACLE - Column = 30, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 1801 08:58:35 SQL Data Out: ORACLE - Column = 31, Name = CXMXID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 0.000000 1802 08:58:35 SQL Data Out: ORACLE - Column = 32, Name = BZ0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1803 08:58:35 SQL Data Out: ORACLE - Column = 33, Name = RZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 1804 08:58:35 SQL Data Out: ORACLE - Column = 34, Name = RCLXMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 正常出库 1805 08:58:35 SQL Data Out: ORACLE - Column = 35, Name = SBBH00, Type = fldZSTRING, Precision = 24, Scale = 0, Data = 90500022 1806 08:58:35 SQL Data Out: ORACLE - Column = 36, Name = CCBH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1807 08:58:45 SQL Prepare: ORACLE - BEGIN "SP_SB_CKDSH" (AS_RCKID0 => :AS_RCKID0,AS_SHR000 => :AS_SHR000,AS_SHKS00 => :AS_SHKS00,RS_CWMS00 => :RS_CWMS00); END; 1808 08:58:45 SQL Data In: ORACLE - Param = 1, Name = AS_RCKID0, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 23206 1809 08:58:45 SQL Data In: ORACLE - Param = 2, Name = AS_SHR000, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 476 1810 08:58:45 SQL Data In: ORACLE - Param = 3, Name = AS_SHKS00, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 175 1811 08:58:45 SQL Data In: ORACLE - Param = 4, Name = RS_CWMS00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1812 08:58:45 SQL Execute: ORACLE - BEGIN "SP_SB_CKDSH" (AS_RCKID0 => :AS_RCKID0,AS_SHR000 => :AS_SHR000,AS_SHKS00 => :AS_SHKS00,RS_CWMS00 => :RS_CWMS00); END; 1813 08:58:46 SQL Prepare: ORACLE - Rollback 1814 08:58:46 SQL Execute: ORACLE - Rollback 1815 08:58:46 SQL Data In: ORACLE - Rows affected = 0 1816 08:58:46 SQL Prepare: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='175' and DJRQ00>='20091001' and DJRQ00<='20100112' and LXID00='5' and SHBZ00='1' order by RCKID0 1817 08:58:46 SQL Execute: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='175' and DJRQ00>='20091001' and DJRQ00<='20100112' and LXID00='5' and SHBZ00='1' order by RCKID0 1818 08:58:46 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1819 08:58:46 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1820 08:58:46 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1821 08:58:46 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1822 08:58:46 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1823 08:58:46 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1824 08:58:46 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1825 08:58:46 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1826 08:58:46 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1827 08:58:46 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1828 09:35:23 Log started for: SQL Navigator for Oracle 1829 09:35:35 SQL Execute: select version from SYS.PRODUCT_COMPONENT_VERSION where upper(product) like '%ORACLE%' 1830 09:35:35 SQL Execute: SELECT table_name, table_owner FROM all_synonyms WHERE owner = 'PUBLIC' AND synonym_name = 'QUEST_COM_TEAM_CODING' 1831 09:35:37 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 1832 09:35:37 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 1833 09:35:37 SQL Execute: select :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,decode(b.partitioned,'YES','Y','NO','N') partitioned,'N' object_table,'N' external_table,decode(b.nested,'YES','Y','N') nested,decode(b.IOT_Type,'IOT',1,'IOT_OVERFLOW',2,0) IOT_Type,b.IOT_Name,b.temporary from sys.dba_objects a,sys.dba_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' and b.dropped='NO' 1834 09:35:37 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 1835 09:35:37 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 1836 09:35:37 SQL Execute: select :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,decode(b.partitioned,'YES','Y','NO','N') partitioned,'Y' object_table,'N' external_table,decode(b.nested,'YES','Y','N') nested,decode(b.IOT_Type,'IOT',1,'IOT_OVERFLOW',2,0) IOT_Type,b.IOT_Name,b.temporary from sys.dba_objects a,sys.dba_object_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' 1837 09:35:37 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 1838 09:35:37 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 1839 09:35:37 SQL Execute: select /*+ QCO9i QCOALL */ :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,'N' partitioned,'N' object_table,'Y' external_table,'N' nested,0 IOT_Type,'' IOT_Name,'N' temporary from sys.dba_objects a,sys.dba_external_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' 1840 09:35:37 SQL Execute: ALTER SESSION SET NLS_DATE_FORMAT='DD-Mon-RRRR' 1841 09:35:38 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 1842 09:35:38 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 1843 09:35:38 SQL Execute: select USER owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status from user_objects a where object_name like :object_name and object_type=:object_type 1844 09:36:20 Log started for: 固定资产核算管理系统 1845 09:36:23 SQL Prepare: ORACLE - BEGIN "SP_SB_CKDSH" (AS_RCKID0 => :AS_RCKID0,AS_SHR000 => :AS_SHR000,AS_SHKS00 => :AS_SHKS00,RS_CWMS00 => :RS_CWMS00); END; 1846 09:36:23 SQL Data In: ORACLE - Param = 1, Name = AS_RCKID0, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 23206 1847 09:36:23 SQL Data In: ORACLE - Param = 2, Name = AS_SHR000, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 476 1848 09:36:23 SQL Data In: ORACLE - Param = 3, Name = AS_SHKS00, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 175 1849 09:36:23 SQL Data In: ORACLE - Param = 4, Name = RS_CWMS00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1850 09:36:23 SQL Execute: ORACLE - BEGIN "SP_SB_CKDSH" (AS_RCKID0 => :AS_RCKID0,AS_SHR000 => :AS_SHR000,AS_SHKS00 => :AS_SHKS00,RS_CWMS00 => :RS_CWMS00); END; 1851 09:36:24 SQL Prepare: ORACLE - Rollback 1852 09:36:24 SQL Execute: ORACLE - Rollback 1853 09:36:24 SQL Data In: ORACLE - Rows affected = 0 1854 09:36:24 SQL Prepare: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='175' and DJRQ00>='20091001' and DJRQ00<='20100112' and LXID00='5' and SHBZ00='1' order by RCKID0 1855 09:36:24 SQL Execute: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='175' and DJRQ00>='20091001' and DJRQ00<='20100112' and LXID00='5' and SHBZ00='1' order by RCKID0 1856 09:36:24 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1857 09:36:24 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1858 09:36:24 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1859 09:36:24 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1860 09:36:24 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1861 09:36:24 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1862 09:36:24 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1863 09:36:24 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1864 09:36:24 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1865 09:36:24 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1866 09:58:21 SQL Prepare: ORACLE - select RCLXID,RCLXMC from vw_SB_RCKLX0 where RCKBZ0='2' 1867 09:58:21 SQL Execute: ORACLE - select RCLXID,RCLXMC from vw_SB_RCKLX0 where RCKBZ0='2' 1868 09:58:21 SQL Prepare: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and DJRQ00>='20100112' and DJRQ00<='20100112' and CKBH00=175 order by SHBZ00,RCKID0 1869 09:58:21 SQL Execute: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and DJRQ00>='20100112' and DJRQ00<='20100112' and CKBH00=175 order by SHBZ00,RCKID0 1870 09:58:21 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 1871 09:58:21 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 1872 09:58:21 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 1873 09:58:21 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 1874 09:58:21 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 1875 09:58:21 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 1876 09:58:21 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 1877 09:58:21 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 1878 09:58:22 SQL Prepare: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and DJRQ00>='20100112' and DJRQ00<='20100112' and CKBH00=175 order by SHBZ00,RCKID0 1879 09:58:22 SQL Execute: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and DJRQ00>='20100112' and DJRQ00<='20100112' and CKBH00=175 order by SHBZ00,RCKID0 1880 09:58:22 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 1881 09:58:22 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 1882 09:58:22 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 1883 09:58:22 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 1884 09:58:24 SQL Prepare: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and DJRQ00>='20100112' and DJRQ00<='20100112' and LXID00='5' and CKBH00=175 order by SHBZ00,RCKID0 1885 09:58:24 SQL Execute: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and DJRQ00>='20100112' and DJRQ00<='20100112' and LXID00='5' and CKBH00=175 order by SHBZ00,RCKID0 1886 09:58:24 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 1887 09:58:24 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 1888 09:58:24 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 1889 09:58:24 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 1890 09:58:25 SQL Prepare: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and DJRQ00>='20100112' and DJRQ00<='20100112' and LXID00='5' and CKBH00=175 order by SHBZ00,RCKID0 1891 09:58:25 SQL Execute: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and DJRQ00>='20100112' and DJRQ00<='20100112' and LXID00='5' and CKBH00=175 order by SHBZ00,RCKID0 1892 09:58:25 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 1893 09:58:25 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 1894 09:58:25 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 1895 09:58:25 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 1896 09:58:28 SQL Prepare: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and DJRQ00>='20090112' and DJRQ00<='20100112' and LXID00='5' and CKBH00=175 order by SHBZ00,RCKID0 1897 09:58:28 SQL Execute: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and DJRQ00>='20090112' and DJRQ00<='20100112' and LXID00='5' and CKBH00=175 order by SHBZ00,RCKID0 1898 09:58:28 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1899 09:58:28 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 1900 09:58:29 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='13303') order by RCMXID,ZFBZ00 1901 09:58:29 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='13303') order by RCMXID,ZFBZ00 1902 09:58:29 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='13304') order by RCMXID,ZFBZ00 1903 09:58:29 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='13304') order by RCMXID,ZFBZ00 1904 09:58:29 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17403') order by RCMXID,ZFBZ00 1905 09:58:29 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17403') order by RCMXID,ZFBZ00 1906 09:58:29 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17501') order by RCMXID,ZFBZ00 1907 09:58:29 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17501') order by RCMXID,ZFBZ00 1908 09:58:29 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17502') order by RCMXID,ZFBZ00 1909 09:58:29 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17502') order by RCMXID,ZFBZ00 1910 09:58:29 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17503') order by RCMXID,ZFBZ00 1911 09:58:29 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17503') order by RCMXID,ZFBZ00 1912 09:58:29 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17504') order by RCMXID,ZFBZ00 1913 09:58:29 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17504') order by RCMXID,ZFBZ00 1914 09:58:29 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17505') order by RCMXID,ZFBZ00 1915 09:58:29 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17505') order by RCMXID,ZFBZ00 1916 09:58:30 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17506') order by RCMXID,ZFBZ00 1917 09:58:30 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17506') order by RCMXID,ZFBZ00 1918 09:58:30 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17507') order by RCMXID,ZFBZ00 1919 09:58:30 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17507') order by RCMXID,ZFBZ00 1920 09:58:30 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17508') order by RCMXID,ZFBZ00 1921 09:58:30 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17508') order by RCMXID,ZFBZ00 1922 09:58:30 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17509') order by RCMXID,ZFBZ00 1923 09:58:30 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17509') order by RCMXID,ZFBZ00 1924 09:58:30 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17510') order by RCMXID,ZFBZ00 1925 09:58:30 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17510') order by RCMXID,ZFBZ00 1926 09:58:30 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17511') order by RCMXID,ZFBZ00 1927 09:58:30 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17511') order by RCMXID,ZFBZ00 1928 09:58:30 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17512') order by RCMXID,ZFBZ00 1929 09:58:30 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17512') order by RCMXID,ZFBZ00 1930 09:58:30 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17513') order by RCMXID,ZFBZ00 1931 09:58:30 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17513') order by RCMXID,ZFBZ00 1932 09:58:31 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17514') order by RCMXID,ZFBZ00 1933 09:58:31 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17514') order by RCMXID,ZFBZ00 1934 09:58:31 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17902') order by RCMXID,ZFBZ00 1935 09:58:31 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17902') order by RCMXID,ZFBZ00 1936 09:58:31 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17903') order by RCMXID,ZFBZ00 1937 09:58:31 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='17903') order by RCMXID,ZFBZ00 1938 09:58:31 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='18101') order by RCMXID,ZFBZ00 1939 09:58:31 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='18101') order by RCMXID,ZFBZ00 1940 09:58:31 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='18102') order by RCMXID,ZFBZ00 1941 09:58:31 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='18102') order by RCMXID,ZFBZ00 1942 09:58:31 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='18103') order by RCMXID,ZFBZ00 1943 09:58:31 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='18103') order by RCMXID,ZFBZ00 1944 09:58:31 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='18104') order by RCMXID,ZFBZ00 1945 09:58:31 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='18104') order by RCMXID,ZFBZ00 1946 09:58:31 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='18502') order by RCMXID,ZFBZ00 1947 09:58:31 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='18502') order by RCMXID,ZFBZ00 1948 09:58:31 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='18503') order by RCMXID,ZFBZ00 1949 09:58:31 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='18503') order by RCMXID,ZFBZ00 1950 09:58:32 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='22801') order by RCMXID,ZFBZ00 1951 09:58:32 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='22801') order by RCMXID,ZFBZ00 1952 09:58:32 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='22803') order by RCMXID,ZFBZ00 1953 09:58:32 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='22803') order by RCMXID,ZFBZ00 1954 09:58:32 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='22804') order by RCMXID,ZFBZ00 1955 09:58:32 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='22804') order by RCMXID,ZFBZ00 1956 09:58:32 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='22807') order by RCMXID,ZFBZ00 1957 09:58:32 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='22807') order by RCMXID,ZFBZ00 1958 09:58:32 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23204') order by RCMXID,ZFBZ00 1959 09:58:32 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23204') order by RCMXID,ZFBZ00 1960 09:58:32 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23207') order by RCMXID,ZFBZ00 1961 09:58:32 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23207') order by RCMXID,ZFBZ00 1962 09:58:32 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23209') order by RCMXID,ZFBZ00 1963 09:58:32 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23209') order by RCMXID,ZFBZ00 1964 09:58:32 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23210') order by RCMXID,ZFBZ00 1965 09:58:32 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23210') order by RCMXID,ZFBZ00 1966 09:58:33 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23703') order by RCMXID,ZFBZ00 1967 09:58:33 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23703') order by RCMXID,ZFBZ00 1968 09:58:33 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24101') order by RCMXID,ZFBZ00 1969 09:58:33 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24101') order by RCMXID,ZFBZ00 1970 09:58:33 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24102') order by RCMXID,ZFBZ00 1971 09:58:33 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24102') order by RCMXID,ZFBZ00 1972 09:58:33 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24103') order by RCMXID,ZFBZ00 1973 09:58:33 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24103') order by RCMXID,ZFBZ00 1974 09:58:33 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24104') order by RCMXID,ZFBZ00 1975 09:58:33 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24104') order by RCMXID,ZFBZ00 1976 09:58:33 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24105') order by RCMXID,ZFBZ00 1977 09:58:33 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24105') order by RCMXID,ZFBZ00 1978 09:58:33 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24106') order by RCMXID,ZFBZ00 1979 09:58:33 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24106') order by RCMXID,ZFBZ00 1980 09:58:33 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24107') order by RCMXID,ZFBZ00 1981 09:58:33 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24107') order by RCMXID,ZFBZ00 1982 09:58:34 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24108') order by RCMXID,ZFBZ00 1983 09:58:34 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24108') order by RCMXID,ZFBZ00 1984 09:58:34 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24109') order by RCMXID,ZFBZ00 1985 09:58:34 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24109') order by RCMXID,ZFBZ00 1986 09:58:34 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24110') order by RCMXID,ZFBZ00 1987 09:58:34 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24110') order by RCMXID,ZFBZ00 1988 09:58:34 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24112') order by RCMXID,ZFBZ00 1989 09:58:34 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24112') order by RCMXID,ZFBZ00 1990 09:58:34 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24113') order by RCMXID,ZFBZ00 1991 09:58:34 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24113') order by RCMXID,ZFBZ00 1992 09:58:34 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24114') order by RCMXID,ZFBZ00 1993 09:58:34 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24114') order by RCMXID,ZFBZ00 1994 09:58:34 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24115') order by RCMXID,ZFBZ00 1995 09:58:34 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24115') order by RCMXID,ZFBZ00 1996 09:58:35 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24116') order by RCMXID,ZFBZ00 1997 09:58:35 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='24116') order by RCMXID,ZFBZ00 1998 09:58:35 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='25105') order by RCMXID,ZFBZ00 1999 09:58:35 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='25105') order by RCMXID,ZFBZ00 2000 09:58:35 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='25106') order by RCMXID,ZFBZ00 2001 09:58:35 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='25106') order by RCMXID,ZFBZ00 2002 09:58:35 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='25109') order by RCMXID,ZFBZ00 2003 09:58:35 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='25109') order by RCMXID,ZFBZ00 2004 09:58:35 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='25110') order by RCMXID,ZFBZ00 2005 09:58:35 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='25110') order by RCMXID,ZFBZ00 2006 09:58:35 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='25111') order by RCMXID,ZFBZ00 2007 09:58:35 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='25111') order by RCMXID,ZFBZ00 2008 09:58:35 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='25112') order by RCMXID,ZFBZ00 2009 09:58:35 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='25112') order by RCMXID,ZFBZ00 2010 09:58:35 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='25113') order by RCMXID,ZFBZ00 2011 09:58:35 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='25113') order by RCMXID,ZFBZ00 2012 09:58:36 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='25114') order by RCMXID,ZFBZ00 2013 09:58:36 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='25114') order by RCMXID,ZFBZ00 2014 09:58:36 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='25114') order by RCMXID,ZFBZ00 2015 09:58:36 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='25114') order by RCMXID,ZFBZ00 2016 09:58:36 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 2017 09:58:36 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 2018 09:58:36 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 2019 09:58:36 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 2020 09:58:36 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 2021 09:58:36 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 2022 09:59:04 SQL Prepare: ORACLE - BEGIN "SP_SB_CKDSH" (AS_RCKID0 => :AS_RCKID0,AS_SHR000 => :AS_SHR000,AS_SHKS00 => :AS_SHKS00,RS_CWMS00 => :RS_CWMS00); END; 2023 09:59:04 SQL Data In: ORACLE - Param = 1, Name = AS_RCKID0, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 23206 2024 09:59:04 SQL Data In: ORACLE - Param = 2, Name = AS_SHR000, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 476 2025 09:59:04 SQL Data In: ORACLE - Param = 3, Name = AS_SHKS00, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 175 2026 09:59:04 SQL Data In: ORACLE - Param = 4, Name = RS_CWMS00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2027 09:59:04 SQL Execute: ORACLE - BEGIN "SP_SB_CKDSH" (AS_RCKID0 => :AS_RCKID0,AS_SHR000 => :AS_SHR000,AS_SHKS00 => :AS_SHKS00,RS_CWMS00 => :RS_CWMS00); END; 2028 10:00:47 Log started for: 固定资产核算管理系统 2029 10:00:47 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'WZ_YYGXH' 2030 10:00:47 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'WZ_YYGXH' 2031 10:00:47 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZCPMZDLBQY2006' 2032 10:00:47 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZCPMZDLBQY2006' 2033 10:00:47 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_SFZDSCLX' 2034 10:00:47 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_SFZDSCLX' 2035 10:00:47 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_GZDJHDL' 2036 10:00:47 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_GZDJHDL' 2037 10:00:47 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_RYGSCS' 2038 10:00:47 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_RYGSCS' 2039 10:00:47 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_RKDQR' 2040 10:00:47 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_RKDQR' 2041 10:00:47 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_JXZJDJBLZ' 2042 10:00:47 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_JXZJDJBLZ' 2043 10:00:47 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_DJHAZCKTJ' 2044 10:00:47 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_DJHAZCKTJ' 2045 10:00:47 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_PDDDYSFZJYZDZD' 2046 10:00:47 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_PDDDYSFZJYZDZD' 2047 10:00:47 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_CKBHSFKZCCBH' 2048 10:00:47 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_CKBHSFKZCCBH' 2049 10:00:47 SQL Prepare: ORACLE - BEGIN "SP_SB_DAXX00_INIT00"; END; 2050 10:00:47 SQL Execute: ORACLE - BEGIN "SP_SB_DAXX00_INIT00"; END; 2051 10:00:48 SQL Prepare: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='G' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='G' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 2052 10:00:48 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='G' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='G' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 2053 10:00:48 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'G$%' and A.XTDM00='G' and trim(A.MKDM00)='G$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='G' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 2054 10:00:48 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'G$%' and A.XTDM00='G' and trim(A.MKDM00)='G$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='G' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 2055 10:00:48 SQL Prepare: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 2056 10:00:48 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 2057 10:00:48 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 2058 10:00:48 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 2059 10:00:48 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 2060 10:00:48 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 2061 10:01:20 SQL Prepare: ORACLE - select RCLXID,RCLXMC from vw_SB_RCKLX0 where RCKBZ0='2' 2062 10:01:20 SQL Execute: ORACLE - select RCLXID,RCLXMC from vw_SB_RCKLX0 where RCKBZ0='2' 2063 10:01:20 SQL Prepare: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='169' and DJRQ00>='20100112' and DJRQ00<='20100112' and SHBZ00='1' order by RCKID0 2064 10:01:20 SQL Execute: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='169' and DJRQ00>='20100112' and DJRQ00<='20100112' and SHBZ00='1' order by RCKID0 2065 10:01:20 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2066 10:01:20 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2067 10:01:20 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2068 10:01:20 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2069 10:01:20 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2070 10:01:20 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2071 10:01:20 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2072 10:01:20 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2073 10:01:22 SQL Prepare: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='169' and DJRQ00>='20100112' and DJRQ00<='20100112' and SHBZ00='1' order by RCKID0 2074 10:01:22 SQL Execute: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='169' and DJRQ00>='20100112' and DJRQ00<='20100112' and SHBZ00='1' order by RCKID0 2075 10:01:22 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2076 10:01:22 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2077 10:01:22 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2078 10:01:22 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2079 10:01:26 SQL Prepare: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='169' and DJRQ00>='20090112' and DJRQ00<='20100112' and SHBZ00='1' order by RCKID0 2080 10:01:26 SQL Execute: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='169' and DJRQ00>='20090112' and DJRQ00<='20100112' and SHBZ00='1' order by RCKID0 2081 10:01:26 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2082 10:01:26 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2083 10:01:26 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2084 10:01:26 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2085 10:01:29 SQL Prepare: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='169' and DJRQ00>='20090112' and DJRQ00<='20100112' and SHBZ00='1' order by RCKID0 2086 10:01:29 SQL Execute: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='169' and DJRQ00>='20090112' and DJRQ00<='20100112' and SHBZ00='1' order by RCKID0 2087 10:01:29 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2088 10:01:29 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2089 10:01:29 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2090 10:01:29 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2091 10:01:30 SQL Prepare: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='169' and DJRQ00>='20090112' and DJRQ00<='20100112' and LXID00='5' and SHBZ00='1' order by RCKID0 2092 10:01:30 SQL Execute: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='169' and DJRQ00>='20090112' and DJRQ00<='20100112' and LXID00='5' and SHBZ00='1' order by RCKID0 2093 10:01:30 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2094 10:01:30 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2095 10:01:30 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2096 10:01:30 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2097 10:01:33 SQL Prepare: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='169' and DJRQ00>='20090112' and DJRQ00<='20100112' and LXID00='5' and SHBZ00='1' order by RCKID0 2098 10:01:33 SQL Execute: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='169' and DJRQ00>='20090112' and DJRQ00<='20100112' and LXID00='5' and SHBZ00='1' order by RCKID0 2099 10:01:33 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2100 10:01:33 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2101 10:01:33 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2102 10:01:33 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2103 10:01:36 SQL Prepare: ORACLE - select RCLXID,RCLXMC from vw_SB_RCKLX0 where RCKBZ0='1' 2104 10:01:36 SQL Execute: ORACLE - select RCLXID,RCLXMC from vw_SB_RCKLX0 where RCKBZ0='1' 2105 10:01:36 SQL Prepare: ORACLE - select decode(a.SFZFCG,'Y','是','否') SFZFCG,decode('9','1','',BGYXM0) BGYXM0, decode('9','1','陈剑锋',YSRXM0) YSRXM0,a.* from vw_SB_RCK000 a where DJLX00='1' and CKBH00='169' and DJRQ00>='20100112' and DJRQ00<='20100112' and (SHBZ00='1' or SHBZ00='0') order by RCKID0 2106 10:01:36 SQL Execute: ORACLE - select decode(a.SFZFCG,'Y','是','否') SFZFCG,decode('9','1','',BGYXM0) BGYXM0, decode('9','1','陈剑锋',YSRXM0) YSRXM0,a.* from vw_SB_RCK000 a where DJLX00='1' and CKBH00='169' and DJRQ00>='20100112' and DJRQ00<='20100112' and (SHBZ00='1' or SHBZ00='0') order by RCKID0 2107 10:01:36 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2108 10:01:36 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2109 10:01:36 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2110 10:01:36 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2111 10:01:36 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2112 10:01:36 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2113 10:01:36 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2114 10:01:36 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2115 10:01:37 SQL Prepare: ORACLE - select decode(a.SFZFCG,'Y','是','否') SFZFCG,decode('9','1','',BGYXM0) BGYXM0, decode('9','1','陈剑锋',YSRXM0) YSRXM0,a.* from vw_SB_RCK000 a where DJLX00='1' and CKBH00='169' and DJRQ00>='20100112' and DJRQ00<='20100112' and (SHBZ00='1' or SHBZ00='0') order by RCKID0 2116 10:01:37 SQL Execute: ORACLE - select decode(a.SFZFCG,'Y','是','否') SFZFCG,decode('9','1','',BGYXM0) BGYXM0, decode('9','1','陈剑锋',YSRXM0) YSRXM0,a.* from vw_SB_RCK000 a where DJLX00='1' and CKBH00='169' and DJRQ00>='20100112' and DJRQ00<='20100112' and (SHBZ00='1' or SHBZ00='0') order by RCKID0 2117 10:01:37 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2118 10:01:37 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2119 10:01:37 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2120 10:01:37 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2121 10:01:39 SQL Prepare: ORACLE - select decode(a.SFZFCG,'Y','是','否') SFZFCG,decode('9','1','',BGYXM0) BGYXM0, decode('9','1','陈剑锋',YSRXM0) YSRXM0,a.* from vw_SB_RCK000 a where DJLX00='1' and CKBH00='169' and DJRQ00>='20100112' and DJRQ00<='20100112' and LXID00='1' and (SHBZ00='1' or SHBZ00='0') order by RCKID0 2122 10:01:39 SQL Execute: ORACLE - select decode(a.SFZFCG,'Y','是','否') SFZFCG,decode('9','1','',BGYXM0) BGYXM0, decode('9','1','陈剑锋',YSRXM0) YSRXM0,a.* from vw_SB_RCK000 a where DJLX00='1' and CKBH00='169' and DJRQ00>='20100112' and DJRQ00<='20100112' and LXID00='1' and (SHBZ00='1' or SHBZ00='0') order by RCKID0 2123 10:01:39 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2124 10:01:39 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2125 10:01:39 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2126 10:01:39 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2127 10:01:42 SQL Prepare: ORACLE - select decode(a.SFZFCG,'Y','是','否') SFZFCG,decode('9','1','',BGYXM0) BGYXM0, decode('9','1','陈剑锋',YSRXM0) YSRXM0,a.* from vw_SB_RCK000 a where DJLX00='1' and CKBH00='169' and DJRQ00>='20090112' and DJRQ00<='20100112' and LXID00='1' and (SHBZ00='1' or SHBZ00='0') order by RCKID0 2128 10:01:42 SQL Execute: ORACLE - select decode(a.SFZFCG,'Y','是','否') SFZFCG,decode('9','1','',BGYXM0) BGYXM0, decode('9','1','陈剑锋',YSRXM0) YSRXM0,a.* from vw_SB_RCK000 a where DJLX00='1' and CKBH00='169' and DJRQ00>='20090112' and DJRQ00<='20100112' and LXID00='1' and (SHBZ00='1' or SHBZ00='0') order by RCKID0 2129 10:01:42 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2130 10:01:42 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2131 10:01:42 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2132 10:01:42 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2133 10:01:45 SQL Prepare: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='169' and DJRQ00>='20090112' and DJRQ00<='20100112' and LXID00='5' and SHBZ00='1' order by RCKID0 2134 10:01:45 SQL Execute: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='169' and DJRQ00>='20090112' and DJRQ00<='20100112' and LXID00='5' and SHBZ00='1' order by RCKID0 2135 10:01:45 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2136 10:01:45 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2137 10:01:45 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2138 10:01:45 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2139 10:01:47 SQL Prepare: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='169' and DJRQ00>='20090112' and DJRQ00<='20100112' and LXID00='5' and SHBZ00='1' order by RCKID0 2140 10:01:47 SQL Execute: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='169' and DJRQ00>='20090112' and DJRQ00<='20100112' and LXID00='5' and SHBZ00='1' order by RCKID0 2141 10:01:47 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2142 10:01:47 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2143 10:01:47 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2144 10:01:47 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2145 10:01:53 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','G',trim(PROGRAM)||'+'||'固定资产核算管理系统',SID,serial# ,'20100112','10:01:53','scott@9998:AA187611476484C390088D38B2ABCDDA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 2146 10:01:53 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','G',trim(PROGRAM)||'+'||'固定资产核算管理系统',SID,serial# ,'20100112','10:01:53','scott@9998:AA187611476484C390088D38B2ABCDDA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 2147 10:01:53 SQL Data In: ORACLE - Rows affected = 1 2148 10:01:53 SQL Prepare: ORACLE - Commit 2149 10:01:53 SQL Execute: ORACLE - Commit 2150 10:01:53 SQL Data In: ORACLE - Rows affected = 0 2151 10:01:53 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 2152 10:01:53 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 2153 10:01:54 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 2154 10:01:54 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 2155 10:01:54 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 2156 10:01:54 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 2157 10:01:54 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','G',trim(PROGRAM)||'+'||'固定资产核算管理系统',SID,serial# ,'20100112','10:01:53','sd_Hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 2158 10:01:54 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','G',trim(PROGRAM)||'+'||'固定资产核算管理系统',SID,serial# ,'20100112','10:01:53','sd_Hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 2159 10:01:54 SQL Data In: ORACLE - Rows affected = 1 2160 10:01:54 SQL Prepare: ORACLE - Commit 2161 10:01:54 SQL Execute: ORACLE - Commit 2162 10:01:54 SQL Data In: ORACLE - Rows affected = 0 2163 10:01:54 SQL Prepare: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 2164 10:01:54 SQL Execute: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 2165 10:01:54 SQL Data In: ORACLE - Rows affected = 0 2166 10:01:54 SQL Prepare: ORACLE - Commit 2167 10:01:54 SQL Execute: ORACLE - Commit 2168 10:01:54 SQL Data In: ORACLE - Rows affected = 0 2169 10:01:54 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='G' 2170 10:01:54 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='G' 2171 10:01:54 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 2172 10:01:54 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 2173 10:01:54 SQL Prepare: ORACLE - Select BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='G' 2174 10:01:54 SQL Execute: ORACLE - Select BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='G' 2175 10:01:54 SQL Prepare: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('a','b') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='G' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by BH0000 2176 10:01:54 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('a','b') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='G' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by BH0000 2177 10:01:55 SQL Prepare: ORACLE - Select '00' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'G' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) 2178 10:01:55 SQL Execute: ORACLE - Select '00' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'G' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) 2179 10:01:55 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 2180 10:01:55 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 2181 10:01:55 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 2182 10:01:55 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 2183 10:01:55 SQL Prepare: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=2017980 2184 10:01:55 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=2017980 2185 10:01:55 SQL Data In: ORACLE - Rows affected = 1 2186 10:01:55 SQL Prepare: ORACLE - Commit 2187 10:01:55 SQL Execute: ORACLE - Commit 2188 10:01:55 SQL Data In: ORACLE - Rows affected = 0 2189 10:01:55 SQL Prepare: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 2190 10:01:55 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 2191 10:01:55 SQL Data In: ORACLE - Rows affected = 0 2192 10:01:55 SQL Prepare: ORACLE - Commit 2193 10:01:55 SQL Execute: ORACLE - Commit 2194 10:01:55 SQL Data In: ORACLE - Rows affected = 0 2195 10:01:55 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.13.206' 2196 10:01:55 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.13.206' 2197 10:01:55 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 2198 10:01:55 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 2199 10:01:55 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 175 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 2200 10:01:55 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 175 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 2201 10:01:55 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 2202 10:01:55 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 2203 10:01:55 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 2204 10:01:55 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 2205 10:01:55 SQL Prepare: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 2206 10:01:55 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 2207 10:01:55 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2017990,476,'wlzx-2','G',nvl('890944',' '),'192.168.13.206#466:11860@Prj_GDZC.exe+固定资产核算管理系统',175) 2208 10:01:55 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2017990,476,'wlzx-2','G',nvl('890944',' '),'192.168.13.206#466:11860@Prj_GDZC.exe+固定资产核算管理系统',175) 2209 10:01:55 SQL Data In: ORACLE - Rows affected = 1 2210 10:01:55 SQL Prepare: ORACLE - Commit 2211 10:01:55 SQL Execute: ORACLE - Commit 2212 10:01:55 SQL Data In: ORACLE - Rows affected = 0 2213 10:01:55 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 175 2214 10:01:55 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 175 2215 10:01:55 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 2216 10:01:55 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 2217 10:01:55 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='G') and YXQ000>='20100112' 2218 10:01:55 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='G') and YXQ000>='20100112' 2219 10:01:55 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 2220 10:01:55 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 2221 10:01:55 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 2222 10:01:55 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 2223 10:01:55 SQL Prepare: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=2017990 2224 10:01:55 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=2017990 2225 10:01:55 SQL Data In: ORACLE - Rows affected = 1 2226 10:01:55 SQL Prepare: ORACLE - Commit 2227 10:01:55 SQL Execute: ORACLE - Commit 2228 10:01:55 SQL Data In: ORACLE - Rows affected = 0 2229 10:01:55 SQL Prepare: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 2230 10:01:55 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 2231 10:01:55 SQL Data In: ORACLE - Rows affected = 0 2232 10:01:55 SQL Prepare: ORACLE - Commit 2233 10:01:55 SQL Execute: ORACLE - Commit 2234 10:01:55 SQL Data In: ORACLE - Rows affected = 0 2235 10:01:55 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 2236 10:01:55 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 2237 10:01:55 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 2238 10:01:55 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 2239 10:01:55 SQL Prepare: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 2240 10:01:55 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 2241 10:01:55 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2017991,476,'wlzx-2','G',nvl('890944',' '),'192.168.13.206#466:11860@Prj_GDZC.exe+固定资产核算管理系统',175) 2242 10:01:55 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2017991,476,'wlzx-2','G',nvl('890944',' '),'192.168.13.206#466:11860@Prj_GDZC.exe+固定资产核算管理系统',175) 2243 10:01:55 SQL Data In: ORACLE - Rows affected = 1 2244 10:01:55 SQL Prepare: ORACLE - Commit 2245 10:01:55 SQL Execute: ORACLE - Commit 2246 10:01:55 SQL Data In: ORACLE - Rows affected = 0 2247 10:01:55 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 175 2248 10:01:55 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 175 2249 10:01:55 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 2250 10:01:55 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 2251 10:01:55 SQL Prepare: ORACLE - select sysdate nowtime from dual 2252 10:01:55 SQL Execute: ORACLE - select sysdate nowtime from dual 2253 10:01:55 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00 = 476 2254 10:01:55 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00 = 476 2255 10:01:55 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_PRINTSCALE' 2256 10:01:55 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_PRINTSCALE' 2257 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PageWidth' 2258 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PageWidth' 2259 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBWidth' 2260 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBWidth' 2261 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBHeigh' 2262 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBHeigh' 2263 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBJ00' 2264 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBJ00' 2265 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_YBJ00' 2266 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_YBJ00' 2267 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PageHeigh' 2268 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PageHeigh' 2269 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageDirect' 2270 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageDirect' 2271 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TJKSSJ' 2272 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TJKSSJ' 2273 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TJJSSJ' 2274 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TJJSSJ' 2275 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SlExperSBLB' 2276 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SlExperSBLB' 2277 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_SFZDSC' 2278 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_SFZDSC' 2279 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_LENGTH' 2280 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_LENGTH' 2281 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_KCDWSFFK' 2282 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_KCDWSFFK' 2283 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBRKGGXHSFGG' 2284 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBRKGGXHSFGG' 2285 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_KPH000_SFZD' 2286 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_KPH000_SFZD' 2287 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_USER_PageWidth' 2288 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_USER_PageWidth' 2289 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_USER_PageHeigh' 2290 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_USER_PageHeigh' 2291 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_DJGSCS' 2292 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_DJGSCS' 2293 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZDY_RKDDYGSID' 2294 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZDY_RKDDYGSID' 2295 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZDY_CKDDYGSID' 2296 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZDY_CKDDYGSID' 2297 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'WZ_YYGXH' 2298 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'WZ_YYGXH' 2299 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZCPMZDLBQY2006' 2300 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZCPMZDLBQY2006' 2301 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_SFZDSCLX' 2302 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_SFZDSCLX' 2303 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_GZDJHDL' 2304 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_GZDJHDL' 2305 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_RYGSCS' 2306 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_RYGSCS' 2307 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_RKDQR' 2308 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_RKDQR' 2309 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_JXZJDJBLZ' 2310 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_JXZJDJBLZ' 2311 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_DJHAZCKTJ' 2312 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_DJHAZCKTJ' 2313 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_PDDDYSFZJYZDZD' 2314 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_PDDDYSFZJYZDZD' 2315 10:01:55 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_CKBHSFKZCCBH' 2316 10:01:55 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_CKBHSFKZCCBH' 2317 10:01:55 SQL Prepare: ORACLE - BEGIN "SP_SB_DAXX00_INIT00"; END; 2318 10:01:55 SQL Execute: ORACLE - BEGIN "SP_SB_DAXX00_INIT00"; END; 2319 10:01:55 SQL Prepare: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='G' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='G' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 2320 10:01:55 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='G' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='G' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 2321 10:01:55 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'G$%' and A.XTDM00='G' and trim(A.MKDM00)='G$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='G' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 2322 10:01:55 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'G$%' and A.XTDM00='G' and trim(A.MKDM00)='G$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='G' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 2323 10:01:55 SQL Prepare: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 2324 10:01:55 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 2325 10:01:55 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 2326 10:01:55 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 2327 10:01:55 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 2328 10:01:55 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 2329 10:01:58 SQL Prepare: ORACLE - select RCLXID,RCLXMC from vw_SB_RCKLX0 where RCKBZ0='2' 2330 10:01:58 SQL Execute: ORACLE - select RCLXID,RCLXMC from vw_SB_RCKLX0 where RCKBZ0='2' 2331 10:01:58 SQL Prepare: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='175' and DJRQ00>='20100112' and DJRQ00<='20100112' and SHBZ00='1' order by RCKID0 2332 10:01:58 SQL Execute: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='175' and DJRQ00>='20100112' and DJRQ00<='20100112' and SHBZ00='1' order by RCKID0 2333 10:01:58 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2334 10:01:58 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2335 10:01:58 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2336 10:01:58 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2337 10:01:58 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2338 10:01:58 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2339 10:01:58 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2340 10:01:58 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='') order by RCMXID,ZFBZ00 2341 10:02:05 SQL Prepare: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='175' and DJRQ00>='20091012' and DJRQ00<='20100112' and SHBZ00='1' order by RCKID0 2342 10:02:05 SQL Execute: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='175' and DJRQ00>='20091012' and DJRQ00<='20100112' and SHBZ00='1' order by RCKID0 2343 10:02:05 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 2344 10:02:05 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 2345 10:02:05 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 2346 10:02:05 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 2347 10:02:05 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 2348 10:02:05 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 2349 10:02:05 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 2350 10:02:05 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 2351 10:02:05 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 2352 10:02:05 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 2353 10:02:08 SQL Prepare: ORACLE - BEGIN "SP_SB_CKDSH" (AS_RCKID0 => :AS_RCKID0,AS_SHR000 => :AS_SHR000,AS_SHKS00 => :AS_SHKS00,RS_CWMS00 => :RS_CWMS00); END; 2354 10:02:08 SQL Data In: ORACLE - Param = 1, Name = AS_RCKID0, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 23206 2355 10:02:08 SQL Data In: ORACLE - Param = 2, Name = AS_SHR000, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 476 2356 10:02:08 SQL Data In: ORACLE - Param = 3, Name = AS_SHKS00, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 175 2357 10:02:08 SQL Data In: ORACLE - Param = 4, Name = RS_CWMS00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2358 10:02:08 SQL Execute: ORACLE - BEGIN "SP_SB_CKDSH" (AS_RCKID0 => :AS_RCKID0,AS_SHR000 => :AS_SHR000,AS_SHKS00 => :AS_SHKS00,RS_CWMS00 => :RS_CWMS00); END; 2359 10:04:15 SQL Prepare: ORACLE - Rollback 2360 10:04:15 SQL Execute: ORACLE - Rollback 2361 10:04:15 SQL Data In: ORACLE - Rows affected = 0 2362 10:04:15 SQL Prepare: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='175' and DJRQ00>='20091012' and DJRQ00<='20100112' and SHBZ00='1' order by RCKID0 2363 10:04:15 SQL Execute: ORACLE - select * from vw_SB_RCK000 where DJLX00='3' and CKBH00='175' and DJRQ00>='20091012' and DJRQ00<='20100112' and SHBZ00='1' order by RCKID0 2364 10:04:15 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 2365 10:04:15 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 2366 10:04:15 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 2367 10:04:15 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 2368 10:04:15 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 2369 10:04:15 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 2370 10:04:15 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 2371 10:04:15 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 2372 10:04:15 SQL Prepare: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 2373 10:04:15 SQL Execute: ORACLE - select * from vw_SB_RCKJFJ where RCMXID in (select RCMXID from SB_RCKMX0 where RCKID0='23206') order by RCMXID,ZFBZ00 2374 10:04:18 SQL Prepare: ORACLE - BEGIN "SP_SB_CKDSH" (AS_RCKID0 => :AS_RCKID0,AS_SHR000 => :AS_SHR000,AS_SHKS00 => :AS_SHKS00,RS_CWMS00 => :RS_CWMS00); END; 2375 10:04:18 SQL Data In: ORACLE - Param = 1, Name = AS_RCKID0, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 23206 2376 10:04:18 SQL Data In: ORACLE - Param = 2, Name = AS_SHR000, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 476 2377 10:04:18 SQL Data In: ORACLE - Param = 3, Name = AS_SHKS00, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 175 2378 10:04:18 SQL Data In: ORACLE - Param = 4, Name = RS_CWMS00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2379 10:04:18 SQL Execute: ORACLE - BEGIN "SP_SB_CKDSH" (AS_RCKID0 => :AS_RCKID0,AS_SHR000 => :AS_SHR000,AS_SHKS00 => :AS_SHKS00,RS_CWMS00 => :RS_CWMS00); END;