Select a.AMOUNT_DATE Qry_Amount_Date ,
a.AUTHORISED_BY Qry_Authorised_By ,
a.COMPANY_CODE Qry_Company_Code ,
a.DEALER_CODE Qry_Dealer_Code ,
a.DEAL_NUMBER Qry_Deal_Number ,
a.EXCEEDED_BY_AMOUNT/:AMT_UNIT2 Qry_Exceeded_Amount ,
a.EXCEEDED_ON_DATE Qry_Exceeded_On_Date ,
a.EXCEPTION_TYPE Qry_Exception_Type ,
a.HCE_AMOUNT/:AMT_UNIT2 Qry_Hce_Amount ,
a.LIMITING_AMOUNT/:AMT_UNIT2 Qry_Limiting_Amount,
a.LIMIT_CHECK_TYPE Qry_Limit_Check_Type ,
a.LIMIT_CODE Qry_Limit_Code ,
a.LIMIT_PARTY Qry_Limit_Party ,
a.LOG_ID Qry_Log_Id ,
a.TRANSACTION_NUMBER Qry_Transaction_Number,
XTR_XTRLIEXP_XMLP_PKG.cf_descriptionformula(a.LIMIT_CHECK_TYPE, a.EXCEPTION_TYPE) cf_description
From xtr_limit_excess_log_v a ,
xtr_parties_v b
Where a.company_code = nvl(:p_Company,a.company_code)
And a.limit_code = nvl(:p_Limit_Code,a.limit_code)
And a.exceeded_on_date >= Trunc(nvl(:p_From_date,trunc(sysdate)))
And b.party_code = a.company_Code
order by a.exceeded_on_date,
Qry_Company_Code,Qry_Exceeded_Amount,Qry_Limit_Code,Qry_Log_Id,Qry_Deal_Number,Qry_Transaction_Number,
Qry_Limit_Party,Qry_Amount_Date,Qry_Hce_Amount,Qry_Limiting_Amount,Qry_Authorised_By,Qry_Dealer_Code,Qry_Limit_Check_Type,Qry_Exception_Type |
