ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D472D251A9E05362FB09050512Y select d.company_code hp_company, hr.hedge_attribute_id hp_hedge_number, hr.primary_code hp_deal_no, trunc(d.value_date)-trunc(sysdate) hp_days_remaining, DECODE(hedge_currency ,currency_sell,currency_buy ,currency_sell) hp_offset_currency, hr.cur_reference_amt hp_amount, &hp_amount_dsp hp_amount_dsp from xtr_hedge_relationships hr, xtr_hedge_attributes ha, xtr_deals_v d where d.deal_no = hr.primary_code AND d.company_code = nvl(:P_COMPANY_CODE,d.company_code) AND ha.hedge_currency = :P_CURRENCY and ha.hedge_attribute_id = hr.hedge_attribute_id and ha.hedge_status = 'CURRENT' AND d.value_date > sysdate AND trunc(d.value_date)-trunc(sysdate) > 0 AND ha.hedge_attribute_id NOT IN (select hedge_attribute_id from xtr_hedge_relationships where instrument_item_flag = 'U' group by hedge_attribute_id having sum(cur_reference_amt) = 0) order by 1,4,2 XTR XTRHOAPR_XML AR XTR المراكز - تقرير المقبوضات /المدفوعات المستحقة (بتنسيق XML) Imported from BI Publisher Description: المراكز - تقرير المقبوضات/المدفوعات المستحقة Application: الخزانة Source: المراكز - تقرير المقبوضات /المدفوعات المستحقة (بتنسيق XML) Short Name: XTRHOAPR_XML DB package: XTR_XTRHOAPR_XMLP_PKG D XTR Offene Forderungen / Verbindlichkeiten Imported from BI Publisher Description: Auswertung "Positionen: Offene Forderungen / Verbindlichkeiten" Application: Treasury Source: Positionen: Offene Forderungen / Verbindlichkeiten (XML) Short Name: XTRHOAPR_XML DB package: XTR_XTRHOAPR_XMLP_PKG E XTR Posiciones - Informe de Cuentas a Pagar/Cuentas a Cobrar Pendientes Imported from BI Publisher Description: Posiciones - Informe de Cuentas a Pagar/Cuentas a Cobrar Pendientes Application: Treasury Source: Posiciones - Informe de Cuentas a Pagar/Cuentas a Cobrar Pendientes (XML) Short Name: XTRHOAPR_XML DB package: XTR_XTRHOAPR_XMLP_PKG F XTR Positions - Etat des comptes client/fournisseur non soldés Imported from BI Publisher Description: Positions - Etat de l'encours client/fournisseur Application: Treasury Source: Positions - Etat des comptes client/fournisseur non soldés (XML) Short Name: XTRHOAPR_XML DB package: XTR_XTRHOAPR_XMLP_PKG I XTR Posizioni - Rapporto Conto clienti/fornitori esistente Imported from BI Publisher Description: Posizioni - rapporto del conto clienti/fornitori esistente Application: Treasury Source: Posizioni - Rapporto Conto clienti/fornitori esistente (XML) Short Name: XTRHOAPR_XML DB package: XTR_XTRHOAPR_XMLP_PKG JA XTR ポジション - 未処理のReceivables / Payablesレポート Imported from BI Publisher Description: ポジション - 未処理のReceivables / Payablesレポート Application: Treasury Source: ポジション - 未処理のReceivables / Payablesレポート(XML) Short Name: XTRHOAPR_XML DB package: XTR_XTRHOAPR_XMLP_PKG KO XTR 포지션 - 미결 AR / AP 보고서 Imported from BI Publisher Description: 포지션 - 미결 AR / AP 보고서 Application: Treasury Source: 포지션 - 미결 AR / AP 보고서(XML) Short Name: XTRHOAPR_XML DB package: XTR_XTRHOAPR_XMLP_PKG PTB XTR Posições - Relatório de Contas a Receber / Pagar Pendentes Imported from BI Publisher Description: Posições - Relatório de Contas a Receber / Pagar Pendentes Application: Treasury Source: Posições - Relatório de Contas a Receber / Pagar Pendentes (XML) Short Name: XTRHOAPR_XML DB package: XTR_XTRHOAPR_XMLP_PKG RU XTR Позиции - отчет об остаточной дебиторской/кредиторской задолженности Imported from BI Publisher Description: Позиции - отчет об остаточной дебиторской/кредиторской задолженности Application: Казначейство Source: Позиции - отчет об остаточной дебиторской/кредиторской задолженности (XML) Short Name: XTRHOAPR_XML DB package: XTR_XTRHOAPR_XMLP_PKG S XTR Positioner - Utestående kundreskontra/leverantörsreskontra - rapport Imported from BI Publisher Description: Positioner - utestående kundreskontra/leverantörsreskontra - rapport Application: Treasury Source: Positioner - Utestående kundreskontra/leverantörsreskontra - rapport (XML) Short Name: XTRHOAPR_XML DB package: XTR_XTRHOAPR_XMLP_PKG TR XTR Pozisyonlar - Bekleyen Alacaklar / Borçlar Raporu Imported from BI Publisher Description: Pozisyonlar - Bekleyen Alacaklar / Borçlar Raporu Application: Hazine Yönetimi Source: Pozisyonlar - Bekleyen Alacaklar / Borçlar Raporu (XML) Short Name: XTRHOAPR_XML DB package: XTR_XTRHOAPR_XMLP_PKG US XTR Positions - Outstanding Receivables / Payables Imported from BI Publisher Description: Positions - Outstanding Receivables / Payables Report Application: Treasury Source: Positions - Outstanding Receivables / Payables Report (XML) Short Name: XTRHOAPR_XML DB package: XTR_XTRHOAPR_XMLP_PKG ZHS XTR 头寸 - 未结应收款/应付款报表 Imported from BI Publisher Description: 头寸 - 未结应收款/应付款报表 Application: 理财管理系统 Source: 头寸 - 未结应收款/应付款报表 (XML) Short Name: XTRHOAPR_XML DB package: XTR_XTRHOAPR_XMLP_PKG BI Publisher &hp_amount_dsp :ap_from_clause :ap_order_clause :ap_source_name :ap_where_clause :ar_from_clause :ar_source_name :ar_where_clause :dsp_company_name :dsp_criteria_set :dsp_discount_method :dsp_factor :dsp_search_by :dsp_show_transactions :dsp_source :dsp_unapld_prepayments :dsp_unapld_receipts :p_company_code :p_conc_request_id :p_criteria_set :p_criteria_set_owner :p_criteria_set_v :p_currency :p_date_from :p_date_from_v :p_date_to :p_date_to_v :p_discount_method :p_dummy1 :p_dummy2 :p_dummy3 :p_dummy4 :p_factor :p_ref_date :p_report_name :p_search_by :p_show_transactions :p_sob_currency :p_source :p_unapld_prepayments :p_unapld_receipts :p_unit :z_actual_hedge_position :z_actual_hedge_position_sum :z_actual_open_position_sum :z_advanced_search_criteria :z_ap_discount :z_as_of_date :z_basic_search_criteria :z_company :z_criteria_set :z_currency :z_customer :z_days :z_deal_number :z_due_date :z_due_date_from :z_due_date_to :z_end_of_report :z_even :z_factor :z_hedge_number :z_invoice_amount :z_invoice_date :z_invoice_number :z_invoice_type :z_net_position :z_no_data_found :z_offset :z_open_arap_hedge_position :z_operating_unit :z_outstanding_amount :z_over_applied :z_page :z_parameters :z_payables :z_receivables :z_remaining :z_report_date :z_search_by :z_show_transactions :z_sob_currency :z_source :z_summary_position :z_supplier :z_total :z_trans_amount :z_trans_date :z_trans_number :z_trans_type :z_unapplied_prepayments :z_unapplied_receipts :z_under_applied 1 -60 :p_dummy1 Char select 'Y' from dual where :$flex$.search_by:NULL = 'ADVANCED' union select null from dual where :$flex$.search_by:NULL is null OR :$flex$.search_by:NULL <> 'ADVANCED' US XTR_HEDGE_IS_ADVANCED 2 -50 :p_dummy2 Char select 'Y' from dual where :$flex$.search_by:NULL = 'BASIC' union select null from dual where :$flex$.search_by:NULL is null OR :$flex$.search_by:NULL <> 'BASIC' US XTR_HEDGE_IS_BASIC 3 -40 :p_criteria_set_owner LOV Oracle XTR_HEDGE_USER_ID Y select fnd_global.user_id id, fnd_global.user_id value, null description from dual order by value,description select fnd_global.user_id from dual AR مالك مجموعة المعايير D KriterienSet-Verantwortlicher E Propietario de Juego de Criterios F Responsable du jeu de critères I Proprietario serie di criteri JA 基準セット所有者 KO 기준 세트 소유자 PTB Proprietário do Conjunto de Critérios RU Владелец набора условий S Ägare till kriterieserie TR Ölçüt Kümesi Sahibi US Criteria Set Owner ZHS 标准集责任人 4 -30 :p_dummy3 Char select 'Y' from dual where :$flex$.source:NULL IN ('AP','BOTH') US XTR_DUMMY 5 -20 :p_dummy4 Char select 'Y' from dual where :$flex$.source:NULL IN ('AR','BOTH') US XTR_DUMMY_2 6 10 :p_search_by LOV Oracle XTR_HEDGE_SEARCH_TYPE Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='XTR_HEDGE_MISC' and lookup_code in ('BASIC','ADVANCED') order by value,description Y AR بحث حسب D Suchen nach E Buscar por F Rechercher par I Cerca per JA 検索基準 KO 검색 기준 PTB Pesquisar por RU Поиск по S Sök per TR Arama Ölçütü US Search By ZHS 搜索依据 7 20 :p_criteria_set LOV Oracle XTR_HEDGE_CRITERIA_SET Y select criteria_set id, criteria_set value, null description from xtr_hedge_criteria where rowid= (select inner_rowid from (select criteria_set inner_criteria_set,rowid inner_rowid from xtr_hedge_criteria where criteria_set is not null and (criteria_set_owner=fnd_global.user_id or criteria_set_owner is null) ) where inner_criteria_set=criteria_set and rownum=1 and nvl(:$flex$.xtr_hedge_is_advanced,'N')='Y' ) order by value,description Y AR مجموعة المعايير D KriterienSet E Juego de Criterios F Jeu de critères I Serie di criteri JA 基準セット KO 기준 세트 PTB Conjunto de Critérios RU Набор условий S Kriterieserie TR Ölçüt Kümesi US Criteria Set ZHS 标准集 8 30 :p_source LOV Oracle XTR_HEDGE_SOURCE Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='XTR_HEDGE_SOURCES' and lookup_code in ('AP','AR','BOTH') and nvl(:$flex$.xtr_hedge_is_basic,'N')='Y' order by value,description SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE='XTR_HEDGE_SOURCES' AND LOOKUP_CODE = 'AR' Y AR المصدر D Herkunft E Origen F Origine I Origine JA ソース KO 출처 PTB Origem RU Источник S Källa TR Kaynak US Source ZHS 来源 9 40 :p_currency LOV Oracle XTR_HEDGE_CURRENCY Y select currency id, currency value, name description from xtr_master_currencies_v where authorised='Y' and nvl(:$flex$.xtr_hedge_is_basic,'N')='Y' order by currency Y AR العملة D Währung E Divisa F Devise I Divisa JA 通貨 KO 통화 PTB Moeda RU Валюта S Valuta TR Para Birimi US Currency ZHS 币种 10 50 :p_company_code LOV Oracle XTR_HEDGE_COMPANY Y select party_code id, party_code value, short_name description from xtr_parties_v where party_type='C' and nvl(:$flex$.xtr_hedge_is_basic,'N')='Y' order by party_code SELECT NULL FROM dual WHERE :$flex$.search_by IS NULL UNION SELECT party_code FROM xtr_parties_v WHERE default_company = 'Y' AND ROWNUM=1 AND :$flex$.search_by='BASIC' UNION SELECT party_code FROM (select party_code from xtr_parties_v where party_type = 'C' order by party_code) WHERE NOT EXISTS (SELECT party_code FROM xtr_parties_v WHERE default_company='Y') AND ROWNUM=1 AND :$flex$.search_by='BASIC' AR الشركة D Firma E Compañía F Société I Società JA 会社 KO 회사 PTB Empresa RU Компания S Företag TR Şirket US Company ZHS 公司 11 60 :p_sob_currency LOV Oracle XTR_SOB_CURRENCY Y select set_of_books_currency id, set_of_books_currency value, null description from xtr_parties_v where ( set_of_books_currency is not null and party_code= ( select inner_party_code from ( select set_of_books_currency inner_set_of_books_currency,party_code inner_party_code from xtr_parties_v ) where inner_set_of_books_currency=set_of_books_currency and rownum=1 ) and :$flex$.xtr_hedge_company:null is null ) or ( :$flex$.xtr_hedge_company:null is not null and party_code=:$flex$.xtr_hedge_company:null ) and nvl(:$flex$.xtr_hedge_is_basic,'N')='Y' order by value,description SELECT set_of_books_currency FROM xtr_parties_v WHERE :$flex$.company=party_code AR عملة دفاتر الحسابات D Währung Buchungsstruktur E Divisa de Juego de Libros F Devise de l'entité comptable I Divisa set of books JA SOB通貨 KO SOB 통화 PTB Moeda SOB RU Валюта НК S Räk.valuta TR Yasal Muhasebe Birimi Para Birimi US SOB Currency ZHS SOB 币种 12 70 :p_discount_method LOV Oracle XTR_HEDGE_DISCOUNT_METHOD Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='XTR_HEDGE_MISC' and lookup_code in ('MAX','MIN','NONE') and :$flex$.xtr_dummy is not null order by value,description SELECT meaning FROM fnd_lookups WHERE lookup_type='XTR_HEDGE_MISC' AND lookup_code='NONE' AND :$FLEX$.XTR_DUMMY IS NOT null Y AR الخصم بحساب المدفوعات D KR Disagio E Descuento de AP F Comptes fournisseur - Escompte I Sconto AP JA AP割引 KO AP 할인 PTB Desconto AP RU Учетная ставка КР S AP: Rabatt TR Brçlr Muh İskonto US AP Discount ZHS AP 贴现 13 80 :p_factor LOV Oracle XTR_HEDGE_NUM_FACTOR Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='XTR_NUM_FACTOR' and nvl(enabled_flag,'N')='Y' and nvl(:$flex$.xtr_hedge_is_basic,'N')='Y' order by lookup_code select meaning FROM fnd_lookups WHERE lookup_type='XTR_NUM_FACTOR' and lookup_code='1' and :$flex$.search_by = 'BASIC' Y AR المعامل D Faktor F Facteur I Fattore JA ファクタ KO 단위 PTB Fator RU Множитель S Faktor TR Faktör US Factor ZHS 贴现 14 90 :p_date_from Date select sysdate from dual where :$flex$.search_by = 'BASIC' AR تاريخ الاستحقاق من D Von Fälligkeitsdatum E De Fecha de Vencimiento F Date d'échéance - Du I Data scadenza - Da JA 期日:自 KO 만기 일자: 부터 PTB Data de Vencimento - De RU Срок с S Förfallodatum från TR İlk Vade Tarihi US Due Date From ZHS 到期日自 15 100 :p_date_to Date AR تاريخ الاستحقاق إلى D Bis Fälligkeitsdatum E A Fecha de Vencimiento F Date d'échéance - Au I Data scadenza - A JA 期日:至 KO 만기 일자: 까지 PTB Data de Vencimento - Até RU Срок по S Till förfallodatum TR Son Vade Tarihi US Due Date To ZHS 到期日至 16 110 :p_unapld_prepayments LOV Oracle XTR_HEDGE_INC_UNPLD_AP Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' and :$flex$.xtr_dummy is not null order by value,description select meaning from fnd_lookups where lookup_type='YES_NO' and lookup_code='N' and :$FLEX$.XTR_DUMMY is not null Y AR تضمين الدفعات المقدمة غير المطبقة D Mit nicht zugeordneten Vorauszahlungen E Incluir Anticipos no Aplicados F Inclure les acomptes non lettrés I Includi anticipi non applicati JA 非充当前払金を含む KO 미반제 선급금 포함 PTB Incluir Pagamentos Antecipados Não-aplicados RU Включение неучтенной предоплаты S Inkludera oapplicerade förskottsbetalningar TR Uygulanmamış Ön Ödemeleri Dahil Et US Include Unapplied Prepayments ZHS 包括未核销预付款 17 120 :p_unapld_receipts LOV Oracle XTR_HEDGE_INC_UNPLD_AR Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' and :$flex$.xtr_dummy_2 is not null order by value,description select meaning from fnd_lookups where lookup_type='YES_NO' and lookup_code='N' and :$FLEX$.XTR_DUMMY_2 is not null Y AR تضمين المقبوضات غير المطبقة D Mit nicht zugeordneten Forderungen E Incluir Cuentas a Cobrar no Aplicadas F Inclure les comptes client non lettrés I Include i conto clienti non applicati JA 非充当売掛金を含む KO 미반제 AR 포함 PTB Incluir Contas a Receber Não-aplicadas RU Вкл. неучтенную дебиторскую задолженность S Inkludera oapplicerade kundreskontran TR Uygulanmamış Alacakları Dahil Et US Include Unapplied Receivables ZHS 包括未核销应收款 18 130 :p_show_transactions LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description select meaning from fnd_lookups where lookup_type='YES_NO' and lookup_code='N' Y AR إظهار الحركات D Transaktionen anzeigen E Mostrar Transacciones F Afficher les opérations I Mostra transazioni JA 取引の表示 KO 거래 표시 PTB Mostrar Transações RU Показать транзакции S Visa transaktioner TR İşlemleri Göster US Show Transactions ZHS 显示事务处理