请教一个关于ROWNUM 问题

   有个sql如下：                                                         
        SELECT ROWNUM NUM,BR_CD,REF_NO,PD_CD,CIF,NEXT_APPLY_INT_RATE,                    
               LOAN_AMT,LOAN_BALANCE,CCY,FINAL_MATURITY,INT_DAY_BASE,             
               INT_RECVD_DATE,UNIT_TYPE,NEXT_PRN_PAY_DATE,INT_RATE,INT_INCL_EXCL            
          FROM (                                                     
              SELECT LN.BR_CD,LN.REF_NO,LN.PD_CD,LN.CIF,LN.NEXT_APPLY_INT_RATE,             
                     LN.LOAN_AMT,LN.LOAN_BALANCE,LN.CCY,             
                     LN.FINAL_MATURITY,LN.INT_RECVD_DATE,LN.INT_DAY_BASE,            
                     LN.UNIT_TYPE,LN.NEXT_PRN_PAY_DATE,LN.INT_RATE,LN.INT_INCL_EXCL               
                FROM LN_LOAN LN                                      
               WHERE LN.PD_CD LIKE ''||'%'                            
                 AND LN.PD_TYPE = 'BDC'                                  
                 AND LN.BR_CD = '100'     
                 --AND LN.CIF   = ''                                    
                 AND LN.REF_NO LIKE ''||'%'                           
                 AND LN.STATUS = NVL((SELECT T1.STATUS                                 
                                        FROM LN_LOAN T1                                
                                       WHERE T1.REF_NO = LN.REF_NO                     
                                         AND T1.STATUS = 'CLO'  
                                         AND EXISTS(SELECT T2.REF_NO                   
                                                      FROM LN_UNRCVD_INT T2            
                                                     WHERE T2.REF_NO = T1.REF_NO       
                                                       AND T2.STATUS = 'REG')) 
                                     ,'NOR')              
               ORDER BY LN.FINAL_MATURITY                            
              )                                                      
                     1.在两个环境中运行：生产环境，测试环境
    2.两个环境数据一致
  运行结果：
      生产环境中可以获取到数值
      测试环境获取不到
  问题分析：
      SELECT ROWNUM NUM 中将ROWNUM 不作为输出项测试环境获取数据。
   个人觉得是不是两个环境中索引不一样产生这个问题啊？