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）限制的操作单元。 C6E085D46F4651A9E05362FB09050512Y select cr.currency_code Currency_B, cr.deposit_date deposit_date_B, cr.cash_receipt_id cash_receipt_id_B, cr.status cr_status_B, cr.amount amount_B, decode( crh.batch_id, null, cr.amount, 0 ) rcpt_control_amount_B, cr.status cr_status_BB, cr.type cr_type_B, cr.reversal_category reversal_category_B, AR_ARXSOC_XMLP_PKG.cr_data_foundformula(cr.currency_code) CR_DATA_FOUND, AR_ARXSOC_XMLP_PKG.ca_summary_labelformula(cr.currency_code) ca_summary_label, AR_ARXSOC_XMLP_PKG.ca_difference_amountformula(:c_rcpt_control_amount_B, :ca_actual_amount) ca_difference_amount, AR_ARXSOC_XMLP_PKG.ca_applied_amountformula(:ca_applied_amount_B, :ca_misc_amount) ca_applied_amount, AR_ARXSOC_XMLP_PKG.f_all_amountsformula(cr.amount, cr.status, cr.type, cr.reversal_category, cr.cash_receipt_id) F_ALL_AMOUNTS, AR_ARXSOC_XMLP_PKG.pa_actual_amount_p pa_actual_amount, AR_ARXSOC_XMLP_PKG.pa_unidentified_amount_p pa_unidentified_amount, AR_ARXSOC_XMLP_PKG.pa_misc_amount_p pa_misc_amount, AR_ARXSOC_XMLP_PKG.pa_nsf_amount_p pa_nsf_amount, AR_ARXSOC_XMLP_PKG.pa_applied_count_p pa_applied_count, AR_ARXSOC_XMLP_PKG.pa_unapplied_count_p pa_unapplied_count, AR_ARXSOC_XMLP_PKG.pa_unidentified_count_p pa_unidentified_count, AR_ARXSOC_XMLP_PKG.pa_misc_count_p pa_misc_count from ar_cash_receipts cr, ar_cash_receipt_history crh where nvl(:p_bank_account_name_low, '!') != nvl(:p_bank_account_name_high,'@@') and :p_bank_count != 0 &lp_date_low &lp_date_high and nvl(cr.confirmed_flag,'Y') = 'Y' and deposit_date is NOT NULL and cr.cash_receipt_id = crh.cash_receipt_id and crh.first_posted_record_flag = 'Y' union all select b.currency_code, b.deposit_date, -1, null, 0, b.control_amount, null, null, null, AR_ARXSOC_XMLP_PKG.cr_data_foundformula(b.currency_code) CR_DATA_FOUND, AR_ARXSOC_XMLP_PKG.ca_summary_labelformula(b.currency_code) ca_summary_label, AR_ARXSOC_XMLP_PKG.ca_difference_amountformula(:c_rcpt_control_amount_B, :ca_actual_amount) ca_difference_amount, AR_ARXSOC_XMLP_PKG.ca_applied_amountformula(:ca_applied_amount_B, :ca_misc_amount) ca_applied_amount, AR_ARXSOC_XMLP_PKG.f_all_amountsformula(NULL, NULL, NULL, NULL, NULL) F_ALL_AMOUNTS, AR_ARXSOC_XMLP_PKG.pa_actual_amount_p pa_actual_amount, AR_ARXSOC_XMLP_PKG.pa_unidentified_amount_p pa_unidentified_amount, AR_ARXSOC_XMLP_PKG.pa_misc_amount_p pa_misc_amount, AR_ARXSOC_XMLP_PKG.pa_nsf_amount_p pa_nsf_amount, AR_ARXSOC_XMLP_PKG.pa_applied_count_p pa_applied_count, AR_ARXSOC_XMLP_PKG.pa_unapplied_count_p pa_unapplied_count, AR_ARXSOC_XMLP_PKG.pa_unidentified_count_p pa_unidentified_count, AR_ARXSOC_XMLP_PKG.pa_misc_count_p pa_misc_count from ar_batches b where nvl(:p_bank_account_name_low, '!') != nvl(:p_bank_account_name_high,'@@') and :p_bank_count != 0 &lp_date_low &lp_date_high and deposit_date is not null order by 1, 2 AR ARXSOC_XML AR AR تقرير النقدية المودعة - تفاصيل مفتوحة (بتنسيق XML) Imported from BI Publisher Description: تقرير النقدية المودعة - تفاصيل مفتوحة Application: المقبوضات Source: تقرير النقدية المودعة - تفاصيل مفتوحة (بتنسيق XML) Short Name: ARXSOC_XML DB package: AR_ARXSOC_XMLP_PKG D AR Einzahlungen - Offen Imported from BI Publisher Description: Auswertung "Einzahlungen - Offen" Application: Debitoren Source: Einzahlungen - Offen (XML) Short Name: ARXSOC_XML DB package: AR_ARXSOC_XMLP_PKG E AR Depósitos en Bancos - Detalle de Efectivo Abierto Imported from BI Publisher Description: Informe de depósitos en bancos - detalle de efectivo abierto Application: Receivables Source: Depósitos en Bancos - Detalle de Efectivo Abierto (XML) Short Name: ARXSOC_XML DB package: AR_ARXSOC_XMLP_PKG F AR Etat des encaissements - Détail des montants non lettrés Imported from BI Publisher Description: Etat des encaissements - Détail des montants non lettrés Application: Receivables Source: Etat des encaissements - Détail des montants non lettrés (XML) Short Name: ARXSOC_XML DB package: AR_ARXSOC_XMLP_PKG I AR Rapporto Contante versato - Dettagli aperti Imported from BI Publisher Description: Rapporto Contante versato - Dettagli aperti Application: Receivables Source: Rapporto Contante versato - Dettagli aperti (XML) Short Name: ARXSOC_XML DB package: AR_ARXSOC_XMLP_PKG JA AR 銀行入金レポート - 未消込詳細 Imported from BI Publisher Description: 銀行入金レポート - 未消込詳細 Application: Receivables Source: 銀行入金レポート - 未消込詳細(XML) Short Name: ARXSOC_XML DB package: AR_ARXSOC_XMLP_PKG KO AR 예금된 현금 보고서 - 미결 상세내역 Imported from BI Publisher Description: 예금된 현금 보고서 - 미결 상세내역 Application: Receivables Source: 예금된 현금 보고서 - 미결 상세내역(XML) Short Name: ARXSOC_XML DB package: AR_ARXSOC_XMLP_PKG PTB AR Relatório de Caixa Depositado - Detalhe Aberto Imported from BI Publisher Description: Relatório de Caixa Depositado - Detalhe Aberto Application: Receivables Source: Relatório de Caixa Depositado - Detalhe Aberto (XML) Short Name: ARXSOC_XML DB package: AR_ARXSOC_XMLP_PKG RU AR Подробный отчет об открытых депонированных средствах Imported from BI Publisher Description: Подробный отчет об открытых депонированных средствах Application: Дебиторы Source: Подробный отчет об открытых депонированных средствах (XML) Short Name: ARXSOC_XML DB package: AR_ARXSOC_XMLP_PKG S AR Insatt likvid - rapport: Öppen, detaljer Imported from BI Publisher Description: Insatt likvid - rapport: Öppen, detaljer Application: Receivables Source: Insatt likvid - rapport: Öppen, detaljer (XML) Short Name: ARXSOC_XML DB package: AR_ARXSOC_XMLP_PKG TR AR Mevduat Nakit Raporu - Açık Detay Imported from BI Publisher Description: Mevduat Nakit Raporu - Açık Detay Application: Alacaklar Muhasebesi Source: Mevduat Nakit Raporu - Açık Detay (XML) Short Name: ARXSOC_XML DB package: AR_ARXSOC_XMLP_PKG US AR Deposited Cash Report - Open Detail Imported from BI Publisher Description: Deposited Cash Report - Open Detail Application: Receivables Source: Deposited Cash Report - Open Detail (XML) Short Name: ARXSOC_XML DB package: AR_ARXSOC_XMLP_PKG ZHS AR 存款现金报表 - 未结明细 Imported from BI Publisher Description: 存款现金报表 - 未结明细 Application: 应收帐款 Source: 存款现金报表 - 未结明细 (XML) Short Name: ARXSOC_XML DB package: AR_ARXSOC_XMLP_PKG BI Publisher &lp_date_high &lp_date_low :c_rcpt_control_amount_b :ca_actual_amount :ca_applied_amount_b :ca_misc_amount :lp_bank_account_name_high :lp_bank_account_name_low :lp_date_high :lp_date_low :operating_unit :p_actual_amount :p_applied_count :p_bank_account_name_high :p_bank_account_name_low :p_bank_count :p_conc_request_id :p_date_high :p_date_high1 :p_date_low :p_date_low1 :p_misc_amount :p_misc_count :p_nsf_amount :p_order_by :p_order_by_1 :p_set_of_books_id :p_unapplied_count :p_unidentified_amount :p_unidentified_count :pa_actual_amount :pa_applied_count :pa_misc_amount :pa_misc_count :pa_nsf_amount :pa_unapplied_count :pa_unidentified_amount :pa_unidentified_count :ph_order_by :rp_company_name :rp_data_found1 :rp_data_found2 :rp_data_found3 :rp_date_range :rp_order_by :rp_report_name 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_order_by LOV Oracle AR_ARXSOC_SORT_BY Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='SORT_BY_ARXSOC' order by value,description Y AR ترتيب حسب فرز حسب D Sortieren nach Sortieren nach E Ordenar por Ordenar por F Tri par Tri par I Ordina per Ordina per JA ソート・キー ソート・キー KO 정렬 기준 정렬 기준 PTB Ordenar Por Classificar Por RU Сортировка Сортировка S Ordna per Sortera efter TR Sıralama Bazı Sıralama Bazı US Order By Sort By ZHS 排序依据 排序依据 4 20 :p_date_low Date AR تاريخ الإيداع من مدى تاريخ الإيداع من D Von Wertstellungsdatum Von Wertstellungsdatum E De Fecha de Depósito Rango inferior de fecha de depósito F Date de remise - Du Début de la fourchette des dates de remise I Data versamento (min) Intervallo minimo per la data di versamento JA 預入日:自 預入日:自 KO 예금 일자 하한 예금 일자 하한 범위 PTB Data do Depósito - Inferior Faixa Inferior de Data do Depósito RU Дата депонирования с Дата депонирования с S Från insättningsdatum Från insättningsdatumintervall TR Kaparo Tarihi Alt Değeri Kaparo Tarihi Alt Aralığı US Deposit Date Low Low Range of Deposit Date ZHS 存款日期下限 存款日期的下限 5 30 :p_date_high Date AR تاريخ الإيداع إلى مدى تاريخ الإيداع إلى D Bis Wertstellungsdatum Bis Wertstellungsdatum E A Fecha de Depósito Rango superior de fecha de depósito F Date de remise - Au Fin de la fourchette des dates de remise I Data versamento (max) Intervallo massimo per la data di versamento JA 預入日:至 預入日:至 KO 예금 일자 상한 예금 일자 상한 범위 PTB Data do Depósito - Superior Faixa Superior de Data do Depósito RU Дата депонирования по Дата депонирования по S Till insättningsdatum Till insättningsdatumintervall TR Kaparo Tarihi Üst Değeri Kaparo Tarihi Üst Aralığı US Deposit Date High High Range of Deposit Date ZHS 存款日期上限 存款日期的上限 6 40 :p_bank_account_name_low LOV Oracle AR_BANK_ACCOUNT_NAME Y select cba.bank_account_name id, cba.bank_account_name value, null description from ce_bank_accounts cba,ce_bank_branches_v bb where cba.bank_branch_id=bb.branch_party_id and cba.account_classification='INTERNAL' and exists (select 'x' from ce_bank_acct_uses bau where bau.bank_account_id=cba.bank_account_id and nvl(bau.ar_use_enable_flag,'N')='Y' and nvl(end_date,to_date('12/31/4712','MM/DD/YYYY'))>=trunc(sysdate) ) order by 1 AR اسم حساب البنك من من مدى اسم حساب البنك D Von Bankkonto Von Bankkonto E De Nombre de Cuenta Bancaria Rango Inferior de Nombre de Cuenta Bancaria F Intitulé du compte bancaire - De Début de la fourchette d'intitulés de compte bancaire I Nome conto bancario (min) Valore minimo per il nome del conto bancario JA 銀行口座名:自 銀行口座名:自 KO 은행 계정명 하한 은행 계정명의 하한 범위 PTB Nome da Conta Bancária - Inferior Faixa de Nomes de Conta Bancária - Inferior RU Имя банковского счета с Имя банковского счета с S Från bankkontonamn Nedre intervallgräns för bankkontonamn TR Banka Hesap Adı Alt Değeri Banka Hesap Adı alt aralığı US Bank Account Name Low Low range of Bank Account Name ZHS 银行帐户名下限 银行帐户名的下限 7 50 :p_bank_account_name_high LOV Oracle AR_BANK_ACCOUNT_NAME Y select cba.bank_account_name id, cba.bank_account_name value, null description from ce_bank_accounts cba,ce_bank_branches_v bb where cba.bank_branch_id=bb.branch_party_id and cba.account_classification='INTERNAL' and exists (select 'x' from ce_bank_acct_uses bau where bau.bank_account_id=cba.bank_account_id and nvl(bau.ar_use_enable_flag,'N')='Y' and nvl(end_date,to_date('12/31/4712','MM/DD/YYYY'))>=trunc(sysdate) ) order by 1 AR اسم حساب البنك إلى مدى اسم حساب البنك من D Bis Bankkonto Bis Bankkonto E A Nombre de la Cuenta Bancaria Rango superior de nombre de cuenta bancaria F Intitulé de compte bancaire - A Fin de la fourchette des intitulés de compte bancaire I Nome conto bancario (max) Intervallo massimo per il nome del conto bancario JA 銀行口座名:至 銀行口座名:至 KO 은행 계정명 상한 은행 계정명의 상한 범위 PTB Nome Conta Bancária (Superior) Faixa de Nomes de Conta Bancária - Superior RU Имя банковского счета по Имя банковского счета по S Till bankkontonamn Övre intervallgräns för bankkontonamn TR Banka Hesap Adı Üst Değeri Banka Hesap Adı Üst Değeri US Bank Account Name High High Range of Bank Account Name ZHS 银行帐户名上限 银行帐户名的上限