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）限制的操作单元。 C6E085D46F3351A9E05362FB09050512Y SELECT decode(:p_sort_by, 'REMITT ACCOUNT', cba.bank_account_name, null) dcol_A, decode(:p_sort_by, 'MATURITY DATE', ps.due_date, 'REMITT ACCOUNT', ps.due_date, null) dcoldate_A, decode(:p_sort_by, 'CUSTOMER', SUBSTRB(PARTY.PARTY_NAME,1,50), 'PHONETIC',DECODE(PARTY.PARTY_TYPE, 'ORGANIZATION', PARTY.ORGANIZATION_NAME_PHONETIC,NULL), &P_SORT) dcolcust_A, cr.currency_code curr_code, SUBSTRB(PARTY.PARTY_NAME,1,50) cust_name, cust.ACCOUNT_NUMBER cust_num, site.location location, cba.bank_account_name acct_name, ps.due_date due_date, cr.receipt_number rcpt_num, cr.receipt_date rcpt_date, cr.amount amount FROM ar_cash_receipts cr, ar_cash_receipt_history crh, ar_payment_schedules ps, HZ_CUST_ACCOUNTS cust, HZ_PARTIES PARTY, HZ_CUST_site_uses site, ce_bank_acct_uses acct, ce_bank_accounts cba WHERE crh.cash_receipt_id = cr.cash_receipt_id AND crh.status = 'APPROVED' AND crh.current_record_flag = 'Y' AND ps.cash_receipt_id = cr.cash_receipt_id AND cust.CUST_ACCOUNT_ID = cr.pay_from_customer AND CUST.PARTY_ID = PARTY.PARTY_ID AND site.site_use_id (+) = cr.customer_site_use_id AND acct.bank_acct_use_id(+) = cr.remit_bank_acct_use_id AND acct.bank_account_id = cba.bank_account_id (+) &LP_CUST_NAME &LP_CUST_NUM &LP_REMIT_ACCOUNT &LP_MATURITY_DATE &LP_CURRENCY ORDER BY curr_code, dcol_A, dcoldate_A, dcolcust_A, cust_num, location, acct_name, due_date, rcpt_num, rcpt_date, amount, 10, 12 AR ARXAPRCF_XML AR AR إيصالات آلية في انتظار التأكيد (بتنسيق XML) Imported from BI Publisher Description: إيصالات آلية منتظرة التأكيد Application: المقبوضات Source: إيصالات آلية في انتظار التأكيد (بتنسيق XML) Short Name: ARXAPRCF_XML DB package: AR_ARXAPRCF_XMLP_PKG D AR Automatische Zahlungen - zur Bestätigung Imported from BI Publisher Description: Automatische Zahlungen - zur Bestätigung Application: Debitoren Source: Automatische Zahlungen - zur Bestätigung (XML) Short Name: ARXAPRCF_XML DB package: AR_ARXAPRCF_XMLP_PKG E AR Efectos Pendientes de Confirmación Imported from BI Publisher Description: Efectos pendientes de confirmación Application: Receivables Source: Efectos Pendientes de Confirmación (XML) Short Name: ARXAPRCF_XML DB package: AR_ARXAPRCF_XMLP_PKG F AR Règlements automatiques en attente d'acceptation Imported from BI Publisher Description: Règlements automatiques en attente d'acceptation Application: Receivables Source: Règlements automatiques en attente d'acceptation (XML) Short Name: ARXAPRCF_XML DB package: AR_ARXAPRCF_XMLP_PKG I AR Incassi automatici in attesa di conferma Imported from BI Publisher Description: Incassi automatici in attesa di conferma Application: Receivables Source: Incassi automatici in attesa di conferma (XML) Short Name: ARXAPRCF_XML DB package: AR_ARXAPRCF_XMLP_PKG JA AR 確認待ち自動入金 Imported from BI Publisher Description: 確認待ち自動入金 Application: Receivables Source: 確認待ち自動入金(XML) Short Name: ARXAPRCF_XML DB package: AR_ARXAPRCF_XMLP_PKG KO AR 확인 대기 중인 자동 수금 Imported from BI Publisher Description: 확인 대기 중인 자동 수금 Application: Receivables Source: 확인 대기 중인 자동 수금(XML) Short Name: ARXAPRCF_XML DB package: AR_ARXAPRCF_XMLP_PKG PTB AR Relatório Recebimentos Automáticos Aguardando Confirmação Imported from BI Publisher Description: Recebimentos Automáticos Aguardando Confirmação Application: Receivables Source: Relatório Recebimentos Automáticos Aguardando Confirmação (XML) Short Name: ARXAPRCF_XML DB package: AR_ARXAPRCF_XMLP_PKG RU AR Автопоступления, ожидающие подтверждения Imported from BI Publisher Description: Автопоступления, ожидающие подтверждения Application: Дебиторы Source: Автопоступления, ожидающие подтверждения (XML) Short Name: ARXAPRCF_XML DB package: AR_ARXAPRCF_XMLP_PKG S AR Automatiska inbetalningar som väntar på bekräftelse Imported from BI Publisher Description: Automatiska inbetalningar som väntar på bekräftelse Application: Receivables Source: Automatiska inbetalningar som väntar på bekräftelse (XML) Short Name: ARXAPRCF_XML DB package: AR_ARXAPRCF_XMLP_PKG TR AR Onay Bekleyen Otomatik Alınan Ödemeler Raporu Imported from BI Publisher Description: Teyit Bekleyen Otomatik Ödemeler Application: Alacaklar Muhasebesi Source: Onay Bekleyen Otomatik Alınan Ödemeler Raporu (XML) Short Name: ARXAPRCF_XML DB package: AR_ARXAPRCF_XMLP_PKG US AR Automatic Receipts Awaiting Confirmation Imported from BI Publisher Description: Automatic Receipts Awaiting Confirmation Application: Receivables Source: Automatic Receipts Awaiting Confirmation (XML) Short Name: ARXAPRCF_XML DB package: AR_ARXAPRCF_XMLP_PKG ZHS AR 等待确认的自动收款 Imported from BI Publisher Description: 等待确认的自动收款 Application: 应收帐款 Source: 等待确认的自动收款 (XML) Short Name: ARXAPRCF_XML DB package: AR_ARXAPRCF_XMLP_PKG BI Publisher &lp_currency &lp_cust_name &lp_cust_num &lp_maturity_date &lp_remit_account &p_sort :cp_maturity_date_high :cp_maturity_date_low :lp_currency :lp_cust_name :lp_cust_num :lp_maturity_date :lp_remit_account :operating_unit :p_conc_request_id :p_currency :p_cust_name_high :p_cust_name_low :p_cust_num_high :p_cust_num_low :p_maturity_date_high :p_maturity_date_low :p_remit_account :p_set_of_books_id :p_sort :p_sort_by :rp_company_name :rp_data_found :rp_report_name :rp_sub_title :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 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_ARXAPRCF_SORT_BY Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='SORT_BY_ARXAPRCF' 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_cust_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 Kunde Von Kundenname E De Nombre del Cliente De nombre del 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 CustomerName Low Customer Name Low ZHS 客户名称下限 客户名称下限 5 30 :p_cust_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 del Cliente A nombre del 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 客户名称上限 客户名称上限 6 40 :p_cust_num_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 客户编号下限 客户编号下限 7 50 :p_cust_num_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 客户编号上限 客户编号上限 8 60 :p_remit_account 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 Konto Zahlungseinzug Bankkonto E Cuenta de la Remesa Nombre de Cuenta Bancaria de la Remesa F Compte de remise Intitulé de compte de remise en banque I Conto di rimessa Nome conto bancario di rimessa JA 送金勘定 送金銀行口座名 KO 수탁 계정 수탁 은행 계정명 PTB Conta para Remessa Nome da Conta Bancária para Remessa RU Счет перевода Имя счета в банке-корреспонденте S Remitteringskonto Namn på remitteringskonto TR Tahsildeki Çekler Hesabı Tahsile Verilen Banka Hesap Adı US Remittance Account Remittance Bank Account Name ZHS 汇款帐户 汇款银行帐户名 9 70 :p_maturity_date_low Date AR تاريخ استحقاق من تاريخ استحقاق من D Von Fälligkeitsdatum Von Fälligkeitsdatum E De Fecha de Vencimiento De Fecha de Vencimiento F Date d'exigibilité - Du Date d'exigibilité - Du I Data scadenza (min) Data scadenza (min) JA 満期日:自 満期日:自 KO 만기 일자 하한 만기 일자 하한 PTB Data de Vencimento - Inferior Data de Vencimento - Inferior RU Дата погашения с Дата погашения с S Från förfallodatum Från förfallodatum TR Vade Tarihi Alt Değeri Vade Tarihi Alt Değeri US Maturity Date Low Maturity Date Low ZHS 到期日下限 到期日下限 10 80 :p_maturity_date_high Date AR تاريخ استحقاق إلى تاريخ استحقاق إلى D Bis Fälligkeitsdatum Bis Fälligkeitsdatum E A Fecha de Vencimiento A Fecha de Vencimiento F Date d'exigibilité - Au Date d'exigibilité - Au I Data scadenza (max) Data scadenza (max) JA 満期日:至 満期日:至 KO 만기 일자 상한 만기 일자 상한 PTB Data de Vencimento - Superior Data de Vencimento - Superior RU Дата погашения по Дата погашения по S Till förfallodatum Till förfallodatum TR Vade Tarihi Üst Değeri Vade Tarihi Üst Değeri US Maturity Date High Maturity Date High ZHS 到期日上限 到期日上限 11 90 :p_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 Währung Währung E Divisa Divisa F Devise Devise I Divisa Divisa JA 通貨 通貨 KO 통화 통화 PTB Moeda Moeda RU Валюта Валюта S Valuta Valuta TR Para Birimi Para Birimi US Currency Currency ZHS 币种 币种