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）限制的操作单元。 C6E085D46F2D51A9E05362FB09050512Y Select invoice_currency_code currency_code, substrb(party.party_name,1,50) cust_name, trx.trx_number br_number, br_amount br_amount, trx.trx_date br_date, rtrim(loc.address1) remit_to_address1, loc.address2 remit_to_address2, loc.address3 remit_to_address3, loc.address4 remit_to_address4, loc.postal_code remit_postal_code, loc.state remit_state, loc.city remit_city, loc.country remit_country, loc2.address1 cust_address1, loc2.address2 cust_address2, loc2.address3 cust_address3, loc2.address4 cust_address4, loc2.postal_code cust_postal_code, loc2.state cust_state, loc2.city cust_city, loc2.country cust_country, AR_ARBRRMLT_XMLP_PKG.cf_br_dateformula(trx.trx_date) CF_BR_DATE, AR_ARBRRMLT_XMLP_PKG.customer_address_stringformula(substrb ( party.party_name , 1 , 50 ), loc2.address1, loc2.address2, loc2.address3, loc2.address4, loc2.city, loc2.state, loc2.postal_code, loc2.country) customer_address_string from hz_cust_accounts cust, hz_parties party, ra_cust_trx_types type, ra_customer_trx trx, hz_cust_acct_sites ad, hz_party_sites party_site, hz_locations loc, hz_cust_site_uses su, hz_cust_acct_sites ad2, hz_party_sites party_site2, hz_locations loc2, ar_transaction_history th where trx.set_of_books_id =:p_set_of_books_id and trx.cust_trx_type_id = type.cust_trx_type_id and type.type = 'BR' and trx.remit_to_address_id = ad.cust_acct_site_id (+) and ad.party_site_id = party_site.party_site_id(+) and loc.location_id(+) = party_site.location_id and cust.cust_account_id = trx.drawee_id and cust.party_id = party.party_id and type.signed_flag = 'Y' and su.site_use_id = trx.drawee_site_use_id and su.cust_acct_site_id = ad2.cust_acct_site_id and ad2.party_site_id = party_site2.party_site_id and loc2.location_id = party_site2.location_id and th.current_record_flag = 'Y' and th.status = 'PENDING_ACCEPTANCE' and th.customer_trx_id = trx.customer_trx_id &lp_customer_range &lp_creation_date &lp_customer_number_range ORDER BY cust_name, cust_address4, cust_address1, cust_address2, cust_address3, cust_postal_code, cust_state, cust_city, cust_country, remit_to_address3, remit_to_address1, remit_to_address2, remit_to_address4, remit_postal_code, remit_state, remit_city, remit_country, currency_code, br_date, br_number, br_amount, party.party_name AR ARBRRMLT_XML AR AR خطابات تذكرة أوراق القبض (بتنسيق XML) Imported from BI Publisher Description: خطابات تذكير أوراق القبض Application: المقبوضات Source: خطابات تذكرة أوراق القبض (بتنسيق XML) Short Name: ARBRRMLT_XML DB package: AR_ARBRRMLT_XMLP_PKG D AR Mahnschreiben Wechselforderung Imported from BI Publisher Description: Mahnschreiben Wechselforderung Application: Debitoren Source: Mahnschreiben Wechselforderung (XML) Short Name: ARBRRMLT_XML DB package: AR_ARBRRMLT_XMLP_PKG E AR Cartas de Aviso de Vencimiento de Efecto Imported from BI Publisher Description: Cartas de aviso de vencimiento de efecto Application: Receivables Source: Cartas de Aviso de Vencimiento de Efecto (XML) Short Name: ARBRRMLT_XML DB package: AR_ARBRRMLT_XMLP_PKG F AR Lettres de rappel des effets à recevoir Imported from BI Publisher Description: Lettres de rappel des effets à recevoir Application: Receivables Source: Lettres de rappel des effets à recevoir (XML) Short Name: ARBRRMLT_XML DB package: AR_ARBRRMLT_XMLP_PKG I AR Lettere promemoria transazioni d'incasso Imported from BI Publisher Description: Lettere promemoria per le transazioni d'incasso Application: Receivables Source: Lettere promemoria transazioni d'incasso (XML) Short Name: ARBRRMLT_XML DB package: AR_ARBRRMLT_XMLP_PKG JA AR 受取手形督促状 Imported from BI Publisher Description: 受取手形督促状 Application: Receivables Source: 受取手形督促状(XML) Short Name: ARBRRMLT_XML DB package: AR_ARBRRMLT_XMLP_PKG KO AR 받을 어음 알림장 Imported from BI Publisher Description: 받을 어음 알림장 Application: Receivables Source: 받을 어음 알림장(XML) Short Name: ARBRRMLT_XML DB package: AR_ARBRRMLT_XMLP_PKG PTB AR Cartas de Lembrete dos Títulos a Receber Imported from BI Publisher Description: Cartas de Lembrete dos Títulos a Receber Application: Receivables Source: Cartas de Lembrete dos Títulos a Receber (XML) Short Name: ARBRRMLT_XML DB package: AR_ARBRRMLT_XMLP_PKG RU AR Письма-напоминания о траттах к получению Imported from BI Publisher Description: Письма-напоминания о дебиторской задолженности Application: Дебиторы Source: Письма-напоминания о траттах к получению (XML) Short Name: ARBRRMLT_XML DB package: AR_ARBRRMLT_XMLP_PKG S AR Påminnelsebrev om växelfordringar Imported from BI Publisher Description: Påminnelsebrev om växelfordringar Application: Receivables Source: Påminnelsebrev om växelfordringar (XML) Short Name: ARBRRMLT_XML DB package: AR_ARBRRMLT_XMLP_PKG TR AR Alacak Hesabı Anımsatıcı Mektupları Imported from BI Publisher Description: Alacak Hesabı Anımsatıcı Mektupları Application: Alacaklar Muhasebesi Source: Alacak Hesabı Anımsatıcı Mektupları (XML) Short Name: ARBRRMLT_XML DB package: AR_ARBRRMLT_XMLP_PKG US AR Bills Receivable Reminder Letters Imported from BI Publisher Description: Bills Receivable Reminder Letters Application: Receivables Source: Bills Receivable Reminder Letters (XML) Short Name: ARBRRMLT_XML DB package: AR_ARBRRMLT_XMLP_PKG ZHS AR 应收票据催函 Imported from BI Publisher Description: 应收票据催函 Application: 应收帐款 Source: 应收票据催函 (XML) Short Name: ARBRRMLT_XML DB package: AR_ARBRRMLT_XMLP_PKG BI Publisher &lp_creation_date &lp_customer_number_range &lp_customer_range :c_listnum :c_location :c_our_sob_name :c_our_street :c_our_zipcity :lp_creation_date :lp_creation_date_from :lp_creation_date_range :lp_creation_date_to :lp_customer_number_range :lp_customer_range :lp_days_late_since_creation :lp_drawee_name_from :lp_drawee_name_to :lp_drawee_number_from :lp_drawee_number_to :operating_unit :p_conc_request_id :p_creation_date_from :p_creation_date_to :p_days_late_since_creation :p_default_country :p_default_country_description :p_drawee_name_from :p_drawee_name_to :p_drawee_number_from :p_drawee_number_to :p_print_home_country_flag :p_set_of_books_id 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 AR معرف دفتر الأستاذ معرف دفتر الأستاذ D Buchkennung Buchkennung E Id Libro Mayor Identificador de 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_creation_date_from Date sysdate AR تاريخ التكوين من تاريخ التكوين من D Von Erstellungsdatum Von Erstellungsdatum E De Fecha de Creación De Fecha de Creación F Date de création - Du Date de création - Du I Data creazione - Da Data creazione - Da JA 作成日:自 作成日:自 KO 생성일자: 부터 생성일자: 부터 PTB Data de Criação - De Data de Criação - De RU Дата создания с Дата создания с S Från skapandedatum Från skapandedatum TR Oluşturma Başlangıç Tarihi Oluşturma Başlangıç Tarihi US Creation Date From Creation Date From ZHS 创建日期自 创建日期自 4 20 :p_creation_date_to Date sysdate AR تاريخ التكوين إلى تاريخ التكوين إلى D Bis Erstellungsdatum Bis Erstellungsdatum E A Fecha de Creación A Fecha de Creación F Date de création - Au Date de création - Au I Data creazione - A Data creazione - A JA 作成日:至 作成日:至 KO 생성 일자: 까지 생성 일자: 까지 PTB Data de Criação - Até Data de Criação - Até RU Дата создания по Дата создания по S Till skapandedatum Till skapandedatum TR Oluşturma Bitiş Tarihi Oluşturma Bitiş Tarihi US Creation Date To Creation Date To ZHS 创建日期至 创建日期至 5 30 :p_days_late_since_creation Number AR أيام التأخير منذ التكوين أيام التأخير منذ التكوين D Tage Verzug seit Erstellung Tage Verzug seit Erstellung E Días de Demora desde la Creación Días de Demora desde la Creación F Jours de retard depuis création Jours de retard depuis création I Giorni di ritardo dalla creazione Giorni di ritardo dalla creazione JA 作成日からの遅延日数 作成日からの遅延日数 KO 생성 이후 지연 일수 생성 이후 지연 일수 PTB Dias de Atraso Desde a Criação Dias de Atraso Desde a Criação RU Число дней просрочки со времени создания Число дней просрочки со времени создания S Förseningsdagar efter generering Förseningsdagar efter generering TR Oluşturmadan Bu Yana Gecikme Gün Sayısı Oluşturmadan Bu Yana Gecikme Gün Sayısı US Days Late Since Creation Days Late Since Creation ZHS 创建后的延迟天数 创建后的延迟天数 6 40 :p_drawee_name_from LOV Oracle AR_BR_DRAWEE_NAME Y select party.party_name id, party.party_name value, null description from hz_cust_accounts c,hz_parties party,hz_cust_acct_sites a,hz_cust_site_uses s where c.party_id=party.party_id and c.cust_account_id=a.cust_account_id and a.cust_acct_site_id=s.cust_acct_site_id and s.site_use_code='DRAWEE' order by value,description AR اسم المحول عليه من اسم المحول عليه من D Von Bezogener Von Bezogener E De Nombre de Librado De Nombre de Librado F Nom de tiré - De Nom de tiré - De I Nome trattario - Da Nome trattario - Da JA 名宛人名:自 名宛人名:自 KO 어음 지급인명: 부터 어음 지급인명: 부터 PTB Nome do Sacado - De Nome do Sacado - De RU Имя трассата с Имя трассата с S Från trassatnamn Från trassatnamn TR İlk Havale Alanın Adı İlk Havale Alanın Adı US Drawee Name From Drawee Name From ZHS 付款人名称自 付款人名称自 7 50 :p_drawee_name_to LOV Oracle AR_BR_DRAWEE_NAME Y select party.party_name id, party.party_name value, null description from hz_cust_accounts c,hz_parties party,hz_cust_acct_sites a,hz_cust_site_uses s where c.party_id=party.party_id and c.cust_account_id=a.cust_account_id and a.cust_acct_site_id=s.cust_acct_site_id and s.site_use_code='DRAWEE' order by value,description AR اسم المحول عليه إلى اسم المحول عليه إلى D Bis Bezogener Bis Bezogener E A Nombre de Librado A Nombre de Librado F Nom de tiré - A Nom de tiré - A I Nome trattario - A Nome trattario - A JA 名宛人名:至 名宛人名:至 KO 어음 지급인명: 까지 어음 지급인명: 까지 PTB Nome do Sacado - Até Nome do Sacado - Até RU Имя трассата по Имя трассата по S Till trassatnamn Till trassatnamn TR Son Havale Alanın Adı Son Havale Alanın Adı US Drawee Name To Drawee Name To ZHS 付款人名称至 付款人名称至 8 60 :p_drawee_number_from LOV Oracle AR_BR_DRAWEE_NUMBER Y select c.account_number id, c.account_number value, null description from hz_cust_accounts c,hz_parties party,hz_cust_acct_sites a,hz_cust_site_uses s where c.party_id=party.party_id c.cust_account_id=a.cust_account_id and a.cust_acct_site_id=s.cust_acct_site_id and s.site_use_code='DRAWEE' order by value,description AR رقم المحول عليه من رقم المحول عليه من D Von Nummer Bezogener Von Nummer Bezogener E De Número de Librado De Número de Librado F Numéro de tiré - De Numéro de tiré - De I Numero trattario - Da Numero trattario - Da JA 名宛人番号:自 名宛人番号:自 KO 어음 지급인 번호: 부터 어음 지급인 번호: 부터 PTB Número do Sacado - De Número do Sacado - De RU Номер трассата с Номер трассата с S Från trassatnummer Från trassatnummer TR İlk Havale Alanın Numarası İlk Havale Alanın Numarası US Drawee Number From Drawee Number From ZHS 付款人编号自 付款人编号自 9 70 :p_drawee_number_to LOV Oracle AR_BR_DRAWEE_NUMBER Y select c.account_number id, c.account_number value, null description from hz_cust_accounts c,hz_parties party,hz_cust_acct_sites a,hz_cust_site_uses s where c.party_id=party.party_id c.cust_account_id=a.cust_account_id and a.cust_acct_site_id=s.cust_acct_site_id and s.site_use_code='DRAWEE' order by value,description AR رقم المحول عليه إلى رقم المحول عليه إلى D Bis Nummer Bezogener Bis Nummer Bezogener E A Número de Librado A Número de Librado F Numéro de tiré - A Numéro de tiré - A I Numero trattario - A Numero trattario - A JA 名宛人番号:至 名宛人番号:至 KO 어음 지급인 번호: 까지 어음 지급인 번호: 까지 PTB Número do Sacado - Até Número do Sacado - Até RU Номер трассата по Номер трассата по S Till trassatnummer Till trassatnummer TR Son Havale Alanın Numarası Son Havale Alanın Numarası US Drawee Number To Drawee Number To ZHS 付款人编号至 付款人编号至