ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 C6E085D46F3E51A9E05362FB09050512 SELECT cash.customer_name Customer_Name, cash.location Location, cash.cash_receipt_id Receipt_Id, cash.receipt_number Receipt_Number, cash.receipt_date Receipt_Date, cash.amount Receipt_Amount, cash.currency_code Receipt_Currency, cash.exchange_rate Receipt_Exchange_Rate, trx.trx_number Trx_Id, trx.trx_number Trx_Number, trx.trx_date Trx_Date, trx.invoice_currency_code Trx_Currency, apps.amount_applied Trx_Amt_Applied, apps.acctd_amount_applied_to Trx_Amt_Applied_Base, apps.amount_applied_from Actual_Alloc_Receipt_Amt, apps.acctd_amount_applied_from Actual_Alloc_Receipt_Amt_Base, apps.trans_to_receipt_rate Actual_Cross_Curr_Rate, curr.precision Receipt_Precision, AR_ARXFXGL_XMLP_PKG.actual_cross_curr_rate_dformul(apps.trans_to_receipt_rate) Actual_Cross_Curr_Rate_D, --AR_ARXFXGL_XMLP_PKG.allocated_amount_rateformula(:Rate_Sys_Curr_Rate) Rate_Alloc_Receipt_Amt, AR_ARXFXGL_XMLP_PKG.allocated_amount_rateformula(apps.amount_applied,curr.precision,:Rate_Sys_Curr_Rate) Rate_Alloc_Receipt_Amt, --AR_ARXFXGL_XMLP_PKG.rate_alloc_receipt_amt_basefor(:Rate_Sys_Curr_Rate) Rate_Alloc_Receipt_Amt_Base, AR_ARXFXGL_XMLP_PKG.rate_alloc_receipt_amt_basefor(:Rate_Sys_Curr_Rate,:Rate_Alloc_Receipt_Amt,cash.exchange_rate) Rate_Alloc_Receipt_Amt_Base, --AR_ARXFXGL_XMLP_PKG.actual_gainformula(:Actual_Gain_Loss) Actual_Gain, AR_ARXFXGL_XMLP_PKG.actual_gainformula(AR_ARXFXGL_XMLP_PKG.cf_gain_loss_actualfo(apps.acctd_amount_applied_from, apps.acctd_amount_applied_to)) Actual_Gain, --AR_ARXFXGL_XMLP_PKG.actual_rate_lossformula(:Actual_Gain_Loss) Actual_Loss, AR_ARXFXGL_XMLP_PKG.actual_rate_lossformula(AR_ARXFXGL_XMLP_PKG.cf_gain_loss_actualfo(apps.acctd_amount_applied_from, apps.acctd_amount_applied_to)) Actual_Loss, AR_ARXFXGL_XMLP_PKG.cf_gain_loss_actualfo(apps.acctd_amount_applied_from, apps.acctd_amount_applied_to) Actual_Gain_Loss, --AR_ARXFXGL_XMLP_PKG.sys_cross_currencyformula() Rate_Sys_Curr_Rate, AR_ARXFXGL_XMLP_PKG.sys_cross_currencyformula(trx.invoice_currency_code,cash.currency_code,cash.receipt_date) Rate_Sys_Curr_Rate, AR_ARXFXGL_XMLP_PKG.rate_sys_curr_rate_dformula(:Rate_Sys_Curr_Rate) Rate_Sys_Curr_Rate_D, AR_ARXFXGL_XMLP_PKG.rate_gainformula(:Rate_Gain_Loss) Rate_Gain, AR_ARXFXGL_XMLP_PKG.rate_lossformula(:Rate_Gain_Loss) Rate_Loss, AR_ARXFXGL_XMLP_PKG.rate_gain_lossformula(:Rate_Alloc_Receipt_Amt_Base, apps.acctd_amount_applied_to) Rate_Gain_Loss, AR_ARXFXGL_XMLP_PKG.absolute_differenceformula(:Actual_Gain_Loss, :Rate_Gain_Loss) Absolute_Difference --from Actual_Alloc_Receipt_Amt, -- apps.acctd_amount_applied_from Actual_Alloc_Receipt_Amt_Base, -- apps.trans_to_receipt_rate Actual_Cross_Curr_Rate, -- curr.precision Receipt_Precision FROM fnd_currencies curr, ra_customer_trx trx, ar_cash_receipts_v cash, ar_receivable_applications apps WHERE curr.currency_code = cash.currency_code AND apps.applied_customer_trx_id = trx.customer_trx_id AND apps.cash_receipt_id = cash.cash_receipt_id AND apps.status = 'APP' AND cash.currency_code != trx.invoice_currency_code &Where_Customer &Where_Location &Where_Date &Where_Currency /*ORDER BY cash.customer_name, cash.location, cash.currency_code, cash.receipt_number, trx.trx_date, trx.invoice_currency_code, trx.trx_number*/ order by 1,18,2,3,4,5,6,7,8,12,9,11,10,13,14,15,16,17 Y AR ARXFXGL_XML AR AR تقرير ربح/خسارة سعر صرف العملة المشتقة (بتنسيق XML) Imported from BI Publisher Description: تقرير ربح/خسارة سعر صرف العملة المشتقة Application: المقبوضات Source: تقرير ربح/خسارة سعر صرف العملة المشتقة (بتنسيق XML) Short Name: ARXFXGL_XML DB package: AR_ARXFXGL_XMLP_PKG D AR Währungsübergreifende Zahlungszuordnungen - Wechselkursgewinne/-verluste Imported from BI Publisher Description: Auswertung "Währungsübergreifende Zahlungszuordnungen - Wechselkursgewinne/-verluste" Application: Debitoren Source: Währungsübergreifende Zahlungszuordnungen - Wechselkursgewinne/-verluste (XML) Short Name: ARXFXGL_XML DB package: AR_ARXFXGL_XMLP_PKG E AR Pérdidas/Ganancias en el Cambio de Divisa Combinada Imported from BI Publisher Description: Informe de pérdidas/ganancias en el cambio de divisa combinada Application: Receivables Source: Pérdidas/Ganancias en el Cambio de Divisa Combinada (XML) Short Name: ARXFXGL_XML DB package: AR_ARXFXGL_XMLP_PKG F AR Etat Ecarts de change des règlements interdevises Imported from BI Publisher Description: Etat des écarts de change des règlements interdevises Application: Receivables Source: Etat Ecarts de change des règlements interdevises (XML) Short Name: ARXFXGL_XML DB package: AR_ARXFXGL_XMLP_PKG I AR Rapporto Utili/perdite per cambio divise incrociate Imported from BI Publisher Description: Rapporto Utile/perdite per cambio divise incrociate Application: Receivables Source: Rapporto Utili/perdite per cambio divise incrociate (XML) Short Name: ARXFXGL_XML DB package: AR_ARXFXGL_XMLP_PKG JA AR 相互通貨換算損益レポート Imported from BI Publisher Description: 相互通貨換算損益レポート Application: Receivables Source: 相互通貨換算損益レポート(XML) Short Name: ARXFXGL_XML DB package: AR_ARXFXGL_XMLP_PKG KO AR 교차 통화 환율 손익 보고서 Imported from BI Publisher Description: 교차 통화 환율 손익 보고서 Application: Receivables Source: 교차 통화 환율 손익 보고서(XML) Short Name: ARXFXGL_XML DB package: AR_ARXFXGL_XMLP_PKG PTB AR Relatório de Ganhos e Perdas Cambiais em Moeda Cruzada Imported from BI Publisher Description: Relatório de Ganhos e Perdas Cambiais em Moeda Cruzada Application: Receivables Source: Relatório de Ganhos e Perdas Cambiais em Moeda Cruzada (XML) Short Name: ARXFXGL_XML DB package: AR_ARXFXGL_XMLP_PKG RU AR Отчет о курсовых прибылях и убытках Imported from BI Publisher Description: Отчет о курсовых прибылях и убытках Application: Дебиторы Source: Отчет о курсовых прибылях и убытках (XML) Short Name: ARXFXGL_XML DB package: AR_ARXFXGL_XMLP_PKG S AR Rapport över kursvinst/kursförlust vid korsvalutaväxling Imported from BI Publisher Description: Rapport över kursvinst/kursförlust vid korsvalutaväxling Application: Receivables Source: Rapport över kursvinst/kursförlust vid korsvalutaväxling (XML) Short Name: ARXFXGL_XML DB package: AR_ARXFXGL_XMLP_PKG TR AR Çapraz Döviz Kuru Karı/Zararı Raporu Imported from BI Publisher Description: Çapraz Döviz Kuru Karı/Zararı Raporu Application: Alacaklar Muhasebesi Source: Çapraz Döviz Kuru Karı/Zararı Raporu (XML) Short Name: ARXFXGL_XML DB package: AR_ARXFXGL_XMLP_PKG US AR Cross Currency Exchange Gain/Loss Imported from BI Publisher Description: Cross Currency Exchange Gain/Loss Report Application: Receivables Source: Cross Currency Exchange Gain/Loss Report (XML) Short Name: ARXFXGL_XML DB package: AR_ARXFXGL_XMLP_PKG ZHS AR 交叉币种汇兑损益报表 Imported from BI Publisher Description: 交叉币种汇兑损益报表 Application: 应收帐款 Source: 交叉币种汇兑损益报表 (XML) Short Name: ARXFXGL_XML DB package: AR_ARXFXGL_XMLP_PKG BI Publisher &where_currency &where_customer &where_date &where_location :actual_gain_loss :functional_currency :functional_precision :operating_unit :p_conc_request_id :p_customer_id :p_customer_name :p_customer_number :p_exchange_rate_type :p_from_receipt_date :p_location :p_rate_type :p_receipt_currency :p_set_of_books_id :p_site_use_id :p_to_receipt_date :rate_alloc_receipt_amt :rate_alloc_receipt_amt_base :rate_gain_loss :rate_sys_curr_rate :report_name :set_of_books_name :where_currency :where_customer :where_date :where_location 1 -20 :p_set_of_books_id LOV Oracle AR_SRS_SET_OF_BOOKS_ID Y select set_of_books_id id, set_of_books_id value, null description from ar_system_parameters order by value,description SELECT set_of_books_id FROM ar_system_parameters Y AR معرف دفتر الأستاذ معرف دفتر الأستاذ D Buchkennung Buchkennung E Id Libro Mayor Identificador de libro mayor F ID livre ID livre I Id libro contabile Id del libro contabile JA 元帳ID 元帳ID KO 원장 ID 원장 ID PTB Id do Razão Id do Razão RU Идентификатор книги Идентификатор книги S Huvudboks-id Huvudboks-id TR Defter No Defter No US Ledger Id Ledger Id ZHS 分类帐标识 分类帐标识 2 0 :operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) Y US Operating Unit Required Operating Unit restriction for reports working in single operating unit mode only 3 10 :p_customer_id LOV Oracle AR_SRS_CUSTOMER_ID Y select ca.cust_account_id id, party.party_name value, null description from hz_cust_accounts ca,hz_parties party where ca.party_id=party.party_id order by value,description AR اسم العميل اسم العميل D Kundenname Kundenname E Nombre del Cliente Nombre del cliente F Nom du client Nom du client I Nome cliente Nome cliente JA 顧客名 顧客名 KO 고객명 고객명 PTB Nome do Cliente Nome do Cliente RU Имя заказчика Имя заказчика S Kund Kund TR Müşteri Adı Müşteri Adı US Customer Name Customer Name ZHS 客户名称 客户名称 4 20 :p_site_use_id LOV Oracle AR_SRS_CUSTOMER_SITE_ID Y select su.site_use_id id, su.location value, null description from hz_cust_site_uses su where su.cust_acct_site_id in (select adr.cust_acct_site_id from hz_cust_acct_sites_all adr, hz_cust_accounts cust where nvl (adr.bill_to_flag,'N')!='N' and adr.cust_account_id=cust.cust_account_id and cust.cust_account_id= :$flex$.ar_srs_customer_id) and su.site_use_code='BILL_TO' order by value,description AR موقع العميل الموقع D Kundenadresse Standort E Sitio del Cliente Ubicación F Site client Lieu I Sede cliente Ubicazione JA 顧客サイト 事業所 KO 고객 지점 위치 PTB Local do Cliente Local RU Отделение заказчика Расположение S Kundplats Adress TR Müşteri İşletme Birimi Yerleşim US Customer Site Location ZHS 客户地点 地点 5 30 :p_from_receipt_date Date AR من تاريخ الإيصال من تاريخ الإيصال D Von Zahlungsdatum Von Zahlungsdatum E De Fecha de Cobro De Fecha de Cobro F Date de règlement - Du Date de règlement - Du I Data incasso - Da Data incasso - Da JA 入金日:自 入金日:自 KO 수금 일자: 부터 수금 일자: 부터 PTB Data de Recebimento - De Data de Recebimento - De S Från inbetalningsdatum Från inbetalningsdatum TR Ödeme Tarihi Başlangıcı Ödeme Tarihi Başlangıcı US From Receipt Date From Receipt Date ZHS 自收款日期 自收款日期 6 40 :p_to_receipt_date Date AR إلى تاريخ الإيصال إلى تاريخ الإيصال D Bis Zahlungsdatum Bis Zahlungsdatum E A Fecha de Cobro A Fecha de Cobro F Date de règlement - Au Date de règlement - Au I Data incasso - A Data incasso - A JA 入金日:至 入金日:至 KO 수금 일자: 까지 수금 일자: 까지 PTB Data de Recebimento - Até Data de Recebimento - Até RU Дата поступления по Дата поступления по S Till inbetalningsdatum Till inbetalningsdatum TR Ödeme Tarihi Bitişi Ödeme Tarihi Bitişi US To Receipt Date To Receipt Date ZHS 至收款日期 至收款日期 7 50 :p_receipt_currency LOV Oracle AR_SRS_CURRENCY Y select currency_code id, currency_code value, name description from fnd_currencies_vl where currency_flag='Y' and enabled_flag in ('Y','N') order by currency_code AR عملة الإيصال عملة الإيصال D Zahlungswährung Zahlungswährung E Divisa de Cobro Divisa de Cobro F Devise de règlement Devise de règlement I Divisa ricevuta Divisa ricevuta JA 入金通貨 入金通貨 KO 수금 통화 수금 통화 PTB Moeda do Recebimento Moeda do Recebimento RU Валюта поступления Валюта поступления S Betalningsvaluta Betalningsvaluta TR Ödeme Para Birimi Ödeme Para Birimi US Receipt Currency Receipt Currency ZHS 收款币种 收款币种 8 60 :p_rate_type LOV Oracle AR_SRS_RATE_TYPE Y select conversion_type id, user_conversion_type value, null description from gl_daily_conversion_types order by value,description AR نوع سعر الصرف نوع سعر الصرف D Wechselkursart Wechselkursart E Clase de Tipo de Cambio Clase de tipo de cambio F Type de taux de change Type de taux de change I Tipo tasso di cambio Tipo di tasso di cambio JA 換算レート・タイプ 換算レート・タイプ KO 환율 유형 환율 유형 PTB Tipo de Taxa de Câmbio Tipo de Taxa de Câmbio RU Тип обменного курса Тип обменного курса S Växelkurstyp Växelkurstyp TR Döviz Kuru Tipi Döviz Kuru Tipi US Exchange Rate Type Exchange Rate Type ZHS 汇率类型 汇率类型 :$flex$.ar_srs_customer_id Customer Name Customer Site