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）限制的操作单元。 C6E085D46F3551A9E05362FB09050512Y SELECT decode(batch.batch_applied_status, 'COMPLETED_CREATION',1, 'COMPLETED_APPROVAL',2, 'STARTED_CREATION',3, 'STARTED_APPROVAL',4, 'STARTED_FORMAT',5, 10) status_order, decode(:P_SORT_BY_T, 'REMITTANCE ACCOUNT', cba.bank_account_name, null) dcol_A, decode(:P_SORT_BY_T, 'REMITTANCE ACCOUNT', batch.remit_method_code, null) dcol_B, status_lc.meaning batch_status, batch.batch_applied_status status_code, batch.name batch_name, batch.batch_date batch_date, batch.bank_deposit_number reference, rbank.bank_name, rbank.bank_branch_name, cba.bank_account_name remit_acct, rmethod_lc.meaning remit_mtd, mtd.name pmt_method, batch.gl_date gl_date, batch.currency_code currency_code, batch.batch_id batch_id, AR_ARXAPRMB_XMLP_PKG.amountformula(batch.batch_applied_status, batch.batch_id) amount, --&currency_code DUMMY_CURRENCY, batch.currency_code DUMMY_CURRENCY, AR_ARXAPRMB_XMLP_PKG.det_batch_statusformula(status_lc.meaning) DET_BATCH_STATUS FROM ar_batches batch, ar_receipt_methods mtd, ce_bank_branches_v rbank, ce_bank_acct_uses racct, ce_bank_accounts cba, ar_lookups status_lc, ar_lookups rmethod_lc WHERE mtd.receipt_method_id(+) = batch.receipt_method_id AND status_lc.lookup_type(+) = 'BATCH_APPLIED_STATUS' AND status_lc.lookup_code(+) = batch.batch_applied_status AND rmethod_lc.lookup_code(+) = batch.remit_method_code AND rmethod_lc.lookup_type(+) = 'REMITTANCE_METHOD' AND batch.remit_method_code = nvl(:P_REMITTANCE_METHOD,batch.remit_method_code) AND batch.type = 'REMITTANCE' AND racct.bank_acct_use_id = batch.remit_bank_acct_use_id AND racct.bank_account_id = cba.bank_account_id AND rbank.branch_party_id = cba.bank_branch_id AND batch.remit_bank_acct_use_id = nvl(:P_REMIT_BANK_ACCOUNT, batch.remit_bank_acct_use_id) AND rbank.bank_branch_name = nvl(:P_REMIT_BANK_BRANCH,rbank.bank_branch_name) AND rbank.bank_name = nvl(:P_REMIT_BANK,rbank.bank_name) AND batch.name between nvl(:p_batch_name_low,batch.name) and nvl(:p_batch_name_high,batch.name) AND ( batch.bank_deposit_number between nvl(:p_depno_low,batch.bank_deposit_number) and nvl(:p_depno_high,batch.bank_deposit_number) or ( batch.bank_deposit_number is null and :p_depno_low is null and :p_depno_high is null ) ) AND batch.batch_date between nvl(:p_rem_date_from,to_date('01-01-0001','DD-MM-YYYY')) and nvl(:p_rem_date_to,to_date('12-12-4000','DD-MM-YYYY')) AND ( batch.batch_applied_status != 'COMPLETED_FORMAT' or nvl(:P_INCLUDE_FORMATTED,'Y') = 'Y' ) &LP_STATUS ORDER BY 6,7,8,11,12,14 AR ARXAPRMB_XML AR AR تقرير إدارة مجموعات التحويلات النقدية (بتنسيق XML) Imported from BI Publisher Description: تقرير إدارة مجموعة التحويلات النقدية Application: المقبوضات Source: تقرير إدارة مجموعات التحويلات النقدية (بتنسيق XML) Short Name: ARXAPRMB_XML DB package: AR_ARXAPRMB_XMLP_PKG D AR Zahlungseinzug - Stapelverwaltung Imported from BI Publisher Description: Auswertung "Zahlungseinzug - Stapelverwaltung" Application: Debitoren Source: Zahlungseinzug - Stapelverwaltung (XML) Short Name: ARXAPRMB_XML DB package: AR_ARXAPRMB_XMLP_PKG E AR Gestión de Lotes de Remesas Imported from BI Publisher Description: Informe de gestión de lotes de remesas Application: Receivables Source: Gestión de Lotes de Remesas (XML) Short Name: ARXAPRMB_XML DB package: AR_ARXAPRMB_XMLP_PKG F AR Etat de gestion des lots de remises en banque Imported from BI Publisher Description: Etat de gestion des lots de remises en banque Application: Receivables Source: Etat de gestion des lots de remises en banque (XML) Short Name: ARXAPRMB_XML DB package: AR_ARXAPRMB_XMLP_PKG I AR Rapporto Gestione batch di rimesse Imported from BI Publisher Description: Rapporto Gestione batch di rimesse Application: Receivables Source: Rapporto Gestione batch di rimesse (XML) Short Name: ARXAPRMB_XML DB package: AR_ARXAPRMB_XMLP_PKG JA AR 送金バッチ管理レポート Imported from BI Publisher Description: 送金バッチ管理レポート Application: Receivables Source: 送金バッチ管理レポート(XML) Short Name: ARXAPRMB_XML DB package: AR_ARXAPRMB_XMLP_PKG KO AR 수탁 배치 관리 보고서 Imported from BI Publisher Description: 수탁 배치 관리 보고서 Application: Receivables Source: 수탁 배치 관리 보고서(XML) Short Name: ARXAPRMB_XML DB package: AR_ARXAPRMB_XMLP_PKG PTB AR Relatório de Gerenciamento de Lotes de Remessas Imported from BI Publisher Description: Relatório de Gerenciamento de Lote de Remessas Application: Receivables Source: Relatório de Gerenciamento de Lotes de Remessas (XML) Short Name: ARXAPRMB_XML DB package: AR_ARXAPRMB_XMLP_PKG RU AR Отчет об управлении пакетами переводов Imported from BI Publisher Description: Отчет об управлении пакетами переводов Application: Дебиторы Source: Отчет об управлении пакетами переводов (XML) Short Name: ARXAPRMB_XML DB package: AR_ARXAPRMB_XMLP_PKG S AR Hantering av överföringsbunt - rapport Imported from BI Publisher Description: Hantering av överföringsbunt - rapport Application: Receivables Source: Hantering av överföringsbunt - rapport (XML) Short Name: ARXAPRMB_XML DB package: AR_ARXAPRMB_XMLP_PKG TR AR Tahsile Verme İşlem Grubu Yönetim Raporu Imported from BI Publisher Description: Tahsile Verme İşlem Grubu Yönetim Raporu Application: Alacaklar Muhasebesi Source: Tahsile Verme İşlem Grubu Yönetim Raporu (XML) Short Name: ARXAPRMB_XML DB package: AR_ARXAPRMB_XMLP_PKG US AR Remittance Batch Management Imported from BI Publisher Description: Remittance Batch Management Report Application: Receivables Source: Remittance Batch Management Report (XML) Short Name: ARXAPRMB_XML DB package: AR_ARXAPRMB_XMLP_PKG ZHS AR 汇款批管理报表 Imported from BI Publisher Description: 汇款批管理报表 Application: 应收帐款 Source: 汇款批管理报表 (XML) Short Name: ARXAPRMB_XML DB package: AR_ARXAPRMB_XMLP_PKG BI Publisher &currency_code &lp_status :lp_status :operating_unit :p_batch_name_high :p_batch_name_low :p_conc_request_id :p_depno_high :p_depno_low :p_include_formatted :p_rem_date_from :p_rem_date_from_t :p_rem_date_to :p_rem_date_to_t :p_remit_bank :p_remit_bank_account :p_remit_bank_branch :p_remittance_method :p_set_of_books_id :p_sort_by :p_sort_by_t :p_status :p_summary_or_detailed :rp_company_name :rp_data_found :rp_report_name :rp_sub_title 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 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_sort_by LOV Oracle AR_ARXAPRMB_SORT_BY Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='SORT_BY_ARXAPRMB' and enabled_flag='Y' order by meaning 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_status LOV Oracle AR_RCB_BATCH_APPLIED_STATUS Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='BATCH_APPLIED_STATUS' and lookup_code!='COMPLETED_FORMAT' and enabled_flag='Y' order by meaning AR الموقف الموقف E Estado Estado F Statut Statut I Stato Stato JA ステータス ステータス KO 상태 상태 RU Статус Статус TR Statü Statü US Status Status ZHS 状态 状态 5 30 :p_summary_or_detailed LOV Oracle AR_ARXAPRMB_SD Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='ARXAPRMB_SD' order by value,description select meaning from ar_lookups where lookup_type = 'ARXAPRMB_SD' and lookup_code = 'DETAILED' Y AR إجمالي أو تفاصيل إجمالي أو تفاصيل D Übersicht oder Details Übersicht oder Details E Resumen o Detalle Resumen o Detalle F Synthèse ou détail Synthèse ou détail I Sintetico o dettagliato Sintetico o dettagliato JA 要約または詳細 要約または詳細 KO 요약 또는 상세내역 요약 또는 상세내역 PTB Sumariado ou Detalhado Sumariado ou Detalhado RU Сводный или подробный Сводный или подробный S Översikt eller detalj Översikt eller detalj TR Özet Veya Detaylı Özet Veya Detaylı US Summary Or Detailed Summary Or Detailed ZHS 汇总或明细 汇总或明细 6 40 :p_rem_date_from Date AR تاريخ التحويل النقدي من تاريخ التحويل النقدي من D Von Einzugsdatum Von Einzugsdatum E De Fecha de Remesa De fecha de remesa F Date de remise en banque - Du Date de remise en banque - Du I Data rimessa - Da Data rimessa - Da JA 送金日:自 送金日:自 KO 수탁 일자: 부터 수탁 일자: 부터 PTB Data - De da Remessa Data - De da Remessa RU Дата перевода с Дата перевода с S Från remitteringsdatum Från remitteringsdatum TR İlk Tahsile Verme Tarihi Tahsile Verme Başlangıç Tarihi US Remittance Date From Remittance Date From ZHS 汇款日期自 汇款日期自 7 50 :p_rem_date_to Date AR تاريخ التحويل النقدي إلى تاريخ التحويل النقدي إلى D Bis Einzugsdatum Bis Einzugsdatum E A Fecha de Remesa A fecha de remesa F Date de remise en banque - Au Date de remise en banque - Au I Data rimessa - A Data rimessa - A JA 送金日:至 送金日:至 KO 수탁 일자: 까지 수탁 일자: 까지 PTB Data - Até da Remessa Data - Até da Remessa RU Дата перевода по Дата перевода по S Till remitteringsdatum Till remitteringsdatum TR Son Tahsile Verme Tarihi Tahsile Verme Bitiş Tarihi US Remittance Date To Remittance Date To ZHS 汇款日期至 汇款日期至 8 60 :p_depno_low LOV Oracle AR_DEPOSIT_NUMBER Y select b1.bank_deposit_number id, b1.bank_deposit_number value, null description from ar_batches b1 where b1.batch_id= (select max(b2.batch_id) from ar_batches b2 where b2.bank_deposit_number =b1.bank_deposit_number) and b1.type='REMITTANCE' order by b1.name AR رقم إيداع من رقم إيداع من D Von Einzahlungsnummer Von Einzahlungsnummer E De Número de Depósito De número de depósito F Numéro de remise - De Numéro de remise - De I Numero versamento (min) Numero del versamento (min) JA 預入番号:自 預入番号:自 KO 예금 번호 하한 예금 번호 하한 PTB Nr. Depósito - Inferior Nr. Depósito - Inferior RU Номер депозита с Номер депозита с S Från insättningsnummer Från insättningsnummer TR Depozito Numarası Alt Değeri Depozito Numarası Alt Değeri US Deposit Number Low Deposit Number Low ZHS 存款编号下限 存款编号下限 9 70 :p_depno_high LOV Oracle AR_DEPOSIT_NUMBER Y select b1.bank_deposit_number id, b1.bank_deposit_number value, null description from ar_batches b1 where b1.batch_id= (select max(b2.batch_id) from ar_batches b2 where b2.bank_deposit_number =b1.bank_deposit_number) and b1.type='REMITTANCE' order by b1.name AR رقم إيداع إلى رقم إيداع إلى D Bis Einzahlungsnummer Bis Einzahlungsnummer E A Número de Depósito A número de depósito F Numéro de remise - A Numéro de remise - A I Numero versamento (max) Numero del versamento (max) JA 預入番号:至 預入番号:至 KO 예금 번호 상한 예금 번호 상한 PTB Nr. Depósito - Superior Nr. Depósito - Superior RU Номер депозита по Номер депозита по S Till insättningsnummer Till insättningsnummer TR Depozito Numarası Üst Değeri Depozito Numarası Üst Değeri US Deposit Number High Deposit Number High ZHS 存款编号上限 存款编号上限 10 80 :p_batch_name_low LOV Oracle AR_ARZACS_REMITTANCE_BATCH_NAME Y select name id, name value, null description from ar_batches where type='REMITTANCE' order by name AR اسم مجموعة من اسم مجموعة من D Von Stapel Von Stapel E De Nombre del Lote De nombre del lote F Nom de lot - De Nom de lot - De I Nome batch (min) Nome del batch (min) JA バッチ名:自 バッチ名:自 KO 배치명 하한 배치명 하한 PTB Nome do Lote - Inferior Nome do Lote - Inferior RU Имя пакета с Имя пакета с S Från buntnamn Från buntnamn TR İşlem Grubu Adı Alt Değeri İşlem Grubu Adı Alt Değeri US Batch Name Low Batch Name Low ZHS 批名下限 批名下限 11 90 :p_batch_name_high LOV Oracle AR_ARZACS_REMITTANCE_BATCH_NAME Y select name id, name value, null description from ar_batches where type='REMITTANCE' order by name AR اسم مجموعة إلى اسم مجموعة إلى D Bis Stapel Bis Stapel E A Nombre del Lote A nombre del lote F Nom de lot - A Nom de lot - A I Nome batch (max) Nome del batch (max) JA バッチ名:至 バッチ名:至 KO 배치명 상한 배치명 상한 PTB Nome do Lote - Superior Nome do Lote - Superior RU Имя пакета по Имя пакета по S Till buntnamn Till buntnamn TR İşlem Grubu Adı Üst Değeri İşlem Grubu Adı Üst Değeri US Batch Name High Batch Name High ZHS 批名上限 批名上限 12 100 :p_include_formatted 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 = 'Y' AR تضمين المجموعات المصاغة تضمين المجموعات المصاغة D Mit formatierten Stapeln Mit formatierten Stapeln E Incluir Lotes Formateados Incluir lotes formateados F Inclure les lots formatés Inclure les lots formatés I Includi batch formattati Include i batch formattati JA フォーマット済バッチを含む フォーマット済バッチを含む KO 형식화된 배치 포함 형식화된 배치 포함 PTB Incluir Lotes Formatados Incluir Lotes Formatados RU Включить форматированные пакеты Включить форматированные пакеты S Inkludera formaterade buntar Inkludera formaterade buntar TR Formatlı İşlem Gruplarını Dahil Et Formatlı İşlem Gruplarını Dahil Et US Include Formatted Batches Include Formatted Batches ZHS 包括格式化批 包括格式化批 13 110 :p_remittance_method LOV Oracle AR_SRS_REMITTANCE_METHOD Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='REMITTANCE_METHOD' and enabled_flag='Y' order by meaning AR طريقة التحويل النقدي طريقة التحويل النقدي D Zahlungseinzugsart Zahlungseinzugsart E Método de Remesa Método de Remesa F Méthode de remise Mode de remise en banque I Metodo rimessa Metodo di rimessa JA 送金方法 送金方法 KO 수탁 방법 수탁 방법 PTB Método de Remessa Método de Remessa RU Метод перевода Метод перевода S Remitteringsmetod Remitteringsmetod TR Tahsile Verme Yöntemi Tahsile Verme Yöntemi US Remittance Method Remittance Method ZHS 汇款方法 汇款方法 14 120 :p_remit_bank LOV Oracle AR_REMITTANCE_BANK_NAME Y select bb.bank_name id, bb.bank_name value, null description from ce_bank_branches_v bb where exists ( select cba.bank_branch_id from ce_bank_acct_uses ba,ce_bank_accounts cba where cba.bank_branch_id=bb.branch_party_id and ba.bank_account_id=cba.bank_account_id and cba.account_classification='INTERNAL') order by bb.bank_name AR البنك المستفيد البنك المستفيد D Eigene Bank Eigene Bank E Banco de Remesa Banco de remesa F Banque de remise Banque de remise I Banca di rimessa Banca di rimessa JA 送金銀行 送金銀行 KO 수탁 은행 수탁 은행 PTB Banco para Remessa Banco para Remessa RU Банк-корреспондент Банк-корреспондент S Överföringsbank Överföringsbank TR Tahsile Verilen Banka Tahsile Verilen Banka US Remittance Bank Remittance Bank ZHS 汇款银行 汇款银行 15 130 :p_remit_bank_branch LOV Oracle AR_REMITTANCE_BANK_BRANCH_NAME Y select bb.bank_branch_name id, bb.bank_branch_name value, null description from ce_bank_branches_v bb where exists (select 'exists' from ce_bank_acct_uses ba,ce_bank_accounts cba where cba.bank_branch_id=bb.branch_party_id and ba.bank_account_id=cba.bank_account_id and cba.account_classification='INTERNAL') order by bb.bank_branch_name AR فرع البنك المستفيد فرع البنك المستفيد D Zweigstelle Eigene Bank Zweigstelle Eigene Bank E Sucursal de Remesa Sucursal de remesa F Agence bancaire de remise Agence bancaire de remise I Filiale rimessa Filiale rimessa JA 送金銀行支店 送金銀行支店 KO 수탁 은행 지점 수탁 은행 지점 PTB Agência Bancária p/ Remessa Agência Bancária p/ Remessa RU Филиал банка-корреспондента Филиал банка-корреспондента S Överföringsbankkontor Överföringsbankkontor TR Tahsile Verilen Banka Şubesi Tahsile Verilen Banka Şubesi US Remittance Bank Branch Remittance Bank Branch ZHS 汇款分行 汇款分行 16 140 :p_remit_bank_account LOV Oracle AR_REMITTANCE_ACCOUNTS Y select bank_acct_use_id id, cba.bank_account_name value, null description from ce_bank_acct_uses uses,ce_bank_accounts cba,ce_bank_branches_v bb where cba.bank_account_id=uses.bank_account_id and bb.branch_party_id=cba.bank_branch_id and cba.account_classification='INTERNAL' order by bank_account_name AR حساب التحويل النقدي حساب التحويل النقدي D Konto Eigene Bank Konto Eigene Bank E Cuenta Bancaria de Remesa Cuenta bancaria de remesa F Compte bancaire de remise Compte bancaire de remise I Conto bancario di rimessa Conto bancario di rimessa JA 送金銀行口座 送金銀行口座 KO 수탁 은행 계정 수탁 은행 계정 PTB Conta Bancária para Remessa Conta Bancária para Remessa RU Счет в банке-корреспонденте Счет в банке-корреспонденте S Remitteringskonto Remitteringskonto TR Tahsile Verilen Banka Hesabı Tahsile Verilen Banka Hesabı US Remittance Bank Account Remittance Bank Account ZHS 汇款银行帐户 汇款银行帐户