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）限制的操作单元。 C6E085D46F3851A9E05362FB09050512 select ps.customer_id customer_id_ps, ps.trx_number trx_number, ctt.name cust_trx_name, ps.trx_date trx_date, ps.due_date due_date, ps.invoice_currency_code invoice_currency_code, ROUND(ps.amount_due_original * nvl(ps.exchange_rate, decode(ps.invoice_currency_code, :functional_currency_code,1, null)), 2) amount_due_original, ROUND(ps.amount_due_remaining * nvl(ps.exchange_rate, decode(ps.invoice_currency_code, :functional_currency_code,1, null)), 2) amount_due_remaining, ROUND(ps.amount_due_remaining * nvl(ps.exchange_rate, decode(ps.invoice_currency_code, :functional_currency_code,1, null)) * (1 - :percent_collectable / 100), 2) provision, to_char(cct.collection_forecast) || decode(cct.collection_forecast, null,'', '%') forecast_percent, cct.forecast_date forecast_date, AR_ARXBDP_XMLP_PKG.D_Amount_Due_OriginalFormula(ROUND(ps.amount_due_original * nvl(ps.exchange_rate, decode(ps.invoice_currency_code, :functional_currency_code,1, null)), 2)) Temp from ar_customer_call_topics cct, ra_cust_trx_types ctt, ar_payment_schedules ps where ps.cust_trx_type_id = ctt.cust_trx_type_id(+) and ps.payment_schedule_id = cct.payment_schedule_id(+) and ps.class != 'GUAR' and not exists ( select 'x' from ar_customer_call_topics cct2 where cct2.payment_schedule_id = ps.payment_schedule_id and (cct2.call_date > cct.call_date OR (cct2.call_date = cct.call_date and cct2.customer_call_topic_id > cct.customer_call_topic_id))) and ps.status || '' = 'OP' and ps.customer_id=:customer_id order by -- ps.trx_number 1,2,3,4,5,6,7,8,9,10,11 Y AR ARXBDP_XML AR AR تقرير مخصص الديون المشكوك في تحصيلها (بتنسيق XML) Imported from BI Publisher Description: تقرير مخصص الديون المشكوك في تحصيلها Application: المقبوضات Source: تقرير مخصص الديون المشكوك في تحصيلها (بتنسيق XML) Short Name: ARXBDP_XML DB package: AR_ARXBDP_XMLP_PKG D AR Wertberichtigung auf uneinbringliche Forderungen Imported from BI Publisher Description: Auswertung "Wertberichtigung auf uneinbringliche Forderungen" Application: Debitoren Source: Wertberichtigung auf uneinbringliche Forderungen (XML) Short Name: ARXBDP_XML DB package: AR_ARXBDP_XMLP_PKG E AR Provisión para Clientes de Dudoso Cobro Imported from BI Publisher Description: Informe de provisión para clientes de dudoso cobro Application: Receivables Source: Provisión para Clientes de Dudoso Cobro (XML) Short Name: ARXBDP_XML DB package: AR_ARXBDP_XMLP_PKG F AR Etat Provisions pour créances irrécouvrables Imported from BI Publisher Description: Etat des provisions pour créances irrécouvrables Application: Receivables Source: Etat Provisions pour créances irrécouvrables (XML) Short Name: ARXBDP_XML DB package: AR_ARXBDP_XMLP_PKG I AR Rapporto Accantonamento al fondo rischi su crediti Imported from BI Publisher Description: Rapporto Accantonamento al fondo rischi su crediti Application: Receivables Source: Rapporto Accantonamento al fondo rischi su crediti (XML) Short Name: ARXBDP_XML DB package: AR_ARXBDP_XMLP_PKG JA AR 貸倒引当金見積レポート Imported from BI Publisher Description: 貸倒引当金見積レポート Application: Receivables Source: 貸倒引当金見積レポート(XML) Short Name: ARXBDP_XML DB package: AR_ARXBDP_XMLP_PKG KO AR 대손 충당금 보고서 Imported from BI Publisher Description: 대손 충당금 보고서 Application: Receivables Source: 대손 충당금 보고서(XML) Short Name: ARXBDP_XML DB package: AR_ARXBDP_XMLP_PKG PTB AR Relatório de Provisão de Débito Inválido Imported from BI Publisher Description: Relatório de Provisão de Débito Inválido Application: Receivables Source: Relatório de Provisão de Débito Inválido (XML) Short Name: ARXBDP_XML DB package: AR_ARXBDP_XMLP_PKG RU AR Отчет о резерве на покрытие безнадежных долгов Imported from BI Publisher Description: Отчет о резерве на покрытие безнадежных долгов Application: Дебиторы Source: Отчет о резерве на покрытие безнадежных долгов (XML) Short Name: ARXBDP_XML DB package: AR_ARXBDP_XMLP_PKG S AR Reserv för osäkra fordringar - rapport Imported from BI Publisher Description: Reserv för osäkra fordringar - rapport Application: Receivables Source: Reserv för osäkra fordringar - rapport (XML) Short Name: ARXBDP_XML DB package: AR_ARXBDP_XMLP_PKG TR AR Şüpheli Alacaklar Karşılık Raporu Imported from BI Publisher Description: Şüpheli Alacaklar Karşılık Raporu Application: Alacaklar Muhasebesi Source: Şüpheli Alacaklar Karşılık Raporu (XML) Short Name: ARXBDP_XML DB package: AR_ARXBDP_XMLP_PKG US AR Bad Debt Provision Imported from BI Publisher Description: Bad Debt Provision Report Application: Receivables Source: Bad Debt Provision Report (XML) Short Name: ARXBDP_XML DB package: AR_ARXBDP_XMLP_PKG ZHS AR 呆帐准备报表 Imported from BI Publisher Description: 呆帐准备报表 Application: 应收帐款 Source: 呆帐准备报表 (XML) Short Name: ARXBDP_XML DB package: AR_ARXBDP_XMLP_PKG BI Publisher :customer_id :functional_currency_code :gsum_amt_due_remaining_dsp :gsum_provision_dsp :lp_end_account_status :lp_end_customer_name :lp_end_customer_number :lp_start_account_status :lp_start_customer_name :lp_start_customer_number :operating_unit :p_conc_request_id :p_end_account_status :p_end_customer_name :p_end_customer_number :p_group_id :p_last_updated_by :p_min_precision :p_set_of_books_id :p_sortby :p_start_account_status :p_start_customer_name :p_start_customer_number :percent_collectable :ref_curr_code :rp_company_name :rp_data_found :rp_report_name 1 -40 :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 -30 :p_last_updated_by Char 1 AR معرف المستخدم معرف المستخدم D Benutzerkennung Benutzerkennung E Id Usuario Id Usuario F ID utilisateur ID utilisateur I Id utente Id dell'utente JA ユーザーID ユーザーID KO 사용자 ID 사용자 ID PTB ID do Usuário ID do Usuário RU Идентификатор пользователя Идентификатор пользователя S Användar-id Användar-id TR Kullanıcı No Kullanıcı No US User ID User ID ZHS 用户标识 用户标识 3 -20 :p_group_id Char 1 AR معرف المجموعة معرف المجموعة D Gruppenkennung Gruppenkennung E Id Grupo Id Grupo F ID groupe ID groupe I Id gruppo Id del gruppo JA グループID グループID KO 그룹 ID 그룹 ID PTB ID do Grupo ID do Grupo RU Идентификатор группы Идентификатор группы S Grupp-id Grupp-id TR Grup No Grup No US Group ID Group ID ZHS 组标识 组标识 4 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 5 10 :p_sortby LOV Oracle AR_ARXBDP_SORT_BY Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='SORT_BY_ARXBDP' order by value,description 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 düzenini gösterir. US Order By Indicates ordering of query ZHS 排序依据 表示查询顺序 6 20 :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 Rango inferior de estado de la cuenta F Statut de compte - De Début de la fourchette de statuts de compte I Stato conto (min) Valore minimo per lo stato del conto JA 勘定ステータス:自 勘定ステータス:自 KO 계정 상태 하한 계정 상태에 대한 하한 범위 PTB Status da Conta (Inferior) Faixa de Status da Conta - Inferior RU Статус счета с Статус счета с S Från kontostatus Nedre intervallgräns för kontostatus TR Hesap Statüsü Alt Değeri Hesap Statüsü Alt Değeri US Account Status Low Low Range For Account Status ZHS 帐户状态下限 帐户状态的下限 7 30 :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 Rango superior de estado de cuenta F Statut du compte - A Fin de la fourchette de statuts de compte I Stato conto (max) Valore massimo per lo stato del conto JA 勘定ステータス:至 勘定ステータス:至 KO 계정 상태 상한 계정 상태에 대한 상한 범위 PTB Status da Conta - Superior Faixa de Status da Conta - Superior RU Статус счета по Статус счета по S Till kontostatus Övre intervallgräns för kontostatus TR Hesap Statüsü Üst Değeri Hesap Statüsü Üst Değeri US Account Status High High Range For Account Status ZHS 帐户状态上限 帐户状态的上限 8 40 :p_start_customer_name 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 Kundename E De Nombre de Cliente Rango inferior de nombre de cliente F Nom de client - De Début de la fourchette de noms de client I Nome cliente (min) Valore minimo per il nome del cliente JA 顧客名:自 顧客名:自 KO 고객명 하한 고객명에 대한 하한 범위 PTB Nome do Cliente - Inferior Faixa de Nomes de Cliente - Inferior RU Имя заказчика с Имя заказчика с S Från kundnamn Nedre intervallgräns för kundnamn TR Müşteri Adı Alt Değeri Müşteri Adı için İlk Aralık US Customer Name Low Low Range For Customer Name ZHS 客户名称下限 客户名称的下限 9 50 :p_end_customer_name 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 Kundename E A Nombre de Cliente Rango superior de nombre de cliente F Nom de client - A Fin de la fourchette de noms de client I Nome cliente (max) Valore massimo per il nome del cliente JA 顧客名:至 顧客名:至 KO 고객명 상한 고객명에 대한 상한 범위 PTB Nome do Cliente - Superior Faixa de Nomes de Cliente - Superior RU Имя заказчика по Имя заказчика по S Till kundnamn Övre intervallgräns för kundnamn TR Müşteri Adı Üst Değeri Müşteri Adı için Üst Aralık US Customer Name High High Range For Customer Name ZHS 客户名称上限 客户名称的上限 10 60 :p_start_customer_number 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) Valore minimo per il numero del cliente JA 顧客番号:自 顧客番号:自 KO 고객 번호 하한 고객 번호에 대한 하한 범위 PTB Número do Cliente - Inferior Faixa de Nomes de Cliente - Inferior RU Номер заказчика с Номер заказчика с S Från kundnummer Nedre intervallgräns för kundnummer TR Müşteri Numarası Alt Değeri Müşteri Numarası için Alt Aralık US Customer Number Low Low Range For Customer Number ZHS 客户编号下限 客户编号的下限 11 70 :p_end_customer_number 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) Valore massimo per il numero del cliente JA 顧客番号:至 顧客番号:至 KO 고객 번호 상한 고객 번호에 대한 상한 범위 PTB Número do Cliente - Superior Faixa de Números do Cliente - Superior RU Номер заказчика по Номер заказчика по S Till kundnummer Övre intervallgräns för kundnummer TR Müşteri Numarası Üst Değeri Müşteri Numarası için Üst Aralık US Customer Number High High Range For Customer Number ZHS 客户编号上限 客户编号的上限 :$flex$.ledger Ledger Operating Unit