XTR Admin - Limit Exceptions Log
Description
Categories: BI Publisher
Application: Treasury
Source: Admin - Limit Exceptions Log (XML)
Short Name: XTRLIEXP_XML
DB package: XTR_XTRLIEXP_XMLP_PKG
Source: Admin - Limit Exceptions Log (XML)
Short Name: XTRLIEXP_XML
DB package: XTR_XTRLIEXP_XMLP_PKG
Run
XTR Admin - Limit Exceptions Log and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Company |
|
LOV Oracle | |
Limit Code |
|
LOV Oracle | |
From Date |
|
Date | |
Factor |
|
LOV Oracle |