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）限制的操作单元。 C6E085D46F3A51A9E05362FB09050512 select cust.cust_account_id customer_id, substrb(party.party_name,1,50) customer_name, cust.account_number customer_number, arpt_sql_func_util.get_trx_type_details(ct.cust_trx_type_id,'NAME') Name, ps.customer_trx_id, ps.trx_number Invoice_No, ct.purchase_order, ps.due_date, ps.amount_due_original Invoice_amt, ps.amount_due_remaining Balance_amt, ps.trx_date, ps.payment_schedule_id, ps.invoice_currency_code Currency_Code, adr.cust_acct_site_id address_id, loc.city, loc.state, nvl(ps.amount_applied,0) Payment_Amt, nvl(ps.amount_adjusted,0) Adjustments, nvl(ps.amount_credited,0) Credit_memo, AR_ARXCBH_XMLP_PKG.set_prn_flagformula(adr.cust_acct_site_id) Set_Prn_Flag, AR_ARXCBH_XMLP_PKG.Addr_Prn_Flag_p Addr_Prn_Flag, AR_ARXCBH_XMLP_PKG.Previous_Addr_Id_p Previous_Addr_Id, AR_ARXCBH_XMLP_PKG.cf_currency_flagformula(ps.payment_schedule_id) CF_CURRENCY_FLAG, AR_ARXCBH_XMLP_PKG.D_INVOICE_AMOUNTFormula(substrb(party.party_name,1,50)) from ar_payment_schedules ps, ra_customer_trx ct, hz_cust_site_uses su, hz_cust_acct_sites adr, hz_party_sites party_site, hz_locations loc, &P_FROM_1 ra_terms ter, hz_cust_accounts cust, hz_parties party where ps.customer_trx_id = ct.customer_trx_id and ct.previous_customer_trx_id is null and ct.bill_to_site_use_id = su.site_use_id and adr.cust_account_id = cust.cust_account_id(+) and cust.party_id = party.party_id(+) and ct.term_id = ter.term_id(+) and su.cust_acct_site_id = adr.cust_acct_site_id and adr.party_site_id = party_site.party_site_id and loc.location_id = party_site.location_id &lp_in_customer_num_low &lp_in_customer_num_high &lp_in_invoice_number_low &lp_in_invoice_number_high &lp_in_trx_date_low &lp_in_trx_date_high &lp_in_collector_low &lp_in_collector_high &P_TERMS_NAME &P_TERMS_NAME1 &P_WHERE_11 &P_WHERE_12 &P_WHERE_2 and ps.class != 'PMT' /*order by party.party_name, cust.cust_account_id, ps.invoice_currency_code, ps.trx_number, ps.due_date*/ order by 1,2,3,13,6,5,8,4,11,7,9,10,17,19,18,12 Y AR ARXCBH_XML AR AR تاريخ تحرير الفواتير (بتنسيق XML) Imported from BI Publisher Description: تاريخ تحرير الفواتير Application: المقبوضات Source: تاريخ تحرير الفواتير (بتنسيق XML) Short Name: ARXCBH_XML DB package: AR_ARXCBH_XMLP_PKG D AR Fakturierungshistorie Imported from BI Publisher Description: Fakturierungshistorie Application: Debitoren Source: Fakturierungshistorie (XML) Short Name: ARXCBH_XML DB package: AR_ARXCBH_XMLP_PKG E AR Historial de Facturación Imported from BI Publisher Description: Historial de facturación Application: Receivables Source: Historial de Facturación (XML) Short Name: ARXCBH_XML DB package: AR_ARXCBH_XMLP_PKG F AR Historique de la facturation Imported from BI Publisher Description: Historique de la facturation Application: Receivables Source: Historique de la facturation (XML) Short Name: ARXCBH_XML DB package: AR_ARXCBH_XMLP_PKG I AR Cronologia fatturazione Imported from BI Publisher Description: Cronologia fatturazione Application: Receivables Source: Cronologia fatturazione (XML) Short Name: ARXCBH_XML DB package: AR_ARXCBH_XMLP_PKG JA AR 請求履歴 Imported from BI Publisher Description: 請求履歴 Application: Receivables Source: 請求履歴(XML) Short Name: ARXCBH_XML DB package: AR_ARXCBH_XMLP_PKG KO AR 청구 내역 Imported from BI Publisher Description: 청구 내역 Application: Receivables Source: 청구 내역(XML) Short Name: ARXCBH_XML DB package: AR_ARXCBH_XMLP_PKG PTB AR Histórico de Faturamento Imported from BI Publisher Description: Histórico do Faturamento Application: Receivables Source: Histórico de Faturamento (XML) Short Name: ARXCBH_XML DB package: AR_ARXCBH_XMLP_PKG RU AR История выставления счетов Imported from BI Publisher Description: Реестр выставленных счетов Application: Дебиторы Source: История выставления счетов (XML) Short Name: ARXCBH_XML DB package: AR_ARXCBH_XMLP_PKG S AR Faktureringshistorik Imported from BI Publisher Description: Faktureringshistorik Application: Receivables Source: Faktureringshistorik (XML) Short Name: ARXCBH_XML DB package: AR_ARXCBH_XMLP_PKG TR AR Faturalama Tarihçesi Imported from BI Publisher Description: Faturalama Tarihçesi Application: Alacaklar Muhasebesi Source: Faturalama Tarihçesi (XML) Short Name: ARXCBH_XML DB package: AR_ARXCBH_XMLP_PKG US AR Billing History Imported from BI Publisher Description: Billing History Application: Receivables Source: Billing History (XML) Short Name: ARXCBH_XML DB package: AR_ARXCBH_XMLP_PKG ZHS AR 开单历史记录 Imported from BI Publisher Description: 开单历史记录 Application: 应收帐款 Source: 开单历史记录 (XML) Short Name: ARXCBH_XML DB package: AR_ARXCBH_XMLP_PKG BI Publisher &lp_in_collector_high &lp_in_collector_low &lp_in_customer_num_high &lp_in_customer_num_low &lp_in_invoice_number_high &lp_in_invoice_number_low &lp_in_trx_date_high &lp_in_trx_date_low &p_from_1 &p_terms_name &p_terms_name1 &p_where_11 &p_where_12 &p_where_2 :addr_prn_flag :lp_in_collector_high :lp_in_collector_low :lp_in_customer_num_high :lp_in_customer_num_low :lp_in_invoice_number_high :lp_in_invoice_number_low :lp_in_trx_date_high :lp_in_trx_date_low :lp_terms_high :lp_terms_low :operating_unit :p_conc_request_id :p_from_1 :p_in_collector_high :p_in_collector_low :p_in_customer_high :p_in_customer_low :p_in_customer_num_high :p_in_customer_num_low :p_in_invoice_number_high :p_in_invoice_number_low :p_in_terms_high :p_in_terms_low :p_in_trx_date_high :p_in_trx_date_high_t :p_in_trx_date_low :p_in_trx_date_low_t :p_min_precision :p_set_of_books_id :p_terms_name :p_terms_name1 :p_terms_name_high :p_terms_name_low :p_trx_date_high :p_trx_date_low :p_where_11 :p_where_12 :p_where_2 :previous_addr_id :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 Buchkennung E Id Libro Mayor F ID livre I Id libro contabile JA 元帳ID KO 원장 ID PTB Id do Razão RU Идентификатор книги S Huvudboks-id TR Defter No US 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_in_customer_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 E De Nombre de Cliente F Nom de client - De I Nome cliente (min) JA 顧客名:自 KO 고객명 하한 PTB Nome do Cliente - Inferior RU Имя заказчика с S Från kundnamn TR Müşteri Adı Alt Değeri US Customer Name Low ZHS 客户名称下限 4 20 :p_in_customer_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 E A Nombre de Cliente F Nom de client - A I Nome cliente (max) JA 顧客名:至 KO 고객명 상한 PTB Nome do Cliente - Superior RU Имя заказчика по S Till kundnamn TR Müşteri Adı Üst Değeri US Customer Name High ZHS 客户名称上限 5 30 :p_in_customer_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 E De Número de Cliente F Numéro de client - De I Numero cliente (min) JA 顧客番号:自 KO 고객 번호 하한 PTB Número do Cliente - Inferior RU Номер заказчика с S Från kundnummer TR Müşteri Numarası Alt Değeri US Customer Number Low ZHS 客户编号下限 6 40 :p_in_customer_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 E A Número de Cliente F Numéro de client - A I Numero cliente (max) JA 顧客番号:至 KO 고객 번호 상한 PTB Número do Cliente - Superior RU Номер заказчика по S Till kundnummer TR Müşteri Numarası Üst Değeri US Customer Number High ZHS 客户编号上限 7 50 :p_in_invoice_number_low LOV Oracle AR_INVOICE_NUMBER Y Y select ct.trx_number id, ct.trx_number value, null description from ra_customer_trx ct where ct.customer_trx_id in ( select max(ct2.customer_trx_id) from ra_customer_trx ct2 where ct.trx_number=ct2.trx_number) order by ct.trx_number,ct.customer_trx_id AR رقم فاتورة من D Von Rechnungsnummer E De Número de Factura F Numéro de facture - De I Numero fattura (min) JA 請求書番号:自 KO 송장 번호 하한 PTB Número de NFF - Inferior RU Номер счета-фактуры с S Från fakturanummer TR Fatura Numarası Alt Değeri US Invoice Number Low ZHS 发票编号下限 8 60 :p_in_invoice_number_high LOV Oracle AR_INVOICE_NUMBER Y Y select ct.trx_number id, ct.trx_number value, null description from ra_customer_trx ct where ct.customer_trx_id in ( select max(ct2.customer_trx_id) from ra_customer_trx ct2 where ct.trx_number=ct2.trx_number) order by ct.trx_number,ct.customer_trx_id AR رقم فاتورة إلى D Bis Rechnungsnummer E A Número de Factura F Numéro de facture - A I Numero fattura (max) JA 請求書番号:至 KO 송장 번호 상한 PTB Número de NFF - Superior RU Номер счета-фактуры по S Till fakturanummer TR Fatura Numarası Üst Değeri US Invoice Number High ZHS 发票编号上限 9 70 :p_in_collector_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 E De Nombre del Cobrador F Nom d'agent de recouvrement - De I Nome esattore (min) JA 回収担当名:自 KO 수금사원명 하한 PTB Nome do Cobrador - Inferior RU Имя сборщика с S Från inkasserare TR Tahsildar Adı Alt Değeri US Collector Name Low ZHS 收帐员姓名下限 10 80 :p_in_collector_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 E A Nombre del Cobrador F Nom d'agent de recouvrement - A I Nome esattore (max) JA 回収担当名:至 KO 수금사원명 상한 PTB Nome do Cobrador - Superior RU Имя сборщика по S Till inkasserare TR Tahsildar Adı Üst Değeri US Collector Name High ZHS 收帐员姓名上限 11 90 :p_in_terms_low LOV Oracle AR_TERMS Y select name id, name value, null description from ra_terms order by name,term_id AR اسم شرط من D Von Zahlungsbedingung E De Nombre de la Condición F Nom de condition - De I Nome condizione (min) JA 支払条件名:自 KO 조건명 하한 PTB Nome da Condição (Inferior) RU Имя условий с S Från villkorsnamn TR Koşul Adı Alt Değeri US Term Name Low ZHS 条件名称下限 12 100 :p_in_terms_high LOV Oracle AR_TERMS Y select name id, name value, null description from ra_terms order by name,term_id AR اسم شرط إلى D Bis Zahlungsbedingung E A Nombre de la Condición F Nom de condition - A I Nome condizione (max) JA 支払条件名:至 KO 조건명 상한 PTB Nome da Condição (Superior) RU Имя условий по S Till villkorsnamn TR Koşul Adı Üst Değeri US Term Name High ZHS 条件名称上限 13 110 :p_in_trx_date_low Date AR تاريخ حركة من D Von Transaktionsdatum E De Fecha de Transacción F Date du mouvement - Du I Data transazione (min) JA 取引日:自 KO 거래 일자 하한 PTB Data da Transação - Inferior RU Дата транзакции с S Från transaktionsdatum TR İşlem Tarihi Alt Değeri US Transaction Date Low ZHS 事务处理日期下限 14 120 :p_in_trx_date_high Date AR تاريخ حركة إلى D Bis Transaktionsdatum E A Fecha de Transacción F Date du mouvement - Au I Data transazione (max) JA 取引日:至 KO 거래 일자 상한 PTB Data da Transação - Superior RU Дата транзакции по S Till transaktionsdatum TR İşlem Tarihi Üst Değeri US Transaction Date High ZHS 事务处理日期上限