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）限制的操作单元。 C6E085D46F4151A9E05362FB09050512Y select cr.currency_code receipt_currency1, bb.bank_name remit_bank_name1, decode(:RP_SORT_BY_PHONETICS, 'Y', bb.bank_name_alt, bb.bank_name) remit_bank_name1_sort, cba.bank_account_num remit_bank_account1, SUBSTRB(PARTY.PARTY_NAME,1,50) customer_name1, decode(:RP_SORT_BY_PHONETICS, 'Y', PARTY.ORGANIZATION_NAME_PHONETIC, SUBSTRB(PARTY.PARTY_NAME,1,50)) customer_name1_sort, site.location customer_site1, cr.issue_date issue_date1, ps.due_date maturity_date1, cr.receipt_number note_number1, cr.amount amount1, ecr.receipt_number exchanged_note_number1, lk.meaning status1 from ar_cash_receipts cr, ar_cash_receipts ecr, ar_receipt_methods rm, ar_receipt_classes rc, ar_cash_receipt_history crh, ar_receivable_applications ra, ar_payment_schedules ps, ar_payment_schedules eps, ce_bank_accounts cba, ce_bank_acct_uses ba, ce_bank_branches_v bb, HZ_CUST_ACCOUNTS cust, HZ_PARTIES PARTY, HZ_CUST_site_uses site, ar_lookups lk where :P_ORDER_BY='REMITTANCE_BANK' and cr.receipt_method_id = rm.receipt_method_id and rm.receipt_class_id = rc.receipt_class_id and rc.notes_receivable = 'Y' and cr.reversal_date is NULL &LP_CURRENCY_CODE and cr.cash_receipt_id = ps.cash_receipt_id (+) &LP_START_DATE &LP_END_DATE and cr.cash_receipt_id = ra.cash_receipt_id and ra.applied_payment_schedule_id = eps.payment_schedule_id (+) and (ra.receivable_application_id,cr.cash_receipt_id) in (select max(ra2.receivable_application_id), cr2.cash_receipt_id from ar_cash_receipts cr2, ar_receivable_applications ra2, ar_payment_schedules ps2 where cr2.cash_receipt_id = ra2.cash_receipt_id and ra2.applied_payment_schedule_id = ps2.payment_schedule_id (+) and (nvl(ps2.reversed_cash_receipt_id,0),cr2.cash_receipt_id) in (select max(nvl(ps3.reversed_cash_receipt_id,0)), cr3.cash_receipt_id from ar_cash_receipts cr3, ar_receivable_applications ra3, ar_payment_schedules ps3 where cr3.cash_receipt_id = ra3.cash_receipt_id and ra3.applied_payment_schedule_id = ps3.payment_schedule_id (+) group by cr3.cash_receipt_id) group by cr2.cash_receipt_id) and eps.reversed_cash_receipt_id = ecr.cash_receipt_id (+) and cr.cash_receipt_id = crh.cash_receipt_id and crh.current_record_flag = 'Y' and crh.status in ('CONFIRMED', 'REMITTED', 'CLEARED', 'RISK_ELIMINATED') and lk.lookup_type = decode(crh.status, 'CONFIRMED', 'AR_NOTE_STATUS', 'REMITTED', 'RECEIPT_CREATION_STATUS', 'CLEARED', decode(crh.factor_flag, 'N', 'AR_NOTE_STATUS', 'RECEIPT_CREATION_STATUS'), 'RISK_ELIMINATED', 'AR_NOTE_STATUS') and lk.lookup_code = decode(crh.status, 'CONFIRMED', decode(eps.reversed_cash_receipt_id, NULL, 'OPEN', 'EXCHANGE'), 'REMITTED', 'REMITTED', 'CLEARED', decode(crh.factor_flag, 'N', 'MATURED', 'REMITTED'), 'RISK_ELIMINATED', 'MATURED') &LP_NOTE_STATUS &LP_BANK_ACCOUNT_ID and cr.remit_bank_acct_use_id = ba.bank_acct_use_id (+) and ba.bank_account_id = cba.bank_account_id (+) and cba.bank_branch_id = bb.branch_party_id (+) &LP_REMITTANCE_BANK and cr.pay_from_customer = cust.CUST_ACCOUNT_ID (+) AND CUST.PARTY_ID = PARTY.PARTY_ID(+) &LP_CUSTOMER_NAME_LOW &LP_CUSTOMER_NAME_HIGH &LP_CUSTOMER_NUMBER_LOW &LP_CUSTOMER_NUMBER_HIGH and cr.customer_site_use_id = site.site_use_id (+) order by receipt_currency1,remit_bank_name1_sort,remit_bank_account1,maturity_date1,decode(:RP_SORT_BY_PHONETICS, 'Y', PARTY.ORGANIZATION_NAME_PHONETIC, PARTY.PARTY_NAME), site.location, cr.receipt_number AR ARXNROPN_XML AR AR تقرير أوراق القبض (بتنسيق XML) Imported from BI Publisher Description: تقرير أوراق القبض Application: المقبوضات Source: تقرير أوراق القبض (بتنسيق XML) Short Name: ARXNROPN_XML DB package: AR_ARXNROPN_XMLP_PKG D AR Wechselforderungen Imported from BI Publisher Description: Auswertung "Wechselforderungen" Application: Debitoren Source: Wechselforderungen (XML) Short Name: ARXNROPN_XML DB package: AR_ARXNROPN_XMLP_PKG E AR Documentos Posdatados Imported from BI Publisher Description: Informe de documentos posdatados Application: Receivables Source: Documentos Posdatados (XML) Short Name: ARXNROPN_XML DB package: AR_ARXNROPN_XMLP_PKG F AR Etat Effets à recevoir Imported from BI Publisher Description: Etat des effets à recevoir Application: Receivables Source: Etat Effets à recevoir (XML) Short Name: ARXNROPN_XML DB package: AR_ARXNROPN_XMLP_PKG I AR Rapporto Note conto clienti Imported from BI Publisher Description: Rapporto Note conto clienti Application: Receivables Source: Rapporto Note conto clienti (XML) Short Name: ARXNROPN_XML DB package: AR_ARXNROPN_XMLP_PKG JA AR 受取手形レポート Imported from BI Publisher Description: 受取手形レポート Application: Receivables Source: 受取手形レポート(XML) Short Name: ARXNROPN_XML DB package: AR_ARXNROPN_XMLP_PKG KO AR 받을 어음 보고서 Imported from BI Publisher Description: 받을 어음 보고서 Application: Receivables Source: 받을 어음 보고서(XML) Short Name: ARXNROPN_XML DB package: AR_ARXNROPN_XMLP_PKG PTB AR Relatório de Notas a Receber Imported from BI Publisher Description: Relatório de Notas a Receber Application: Receivables Source: Relatório de Notas a Receber (XML) Short Name: ARXNROPN_XML DB package: AR_ARXNROPN_XMLP_PKG RU AR Отчет о векселях к получению Imported from BI Publisher Description: Отчет о векселях к получению Application: Дебиторы Source: Отчет о векселях к получению (XML) Short Name: ARXNROPN_XML DB package: AR_ARXNROPN_XMLP_PKG S AR Växelfordran - rapport Imported from BI Publisher Description: Växelfordran - rapport Application: Receivables Source: Växelfordran - rapport (XML) Short Name: ARXNROPN_XML DB package: AR_ARXNROPN_XMLP_PKG TR AR Alacak Senetleri Raporu Imported from BI Publisher Description: Alacak Senetleri Raporu Application: Alacaklar Muhasebesi Source: Alacak Senetleri Raporu (XML) Short Name: ARXNROPN_XML DB package: AR_ARXNROPN_XMLP_PKG US AR Notes Receivable Imported from BI Publisher Description: Notes Receivable Report Application: Receivables Source: Notes Receivable Report (XML) Short Name: ARXNROPN_XML DB package: AR_ARXNROPN_XMLP_PKG ZHS AR 应收票据报表 Imported from BI Publisher Description: 应收票据报表 Application: 应收帐款 Source: 应收票据报表 (XML) Short Name: ARXNROPN_XML DB package: AR_ARXNROPN_XMLP_PKG BI Publisher &lp_bank_account_id &lp_currency_code &lp_customer_name_high &lp_customer_name_low &lp_customer_number_high &lp_customer_number_low &lp_end_date &lp_note_status &lp_remittance_bank &lp_start_date :hp_bank_account :hp_note_status :hp_order_by :lp_bank_account_id :lp_currency_code :lp_customer_name_high :lp_customer_name_low :lp_customer_number_high :lp_customer_number_low :lp_end_date :lp_note_status :lp_remittance_bank :lp_start_date :operating_unit :p_bank_account_id :p_conc_request_id :p_currency_code :p_customer_name_high :p_customer_name_low :p_customer_number_high :p_customer_number_low :p_end_date :p_end_date1 :p_note_status :p_order_by :p_remittance_bank :p_set_of_books_id :p_start_date :p_start_date1 :rp_data_found :rp_functional_curr :rp_functional_curr_prec :rp_set_of_books_name :rp_sort_by_phonetics 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 Buch Buch E Libro Mayor Libro mayor F Livre Livre I Libro contabile Libro contabile JA 元帳 元帳 KO 원장 원장 PTB Razão Razão RU Книга Книга S Huvudbok Huvudbok TR Defter Defter US Ledger Ledger 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_currency_code 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 Währung Währung E Código de Divisa Código de Divisa F Code devise Code devise I Codice divisa Codice della divisa JA 通貨コード 通貨コード KO 통화 코드 통화 코드 PTB Código da Moeda Código da Moeda RU Код валюты Код валюты S Valutakod Valutakod TR Para Birimi Kodu Para Birimi Kodu US Currency Code Currency Code ZHS 币种代码 币种代码 4 20 :p_order_by LOV Oracle AR_ARXNROPN_ORDER_BY Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='ARXNROPN_ORDER_BY' order by value,description select meaning from ar_lookups where lookup_type = 'ARXNROPN_ORDER_BY' and lookup_code = 'REMITTANCE_BANK' Y AR خيار الفرز خيار الفرز D Sortieroption Sortieroption E Opción de Ordenación Opción de Ordenación F Option de tri Option de tri I Opzione di ordinamento Opzione di ordinamento JA ソート・オプション ソート・オプション KO 정렬 옵션 정렬 옵션 PTB Opção de Classificação Opção de Classificação RU Параметр сортировки Параметр сортировки S Sorteringsalternativ Sorteringsalternativ TR Sıralama Seçeneği Sıralama Seçeneği US Sort Option Sort Option ZHS 排序选项 排序选项 5 30 :p_start_date Date AR تاريخ بداية الاستحقاق تاريخ بداية الاستحقاق D Von Fälligkeitsdatum Von Fälligkeitsdatum E De Fecha de Vencimiento De Fecha de Vencimiento F Date début exigibilité Date début exigibilité I Data scadenza iniziale Data di scadenza iniziale JA 開始満期日 開始満期日 KO 만기 시작 일자 만기 시작 일자 PTB Data de Vencimento Inicial Data de Vencimento Inicial RU Дата погашения с Дата погашения с S Från förfallodatum Från förfallodatum TR Başlangıç Vade Tarihi Başlangıç Vade Tarihi US Start Maturity Date Start Maturity Date ZHS 起始到期日 起始到期日 6 40 :p_end_date Date AR تاريخ نهاية الاستحقاق تاريخ نهاية الاستحقاق D Bis Fälligkeitsdatum Bis Fälligkeitsdatum E A Fecha de Vencimiento A Fecha de Vencimiento F Date fin exigibilité Date fin exigibilité I Data scadenza finale Data di scadenza finale JA 満期日:至 満期日:至 KO 만기 종료 일자 만기 종료 일자 PTB Data de Vencimento Final Data de Vencimento Final RU Дата погашения по Дата погашения по S Till förfallodatum Till förfallodatum TR Bitiş Vade Tarihi Bitiş Vade Tarihi US End Maturity Date End Maturity Date ZHS 终止到期日 终止到期日 7 50 :p_remittance_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 汇款银行 汇款银行 8 60 :p_bank_account_id 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 Bankkonto Konto Eigene Bank E Cuenta Bancaria de la Remesa Cuenta bancaria de la 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 de Remessa Conta Bancária para Remessa RU Счет в банке-корреспонденте Счет в банке-корреспонденте S Remitteringskonto Remitteringskonto TR Tahsile Verilen Banka Hesabı Tahsile Verilen Banka Hesabı US Remittance Bank Accoun Remittance Bank Account ZHS 汇款银行帐户 汇款银行帐户 9 70 :p_customer_name_low LOV Oracle AR_CUSTOMER_NAME Y Y select party.party_name id, party.party_name value, null description from hz_cust_accounts cu,hz_parties party where cu.party_id=party.party_id and cu.cust_account_id in (select cu2.cust_account_id from hz_cust_accounts cu2,hz_parties party2 where cu2.party_id=party2.party_id and party2.party_name= party.party_name) order by party.party_name AR اسم العميل من اسم العميل من D Von Kundenname Von Kundenname E De Nombre de Cliente De nombre de cliente F Nom de client - De Nom de client - De I Nome cliente (min) Nome cliente (min) JA 顧客名:自 顧客名:自 KO 고객명 하한 고객명 하한 PTB Nome do Cliente - Inferior Nome do Cliente - Inferior RU Имя заказчика с Имя заказчика с S Från kundnamn Från kundnamn TR Müşteri Adı Alt Değeri Müşteri Adı Alt Değeri US Customer Name Low Customer Name Low ZHS 客户名称下限 客户名称下限 10 80 :p_customer_name_high LOV Oracle AR_CUSTOMER_NAME Y Y select party.party_name id, party.party_name value, null description from hz_cust_accounts cu,hz_parties party where cu.party_id=party.party_id and cu.cust_account_id in (select cu2.cust_account_id from hz_cust_accounts cu2,hz_parties party2 where cu2.party_id=party2.party_id and party2.party_name= party.party_name) order by party.party_name AR اسم العميل إلى اسم العميل إلى D Bis Kundenname Bis Kundenname E A Nombre de Cliente A nombre de cliente F Nom de client - A Nom de client - A I Nome cliente (max) Nome cliente (max) JA 顧客名:至 顧客名:至 KO 고객명 상한 고객명 상한 PTB Nome do Cliente - Superior Nome do Cliente - Superior RU Имя заказчика по Имя заказчика по S Till kundnamn Till kundnamn TR Müşteri Adı Üst Değeri Müşteri Adı Üst Değeri US Customer Name High Customer Name High ZHS 客户名称上限 客户名称上限 11 90 :p_customer_number_low LOV Oracle AR_CUSTOMER_NUMBER Y Y select cust.account_number id, cust.account_number value, null description from hz_cust_accounts cust,hz_parties party where cust.party_id=party.party_id order by cust.account_number AR رقم العميل من رقم العميل من D Von Kundennummer Von Kundennummer E De Número de Cliente De número de cliente F Numéro de client - De Numéro de client - De I Numero cliente (min) Numero cliente (min) JA 顧客番号:自 顧客番号:自 KO 고객 번호 하한 고객 번호 하한 PTB Número do Cliente - Inferior Número do Cliente - Inferior RU Номер заказчика с Номер заказчика с S Från kundnummer Från kundnummer TR Müşteri Numarası Alt Değeri Müşteri Numarası Alt Değeri US Customer Number Low Customer Number Low ZHS 客户编号下限 客户编号下限 12 100 :p_customer_number_high LOV Oracle AR_CUSTOMER_NUMBER Y Y select cust.account_number id, cust.account_number value, null description from hz_cust_accounts cust,hz_parties party where cust.party_id=party.party_id order by cust.account_number AR رقم العميل إلى رقم العميل إلى D Bis Kundennummer Bis Kundennummer E A Número de Cliente A número de cliente F Numéro de client - A Numéro de client - A I Numero cliente (max) Numero cliente (max) JA 顧客番号:至 顧客番号:至 KO 고객 번호 상한 고객 번호 상한 PTB Número do Cliente - Superior Número do Cliente - Superior RU Номер заказчика по Номер заказчика по S Till kundnummer Till kundnummer TR Müşteri Numarası Üst Değeri Müşteri Numarası Üst Değeri US Customer Number High Customer Number High ZHS 客户编号上限 客户编号上限 13 110 :p_note_status LOV Oracle AR_ARXNROPN_STATUS Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type in ('RECEIPT_CREATION_STATUS', 'AR_NOTE_STATUS') and lookup_code in ('REMITTED','OPEN','EXCHANGE','MATURED') order by value,description AR موقف أوراق القبض موقف أوراق القبض D Status Wechselforderungen Status Wechselforderungen E Estado de Documentos Posdatados Estado de Documentos Posdatados F Statut effet à recevoir Statut effet à recevoir I Stato note conto clienti Stato delle note del conto clienti JA 受取手形ステータス 受取手形ステータス KO 받을 어음 상태 받을 어음 상태 PTB Informa o Status das Contas a Receber Informa o Status das Contas a Receber RU Статус векселей к получению Статус векселей к получению S Status för växelfordran Status för växelfordran TR Alacak Senetleri Statüsü Alacak Senetleri Statüsü US Notes Receivable Status Notes Receivable Status ZHS 应收票据状态 应收票据状态