ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F4951A9E05362FB09050512Y select substrb(party.party_name,1,50) Customer_Name , cust.account_number Customer_Number , substrb(look.meaning, 1, 8) Site_Use , acct_site.cust_acct_site_id Address_Id, substrb(loc.address1,1,30) Address_Line_1, substrb(loc.city,1,15) City , substrb(loc.state,1,2) State , substrb(loc.postal_code,1,10) Zip_Code , cust.status Cust_Status, AR_RAXCUS_XMLP_PKG.c_data_not_foundformula(substrb ( party.party_name , 1 , 50 )) C_DATA_NOT_FOUND from ar_lookups look, ar_lookups look_status, hz_cust_accounts cust, hz_parties party, hz_cust_site_uses site_uses, hz_cust_acct_sites acct_site, hz_party_sites party_site, hz_locations loc where cust.cust_account_id = acct_site.cust_account_id(+) and cust.party_id= party.party_id and acct_site.party_site_id = party_site.party_site_id(+) and loc.location_id(+) = party_site.location_id and acct_site.cust_acct_site_id = site_uses.cust_acct_site_id(+) and look.lookup_type(+) = 'SITE_USE_CODE' and look.lookup_code(+) = site_uses.site_use_code and look_status.lookup_type(+) = 'CODE_STATUS' and look_status.lookup_code(+) = nvl(cust.status, 'A') and substrb(party.party_name,1,50) between :pr_customer_name_low and :pr_customer_name_high and cust.account_number between :pr_customer_number_low and :pr_customer_number_high &lp_city_low &lp_city_high &lp_state_low &lp_state_high &lp_zip_low &lp_zip_high &lp_site_low &lp_site_high and nvl(look_status.lookup_code, :p_status_low) between :pr_status_low and :pr_status_high order by decode(upper(:p_order_by), 'CUSTOMER', party.party_name, 'PHONETIC',party.organization_name_phonetic, 'CUSTOMER NUMBER', cust.account_number, 'SITE USE', look.meaning, 'CITY', loc.city, 'STATE',loc.state, 'ZIP CODE',loc.postal_code, 'STATUS',cust.status), party.party_name, loc.state, look.meaning, cust.account_number, loc.address1, loc.city, loc.postal_code, cust.status AR RAXCUS_XML AR AR قائمة العملاء - إجمالي (بتنسيق XML) Imported from BI Publisher Description: قائمة العملاء - إجمالي Application: المقبوضات Source: قائمة العملاء - إجمالي (بتنسيق XML) Short Name: RAXCUS_XML DB package: AR_RAXCUS_XMLP_PKG D AR Kundenliste - Übersicht Imported from BI Publisher Description: Kundenliste - Übersicht Application: Debitoren Source: Kundenliste - Übersicht (XML) Short Name: RAXCUS_XML DB package: AR_RAXCUS_XMLP_PKG E AR Listado de Clientes - Resumen Imported from BI Publisher Description: Listado de clientes - resumen Application: Receivables Source: Listado de Clientes - Resumen (XML) Short Name: RAXCUS_XML DB package: AR_RAXCUS_XMLP_PKG F AR Liste récapitulative des clients Imported from BI Publisher Application: Receivables Source: Liste récapitulative des clients (XML) Short Name: RAXCUS_XML DB package: AR_RAXCUS_XMLP_PKG I AR Elenco clienti - Sintetico Imported from BI Publisher Description: Elenco clienti - Sintetico Application: Receivables Source: Elenco clienti - Sintetico (XML) Short Name: RAXCUS_XML DB package: AR_RAXCUS_XMLP_PKG JA AR 顧客リスト - 要約 Imported from BI Publisher Description: 顧客リスト - 要約 Application: Receivables Source: 顧客リスト - 要約(XML) Short Name: RAXCUS_XML DB package: AR_RAXCUS_XMLP_PKG KO AR 고객 목록 - 요약 Imported from BI Publisher Description: 고객 목록 - 요약 Application: Receivables Source: 고객 목록 - 요약(XML) Short Name: RAXCUS_XML DB package: AR_RAXCUS_XMLP_PKG PTB AR Lista de Clientes - Sumariada Imported from BI Publisher Description: Lista de Clientes - Sumariada Application: Receivables Source: Lista de Clientes - Sumariada (XML) Short Name: RAXCUS_XML DB package: AR_RAXCUS_XMLP_PKG RU AR Сводный список заказчиков Imported from BI Publisher Description: Сводный список заказчиков Application: Дебиторы Source: Сводный список заказчиков (XML) Short Name: RAXCUS_XML DB package: AR_RAXCUS_XMLP_PKG S AR Kundlista - översikt Imported from BI Publisher Description: Kundlista - översikt Application: Receivables Source: Kundlista - översikt (XML) Short Name: RAXCUS_XML DB package: AR_RAXCUS_XMLP_PKG TR AR Müşteri Listesi - Özet Imported from BI Publisher Description: Müşteri Listesi - Özet Application: Alacaklar Muhasebesi Source: Müşteri Listesi - Özet (XML) Short Name: RAXCUS_XML DB package: AR_RAXCUS_XMLP_PKG US AR Customer Listing - Summary Imported from BI Publisher Description: Customer Listing - Summary Application: Receivables Source: Customer Listing - Summary (XML) Short Name: RAXCUS_XML DB package: AR_RAXCUS_XMLP_PKG ZHS AR 客户列表 - 汇总 Imported from BI Publisher Description: 客户列表 - 汇总 Application: 应收帐款 Source: 客户列表 - 汇总 (XML) Short Name: RAXCUS_XML DB package: AR_RAXCUS_XMLP_PKG BI Publisher &lp_city_high &lp_city_low &lp_site_high &lp_site_low &lp_state_high &lp_state_low &lp_zip_high &lp_zip_low :lp_city_high :lp_city_low :lp_site_high :lp_site_low :lp_state_high :lp_state_low :lp_zip_high :lp_zip_low :p_city_high :p_city_low :p_conc_request_id :p_customer_name_high :p_customer_name_low :p_customer_number_high :p_customer_number_low :p_order_by :p_site_high :p_site_low :p_state_high :p_state_low :p_status_high :p_status_low :p_zip_high :p_zip_low :pr_customer_name_high :pr_customer_name_low :pr_customer_number_high :pr_customer_number_low :pr_status_high :pr_status_low :rp_company_name :rp_data_found :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 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 10 :p_order_by LOV Oracle AR_RAXCUS_SORT_BY Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='SORT_BY_RAXCUS' order by meaning Y AR ترتيب حسب يدل على ترتيب الاستعلام D Sortieren nach Sortieroption für die Abfrage E Ordenar por Indica el orden de consulta F Tri par Indique l'ordre de tri de la recherche I Ordina per Indica l'ordinamento della query JA ソート・キー 受注照会の表示 KO 정렬 기준 질의 순서 표시 PTB Ordenar Por Indica ordenação de consulta RU Сортировка Упорядочение запроса S Ordna per Anger att fråga beställs TR Sıralama Bazı Sorgulama sırasını gösterir US Order By Indicates ordering of query ZHS 排序依据 表示查询顺序 3 20 :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 Rango inferior de nombre de cliente F Nom de client - De Début de la fourchette des noms de client I Nome cliente (min) Intervallo minimo per nome cliente JA 顧客名:自 顧客名:自 KO 고객명 하한 고객명에 대한 하한 범위 PTB Nome do Cliente - Inferior Faixa Inferior para Nomes de Cliente RU Имя заказчика с Имя заказчика с S Från kundnamn Nedre intervallgräns för kundnamn TR Müşteri Adı Alt Değeri Müşteri Adı Alt Değeri US Customer Name Low Low Range for Customer Name ZHS 客户名称下限 客户名称下限 4 30 :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 Rango superior de nombre de cliente F Nom de client - A Fin de la fourchette des noms de client I Nome cliente (max) Intervallo massimo per nome cliente JA 顧客名:至 顧客名:至 KO 고객명 상한 고객명에 대한 상한 범위 PTB Nome do Cliente - Superior Faixa Superior para Nomes de Cliente RU Имя заказчика по Имя заказчика по S Till kundnamn Övre intervallsgräns för kundnamn TR Müşteri Adı Üst Değeri Müşteri Adı Üst Değeri US Customer Name High High Range for Customer Name ZHS 客户名称上限 客户名称的上限 5 40 :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 Rango inferior de número de cliente F Numéro de client - De Début de la fourchette de numéros de client I Numero cliente (min) Intervallo minimo per numero cliente JA 顧客番号:自 顧客番号:自 KO 고객 번호 하한 고객 번호에 대한 하한 범위 PTB Número do Cliente - Inferior Faixa Inferior para Números do Cliente RU Номер заказчика с Номер заказчика с S Från kundnummer Nedre intervallgräns för kundnummer TR Müşteri Numarası Alt Değeri Müşteri Numarası Alt Değeri US Customer Number Low Low Range for Customer Number ZHS 客户编号下限 客户编号下限 6 50 :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 Rango superior de número de cliente F Numéro de client - A Fin de la fourchette de numéros de client I Numero cliente (max) Intervallo massimo per numero cliente JA 顧客番号:至 顧客番号:至 KO 고객 번호 상한 고객 번호에 대한 상한 범위 PTB Número do Cliente - Superior Faixa Superior para Números do Cliente RU Номер заказчика по Номер заказчика по S Till kundnummer Övre intervallsgräns för kundnummer TR Müşteri Numarası Üst Değeri Müşteri Numarası Üst Değeri US Customer Number High High Range for Customer Number ZHS 客户编号上限 客户编号的上限 7 60 :p_site_low LOV Oracle AR_SITE_USE_CODE Y select lookup_code id, lookup_code value, meaning description from ar_lookups where lookup_type='SITE_USE_CODE' order by meaning AR موقع من من مدى الموقع D Von Adresse Von Adresse E De Sitio Rango inferior de sitio F Site - De Début de la fourchette de sites I Sede (min) Valore minimo per la sede JA サイト:自 サイト:自 KO 지점 하한 지점에 대한 하한 범위 PTB Local (Inferior) Faixa de Locais - Inferior RU Отделение с Отделение с S Från plats Nedre intervallgräns för ort TR İşletme Birimi Alt Değeri İşletme Alt Aralığı US Site Low Low Range for Site ZHS 地点下限 地点的下限 8 70 :p_site_high LOV Oracle AR_SITE_USE_CODE Y select lookup_code id, lookup_code value, meaning description from ar_lookups where lookup_type='SITE_USE_CODE' order by meaning AR موقع إلى إلى مدى الموقع D Bis Adresse Bis Adresse E A Sitio Rango superior de sitio F Site - A Fin de la fourchette de sites I Sede (max) Valore massimo per la sede JA サイト:至 サイト:至 KO 지점 상한 지점에 대한 상한 범위 PTB Local (Superior) Faixa de Locais - Superior RU Отделение по Отделение по S Till plats Övre intervallgräns för ort TR İşletme Birimi Üst Değeri İşletme Üst Aralığı US Site High High Range for Site ZHS 地点上限 地点的上限 9 80 :p_city_low LOV Oracle AR_CITY Y Y select loc.city id, loc.city value, null description from hz_cust_acct_sites acct_site,hz_party_sites ps,hz_locations loc where acct_site.party_site_id=ps.party_site_id and loc.location_id=ps.location_id and acct_site.cust_acct_site_id in (select min(acct_site1.cust_acct_site_id) from hz_cust_acct_sites acct_site1, hz_party_sites ps1,hz_locations loc1, hz_loc_assignments loc_assign where acct_site1.party_site_id=ps1.party_site_id and loc1.location_id=ps1.location_id and loc1.location_id=loc_assign.location_id and nvl(acct_site1.org_id,-99)=nvl(loc_assign.org_id,-99) group by loc1.city) order by loc.city AR مدينة من من مدى المدينة D Von Ort Von Ort E De Municipio Rango inferior de municipio F Ville - De Début de la fourchette de villes I Città (min) Valore minimo per la città JA 郡市区:自 郡市区:自 KO 시 하한 시에 대한 하한 범위 PTB Cidade (Inferior) Faixa de Cidades - Inferior RU Город с Город с S Från stad Nedre intervallgräns för stad TR Şehir Alt Değeri Şehir Alt Aralığı US City Low Low Range for City ZHS 城市下限 城市的下限 10 90 :p_city_high LOV Oracle AR_CITY Y Y select loc.city id, loc.city value, null description from hz_cust_acct_sites acct_site,hz_party_sites ps,hz_locations loc where acct_site.party_site_id=ps.party_site_id and loc.location_id=ps.location_id and acct_site.cust_acct_site_id in (select min(acct_site1.cust_acct_site_id) from hz_cust_acct_sites acct_site1, hz_party_sites ps1,hz_locations loc1, hz_loc_assignments loc_assign where acct_site1.party_site_id=ps1.party_site_id and loc1.location_id=ps1.location_id and loc1.location_id=loc_assign.location_id and nvl(acct_site1.org_id,-99)=nvl(loc_assign.org_id,-99) group by loc1.city) order by loc.city AR مدينة إلى إلى مدى المدينة D Bis Ort Bis Ort E A Municipio Rango superior de municipio F Ville - A Fin de la fourchette de villes I Città (max) Valore massimo per la città JA 郡市区:至 郡市区:至 KO 시 상한 시에 대한 상한 범위 PTB Cidade (Superior) Faixa de Cidades - Superior RU Город по Город по S Till stad Övre intervallgräns för stad TR Şehir Üst Değeri Şehir Üst Aralığı US City High High Range for City ZHS 城市上限 城市的上限 11 100 :p_state_low LOV Oracle AR_STATE Y select location_segment_value id, location_segment_user_value value, null description from ar_location_values where location_structure_id= (select location_structure_id from ar_system_parameters) and location_segment_qualifier='STATE' order by location_segment_user_value AR ولاية من من مدى الولاية D Von Bundesland Von Bundesland E De Provincia Rango inferior de provincia F Département - De Début de la fourchette de départements I Stato (min) Valore minimo per lo stato JA 州:自 州:自 KO 도 하한 도에 대한 하한 범위 PTB Estado - Inferior Faixa de Estados - Inferior RU Республика с Республика с S Från delstat Nedre intervallgräns för delstat TR Eyalet Alt Değeri Eyalet Alt Aralığı US State Low Low Range for State ZHS 省（州）下限 省（州）的下限 12 110 :p_state_high LOV Oracle AR_STATE Y select location_segment_value id, location_segment_user_value value, null description from ar_location_values where location_structure_id= (select location_structure_id from ar_system_parameters) and location_segment_qualifier='STATE' order by location_segment_user_value AR ولاية إلى إلى مدى الولاية D Bis Bundesland Bis Bundesland E A Provincia Rango superior de provincia F Département - A Fin de la fourchette de départements I Stato (max) Valore massimo per lo stato JA 州:至 州:至 KO 도 상한 도에 대한 상한 범위 PTB Estado - Superior Faixa de Estados - Superior RU Республика по Республика по S Till delstat Övre intervallgräns för delstat TR Eyalet Üst Değeri Eyalet Üst Aralığı US State High High Range for State ZHS 省（州）上限 省（州）的上限 13 120 :p_zip_low LOV Oracle AR_ZIP_CODE Y Y select loc.postal_code id, loc.postal_code value, null description from hz_cust_acct_sites acct_site,hz_party_sites ps,hz_locations loc where acct_site.party_site_id=ps.party_site_id and loc.location_id=ps.location_id and acct_site.cust_acct_site_id in (select min(acct_site1.cust_acct_site_id) from hz_cust_acct_sites acct_site1, hz_party_sites ps1,hz_locations loc1, hz_loc_assignments loc_assign where acct_site1.party_site_id=ps1.party_site_id and loc1.location_id=ps1.location_id and loc1.location_id=loc_assign.location_id and nvl(acct_site1.org_id,-99)=nvl(loc_assign.org_id,-99) group by loc1.postal_code) order by loc.postal_code AR رمز منطقة من من مدى رمز المنطقة D Von PLZ Von PLZ E De Código Postal Rango inferior de código postal F Code postal - De Début de la fourchette de codes postaux I C.A.P. (min) Valore minimo per il C.A.P. JA 郵便番号:自 郵便番号:自 KO 우편 번호 하한 우편 번호에 대한 하한 범위 PTB Código Postal (Inferior) Faixa de Códigos Postais - Inferior RU Индекс с Индекс с S Från postnummer Nedre intervallgräns för postnummer TR Posta Kodu Alt Değeri Posta Kodu Alt Aralığı US Zip Code Low Low Range for Zip Code ZHS 邮政编码下限 邮政编码的下限 14 130 :p_zip_high LOV Oracle AR_ZIP_CODE Y Y select loc.postal_code id, loc.postal_code value, null description from hz_cust_acct_sites acct_site,hz_party_sites ps,hz_locations loc where acct_site.party_site_id=ps.party_site_id and loc.location_id=ps.location_id and acct_site.cust_acct_site_id in (select min(acct_site1.cust_acct_site_id) from hz_cust_acct_sites acct_site1, hz_party_sites ps1,hz_locations loc1, hz_loc_assignments loc_assign where acct_site1.party_site_id=ps1.party_site_id and loc1.location_id=ps1.location_id and loc1.location_id=loc_assign.location_id and nvl(acct_site1.org_id,-99)=nvl(loc_assign.org_id,-99) group by loc1.postal_code) order by loc.postal_code AR رمز منطقة إلى إلى مدى رمز المنطقة D Bis PLZ Bis PLZ E A Código Postal Rango superior de código postal F Code postal - A Fin de la fourchette de codes postaux I C.A.P. (max) Valore massimo per il C.A.P. JA 郵便番号:至 郵便番号:至 KO 우편 번호 상한 우편 번호에 대한 상한 범위 PTB Código Postal (Superior) Faixa de Códigos Postais - Superior RU Индекс по Индекс по S Till postnummer Övre intervallgräns för postnummer TR Posta Kodu Üst Değeri Posta Kodu Üst Aralığı US Zip Code High High Range for Zip Code ZHS 邮政编码上限 邮政编码的上限 15 140 :p_status_low LOV Oracle AR_CUSTOMER_STATUS Y select lookup_code id, lookup_code value, meaning description from ar_lookups where lookup_type='CODE_STATUS' order by meaning AR موقف عميل من من مدى موقف العميل D Von Kundenstatus Von Kundenstatus E De Estado del Cliente Rango inferior de estado del cliente F Statut de client - De Début de la fourchette de statuts de client I Stato cliente (min) Valore minimo per lo stato del cliente JA 顧客ステータス:自 顧客ステータス:自 KO 고객 상태 하한 고객 상태에 대한 하한 범위 PTB Status do Cliente (Inferior) Faixa de Status de Cliente - Inferior RU Статус заказчика с Статус заказчика с S Från kundstatus Nedre intervallgräns för kundstatus TR Müşteri Statüsü Alt Değeri Müşteri Statüsü Alt Aralığı US Customer Status Low Low Range for Customer Status ZHS 客户状态下限 客户状态的下限 16 150 :p_status_high LOV Oracle AR_CUSTOMER_STATUS Y select lookup_code id, lookup_code value, meaning description from ar_lookups where lookup_type='CODE_STATUS' order by meaning AR موقف عميل إلى إلى مدى موقف العميل D Bis Kundenstatus Bis Kundenstatus E A Estado del Cliente Rango superior de estado del cliente F Statut de client - A Fin de la fourchette de statuts de client I Stato cliente (max) Valore massimo per lo stato del cliente JA 顧客ステータス:至 顧客ステータス:至 KO 고객 상태 상한 고객 상태에 대한 상한 범위 PTB Status do Cliente (Superior) Faixa de Status de Cliente - Superior RU Статус заказчика по Статус заказчика по S Till kundstatus Övre intervallgräns för kundstatus TR Müşteri Statüsü Üst Değeri Müşteri Statüsü Üst Aralığı US Customer Status High High Range for Customer Status ZHS 客户状态上限 客户状态的上限