ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F56B3869E053B46B63588994 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 Y XTR XTRLIEXP_XML AR XTR إدارة - أرشيف استثناءات الحد (بتنسيق XML) Application: الخزانة Source: إدارة - أرشيف استثناءات الحد (بتنسيق XML) Short Name: XTRLIEXP_XML DB package: XTR_XTRLIEXP_XMLP_PKG D XTR Überschrittene Limits Application: Treasury Source: Administrator: Überschrittene Limits (XML) Short Name: XTRLIEXP_XML DB package: XTR_XTRLIEXP_XMLP_PKG F XTR Admin - Journal exceptions limites Application: Treasury Source: Admin - Journal exceptions limites (XML) Short Name: XTRLIEXP_XML DB package: XTR_XTRLIEXP_XMLP_PKG US XTR Admin - Limit Exceptions Log Application: Treasury Source: Admin - Limit Exceptions Log (XML) Short Name: XTRLIEXP_XML DB package: XTR_XTRLIEXP_XMLP_PKG ZHS XTR 管理 - 限额例外日志 Application: 理财管理系统 Source: 管理 - 限额例外日志 (XML) Short Name: XTRLIEXP_XML DB package: XTR_XTRLIEXP_XMLP_PKG BI Publisher :amt_unit2 :company_code :company_code2 :company_name_header :cp_para :from_date :from_date2 :limit_code :limit_code2 :lp_factor_desc :p_company :p_conc_request_id :p_display_debug :p_factor :p_from_date :p_from_date1 :p_limit_code :p_sql_trace :report_date :report_date2 :report_group :report_nos :report_short_name :report_short_name2 :use_defaults :version_num :z1company_code :z1from_date :z1limit_code :z1p_factor :z1parameters :z2amount_date :z2deal_number :z2dealer_code :z2discription_of_exception :z2end_of_report :z2exceeded_by :z2exceeded_on_date :z2hce_amount :z2limit_amount :z2limit_party :z2page 1 10 :p_company LOV Oracle XTR_COMPANY Y select party_code id, party_code value, short_name description from xtr_parties_v where party_type='C' order by party_code Y AR الشركة D Firma F Société US Company ZHS 公司 2 20 :p_limit_code LOV Oracle XTR_LIMIT_CODE Y select limit_code id, limit_code value, name description from xtr_company_limits_v where company_code=nvl(:$flex$.xtr_company,company_code) order by limit_code AR رمز الحد D Limitschlüssel F Code limite US Limit Code ZHS 限额代码 3 30 :p_from_date Date select sysdate from dual Y AR من تاريخ D Von Datum F Date de début US From Date ZHS 自日期 4 40 :p_factor LOV Oracle XTR_FACTOR Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='XTR_MISC' and lookup_code in ('UNIT','THOUSAND','MILLION','BILLION') order by lookup_code SELECT meaning FROM fnd_lookups WHERE lookup_type = 'XTR_MISC' AND lookup_code = 'UNIT' Y AR المعامل D Faktor F Facteur US Factor ZHS 贴现 :$flex$.xtr_company Company Limit Code