ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F56C3869E053B46B63588994Y select (AVAILABLE/:AMT_UNIT2) Qry_Available_Amount , COMPANY Qry_Company , COUNTRY Qry_Country , CURRENCY Qry_Currency , EFFECTIVE_DATE Qry_Effective_Date , (LIMIT_AMT/:AMT_UNIT2) Qry_Limit_Amount, LIMIT_CODE Qry_Limit_Code , LIMIT_GROUP Qry_Limit_Group , LIMIT_PARTY Qry_Limit_Party , LIMIT_TYPE Qry_Limit_Type , (UTILISED/:AMT_UNIT2) Qry_Utilized_Amount, XTR_XTRLIUTL_XMLP_PKG.fc_get_limit_type_descformula(LIMIT_TYPE) Fc_Get_Limit_Type_Desc from XTR_LIMIT_OVERVIEW_V where LIMIT_GROUP like upper(nvl(:LIMIT_TYPE2, LIMIT_GROUP)) and AVAILABLE >= nvl(:P_AVAILABLE_LOW, -9999999999999999999) and AVAILABLE <= nvl(:P_AVAILABLE_HIGH, 9999999999999999999) and LIMIT_CODE like upper(nvl(:P_LIMIT_CODE,LIMIT_CODE)) and EFFECTIVE_DATE between nvl(:P_EFFECTIVE_DATE_FROM_1,EFFECTIVE_DATE) and nvl(:P_EFFECTIVE_DATE_TO_1,EFFECTIVE_DATE) and company in (select party_code from xtr_parties_v where party_code = nvl(:p_company_code,party_code) ) ORDER BY 2 ASC,4 ASC,10 ASC,7 ASC , LIMIT_TYPE , EFFECTIVE_DATE , LIMIT_PARTY XTR XTRLIUTL_XML AR XTR المراكز - تقرير استخدامات الحد (بتنسيق XML) Application: الخزانة Source: المراكز - تقرير استخدامات الحد (بتنسيق XML) Short Name: XTRLIUTL_XML DB package: XTR_XTRLIUTL_XMLP_PKG D XTR Grenzwertanalyse Application: Treasury Source: Positionen: Grenzwertanalyse (XML) Short Name: XTRLIUTL_XML DB package: XTR_XTRLIUTL_XMLP_PKG F XTR Positions - Etat Plafonds d'utilisation Application: Treasury Source: Positions - Etat Plafonds d'utilisation (XML) Short Name: XTRLIUTL_XML DB package: XTR_XTRLIUTL_XMLP_PKG US XTR Positions - Limit Utilizations Application: Treasury Source: Positions - Limit Utilizations Report (XML) Short Name: XTRLIUTL_XML DB package: XTR_XTRLIUTL_XMLP_PKG ZHS XTR 头寸 - 使用限额报表 Application: 理财管理系统 Source: 头寸 - 使用限额报表 (XML) Short Name: XTRLIUTL_XML DB package: XTR_XTRLIUTL_XMLP_PKG BI Publisher :amt_unit :amt_unit2 :available_high_range :available_high_range2 :available_low_range :available_low_range2 :base_ccy :ccy :company :company_name_header :cp_para :dflt_disc_rate :effective_date_from2 :effective_date_to2 :incl_indic_exp :incl_options :limit_code :limit_code2 :limit_type :limit_type2 :lp_factor_desc :p_available_high :p_available_low :p_company_code :p_conc_request_id :p_display_bug :p_display_debug :p_effective_date_from :p_effective_date_from_1 :p_effective_date_to :p_effective_date_to_1 :p_factor :p_limit_code :p_limit_type :p_sql_trace :period_from :period_to :portfolio :ref_number :report_date :report_group :report_nos :report_short_name :report_short_name2 :show_details :use_defaults :version_num :yield_curve :z1available_high_range :z1available_low_range :z1effective_date_from :z1effective_date_to :z1limit_code :z1limit_type :z1p_factor :z1parameters :z2available :z2company :z2country :z2currency :z2effective_date :z2end_of_report :z2limit_amt :z2limit_group :z2limit_party :z2page :z2utilised :z3_cparty :z3_curr :z3_global :z3_group :z3_na :z3_settle :z3_sovgn 1 10 :p_company_code 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 AR الشركة D Firma F Société US Company ZHS 公司 2 20 :p_limit_type LOV Oracle XTR_LIMIT_TYPE Y select limit_type id, limit_type value, name description from xtr_limit_types_v order by limit_type AR نوع الحد D Limitart F Type de limite US Limit Type ZHS 限额类型 3 30 :p_available_low Number AR مبلغ متاح من D Verfügbarer Betrag von F Montant disponible - De US Available Amount From ZHS 最小可用额 4 40 :p_available_high Number AR مبلغ متاح إلى D Verfügbarer Betrag bis F Montant disponible - A US Available Amount To ZHS 最大可用额 5 50 :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 限额代码 6 60 :p_effective_date_from Date AR تاريخ الفعالية من D Gültig von F Date de début de validité US Effective Date From ZHS 有效日期自 7 70 :p_effective_date_to Date AR تاريخ الفعالية إلى D Gültig bis F Date de fin de validité US Effective Date To ZHS 有效日期至 8 80 :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 贴现