Select * From (
  Select 
    T.*, 
    agr.Ageement_Number,
    Case Opkind_Rk 
      When 4 Then 'Accrued ATM Fee'
      When 5 Then 'Accrued POS Fee'
      When 8 Then 'Cash Withdrawal Fee'
    End As Opkind,
    Row_Number() Over (Partition By Opkind_Rk Order By Oper_Date) Rn
  From ARA.Ft_Ar_Posting_Prepared T,
     MRA.Dm_Agreement_F agr
  Where 
    CURRENT_TIMESTAMP Between agr.Data_Actual_Date and agr.Data_actual_End_Date 
	    And agr.Agreement_Rk= T.Agreement_Rk
    And T.Oper_Date Between Date'2013-01-01' And  Date'2013-01-15'
    And T.Opkind_Rk In (4,5,8)
) 
where rn <= 100