1       16:51:40  SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20231101
2       16:51:40  SQL Data In: ORACLE - Param = 2, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00:00:00
3       16:51:40  SQL Data In: ORACLE - Param = 3, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20231130
4       16:51:40  SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 23:59:59
5       16:51:40  SQL Data In: ORACLE - Param = 5, Name = AS_TJLB00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000
6       16:51:40  SQL Data In: ORACLE - Param = 6, Name = AS_XXLB00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
7       16:51:40  SQL Data In: ORACLE - Param = 7, Name = AS_KDBQ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000
8       16:51:40  SQL Data In: ORACLE - Param = 8, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
9       16:51:40  SQL Data In: ORACLE - Param = 9, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
10      16:51:40  SQL Data In: ORACLE - Param = 10, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
11      16:51:40  SQL Data In: ORACLE - Param = 11, Name = AS_JSJZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
12      16:51:40  SQL Data In: ORACLE - Param = 12, Name = AS_KSLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
13      16:51:40  SQL Execute: ORACLE - BEGIN "SP_ZY_BQKSHSXMSR" (AS_KSRQ00 => :AS_KSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSRQ00 => :AS_JSRQ00,AS_JSSJ00 => :AS_JSSJ00,AS_TJLB00 => :AS_TJLB00,AS_XXLB00 => :AS_XXLB00,AS_KDBQ00 => :AS_KDBQ00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_JSJZ00 => :AS_JSJZ00,AS_KSLB00 => :AS_KSLB00); END;
14      16:52:42  SQL Execute: ORACLE - select decode(B.BMBH00,999999999,' ϼ ',A.BMMC00) BMMC00,nvl(A.BMXZ00,-1) BMXZSX,XMHJ00,YPHJ00,
SFXM01,SFXM02,SFXM03,SFXM04,SFXM05,SFXM06,SFXM07,SFXM08,SFXM09,SFXM10,SFXM11,SFXM12,SFXM13,SFXM14,SFXM15,SFXM16,SFXM17,SFXM18,SFXM19,SFXM20,SFXM21,SFXM22,SFXM23,SFXM24,SFXM25,SFXM26,SFXM27,SFXM28,SFXM29,SFXM30,SFXM31,SFXM32,SFXM92,SFXM33,SFXM93,SFXM34,SFXM94,SFXM35,SFXM36,SFXM37,SFXM38,SFXM39,SFXM40,SFXM41,SFXM42,SFXM43,SFXM44,SFXM45,SFXM46,SFXM47,SFXM48,SFXM49,SFXM50,SFXM51,SFXM52,SFXM53,SFXM54,SFXM55,SFXM56,SFXM57,SFXM58,SFXM59,SFXM60,SFXM61,SFXM62,SFXM63,SFXM64,SFXM65,SFXM66,SFXM67,SFXM68,SFXM69,SFXM70,SFXM71,SFXM72,SFXM73,SFXM74,SFXM75,SFXM76,SFXM77,SFXM78,SFXM79,SFXM80,SFXM81,SFXM82,SFXM83,SFXM84,SFXM85,SFXM86,SFXM87,SFXM88,SFXM89,SFXM90,SFXM91,SFXM92,SFXM93,SFXM94,SFXM95,SFXM96,SFXM97,SFXM98
,A.bmbh00 BHPX00 from  BM_BMBM00 A,BM_YYSFTJ B where  
 A.BMBH00(+)=B.BMBH00 and B.ID0000=11936624
 order by A.PXXH00,A.BH0000,BMXZSX DESC,BHPX00 DESC