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）限制的操作单元。 C6E085D46F3751A9E05362FB09050512Y select ARPT_SQL_FUNC_UTIL.get_lookup_meaning( 'ACCOUNT_STATUS', decode( cp_site.collector_id, null, cp_cust.account_status, cp_site.account_status ) ) status , substrb(party.party_name,1,50) Name , cust_acct.account_number Number_A , cust_acct.cust_account_id Customer_Id , nvl(cp_site.collector_id,cp_cust.collector_id) Collector_Id , col.name Collector , site_uses.site_use_id cp_site_use_id , site_uses.location location, AR_ARXASR_XMLP_PKG.c_status_summary_labelformula(ARPT_SQL_FUNC_UTIL.get_lookup_meaning ( 'ACCOUNT_STATUS' , decode ( cp_site.collector_id , null , cp_cust.account_status , cp_site.account_status ) )) c_status_summary_label, AR_ARXASR_XMLP_PKG.c_data_not_foundformula(ARPT_SQL_FUNC_UTIL.get_lookup_meaning ( 'ACCOUNT_STATUS' , decode ( cp_site.collector_id , null , cp_cust.account_status , cp_site.account_status ) )) c_data_not_found from ar_collectors col, hz_customer_profiles cp_cust, hz_customer_profiles cp_site, hz_cust_accounts cust_acct, hz_parties party, hz_cust_site_uses site_uses, hz_cust_acct_sites acct_site where acct_site.cust_account_id = cust_acct.cust_account_id and cust_acct.party_id = party.party_id and site_uses.cust_acct_site_id = acct_site.cust_acct_site_id and site_uses.site_use_code = 'BILL_TO' and cp_site.site_use_id(+) = site_uses.site_use_id and cp_cust.cust_account_id = cust_acct.cust_account_id and cp_cust.site_use_id is NULL and col.collector_id = nvl(cp_site.collector_id,cp_cust.collector_id) and exists ( select 'x' from &lp_ar_payment_schedules ps where ps.status = 'OP' and ps.customer_id = cust_acct.cust_account_id and ps.customer_site_use_id = site_uses.site_use_id ) &lp_start_account_status1 &lp_end_account_status1 &lp_customer_name_low &lp_customer_name_high &lp_customer_number_low &lp_customer_number_high &lp_collector_name_low &lp_collector_name_high UNION select ARPT_SQL_FUNC_UTIL.get_lookup_meaning('ACCOUNT_STATUS', cp_cust.account_status), substrb(party.party_name,1,50) , cust_acct.account_number, cust_acct.cust_account_id, col.collector_id, col.name, decode(:p_order_by,NULL,0,-88888), to_char(null), AR_ARXASR_XMLP_PKG.c_status_summary_labelformula(ARPT_SQL_FUNC_UTIL.get_lookup_meaning('ACCOUNT_STATUS',cp_cust.account_status)) c_status_summary_label, AR_ARXASR_XMLP_PKG.c_data_not_foundformula(ARPT_SQL_FUNC_UTIL.get_lookup_meaning('ACCOUNT_STATUS',cp_cust.account_status)) c_data_not_found from ar_collectors col, hz_customer_profiles cp_cust, hz_cust_accounts cust_acct, hz_parties party where cp_cust.cust_account_id = cust_acct.cust_account_id and cust_acct.party_id = party.party_id and cp_cust.site_use_id is null and cp_cust.collector_id = col.collector_id and exists ( select 'x' from &lp_ar_payment_schedules ps where ps.status = 'OP' and ps.customer_id = cust_acct.cust_account_id and ps.customer_site_use_id is null ) &lp_start_account_status2 &lp_end_account_status2 &lp_customer_name_low &lp_customer_name_high &lp_customer_number_low &lp_customer_number_high &lp_collector_name_low &lp_collector_name_high &lp_order_by AR ARXASR_XML AR AR تقرير موقف الحساب (بتنسيق XML) Imported from BI Publisher Description: تقرير موقف الحساب Application: المقبوضات Source: تقرير موقف الحساب (بتنسيق XML) Short Name: ARXASR_XML DB package: AR_ARXASR_XMLP_PKG D AR Kunden - Kontenstatus Imported from BI Publisher Description: Auswertung "Kunden - Kontenstatus" Application: Debitoren Source: Kunden - Kontenstatus (XML) Short Name: ARXASR_XML DB package: AR_ARXASR_XMLP_PKG E AR Estado de Cuentas Imported from BI Publisher Description: Informe de estado de cuentas Application: Receivables Source: Estado de Cuentas (XML) Short Name: ARXASR_XML DB package: AR_ARXASR_XMLP_PKG F AR Etat Statut des comptes clients Imported from BI Publisher Description: Etat du statut des comptes clients Application: Receivables Source: Etat Statut des comptes clients (XML) Short Name: ARXASR_XML DB package: AR_ARXASR_XMLP_PKG I AR Rapporto Stato conto Imported from BI Publisher Description: Rapporto Stato conto Application: Receivables Source: Rapporto Stato conto (XML) Short Name: ARXASR_XML DB package: AR_ARXASR_XMLP_PKG JA AR 勘定ステータス・レポート Imported from BI Publisher Description: 勘定ステータス・レポート Application: Receivables Source: 勘定ステータス・レポート(XML) Short Name: ARXASR_XML DB package: AR_ARXASR_XMLP_PKG KO AR 계정 상태 보고서 Imported from BI Publisher Description: 계정 상태 보고서 Application: Receivables Source: 계정 상태 보고서(XML) Short Name: ARXASR_XML DB package: AR_ARXASR_XMLP_PKG PTB AR Relatório Status de Conta Imported from BI Publisher Description: Relatório Status de Conta Application: Receivables Source: Relatório Status de Conta (XML) Short Name: ARXASR_XML DB package: AR_ARXASR_XMLP_PKG RU AR Отчет о статусе счета Imported from BI Publisher Description: Отчет о статусе счета Application: Дебиторы Source: Отчет о статусе счета (XML) Short Name: ARXASR_XML DB package: AR_ARXASR_XMLP_PKG S AR Kontostatus - rapport Imported from BI Publisher Description: Kontostatus - rapport Application: Receivables Source: Kontostatus - rapport (XML) Short Name: ARXASR_XML DB package: AR_ARXASR_XMLP_PKG TR AR Hesap Statüsü Raporu Imported from BI Publisher Description: Hesap Statüsü Raporu Application: Alacaklar Muhasebesi Source: Hesap Statüsü Raporu (XML) Short Name: ARXASR_XML DB package: AR_ARXASR_XMLP_PKG US AR Account Status Imported from BI Publisher Description: Account Status Report Application: Receivables Source: Account Status Report (XML) Short Name: ARXASR_XML DB package: AR_ARXASR_XMLP_PKG ZHS AR 帐户状态报表 Imported from BI Publisher Description: 帐户状态报表 Application: 应收帐款 Source: 帐户状态报表 (XML) Short Name: ARXASR_XML DB package: AR_ARXASR_XMLP_PKG BI Publisher &lp_ar_payment_schedules &lp_collector_name_high &lp_collector_name_low &lp_customer_name_high &lp_customer_name_low &lp_customer_number_high &lp_customer_number_low &lp_end_account_status1 &lp_end_account_status2 &lp_order_by &lp_start_account_status1 &lp_start_account_status2 :lp_ar_adjustments :lp_ar_adjustments_all :lp_ar_batches :lp_ar_batches_all :lp_ar_cash_receipt_history :lp_ar_cash_receipt_history_all :lp_ar_cash_receipts :lp_ar_cash_receipts_all :lp_ar_distributions :lp_ar_distributions_all :lp_ar_misc_cash_dists :lp_ar_misc_cash_dists_all :lp_ar_payment_schedules :lp_ar_payment_schedules_all :lp_ar_rate_adjustments :lp_ar_rate_adjustments_all :lp_ar_receivable_apps :lp_ar_receivable_apps_all :lp_ar_system_parameters :lp_ar_system_parameters_all :lp_collector_name_high :lp_collector_name_low :lp_customer_name_high :lp_customer_name_low :lp_customer_number_high :lp_customer_number_low :lp_end_account_status1 :lp_end_account_status2 :lp_order_by :lp_query_show_bill :lp_ra_batches :lp_ra_batches_all :lp_ra_cust_trx_gl_dist :lp_ra_cust_trx_gl_dist_all :lp_ra_customer_trx :lp_ra_customer_trx_all :lp_start_account_status1 :lp_start_account_status2 :lp_table_show_bill :lp_where_show_bill :operating_unit :p_ca_org_id :p_ca_set_of_books_id :p_collector_name_high :p_collector_name_low :p_conc_request_id :p_cons_profile_value :p_customer_name_high :p_customer_name_low :p_customer_number_high :p_customer_number_low :p_end_account_status :p_mrcsobtype :p_order_by :p_set_of_books_id :p_start_account_status :rp_company_name :rp_data_found :rp_report_name :rpd_report_summary 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 Id 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_ca_set_of_books_id LOV Oracle AR_S_SOB_CURRENCY Y select gsob.set_of_books_id id, gsob.currency_code value, gsob.name description from gl_sets_of_books gsob,ar_system_parameters sp where gsob.set_of_books_id=sp.set_of_books_id order by value,description select g.currency_code from gl_sets_of_books g, ar_system_parameters p where g.set_of_books_id = p.set_of_books_id Y AR عملة دفتر الأستاذ عملة دفتر الأستاذ D Buchwährung Buchwährung E Divisa de Libro Mayor Divisa de Libro Mayor F Devise comptable Devise comptable I Divisa libro contabile Divisa del libro contabile JA 元帳通貨 元帳通貨 KO 원장 통화 원장 통화 PTB Moeda do Razão Moeda do Razão RU Валюта книги Валюта книги S Huvudboksvaluta Huvudboksvaluta TR Defter Para Birimi Defter Para Birimi US Ledger Currency Ledger Currency ZHS 分类帐币种 分类帐币种 4 20 :p_order_by LOV Oracle AR_ARXASR_SORT_BY Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='SORT_BY_ARXASR' order by meaning select meaning from ar_lookups where lookup_type ='SORT_BY_ARXASR' and lookup_code='Customer' Y AR ترتيب حسب خيار الفرز حسب D Sortieren nach Sortieroption E Ordenar por Opción de ordenación F Tri par Option de tri I Ordina per Opzione Ordina per JA ソート・キー ソート・キー・オプション KO 정렬 기준 정렬 기준 옵션 PTB Ordenar Por Classificar Por Opção RU Сортировка Параметр сортировки S Ordna per Sorteringsalternativ TR Sıralama Bazı Seçeneğe Göre Sırala US Order By Sort By Option ZHS 排序依据 排序依据选项 5 30 :p_start_account_status LOV Oracle AR_ACCOUNT_STATUS Y select lookup_code id, lookup_code value, meaning description from ar_lookups where lookup_type='ACCOUNT_STATUS' order by meaning,lookup_code AR موقف الحساب من موقف الحساب من D Von Kontenstatus Von Kontenstatus E De Estado de la Cuenta De Estado de la Cuenta F Statut du compte - De Statut de compte - De I Stato conto (min) Valore minimo per lo stato del conto JA 勘定ステータス:自 勘定ステータス:自 KO 계정 상태 하한 계정 상태 하한 PTB Status da Conta (Inferior) Status da Conta (Inferior) RU Статус счета с Статус счета с S Från kontostatus Från kontostatus TR Hesap Statüsü Alt Değeri Hesap Statüsü Alt Değeri US Account Status Low Account Status Low ZHS 帐户状态下限 帐户状态下限 6 40 :p_end_account_status LOV Oracle AR_ACCOUNT_STATUS Y select lookup_code id, lookup_code value, meaning description from ar_lookups where lookup_type='ACCOUNT_STATUS' order by meaning,lookup_code AR موقف الحساب إلى موقف الحساب إلى D Bis Kontenstatus Bis Kontenstatus E A Estado de la Cuenta A Estado de la Cuenta F Statut du compte - A Statut de compte - A I Stato conto (max) Valore massimo per lo stato del conto JA 勘定ステータス:至 勘定ステータス:至 KO 계정 상태 상한 계정 상태 상한 PTB Status da Conta - Superior Status da Conta - Superior RU Статус счета по Статус счета по S Till kontostatus Till kontostatus TR Hesap Statüsü Üst Değeri Hesap Statüsü Üst Değeri US Account Status High Account Status High ZHS 帐户状态上限 帐户状态上限 7 50 :p_collector_name_low LOV Oracle AR_COLLECTOR_NAME Y select name id, name value, null description from ar_collectors where status!='I' order by name,collector_id AR محصل من محصل من D Von Debitorenbearbeiter Von Debitorenbearbeiter E De Cobrador De Cobrador F Agent de recouvrement - De Agent de recouvrement - De I Esattore (min) Esattore (min) JA 回収担当:自 回収担当:自 KO 수금사원 하한 수금사원 하한 PTB Cobrador - Inferior Cobrador - Inferior RU Сборщик с Сборщик с S Från inkasserare Från inkasserare TR Tahsildar Alt Değeri Tahsildar Alt Değeri US Collector Low Collector Low ZHS 收帐员下限 收帐员下限 8 60 :p_collector_name_high LOV Oracle AR_COLLECTOR_NAME Y select name id, name value, null description from ar_collectors where status!='I' order by name,collector_id AR محصل إلى محصل إلى D Bis Debitorenbearbeiter Bis Debitorenbearbeiter E A Cobrador A Cobrador F Agent de recouvrement - A Agent de recouvrement - A I Esattore (max) Esattore (max) JA 回収担当:至 回収担当:至 KO 수금사원 상한 수금사원 상한 PTB Cobrador - Superior Cobrador - Superior RU Сборщик по Сборщик по S Till inkasserare Till inkasserare TR Tahsildar Üst Değeri Tahsildar Üst Değeri US Collector High Collector High 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 客户编号上限 客户编号上限