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）限制的操作单元。 C6E085D46F3D51A9E05362FB09050512Y SELECT &ACCT_FLEX_BAL_SEG bal_seg, ps.invoice_currency_code currency_code, to_char(ps.trx_date ,'DD-MON-RR') trx_date, ps.customer_id customer_id, cust.ACCOUNT_NUMBER customer_number, SUBSTRB(PARTY.PARTY_NAME,1,50) customer_name, ps.trx_number trx_number, ps.due_date due_date, nvl(ps.discount_taken_earned ,0) disc_taken_earned, nvl(ps.discount_taken_unearned ,0) disc_taken_unearned, nvl(ps. amount_line_items_original,0) lio, ps.payment_schedule_id psi, l.meaning invoice_class, ps.term_id term_id, term.name term_name, term.calc_discount_on_lines_flag discount_on_lines, term.partial_discount_flag partial_discount, ps.terms_sequence_number seq_number, ps.amount_due_original ado, nvl(nvl(cp_site.discount_grace_days,cp_cust.discount_grace_days),0) discount_grace_days, ps.amount_due_remaining adr, ps.cash_receipt_id, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_bal_seg', 'SQLGL', 'GL#', comp.CHART_OF_ACCOUNTS_ID, NULL, comp.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') d_bal_seg, &currency_code curr, &out_disc_to_take out_disc_to_take, AR_ARXDPR_XMLP_PKG.unearnd_disc_pctformula(:UNEARNED_DISCOUNT) Unearnd_disc_pct, AR_ARXDPR_XMLP_PKG.abs_discformula() abs_disc, AR_ARXDPR_XMLP_PKG.out_discount_date_p out_discount_date, AR_ARXDPR_XMLP_PKG.out_amt_to_apply_p out_amt_to_apply, AR_ARXDPR_XMLP_PKG.earned_disc_pct_p earned_disc_pct, AR_ARXDPR_XMLP_PKG.out_earned_disc_p out_earned_disc, AR_ARXDPR_XMLP_PKG.out_unearned_disc_p out_unearned_disc, AR_ARXDPR_XMLP_PKG.best_disc_pct_p best_disc_pct FROM ar_lookups l, HZ_customer_profiles cp_cust, HZ_customer_profiles cp_site, ra_terms term, gl_code_combinations comp, ra_customer_trx trx, ar_xla_ctlgd_lines_v dist, HZ_CUST_ACCOUNTS cust, HZ_PARTIES PARTY, ar_payment_schedules ps WHERE ps.status = 'OP' AND ps.class != 'GUAR' AND cust.CUST_ACCOUNT_ID = ps.customer_id AND CUST.PARTY_ID = PARTY.PARTY_ID AND trx.customer_trx_id = ps.customer_trx_id AND trx.customer_trx_id = dist.customer_trx_id AND dist.account_class = 'REC' AND dist.account_set_flag = decode(trx.invoicing_rule_id, null,'N','Y') AND dist.code_combination_id = comp.code_combination_id(+) AND term.term_id(+) = ps.term_id AND ps.customer_id = cp_cust.CUST_ACCOUNT_ID AND cp_cust.site_use_id is null AND ps.customer_site_use_id = cp_site.site_use_id(+) AND l.lookup_type = 'INV/CM' AND l.lookup_code = ps.class AND PARTY.PARTY_NAME BETWEEN NVL(:p_cust_name_low,PARTY.PARTY_NAME) AND NVL(:p_cust_name_high,PARTY.PARTY_NAME) AND cust.ACCOUNT_NUMBER BETWEEN NVL(:p_cust_num_low,cust.ACCOUNT_NUMBER) AND NVL(:p_cust_num_high,cust.ACCOUNT_NUMBER) AND ps.invoice_currency_code BETWEEN NVL(:p_currency_low,ps.invoice_currency_code) AND NVL(:p_currency_high,ps.invoice_currency_code) AND &ACCT_BAL_WHERE_CLAUSE --ORDER BY 2,1,4,5,6,22,7,13,15,8 ORDER BY 2 ASC,1 ASC,4 ASC,6 ASC,5 ASC AR ARXDPR_XML AR AR تقرير تقدير الخصومات (بتنسيق XML) Imported from BI Publisher Description: إظهار كشف الخصم المحتمل للمستخدم Application: المقبوضات Source: تقرير تقدير الخصومات (بتنسيق XML) Short Name: ARXDPR_XML DB package: AR_ARXDPR_XMLP_PKG D AR Skonto - Vorausschau Imported from BI Publisher Description: Zeigt dem Benutzer den möglichen Skonto an Application: Debitoren Source: Skonto - Vorausschau (XML) Short Name: ARXDPR_XML DB package: AR_ARXDPR_XMLP_PKG E AR Previsión de Descuentos Ofrecidos Imported from BI Publisher Description: Muestra los posibles descuentos del usuario Application: Receivables Source: Previsión de Descuentos Ofrecidos (XML) Short Name: ARXDPR_XML DB package: AR_ARXDPR_XMLP_PKG F AR Etat Prévisions d'escomptes Imported from BI Publisher Description: Indique à l'utilisateur les conditions d'escompte possibles Application: Receivables Source: Etat Prévisions d'escomptes (XML) Short Name: ARXDPR_XML DB package: AR_ARXDPR_XMLP_PKG I AR Rapporto Proiezione sconto Imported from BI Publisher Description: Mostra la possibile esposizione dell'utente allo sconto Application: Receivables Source: Rapporto Proiezione sconto (XML) Short Name: ARXDPR_XML DB package: AR_ARXDPR_XMLP_PKG JA AR 売上割引額見積レポート Imported from BI Publisher Description: 売上割引可能対象ユーザーの表示 Application: Receivables Source: 売上割引額見積レポート(XML) Short Name: ARXDPR_XML DB package: AR_ARXDPR_XMLP_PKG KO AR 할인 추정 보고서 Imported from BI Publisher Description: 사용자 가능 할인 기준 표시 Application: Receivables Source: 할인 추정 보고서(XML) Short Name: ARXDPR_XML DB package: AR_ARXDPR_XMLP_PKG PTB AR Relatório de Projeção de Desconto Imported from BI Publisher Description: Mostra a exposição de desconto possível ao usuário Application: Receivables Source: Relatório de Projeção de Desconto (XML) Short Name: ARXDPR_XML DB package: AR_ARXDPR_XMLP_PKG RU AR Отчет о прогнозе скидок Imported from BI Publisher Description: Отображение суммарного объема возможных скидок для пользователя Application: Дебиторы Source: Отчет о прогнозе скидок (XML) Short Name: ARXDPR_XML DB package: AR_ARXDPR_XMLP_PKG S AR Rabattprognos - rapport Imported from BI Publisher Description: Visar möjlig rabattexponering för användare Application: Receivables Source: Rabattprognos - rapport (XML) Short Name: ARXDPR_XML DB package: AR_ARXDPR_XMLP_PKG TR AR İndirim Projeksiyonu Raporu Imported from BI Publisher Description: Olası kullanıcı indirimi etkisini gösterir. Application: Alacaklar Muhasebesi Source: İndirim Projeksiyonu Raporu (XML) Short Name: ARXDPR_XML DB package: AR_ARXDPR_XMLP_PKG US AR Discount Projection Imported from BI Publisher Description: Shows user possible discount exposure Application: Receivables Source: Discount Projection Report (XML) Short Name: ARXDPR_XML DB package: AR_ARXDPR_XMLP_PKG ZHS AR 预计折扣报表 Imported from BI Publisher Description: 向用户显示可能存在的折扣风险 Application: 应收帐款 Source: 预计折扣报表 (XML) Short Name: ARXDPR_XML DB package: AR_ARXDPR_XMLP_PKG BI Publisher &acct_bal_where_clause &acct_flex_bal_seg &currency_code &out_disc_to_take :acct_bal_aprompt :best_disc_pct :cp_acc_message :earned_disc_pct :operating_unit :out_amt_to_apply :out_discount_date :out_earned_disc :out_unearned_disc :p_as_of_date :p_bal_seg_high :p_bal_seg_low :p_conc_request_id :p_currency_high :p_currency_low :p_cust_name_high :p_cust_name_low :p_cust_num_high :p_cust_num_low :rp_company_name :rp_report_name :unearned_discount 1 -20 :p_coa Char select gl.chart_of_accounts_id from gl_sets_of_books gl, ar_system_parameters ar where ar.set_of_books_id = gl.set_of_books_id AR معرف جدول تصنيف الحسابات معرف جدول تصنيف الحسابات (يستخدم لمعامل مقطع الشركة المرن التالي) D Kontenplankennung Kennung Kontenplan (für spätere Parameter für Firmensegmente) E Id Plan de Cuentas Id Plan de Cuentas (usado para último parámetro de Segmento de Compañía de Estructura) F ID plan de comptes ID plan de comptes (utilisé pour paramètre Segment de société ultérieur) I Id piano dei conti Id del piano dei conti (utilizzato per il parametro Segmento aziendale del flexfield successivo) JA 勘定体系ID 勘定体系ID (最新フレックス会社セグメント・パラメータで使用) KO 계정코드집 ID 계정코드집 ID(차후 가변 회사 세그먼트 매개변수를 위해 사용됨) PTB Id do Plano de Contas ID do Plano de Contas (usado para o parâmetro de Segmento de Empresa do flexfield posterior) RU Идентификатор плана счетов Идент. плана счетов (используется для последнего параметра сегмента компании ГП) S Kontoplans-id Kontoplans-id (används för senare parametrar för flexbolagssegment) TR Hesap Planı No Hesap Planı No (sonraki esnek Şirket Segment par. için kullanılan) US Chart of Accounts Id Chart of Accounts ID (used for later flex Company Segment parameter) 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_as_of_date Date sysdate Y AR اعتبارًا من تاريخ اعتبارًا من تاريخ D Vom Vom E A la Fecha A la Fecha F En date du En date du I In data In data JA 現在日 現在日 KO 기준 일자 기준 일자 PTB Data de Referência Data de Referência RU На дату На дату S Per datum Per datum TR Geçerlilik Başlangıcı Geçerlilik Başlangıcı US As of Date As of Date ZHS 截止日期 截止日期 4 20 :p_currency_low 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 Von Währung Von Währung E De Divisa Rango inferior de divisa F Devise - De Début de la fourchette de devises I Divisa (min) Valore minimo per la divisa JA 通貨:自 通貨:自 KO 통화 하한 통화의 하한 범위 PTB Moeda - Inferior Faixa de Moedas - Inferior RU Валюта с Валюта с S Från valuta Nedre intervallgräns för valuta TR Para Birimi Alt Değeri Para Birimi alt aralığı US Currency Low Low range of Currency ZHS 币种下限 币种下限 5 30 :p_currency_high 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 Bis Währung Bis Währung E A Divisa Rango superior de divisa F Devise - A Fin de la fourchette de devises I Divisa (max) Valore massimo per la divisa JA 通貨:至 通貨:至 KO 통화 상한 통화의 상한 범위 PTB Moeda - Superior Faixa de Moedas - Superior RU Валюта по Валюта по S Till valuta Övre intervallgräns för valuta TR Para Birimi Üst Değeri Para Birimi Üst Aralığı US Currency High High Range of Currency ZHS 币种上限 币种的上限 6 40 :p_bal_seg_low Char AR مقطع الشركة من من مدى مقطع الشركة D Von Firmensegment Von Firmensegment E De Segmento de Compañía Rango inferior de segmento de compañía F Segment société - De Début de la fourchette de segments de société I Segmento aziendale (min) Valore minimo per il segmento aziendale JA 会社セグメント:自 会社セグメント:自 KO 회사 세그먼트 하한 회사 세그먼트의 하한 범위 PTB Segmento da Empresa - Inferior Faixa de Segmentos de Empresa - Inferior RU Сегмент компании с Сегмент компании с S Från bolagssegment Nedre intervallgräns för bolagssegment TR Şirket Segmenti Alt Değeri Şirket Segmenti alt aralığı US Company Segment Low Low range of Company Segment ZHS 公司段下限 公司段的下限 7 50 :p_bal_seg_high Char AR مقطع الشركة إلى إلى مدى مقطع الشركة D Bis Firmensegment Bis Firmensegment E A Segmento de Compañía Rango superior de segmento de compañía F Segment société - A Fin de la fourchette de segments de société I Segmento aziendale (max) Valore massimo per il segmento aziendale JA 会社セグメント:至 会社セグメント:至 KO 회사 세그먼트 상한 회사 세그먼트의 상한 범위 PTB Segmento Empresa (Superior) Faixa de Segmentos de Empresa - Superior RU Сегмент компании по Сегмент компании по S Till bolagssegment Övre intervallgräns för bolagssegment TR Şirket Segmenti Üst Değeri Şirket Segmenti üst aralığı US Company Segment High High range of Company Segment ZHS 公司段上限 公司段的上限 8 60 :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 Rango inferior de número de cliente F Numéro de client - De Début de la fourchette des numéros de client I Numero cliente (min) Intervallo minimo per il numero del cliente JA 顧客番号:自 顧客番号:自 KO 고객 번호 하한 고객 번호의 하한 범위 PTB Número do Cliente - Inferior Faixa de Números de Cliente - Inferior RU Номер заказчика с Номер заказчика с S Från kundnummer Undre intervallsgräns för kundnummer TR Müşteri Numarası Alt Değeri Müşteri Numarası alt değeri US Customer Number Low Low range of Customer Number ZHS 客户编号下限 客户编号的下限 9 70 :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 Rango superior de número de cliente F Numéro de client - A Fin de la fourchette des numéros de client I Numero cliente (max) Intervallo massimo per il numero del cliente JA 顧客番号:至 顧客番号:至 KO 고객 번호 상한 고객 번호의 상한 범위 PTB Número do Cliente - Superior Faixa de Números de Cliente - Superior 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 of Customer Number ZHS 客户编号上限 客户编号的上限 10 80 :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 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 il nome del cliente JA 顧客名:自 顧客名:自 KO 고객명 하한 고객명의 하한 범위 PTB Nome do Cliente - Inferior Faixa de Nomes de Cliente - Inferior RU Имя заказчика с Имя заказчика с S Från kundnamn Undre intervallsgräns för kundnamn TR Müşteri Adı Alt Değeri Müşteri Adı Alt Değeri US Customer Name Low Low range of Customer Name ZHS 客户名称下限 客户名称下限 11 90 :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 de Cliente Rango superior de nombre del cliente F Nom de client - A Fin de la fourchette des noms de client I Nome cliente (max) Intervallo massimo per il nome del cliente JA 顧客名:至 顧客名:至 KO 고객명 상한 고객명의 상한 범위 PTB Nome do Cliente - Superior Faixa de Nomes de Cliente - Superior 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 of Customer Name ZHS 客户名称上限 客户名称的上限