ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEAF79D2E0530100007F1FF2 AR Period Y select gps.period_name value, xxen_util.meaning(gps.closing_status,'CLOSING_STATUS',222)||': '||gps.start_date||' - '||gps.end_date description from gl_period_statuses gps where gps.ledger_id= ( select asp.set_of_books_id from ar_system_parameters asp where (:$flex$.ledger is null or asp.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and (:$flex$.operating_unit is null or asp.set_of_books_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and rownum=1 ) and gps.start_date<=sysdate+400 and gps.application_id=222 order by gps.start_date desc AR فترة AR السابقة لدفتر الأستاذ الحالي لتسجيل الدخول D Vergangene AR-Periode des aktuellen Login-Ledgers E Periodo AR pasado del libro de registro actual F Période AR passée du registre de connexion actuel I Periodo AR passato del libro mastro del login corrente JA 現在のログイン帳の過去のAR期間 KO 현재 로그인 원장의 과거 AR 기간 PTB Período AR passado do registro de login atual RU Прошедший период АР текущей регистрационной книги S Senaste AR-perioden för den aktuella inloggningsboken TR Mevcut giriş defterinin geçmiş AR dönemi US Past AR period of the current login ledger ZHS 当前登录分类账的过去AR期 F26C78167A214EFBE0530100007F336B GL Balancing Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and (fifsgv.application_id, fifsgv.id_flex_code, fifsgv.id_flex_num, fifsgv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='GL_BALANCING' and fsav.attribute_value='Y') and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and (:$flex$.chart_of_accounts_id is not null or :$flex$.chart_of_accounts is not null or :$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null or :$flex$.book is not null) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( fifsv.id_flex_num=:$flex$.chart_of_accounts_id or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or (:$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null) and fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (:$flex$.operating_unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) or fifsgv.id_flex_num in (select fbc.accounting_flex_structure from fa_book_controls fbc where xxen_util.contains(:$flex$.book,fbc.book_type_code)='Y') ) ) order by ffvv.flex_value US B581C79E6D7AE63DE0530100007FE14A GL Ledger (restricted by AR System Parameters) Y select gl.name value, fifsv.id_flex_structure_name||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where gl.ledger_id in (select asp.set_of_books_id from ar_system_parameters asp) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, gl.name AR دفاتر الأستاذ مقيدة بمعلمات النظام ar D Ledger eingeschränkt durch ar-Systemparameter E Libros mayores restringidos por los parámetros del sistema ar F Les grands livres sont limités par les paramètres du système ar I Libri mastri limitati da parametri di sistema JA ARシステムパラメータで制限された帳票 KO AR 시스템 매개 변수에 의해 제한되는 원장 PTB Ledgers restringidos por parâmetros do sistema ar RU Леджеры ограничены параметрами системы ar S Ledgers begränsade av ar-systemparametrar TR Ar sistem parametreleri ile kısıtlanmış defterler US Ledgers restricted by ar system parameters ZHS 受人工智能系统参数限制的分类账 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）限制的操作单元。 B27680573AE27805E0530100007F14D6Y select trx.c_ledger "Ledger" , trx.c_balancing "Balancing Segment" , trx.c_account "Account Segment" , trx.c_flexdata "Accounting Flexfield" , trx.c_desc_all "Accounting Flexfield Desc." &lp_report_format_cols from ( select ps.c_ccid , ps.c_balancing , ps.c_account , ps.c_flexdata , ps.c_cust_name , ps.c_cust_number , ps.c_cust_city , ps.c_trx_id , ps.c_pay_id , ps.c_trx_number , ps.c_inv_type , ps.c_inv_date , ps.c_due_date , ps.c_curr , ps.c_pay_amount , ps.c_exchange_rate , ps.c_type , ps.c_revaluate_yes_no , ps.c_inv_gl_posted_date , ps.c_previous_cust_trx_id , ps.c_trx_length , ps.c_ledger , ps.c_operating_unit , ps.c_desc_all -- , ps.c_eop_rate , ps.c_receiptsformula , ps.c_adjustformula , ps.c_cmformula , ps.c_cm1formula -- , (nvl(ps.c_pay_amount,0) - nvl(ps.c_receiptsformula,0) + nvl(ps.c_adjustformula,0) - nvl(ps.c_cmformula,0) + nvl(ps.c_cm1formula,0)) c_open_orig , case when ps.p_minimum_accountable_unit is null then round(((nvl(ps.c_pay_amount,0) - nvl(ps.c_receiptsformula,0) + nvl(ps.c_adjustformula,0) - nvl(ps.c_cmformula,0) + nvl(ps.c_cm1formula,0)) * ps.c_exchange_rate),ps.p_precision) else round(((nvl(ps.c_pay_amount,0) - nvl(ps.c_receiptsformula,0) + nvl(ps.c_adjustformula,0) - nvl(ps.c_cmformula,0) + nvl(ps.c_cm1formula,0)) * ps.c_exchange_rate) / ps.p_minimum_accountable_unit) * ps.p_minimum_accountable_unit end calc_open_func -- , case when ps.p_minimum_accountable_unit is null then round(((nvl(ps.c_pay_amount,0) - nvl(ps.c_receiptsformula,0) + nvl(ps.c_adjustformula,0) - nvl(ps.c_cmformula,0) + nvl(ps.c_cm1formula,0)) * ps.c_eop_rate),ps.p_precision) else round(((nvl(ps.c_pay_amount,0) - nvl(ps.c_receiptsformula,0) + nvl(ps.c_adjustformula,0) - nvl(ps.c_cmformula,0) + nvl(ps.c_cm1formula,0)) * ps.c_eop_rate) / ps.p_minimum_accountable_unit) * ps.p_minimum_accountable_unit end calc_eop_amount -- -- , case -- when ps.c_eop_rate is null -- then to_number(null) -- when ps.c_eop_rate < ps.c_exchange_rate -- then (nvl(ps.c_pay_amount,0) - nvl(ps.c_receiptsformula,0) + nvl(ps.c_adjustformula,0) - nvl(ps.c_cmformula,0) + nvl(ps.c_cm1formula,0)) * ps.c_eop_rate -- else (nvl(ps.c_pay_amount,0) - nvl(ps.c_receiptsformula,0) + nvl(ps.c_adjustformula,0) - nvl(ps.c_cmformula,0) + nvl(ps.c_cm1formula,0)) * ps.c_exchange_rate -- end calc_open_rev , case when ps.c_eop_rate is null then to_number(null) else case when ps.p_minimum_accountable_unit is null then round((((nvl(ps.c_pay_amount,0) - nvl(ps.c_receiptsformula,0) + nvl(ps.c_adjustformula,0) - nvl(ps.c_cmformula,0) + nvl(ps.c_cm1formula,0)) * ps.c_eop_rate) - ((nvl(ps.c_pay_amount,0) - nvl(ps.c_receiptsformula,0) + nvl(ps.c_adjustformula,0) - nvl(ps.c_cmformula,0) + nvl(ps.c_cm1formula,0)) * ps.c_exchange_rate)),ps.p_precision) else round((((nvl(ps.c_pay_amount,0) - nvl(ps.c_receiptsformula,0) + nvl(ps.c_adjustformula,0) - nvl(ps.c_cmformula,0) + nvl(ps.c_cm1formula,0)) * ps.c_eop_rate) - ((nvl(ps.c_pay_amount,0) - nvl(ps.c_receiptsformula,0) + nvl(ps.c_adjustformula,0) - nvl(ps.c_cmformula,0) + nvl(ps.c_cm1formula,0)) * ps.c_exchange_rate)) / ps.p_minimum_accountable_unit) * ps.p_minimum_accountable_unit end end calc_open_rev from (select dist.code_combination_id c_ccid , fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', cc.chart_of_accounts_id, NULL, cc.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE') c_balancing , fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_acc_seg', 'SQLGL', 'GL#', cc.chart_of_accounts_id, NULL, cc.code_combination_id, 'GL_ACCOUNT', 'Y', 'VALUE') c_account , fnd_flex_xml_publisher_apis.process_kff_combination_1('p_flexdata', 'SQLGL', 'GL#', cc.chart_of_accounts_id, NULL, cc.code_combination_id, 'ALL', 'Y', 'VALUE') c_flexdata , substrb(party.party_name,1,50) c_cust_name , cust.account_number c_cust_number , loc.city c_cust_city , trx.customer_trx_id c_trx_id , pay.payment_schedule_id c_pay_id , ltrim(rtrim(trx.trx_number)) c_trx_number , typ.name c_inv_type , trx.trx_date c_inv_date , pay.due_date c_due_date , pay.invoice_currency_code c_curr , pay.amount_due_original c_pay_amount , nvl(trx.exchange_rate,1.00) c_exchange_rate , typ.type c_type , typ.global_attribute1 c_revaluate_yes_no , dist.gl_posted_date c_inv_gl_posted_date , nvl(previous_customer_trx_id,0) c_previous_cust_trx_id , length(ltrim(rtrim(nvl(to_char(doc_sequence_value),trx.trx_number)))) c_trx_length , sob.name c_ledger , fc.precision p_precision , fc.minimum_accountable_unit p_minimum_accountable_unit , haouv.name c_operating_unit , fnd_flex_xml_publisher_apis.process_kff_combination_1('c_desc_all', 'SQLGL', 'GL#', cc.chart_of_accounts_id, NULL, cc.code_combination_id, 'ALL', 'Y', 'DESCRIPTION') c_desc_all -- , case when pay.invoice_currency_code = sob.currency_code then 1 when typ.type = 'DEP' then nvl (trx.exchange_rate,1) when :p_rate_type_lookup = 'PERIOD' then (select /*+ push_pred */ decode(tr.eop_rate, 0,0, 1/tr.eop_rate) from gl_translation_rates tr where tr.set_of_books_id = sob.set_of_books_id and tr.to_currency_code = pay.invoice_currency_code and upper(tr.period_name) = upper(:p_revaluation_period) and tr.actual_flag = 'A' ) else case when gl_currency_api.get_rate_sql(pay.invoice_currency_code,sob.currency_code,:p_rate_date,:p_daily_rate_type) < 0 then null else gl_currency_api.get_rate_sql(pay.invoice_currency_code,sob.currency_code,:p_rate_date,:p_daily_rate_type) end end c_eop_rate -- , case when :p_cleared = 'N' then (select /*+ push_pred */ sum(nvl(app2.amount_applied,0) + nvl(app2.earned_discount_taken,0) + nvl(app2.unearned_discount_taken,0)) receipt_amt from ar_receivable_applications app2 where app2.applied_payment_schedule_id = pay.payment_schedule_id and app2.status = 'APP' and app2.gl_date <= gps.end_date and app2.application_type='CASH' and not exists (select 'reversed' from ar_cash_receipt_history crh where app2.cash_receipt_id = crh.cash_receipt_id and crh.status = 'REVERSED' and crh.gl_date <= gps.end_date ) ) else (select /*+ push_pred */ sum(nvl(app2.amount_applied,0) + nvl(app2.earned_discount_taken,0) + nvl(app2.unearned_discount_taken,0)) receipt_amt from ar_receivable_applications app2 where app2.applied_payment_schedule_id = pay.payment_schedule_id and app2.status = 'APP' and app2.gl_date <= gps.end_date and app2.application_type='CASH' and exists (select 'cleared cleared receipt' from ar_cash_receipt_history crh where app2.cash_receipt_id = crh.cash_receipt_id and crh.status = 'CLEARED' and crh.gl_date <= gps.end_date and nvl(crh.reversal_gl_date,gps.end_date+1) > gps.end_date ) ) end c_receiptsformula -- , (select /*+ push_pred */ sum(adj2.amount) adjustment_amt from ar_adjustments adj2 where adj2.payment_schedule_id = pay.payment_schedule_id and adj2.gl_date <= gps.end_date and adj2.status = 'A' ) c_adjustformula -- , (select /*+ push_pred */ sum(nvl(app2.amount_applied,0)) cm_amt from ar_receivable_applications app2 where app2.applied_payment_schedule_id = pay.payment_schedule_id and app2.gl_date <= gps.end_date and app2.status ='APP' and app2.application_type = 'CM' ) c_cmformula -- , (select /*+ push_pred */ sum(nvl(app2.amount_applied,0)) cm_amt from ar_receivable_applications app2 where app2.payment_schedule_id = pay.payment_schedule_id and app2.gl_date <= gps.end_date and (app2.status ='APP' or (app2.status='ACTIVITY' and app2.applied_payment_schedule_id = -8)) and app2.application_type = 'CM' ) c_cm1formula from ra_cust_trx_types typ , hz_cust_accounts cust , hz_parties party , hz_locations loc , hz_cust_acct_sites acct_site , hz_party_sites party_site , hz_cust_site_uses site , gl_code_combinations cc , gl_sets_of_books sob , fnd_currencies fc , hr_all_organization_units_vl haouv , ra_customer_trx trx , ar_xla_ctlgd_lines_v dist , ar_payment_schedules pay , (select /*+ push_pred */ gps.set_of_books_id,gps.end_date from gl_period_statuses gps where gps.application_id = 222 and gps.period_name = :p_revaluation_period ) gps where 1=1 and pay.gl_date <= gps.end_date and cust.cust_account_id = pay.customer_id and cust.party_id = party.party_id and trx.customer_trx_id = pay.customer_trx_id and pay.customer_site_use_id = site.site_use_id(+) and site.cust_acct_site_id = acct_site.cust_acct_site_id(+) and acct_site.party_site_id = party_site.party_site_id(+) and party_site.location_id = loc.location_id(+) and dist.customer_trx_id = trx.customer_trx_id and dist.account_class = 'REC' and dist.latest_rec_flag = 'Y' and dist.account_set_flag = 'N' and trx.complete_flag = 'Y' and trx.set_of_books_id = sob.set_of_books_id and sob.currency_code = fc.currency_code and trx.org_id = haouv.organization_id and typ.cust_trx_type_id = pay.cust_trx_type_id and typ.org_id = pay.org_id and dist.code_combination_id = cc.code_combination_id and dist.set_of_books_id = sob.set_of_books_id and ar_arxinrev_xmlp_pkg.c_daily_rate_lookup_error_p = 'N' and gps.set_of_books_id = sob.set_of_books_id and case when :p_rate_type_lookup = 'DAILY' and (:p_daily_rate_type is null or :p_rate_date is null) then 'Y' else 'N' end = 'N' ) ps order by c_ledger , c_balancing , c_account , c_flexdata , c_ccid , c_cust_name , c_cust_number , c_cust_number , c_trx_length , c_trx_number , c_inv_gl_posted_date , c_revaluate_yes_no , c_inv_type , c_inv_date , c_due_date , c_trx_id , c_exchange_rate , c_type , c_pay_id , c_curr , c_pay_amount ) trx where trx.c_open_orig != 0 and (trx.c_type != 'CM' or (trx.c_type = 'CM' and trx.c_previous_cust_trx_id = 0)) &lp_group_by_cols AR #,##0.00;[Red]-#,##0.00 AR AR Open Items Revaluation Imported from BI Publisher Description: تقرير إعادة تقييم البنود المفتوحة Application: المقبوضات Source: تقرير إعادة تقييم البنود المفتوحة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: ARXINREV_XML DB package: AR_ARXINREV_XMLP_PKG D AR Open Items Revaluation Imported from BI Publisher Description: Auswertung "Offene Posten - Neubewertung" Application: Debitoren Source: Offene Posten - Neubewertung (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: ARXINREV_XML DB package: AR_ARXINREV_XMLP_PKG E AR Open Items Revaluation Importado de BI Publisher Descripción: Informe de revalorización de partidas abiertas Aplicación: Cuentas por cobrar Fuente: Informe de revalorización de partidas abiertas (XML) Nombre corto: ARXINREV_XML Paquete DB: AR_ARXINREV_XMLP_PKG F AR Open Items Revaluation Imported from BI Publisher Description: Etat de réévaluation des mouvements non soldés Application: Receivables Source: Etat de réévaluation des mouvements non soldés (XML) - Non pris en charge : réservé en vue d'une utilisation future Short Name: ARXINREV_XML DB package: AR_ARXINREV_XMLP_PKG I AR Open Items Revaluation Imported from BI Publisher Description: Rapporto Rivalutazione voci aperte Application: Receivables Source: Rapporto Rivalutazione voci aperte (XML) - non supportato: riservato per usi futuri Short Name: ARXINREV_XML DB package: AR_ARXINREV_XMLP_PKG JA AR Open Items Revaluation BI Publisherからのインポート 内容を記載しています。オープンアイテム再評価報告書 申請書を提出する。売掛債権 出典はこちらです。オープンアイテム再評価報告書(XML) 短縮名。ARXINREV_XML DBパッケージです。AR_ARXINREV_XMLP_PKG KO AR Open Items Revaluation BI Publisher에서 가져옴 설명 : 미결 항목 재평가 보고서 신청 : AR 출처 : 미결 항목 재평가 보고서 (XML) 짧은 이름 : ARXINREV_XML DB 패키지 : AR_ARXINREV_XMLP_PKG PTB AR Open Items Revaluation Importado da editora BI Descrição: Relatório de reavaliação de partidas em aberto Aplicação: Contas a receber Fonte: Relatório de reavaliação de partidas em aberto (XML) Nome curto: ARXINREV_XML Pacote DB: AR_ARXINREV_XMLP_PKG RU AR Open Items Revaluation Импортировано из Издательства БИ Описание: Отчет о переоценке открытых позиций Приложение: Дебиторская задолженность Источник: Отчет о переоценке открытых позиций (XML) Короткое имя: ARXINREV_XML БД-пакет: AR_ARXINREV_XMLP_PKG S AR Open Items Revaluation Importerad från BI Publisher Beskrivning: Omvärderingsrapport om öppna artiklar Ansökan: Fordringar Källa: Revalueringsrapport om öppna poster (XML) Kort namn: ARXINREV_XML DB-paket: AR_ARXINREV_XMLP_PKG TR AR Open Items Revaluation BI Publisher'dan içe aktarıldı Açıklama: Kalemler Yeniden Değerleme Raporunu Aç Uygulama: Alacaklar Kaynak: Açık Öğeler Yeniden Değerleme Raporu (XML) Kısa isim: ARXINREV_XML DB paketi: AR_ARXINREV_XMLP_PKG US AR Open Items Revaluation Imported from BI Publisher Description: Open Items Revaluation Report Application: Receivables Source: Open Items Revaluation Report (XML) Short Name: ARXINREV_XML DB package: AR_ARXINREV_XMLP_PKG ZHS AR Open Items Revaluation Imported from BI Publisher Description: 未结项目重估报表 Application: 应收帐款 Source: 未结项目重估报表 (XML) - 不支持：已保留供将来使用 Short Name: ARXINREV_XML DB package: AR_ARXINREV_XMLP_PKG BI Publisher Enginatics R12 only &lp_group_by_cols &lp_report_format_cols 1=1 :p_cleared :p_daily_rate_type :p_rate_date :p_rate_type_lookup :p_revaluation_period 1 5 1=1 sob.name=:ledger LOV GL Ledger (restricted by AR System Parameters) B581C79E6D7AE63DE0530100007FE14A Y select gl.name value, fifsv.id_flex_structure_name||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where gl.ledger_id in (select asp.set_of_books_id from ar_system_parameters asp) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, gl.name coalesce(xxen_util.default_ledger,xxen_util.previous_parameter_value(:parameter_id)) US Ledger 2 10 1=1 haouv.name=: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 coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) US Operating Unit 3 20 &lp_report_format_cols , trx.c_operating_unit "Operating Unit" , trx.c_cust_name "Customer Name" , trx.c_cust_number "Customer Number" , trx.c_cust_city "Customer City" , trx.c_trx_number "Trx. Number" , trx.c_inv_type "Trx. Type" , trx.c_inv_date "Trx. Date" , trx.c_due_date "Due Date" , trx.c_curr "Currency" , trx.c_open_orig "Open Original Amount" , trx.c_exchange_rate "Exchange Rate" , trx.calc_open_func "Open Functional Amount (A)" , trx.c_eop_rate "Revaluation Rate" , trx.calc_eop_amount "Revaluation Open Amount (B)" , nvl(trx.calc_eop_amount ,0) - trx.calc_open_func "Diff (B-A)" , trx.calc_open_rev "Open Revalued Adjustment" , nvl2(trx.c_eop_rate,null,'Yes') "Missing Revaluation Rates" LOV Oracle AR_REPORT_TYPE Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='REPORT_TYPE_SD' and enabled_flag='Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) order by meaning,lookup_code D D Y US Report Format 4 &lp_report_format_cols , sum(trx.calc_open_func) "Open Functional Amount (A)" , sum(trx.calc_eop_amount) "Revaluation Open Amount (B)" , sum(nvl(trx.calc_eop_amount ,0) - trx.calc_open_func) "Diff (B-A)" , sum(trx.calc_open_rev) "Open Revalued Adjustment" , max(nvl2(trx.c_eop_rate,null,'Yes')) "Missing Revaluation Rates" S US Report Format 5 &lp_group_by_cols select null from dual D US Report Format 6 &lp_group_by_cols group by trx.c_ledger , trx.c_balancing , trx.c_account , trx.c_flexdata , trx.c_desc_all S US Report Format 7 30 :p_revaluation_period LOV AR Period 8E2FF36EDEAF79D2E0530100007F1FF2 Y select gps.period_name value, xxen_util.meaning(gps.closing_status,'CLOSING_STATUS',222)||': '||gps.start_date||' - '||gps.end_date description from gl_period_statuses gps where gps.ledger_id= ( select asp.set_of_books_id from ar_system_parameters asp where (:$flex$.ledger is null or asp.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and (:$flex$.operating_unit is null or asp.set_of_books_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and rownum=1 ) and gps.start_date<=sysdate+400 and gps.application_id=222 order by gps.start_date desc Y US Revaluation Period Revaluation Period 8 40 1=1 pay.due_date <=:p_up_to_due_date Date US Include Up To Due Date Include Up To Due Date 9 50 :p_rate_type_lookup LOV Oracle AR_SRS_ARXINREV_RATE_TYPE Y select lookup_code id, lookup_code value, meaning description from ar_lookups where lookup_type='ARXINREV_RATE_TYPE' order by value,description select lookup_code from ar_lookups where lookup_type = 'ARXINREV_RATE_TYPE' and lookup_code = 'PERIOD' Y US Rate Type Rate Type 10 60 :p_daily_rate_type LOV Oracle AR_SRS_ARXINREV_DAILY_RATE_TYPE Y select conversion_type id, user_conversion_type value, description description from gl_daily_conversion_types where conversion_type<>'User' order by upper (user_conversion_type) US Daily Rate Type Daily Rate Type 11 70 :p_rate_date Date US Daily Rate Date Daily Rate Date 12 80 1=1 fnd_flex_xml_publisher_apis.process_kff_combination_1('bs', 'SQLGL', 'GL#', cc.chart_of_accounts_id, NULL, cc.code_combination_id,'GL_BALANCING','N','VALUE') >= :p_bal_segment_low LOV GL Balancing F26C78167A214EFBE0530100007F336B Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and (fifsgv.application_id, fifsgv.id_flex_code, fifsgv.id_flex_num, fifsgv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='GL_BALANCING' and fsav.attribute_value='Y') and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and (:$flex$.chart_of_accounts_id is not null or :$flex$.chart_of_accounts is not null or :$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null or :$flex$.book is not null) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( fifsv.id_flex_num=:$flex$.chart_of_accounts_id or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or (:$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null) and fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (:$flex$.operating_unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) or fifsgv.id_flex_num in (select fbc.accounting_flex_structure from fa_book_controls fbc where xxen_util.contains(:$flex$.book,fbc.book_type_code)='Y') ) ) order by ffvv.flex_value US Balancing Segment Low Balancing Segment Low 13 90 1=1 fnd_flex_xml_publisher_apis.process_kff_combination_1('bs', 'SQLGL', 'GL#', cc.chart_of_accounts_id, NULL, cc.code_combination_id,'GL_BALANCING','N','VALUE') <= :p_bal_segment_high LOV GL Balancing F26C78167A214EFBE0530100007F336B Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and (fifsgv.application_id, fifsgv.id_flex_code, fifsgv.id_flex_num, fifsgv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='GL_BALANCING' and fsav.attribute_value='Y') and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and (:$flex$.chart_of_accounts_id is not null or :$flex$.chart_of_accounts is not null or :$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null or :$flex$.book is not null) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( fifsv.id_flex_num=:$flex$.chart_of_accounts_id or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or (:$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null) and fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (:$flex$.operating_unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) or fifsgv.id_flex_num in (select fbc.accounting_flex_structure from fa_book_controls fbc where xxen_util.contains(:$flex$.book,fbc.book_type_code)='Y') ) ) order by ffvv.flex_value :$flex$.Balancing_Segment_Low US Balancing Segment High Balancing Segment High 14 100 :p_posted LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y Y US Transferred To GL only Transferred To GL Only 15 1=1 'y'='y' N US Transferred To GL only 16 1=1 dist.gl_posted_date is not null Y US Transferred To GL only 17 110 :p_cleared LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y Y US Cleared only Cleared Only 18 1=1 pay.gl_date_closed > gps.end_date N US Cleared only 19 1=1 ( ( pay.gl_date_closed > gps.end_date ) or exists ( select 'receipt clear after p_end_date' from ar_receivable_applications_all app , ar_cash_receipt_history_all crh where trx.customer_trx_id = app.applied_customer_Trx_id and app.cash_receipt_id = crh.cash_receipt_id and crh.status <> 'CLEARED' and crh.gl_date <=gps.end_date and nvl ( crh.reversal_gl_date , gps.end_date + 1 ) > gps.end_date ) ) Y US Cleared only :$flex$.Balancing_Segment_Low Balancing Segment Low Balancing Segment High :$flex$.ledger Ledger Balancing Segment High :$flex$.ledger Ledger Balancing Segment Low :$flex$.ledger Ledger Operating Unit :$flex$.ledger Ledger Revaluation Period :$flex$.operating_unit Operating Unit Balancing Segment High :$flex$.operating_unit Operating Unit Balancing Segment Low :$flex$.operating_unit Operating Unit Revaluation Period C9CCCFD1C867EFEB04F2185842816DA2 Default Y SYSADMIN 3 Account Segment 4 Accounting Flexfield 5 Accounting Flexfield Desc. 2 Balancing Segment 14 Currency 9 Customer City 7 Customer Name 8 Customer Number 20 Diff (B-A) 13 Due Date 16 Exchange Rate 1 Ledger 22 Missing Revaluation Rates 17 Open Functional Amount (A) 15 Open Original Amount 21 Open Revalued Adjustment 6 Operating Unit 19 Revaluation Open Amount (B) 18 Revaluation Rate 12 Trx. Date 10 Trx. Number 11 Trx. Type AR Open Items Revaluation - Default Template.xlsx US UEsDBBQAAAAIAKpy2lyQ7xzWmgEAAG0HAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbM2V30/CMBDH3038H5a+mq2AiTGGwQPqoxLFP6CsB2vY2qZXEP57bx34g0yQgNGXtVt79/20d7vr9pdlES3AoTI6Ze2kxSLQmZFKT1P2MrqPr1mEXmgpCqMhZStA1u+dn3VHKwsYkbXGlOXe2xvOMcuhFJgYC5pWJsaVwtOrm3IrspmYAu+0Wlc8M9qD9rGvfLBe9xYmYl746G5Jn2sSBwWyaFBvrLRSJqwtVCY8rfOFllsq8VohIcuwB3Nl8YIwGG9UqFa+F1jbPdLVOCUhGgrnH0RJGHxZ8FfjZmNjZsluJw2UZjJRGUiTzUs6WILWgZCYA/iySMKYlELpDfcO/bAZeRjaJwapzhccH8jR+Sccl3/EYdXC+IGg34B/TCm7lVZVSp46TE0aeyLWSPgEmXESfw9vLbCHzVP1AB6ex6MEN3sE0a8KwBPnSu10n3IuHMhn76jOnhzgs++fpMNIjIm4ztgwP/72v9a1D8+7cKgoDp2xSO3BweFB2dT/yjq25AicV7sD8a5IreVwwa1SDlXzkiAbtHlolr03UEsDBBQAAAAIAKpy2ly1VTAj7gAAAEwCAAALAAAAX3JlbHMvLnJlbHONks9OwzAMxu9IvEPk++puSAihpbtMSLshVB7AJO4ftY2jJED39oQDgkpj29H2588/W97u5mlUHxxiL07DuihBsTNie9dqeK2fVg+gYiJnaRTHGo4cYVfd3mxfeKSUm2LX+6iyi4saupT8I2I0HU8UC/HscqWRMFHKYWjRkxmoZdyU5T2Gvx5QLTzVwWoIB3sHqj76PPmytzRNb3gv5n1il06MQJ4TO8t25UNmC6nP26iaQstJgxXznNMRyfsiYwOeJtpcT/T/tjhxIkuJ0Ejg8zzfinNA6+uBLp9oqfi9zjzip4ThTWT4YcHFD1RfUEsDBBQAAAAIAKpy2lyz66gDnwEAAGIDAAAQAAAAZG9jUHJvcHMvYXBwLnhtbJ2TwW7bMAyG7wP2DoLujdxmKIZAVlG0GzpgQ4PG7c6cTMdCZcmQGCPZ00+2Ecdpe9qN5P+b/kRK8mbfWNZhiMa7nF8uMs7QaV8at835c/H94itnkcCVYL3DnB8w8hv1+ZNcB99iIIORpRYu5rwmaldCRF1jA3GRZJeUyocGKKVhK3xVGY33Xu8adCSusuxa4J7QlVhetFNDPnZcdfS/TUuve774UhzaBKxk4QlsYRpUmRSnRN62rTUaKJ1e/TI6+OgrYt/2Gq0Uc1Em6g3qXTB06HvMU7nRYPEu/VBVYCNKcSrIB4R+mGswISrZ0apDTT6waP6mcV5x9gci9pg57yAYcJRwe9uYDLFtIwX124fXWCNSlGIqDuHcO4/NF7UcDCk4Nw5fDSBJOEcsDFmMj9UaAn1AvJwTD2Aj78h4+8Qe097ZD8ImsifswO6G6c6RJ/fadJ4+ViBAg5Tu5buzHqnfcP407jU+t4W/B8LjHs6LclNDwDKtbtrTVJAPaQXB9k3uanBbLI+e90J/a17GJ6MurxfZMksXYlaT4vQ41D9QSwMEFAAAAAgAqnLaXMzuGzo2AQAAUQIAABEAAABkb2NQcm9wcy9jb3JlLnhtbI2SzWrDMBCE74W+g9HdlmWXEITtQFtyaqDQlJbehLRJRK0fJLVO3r6ynTgJ5NDj7sx+ml1ULfaqTX7BeWl0jUiWowQ0N0LqbY3e18t0jhIfmBasNRpqdACPFs39XcUt5cbBqzMWXJDgk0jSnnJbo10IlmLs+Q4U81l06ChujFMsxNJtsWX8m20BF3k+wwoCEyww3ANTOxHRESn4hLQ/rh0AgmNoQYEOHpOM4LM3gFP+5sCgXDiVDAcbdzrGvWQLPoqTe+/lZOy6LuvKIUbMT/Dn6uVtWDWVur8VB9RUglPugAXjmiqmPRfxcC3zYRVvvJEgHg9Rv9ETfIg7zoFIYgA6xj0pH+XT83qJmiIvypTkKSHrPKfFjBbkq3/yar4PNDbU8eF/Eh8omdNyfkE8Acbc15+g+QNQSwMEFAAAAAgAqnLaXE1B1tIaAQAAewQAABoAAAB4bC9fcmVscy93b3JrYm9vay54bWwucmVsc72UwUrEMBCG74LvEOZu03Z1Fdl0Dy7CXnV9gNBO27BtEjJxtW9vrNBaWOoeipfAzCT//zHMZLP9bBt2QkfKaAFJFANDnZtC6UrA2+H55gEYeakL2RiNAjok2GbXV5sXbKQPj6hWllhQ0SSg9t4+ck55ja2kyFjUoVIa10ofQldxK/OjrJCncbzm7rcGZBNNti8EuH2xAnbobHD+W9uUpcpxZ/L3FrU/Y8E/jDtSjeiDqHQVegFDinhfWUWBGPh5mPslYaiWDotX70KvaQSapOdg0iVhLuhMOgeT/DNMMgezXhKGfNeEoR8G5iees79b0t6HVcLRvQ95f8624HZJBqtOxj/JsNU7LJVW33s/Io1Vfu7igMknX0b2BVBLAwQUAAAACACqctpc4it/e7sAAAAzAQAAMgAAAHhsL3Bpdm90Q2FjaGUvX3JlbHMvcGl2b3RDYWNoZURlZmluaXRpb24xLnhtbC5yZWxzhY/BasMwEETvhf6D2HstO4dQiuUcEgK5BucDFmlti9haoVVC/PfRMaGFHodh3sy0u8cyqzsl8RwMNFUNioJl58No4NIfv75BScbgcOZABlYS2HWfH+2ZZswlJJOPogoliIEp5/ijtdiJFpSKI4XiDJwWzEWmUUe0VxxJb+p6q9MrA7o3pjo5A+nkGlD9Gkvz/2weBm/pwPa2UMh/VOjo75z3WOadyXJyUuCYRsoGfllNVaaD7lr9drV7AlBLAwQUAAAACACqctpcQZJjpcADAADwEAAAJwAAAHhsL3Bpdm90Q2FjaGUvcGl2b3RDYWNoZURlZmluaXRpb24xLnhtbO1YXW/iOhB9v9L+BytPuw8hH4RCELAKUCSkbiuVdt/dxIC3sY1sh5vqav/7HTuQZku3LQ9Fu6uVEBB7mJkzMz7jYfC5ZDnaEqmo4EMnaPkOIjwVGeWroXN7M3N7DlIa8wzngpOh80CU83n04Z/Bhm6FnuB0TaZkSTnVoACBMq6GzlrrTd/zFGwyrFpiQzjsLIVkWMOjXHlqIwnO1JoQzXIv9P0zj2HKnUpDX75Fh1guaUqmIi0Y4bpSIkmOjSdqTTdqr42lb1HHsLwvNm4q2AZU3NGc6ger1EEs7c9XXEh8l0MISrlXXB76yWgqhRJL3QJFXuXiAdogAke31MTcQbJPs6Ej51kA38lSErW+4hcCw+LjCsnGD0MnKfRagPWdGMmmWINDUScM/FY39OOwHcWddhc8pkpBCueaMHVBGdVDBzKbQtA1yb7u0w25rVU1Fxnl15UnBnG90zbiqZDZRBQcNIJ7pewXxv3/orA3afu9czdOprEbTc4St9dJxm5wFk/a08Dvdbvxd2c0SE3FLEQhU4L0wwa8/1fIe1sIsFt/30lwzECiegCs2PFGA6+hYqdvRkmeKZRWboXh3o5dR5WSC5KtCMSOF2zG9Bx89kEMEEqS2TDtfx6YZbQdOpeJNdcQ2Ru3epu2dzbGOMc8hbijBVmZonxfc0lqEZ/UmAE3y0m5NCE4CbwfLKIpUWnrBbt1gfwsR1cbIuF8A4xbIK33RTAplBaMSHQJJXgqUwW7e+86r3FNgCPfF9eNLFvo8gSYrKEbYKQT4DG03TQTdA6oiGtoh2pBGP1CS5IZx6CxGg4X1dal4BX7N9aqBaDlvdBCS9vIQQY4vdqGlua7fgCvG9/v2xfs4vLJbtjY3RGrYcbMMONzKo6kymlB0N8wOJNCSrhvHXWIbhfTYxsTkB5HV5KuKMc5SphpG80CjA574asF2KituibtOf2hAudcE+i7dg1K8CvOi6pmoeIeHxoFxk2B+ccCPC/TNeYrgq6fHK1TIzMwa2T2JO6uSqOBRRYci8ymblbw1Fxr6+Shj8mnXyiBr3bda7KFzNur+Z+XoiY4m67qgKGP498qR1O6XILP7u9VWTbgVQZIhpLsG9y5nl69T00CT+jt1dPxpZrWdjAeTwlMsC+NKz+/CDzDzWMYTe531FxTEnu5a1ejVjVdjQak1BdK209USApDXzfsJOdhAkNfFAdu1Lsj7jgcR250Po670cwMhNH3elgOooMx/E3Tsh97cfXvwGhQBlH/uX8eDA7wq3q3XnrPiY3+B1BLAwQUAAAACACqctpcGx56aQoBAACCAgAAJAAAAHhsL3Bpdm90Q2FjaGUvcGl2b3RDYWNoZVJlY29yZHMxLnhtbI2STWrDMBCF94XeQcw+llNKKcF2KC2Fbroo7QEUeWyLWhqhkY1z+yo1IQsH4t38PD7eG6bYT7YXIwY25ErYZjkIdJpq49oSfr7fN88gOCpXq54clnBEhn11f1d4M1J8VbrDL9QUahaJ5LiELka/k5LTxirOyKNLm4aCVTG1oZXsA6qaO8Roe/mQ50/SKuNgJuzCGgY1jdH4Rnqw6OIMCdirmHJwZzyfaVavwVkVfge/0WR9QhxMb+LxHwrC6t1H6yioQ5/yT+EMnpY+rdGBmJqYJZCcLS7Sbh+T0dGcDg5C0+BiujtURaiKSYwl5CBvVXzSfb7cFq4FrtW5KwYvs2vVhSxTQLn4muoPUEsDBBQAAAAIAKpy2lwKQQzqvQAAAEcBAAApAAAAeGwvcGl2b3RUYWJsZXMvX3JlbHMvcGl2b3RUYWJsZTEueG1sLnJlbHOFj8EKwjAMhu+C71Byt908iMg6D4rgVfQBQpdtxS0tbRV9e+ttA8FjyJ/vz1ftX+MgnhSidayhlAUIYuMay52G2/W02oKICbnBwTFpeFOEfb1cVBcaMOWj2FsfRaZw1NCn5HdKRdPTiFE6T5w3rQsjpjyGTnk0d+xIrYtio8KUAfWMKc6NhnBuShDXt8/N/9muba2hozOPkTj9qFDePl06YH7vSK1l+xXIfAwdJQ1STgI/s6XMOqDqSs306w9QSwMEFAAAAAgAqnLaXFIICkMwBgAAuykAAB4AAAB4bC9waXZvdFRhYmxlcy9waXZvdFRhYmxlMS54bWztWt1v2zYQfx+w/0HQU/egylIk2Q5sF7IVoQGyNWiz7pmRKJurJAoSlTgY9r/vSOrbyZovD0Oqh6bmibr78XhHkbzf4sM+iZUbnBeEpkvVeD9RFZwGNCTpdqn+fuVrM1UpGEpDFNMUL9U7XKgfVj//tMjIDWVX6DrGHo5IShgoUEBZWizVHWPZqa4XwQ4nqHhPM5zCk4jmCWLQzLd6keUYhcUOY5bEujmZOHqCSKpKDadJ8BglCcq/lZkW0CRDjFyTmLA7oUtVkuD0fJvSnONbqvu8VrzPDxQnJMhpQSP2HhTpNIpIgA/wGZae4xvCvQSq8tOShEv1r9nMnVnriadNHWOiWa6/1ub+zNfma8eZeY5nzmzzb1VJUQIgLhuHgUsDBL45Bx3GXFVQlsV3v5XJNc596aOlCvMgxGuah/eIfZqyg76XiDGcpwdyNybbNMH3vPEHCdnuIybbXavNUJUQMbRBGZ/SpfoVxSVMulJmIMbh1zpWYBQJST/jKMfFjvu5eXICIbOjt15O4liMpCywWzIqgTERWmCFMJxc5iRlV4TFGMYMsgDCYmCEpCFAF3rETAe93x5AFc+SMmYki7FPcBz6JAZPCDeuFjENIDwgOnMcLVXXOb0yAGFE8oJ9hCDE+Wd6K1QIEVcoBICmEWwoDMSAuMrp7SXa4g0tOSQOmMY9gb6SmSFgFPBYdDRNwNHKFbQnAI7/BVP9cdGSxYRnGgDiXnQrH5K0wDlbxyj9VsFbLbgHWxtggguUPX8XcIgGGA9xhMA5XKSLN1YLvGcXBRP/K2VOIJTNueWceTNHc42prVknJtJm7sbQHOtssrEtx5t6ZxDKMj33hvW8NJrM9blM9NUClJx2XBJBsHj0Nr1A1zgWwcDxAkD5V8DV2/6jO/lK939x5xiKVcY/J7Or/PxSXjPKkFgxB/40hqn9RvO4u74/tA7e6603u57xb8vjvg9jFD0/BR9avgrYoMFn+KEPqiKfj9/VzjZlDMPnh6EyOm90njw5wNHjP90Oj5H3iMhLy8RPmDi126rypA1K76T2o2zn/uWUO7ry6CfcMaWflNIWbPTGlH7BTUub0qMrH3NpxS9Zxbe+ukdsrzZf4Mk3exB+9D3puOzVy97DAfakde6NhdSYdt+/Tx8jp8qhl1YZfvDFqFOvgaIT1M76VTEoqK0WkTju1ldsTUuUf5qW2Wud9FpOrzXttWa91rzXMsTNXWuwb9Hom4SKYa+z1W/a/WYfhClLWc3whSfOu6W7Kb/fh4oYdBv+00FOulU8BSrYvJrIO977kJ8uew+vec0QSpd8n/HAe/e+MRBuc2ABdBTwAYlRrBZQBB3MbHdiNeFKvekk+vfGb7Xjl0OCiqTAqtzUx6RaLIbOxVJpLT6pxWKeuJjbq+BlcIl+iK+RKhHfg8GJfkcwOEmT09W+tFo062FTbOWIG2lV4Fc+Ac9B8cs04NVmFCtuwqu/yjv3Fygli30eVJCvUSHBLNWqxVGKe+bOodgREXVg4TO+gWq8rGYLa7WJdWMCyvIdExB7oiltQOP7NjwSRcq7tdaiBorCy1QKqBI7DhU3/LMsGOcjVG4xYexPMqC3EwIZLCkTdaldrClCpIT7SFzW8PQSlWMX2AWC3PApje+Ey7s7IbEUXNJCUFlkFQ4YAzgHPgxu1POwbKRwS1dPZFXoB5UHa36V/o2quo7N0cBvCfYANB/HUUGbvK4k2AmvB9o+NmjBuHhl0DyXj+ppyPNXB80XvKOCPkZ4NCwYkYivk3sWMFfmzhT+Nl5uPh2yNteka/c3fLXk7mSQhVU6wuOW4PaF3cX4PI1ol8klhL/ikJQJrI+cqQNHVMknklQmLgLe0FAEvb6wnGSc8FRRfKDXUHSBCgbiMuGkPD6Kw1PY3DHPfNszNHvjmpoVzE+02Zlvad7atzcT2zqZe5x8dgzGzpD21y9WAB+Q842EE3YkxJJAVnOqKjzwNRqwBO/l4eF9gLv8wIYT1DKXptbUdQzH0oyZ7WrWxNsAc8m1NX9i2IZpGxPPtlo/ZCEQLB5jechQNBwZL9XyHqM7iF++6wCNksc08IrhKGcp58WFNbOjaDwDE98IP6VXNOs8eYj2NFC/+gdQSwMEFAAAAAgAqnLaXMHu+u1LBAAAXBMAAA0AAAB4bC9zdHlsZXMueG1s5Vhtj+I2EP5eqf/Byn5tNi8kXEIJpwU20knXU9XdSpW6VWUSB6yzY+SYbWh1//3GToCwt7Asvd1WOj6APbafeewZzwwevq05Q/dEVlSUieVduhYiZSZyWs4T69fb1I4sVClc5piJkiTWmlTW29H33w0rtWbkZkGIQgBRVom1UGo5cJwqWxCOq0uxJCWMFEJyrKAr5061lATnlV7EmeO7bt/hmJZWgzDg2SkgHMuPq6WdCb7Eis4oo2ptsCzEs8G7eSkknjGgWnsBzlDt9aWParlRYqRf6OE0k6IShboEXEcUBc3Il3RjJ3ZwtkMC5POQvNBx/b291/JMpMCR5J5q81mjYbniKVcVysSqVInlb0WoGXmXg437gYUaq0xEDueU39mc8zt7vb5Di8WA80FVWc4GbG9luL/y4oeLC/fSdf9EP/7+C8n/uLM3kjukEZyWz2hYiHJHC/QbKww+luKvMtVDQAu46lmjYfU3uscMJK7GyAQTEinwKaDqGV6Yk2bGBDM6k1QLC8wpWzdiXwuMG7bzOAWnMIQaDc33TM96JV2P6ZHzWWKlqWs+r7GxF1BoDrSCE6WMbd0u0KYEwWgIN1QRWabQQW37dr0EQ5YQTBqDmHlPzJ5LvPb88PQFlWA01yzmE+M+7c6vr67T1MDM2gFa5qQmcCvgUmg6HcKnknuoq3VVcHJF9SV0L9/EcRx5/SiK4qDnBYHxz+cwMKcEpzwTModQvbne+so0otGQkUIBqqTzhf5VYql1CKUgnI2GOcVzUWKmt7hZ0TYANiOM3ehw/luxh10XncsPiUHbWkcQ3QRCbbPBazoav4vWYHdhe8D5+bioLrYKDq32dqx8C3VZbVcjvFyytQ44OpS0PdhJG1j2kD0T657a8APoDys+IzI1wfVR0Cb2fmXU4CTbPJPqMzGX9F6o8Qr8TZcR2hH2T7P/Esf5OMfecesfsvcBhsfRHhr8uE91+Ha89Qm+p3lrl/3J2AfYn6Sxsxe4bgfiwdGbd8XovOSkuYyjIeTypqvLUUUznckz6JImc9fF4cABJ/g6BExwg3DWiZl7EXMb+5AuUhLrg44EDMqdNnyh2YoySAuPREvAzOtO/I3gSEDwZG7cpJ9NPjkx/Tya6Ryj8NvTui0H2/qwew5Hxprq9l8VyN/ogR8vDl/Kpf8PZv66PnPmjp4ot1/q/P8bq7+2Vh08IJgr/QhhqupthoCUmZMCr5i63Q4m1q79E8npikM2bWf9rGsqA5FYu3YzK9ZJkdTqfQX/ZOEXrSRNrH+ux2/i6XXq25E7juygR0I7DsdTOwwm4+k0jV3fnXzqPIWc9+jg6ocQ83IDOdkLBhWD5xLZbrYlf7OTJVan817/QzEFogO0u9xjv+9ehZ5rpz3Xs4M+juyo3wvtNPT8aT8YX4dp2OEensfdcx3P25EPB4pywmi5sdXGQl0pGAm6Rzaht2Is4eyexUafAVBLAwQUAAAACACqctpcwofb8lEGAADXGwAAEwAAAHhsL3RoZW1lL3RoZW1lMS54bWztWU9v2zYUvw/YdyB0b2MnthMHdYrYsZutTRskboceaZmW2FCiQNJJfRva44ABw7phlwG77TBsK9ACu3SfJluHrQP6FfZISrYYM43Tpti/5hCL1I/v/3t8pK5cvZ8wdEiEpDxtBdXLlQCRNORDmkat4Ha/d2ktQFLhdIgZT0krmBAZXN14/70reF3FJCEI1qdyHbeCWKlsfWlJhjCN5WWekRTejbhIsIKhiJaGAh8B3YQtLVcqjaUE0zRAKU6A7K3RiIYE9Q1JeLuKLsFPtRJsFIy6DF6lSuqJkIl9zYa4q0+uGx5UNVpOZIcJdIhZKwD+Q37UJ/dVgBiWCl60gor5C5Y2rizh9XwRU6esLa3rmb98Xb5geLBseIpoMGVa7dWaq1tT+gbA1Dyu2+12utUpPQPAYQhaW1nKNGu9tWq7oFkC2cd52p1KvVJz8SX6K3P0m+12u97MZbFEDcg+1ubwa5VGbXPZwRuQxdfn5W9vdjoNB29AFt+Yw/dWm42aizegmNH0YA6t/Tn1zBQy4mzbC18D+FoRADMURMM00jSLEU/VInGX4Htc9ABsHI0VTZGaZGSEQ4j0Dk4GgmKtOV4nuPTGToVybkrzRTIUNFOt4MMMQ9bM6L189v3LZ0/Qy2ePjx88PX7w0/HDh8cPfrS0nIXbOI3KC198+9mfX3+M/njyzYtHX/jxsoz/9YdPfvn5cz8Qsmkm0fMvH//29PHzrz79/btHHvimwIMyvE8TItFNcoT2eAK6eSQnA3G+Ff0YU2cFjoG2h3RXxQ7w5gQzH65NXOPdEVBIfMBr43uOrPuxGCvq4Xw9ThzgDueszYXXANc1r5KF++M08jMX4zJuD+NDH+8OTh3XdscZVNMiKJ2o6cTEEXOX4VThiKREIf2OHxDi0e4upY5dd2gouOQjhe5S1MbUa5I+HTiBNFu0TRPwy8SnM7jasc3OHdTmzKf1Fjl0kZAQmHmE7xPmmPEaHiuc+Ej2ccLKBr+BVewTcn8iwjKuKxV4OiKMo+6QSOlbc0uAviWnX8dQu7xu32GTxEUKRQ98NG9gzsvILX7QiXGSeWWmaVzGfiAPIEQx2uXKB9/hboboMfgBp6e6+w4ljrvPLgS3aeSINAsQ/WYsPL68RribjxM2wsRUGSjvTqVOaPqqss0o1O13ZbvYxzZhE/Mlz/aJYn0a7l9YorfwON0lkBXzW9S7Cv2uQgf/+Qp9Wi5ffF2elWKo0rO+2zS1yUJN+Igytq8mjNyQpg+XsBkNezBpBub0OD2gZTE85luCg4sENmuQ4OojquL9GGfQw1fNsTSSOelIooxLOEeaaS9tc4yl0MabU2i9OG8CGqsdPrTTK+Vz6JSM2agic+4tGK1oAosyW1nND7evyaxqpVpQtaoRzRRIR7WpyqDMvGpGw9ya0OUg6I3Ayg040GtqcPbBjAy13e22XbjF2OQiXSRjPCS5j7Te84pUjZOKWCnCyOMjfaY8w2olbk1N9g24LeKkMrvaKewK772JlwrrzLykc/hEOrK0nJwsRUetoFlfrgcoxFkrGMGxGR6TDLwudWOJWQT3U6ESNhDPTGaDmnmz6Q/LKtyKnOJNh0UmpNrCMrahYV4V1zSpOeQb+ZfrYNaLUsBG+mtIsbIGwfC3SQEyu64loxEJVdnZpRlzB2IAefLzsSJiPx4eoQEbiz0M7tehCvoMqYTbD1MR9ACu7bS1zcgtznnSlS/LDM7OY5bFOC+3OkWLTLZwY/OpDGZUEm86MtrMZD8xXFQVk/IXpEo5jP9nquj9BK4jVobm9gxukwVGOl9bARcq5lCFspiGPQGXaCYCIFrg6hdeg/HhTtv8CnKof23OWRomreFUqfZohASF/UjFgpBdKEsm+s4gVs33LkuyIGRzeiauzKzYA3JIWF/XkIbe2wMUF9UkLwMGdzL+3HEedoNINyz/1M7HJvN524NZ52PXL9iL1EpFv7QVNN9MhHNutbZizWm8XF94q83gUgnpf7D/UREyYvTXG2qf70HpRNOOEkFUX7KNB9IF0j4NoHGykzaYNKm320bNOt0p37fYfJa2+Wlz5rJzcvHV3ef5jJ1b2LF1udP1mBoccDJFdXtUHGqMY8yXtfIHLz64B47egk8IY6ak/XRwH64QYcuyHyQg+a1zzdKNvwBQSwMEFAAAAAgAqnLaXHdB8SETAwAALwcAAA8AAAB4bC93b3JrYm9vay54bWylVW1v2jAQ/j5p/8GzkLZKCyEhBBoRKl41pK5FhbYfkUkMWE3iyHEgqOp/3zkQXsqmoi6Ag8+Xx889d740b7IwQCsqEsYjFxvlCkY08rjPooWLHycDrYFRIknkk4BH1MUbmuCb1tcvzTUXLzPOXxAARImLl1LGjq4n3pKGJCnzmEawMuciJBKmYqEnsaDET5aUyjDQzUrF1kPCIrxFcMQlGHw+Zx7tcS8NaSS3IIIGRAL9ZMnipEALvUvgQiJe0ljzeBgDxIwFTG5yUIxCzxkuIi7ILICwM6OGMgFfG35GBQaz2AmWzrYKmSd4wueyDND6lvRZ/EZFN4wTCbJzDS5DskCEFVM53LMS9idZKUG3WKDCNjUq5P9GM6C0Cjjzk2i1PTcTt5pzFtCnbekiEsd3JFSZCjAKSCL7PpPUd3EdpnxNDwYLI5HGnZQFsGraDbOO9da+nEcCAaykYiTYingbOBMYLZlPR2zF5YDRwL9liczNPp2TNJATqPiCB9hNyzRtBZkJp1ByJAWC/8PeLTAbkxXwBDX8XRkPgYhRnUaecIzp63Wv36l1az2t2rG7mmXXO1qndm1p9Wq737GrYGgM3kBKYTseJ6lc7iRQ0C62IN6zpd8kK1aMipMy/0DjtbK7NHV/NxRrbyocddifGF0nB7HUFGXPLPL52sWaYUJQm9PpOl98Zr5curjasC1w2dp+UbZYAmMTFAMj8SRb0QmZ5dLC+VI8XXzCr7flN4ArH0746UcE8yYDRPM7ivLCaD+ge2hKaChpmKAHuiJBmvcNaHDKLc8C1IajthVD31BBHwPkFXDkXD1yNs+ciYBdoY6gI+3hoWfs4avqCb0gCqXEIuqrEgbaR7Md+WkWRGF5OshLs0ckmZGEqsr2SDAu2IOKUKk+VY0ct77/M+Dv30rtkuGUnkpGUz/a628bj3kqoOHCjrh1PxiM+5MfHwH/rMCne/94N2l/4OuU2lcXeQJZ4+rqHdlj6iAaKOHB6VW3PJWmaRp5DmOVty6BFxN4HSbgCabc9fooL1ael5Nn9OJd1/oDUEsDBBQAAAAIAKpy2lzIobj6uAAAADQBAAAjAAAAeGwvd29ya3NoZWV0cy9fcmVscy9zaGVldDIueG1sLnJlbHOFj8EKwjAQRO+C/xD2btJ6EJGmvYjgVeoHrOm2DbZJyEbRvzfHCoK32R32zU7VvOZJPCmy9U5DKQsQ5IzvrBs0XNvTZg+CE7oOJ+9Iw5sYmnq9qi40YcpHPNrAIlMcaxhTCgel2Iw0I0sfyGWn93HGlMc4qIDmjgOpbVHsVFwyoP5iinOnIZ67EkT7Djn5P9v3vTV09OYxk0s/IlSwT59avE2UqRgHShqkXKx5oUuZfwdVV+qra/0BUEsDBBQAAAAIAKpy2lyjzgw1ewMAAFALAAAYAAAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1snZZdb9sgFIbvJ+0/IC52V9s4dr6WZKpaRa20aVO7j2ti4wQVGw9I23Taf98BmzhTN8lOlRps7IeXwwuHxYfnUqBHpjSX1RKTIMKIVZnMebVd4m9f1xdTjLShVU6FrNgSH5jGH1Zv3yyepHrQO8YMAkKll3hnTD0PQ53tWEl1IGtWQUshVUkN3KptqGvFaO4+KkUYR9E4LCmvcEOYqz4MWRQ8Y9cy25esMg1EMUEN6Nc7XmtPK7M+uJKqh319kcmyBsSGC24ODopRmc1vt5VUdCNg3M8koRl6VvCL4X/ku3HPX/VU8kxJLQsTADlsNL8e/iychTQ7kl6PvxeGJBCAR24nsEPF50ki6ZEVd7DRmTA7M40wGy413/N8iX9F7d8FlMReou7i237j1SLnMMP2Y6RYscSXZP49xuFq4fzznbMnfVJH1o4bKR9swy10EwGhphVDh/saJhWsjZGR9UdWmCsmBPBggDQz/JF9gdeWeCONkaVtd4Y38KhQ8oVVrk8mGLwLWizz75cbSAfVPxu9Tmx4VHta98rXbnF8UShnBd0LcyXFD56bHaglQRKnkymJU+xb7+TTDePbnR1MHEygwZlvnh+umc5gNcCoA9drJgV0AVdUcruqwcz02ZVPLX4WTNM0GU8tZcO0WbchyvYaouBFtKyGAvFyFCg9ZRrE05SkYyuyJwWc4ChQesokIEk0hJG0DCi78XTh6qkENDslULaUcRRMSDQbDQiK3ScsBEovpX8sJu3HULYfx4NjAduzEwBlF8/BcztrKVB6SnJiwJ4RJZA8GqNBxXNGQ2eXHO164tfxGWq8YcmJY6MzON6y5MSzUZBOopFbnX2D411LTmwbDQ6Ody3pbBuTwRRvW3Li22Sw+Yk3sK14B6fDdxbiTWwr3jfj4XK8i0ln4+ELKvYmthUv5gzbxN7GttIFZ/CGGR/33c7GcdJzxsMmE7gkdE0N9UmoqdO9kWsuDFNdigWx/8zUs/9masg3Nd2yT1RteaWRgAxqExFYQjXJytUh97qaXTAu0/q7HRwJGRx9ogCWVyElqGluWu49M/sa0m7N1D1/gdwLkysVh3TnznxLLOBwqjNox2gHDS8SWsR1ze0ZwJ5sDc+O98Bs+lu7jlYLmec37sHqHS3r91eXd+gzHFzRrWGlRnfskYq962cRdq8uwr8h4fEsvPoDUEsDBBQAAAAIAKpy2lwAwYxC8wUAAFwYAAAYAAAAeGwvd29ya3NoZWV0cy9zaGVldDIueG1snVlbc6pIEH7fqv0PFO8qgxovFXLKaDy5R6O7+4w4RirAuDCa5Gztf9/ugYEwIgtWJaHp7vmmp/ubC5PLH5++px1oGLkssHTSNHSNBg5bu8Gbpf+xnDb6uhZxO1jbHguopX/RSP9x9ftvlx8sfI+2lHINEILI0rec74atVuRsqW9HTbajAVg2LPRtDq/hWyvahdRei0a+1zIN46Ll226gxwjDsAoG22xch06Ys/dpwGOQkHo2h/ijrbuLJJrvVIHz7fB9v2s4zN8BxMr1XP4lQHXNd4Z3bwEL7ZUH4/4kHdvRPkP4MeG3LbsR+qOefNcJWcQ2vAnIrTjm4+EPWoOW7aRIx+OvBEM6kICDiwXMoMzzQiLdFMvMwNpngmFl4sAwXeFw764t/Z+uYfTHo06/0Tb7o0bH7F03RtfTdqPd6d4MJjeEXI/Mf/Wry7ULFcbGWkg3lj4iwyVp662rS0GgP136EX2TNW6vFtSjDqfQCdE15OeKsXd0vAOVAZA7O6Da52IHVbZ0iOkrEaHanO0e6YaPqedZ+qSna7bD3QOdQQtLXzHOmf/qvm25mA0cdJuQ/aKBiEd0i4EivqUDVOIaYySYEFP0txjKhBQ1izvBIGTnccNRJ20IYkF/uehyXcIwZJc9bLlzD4zHWcJwoy37uIUZSYF5EJ396cI0xr+v7EPX0vyLVMW4YLB0yFbSC4PwwAbT+uCyPTYTVvk+TuyO5zrvootwiBQI79YEq4HRjGBJ0NY2t18C7wurpHn2inrxG7Rge+65mFWwbFzqrWcscjH6uKKQTxrCgkUjzWH7AMqKyKk2biKCTMwG5gF4KZvBSxqHlNMMgSIl23dZEm8qFrdZqK3pxt57HBJwS5ElEIbZ7HWB9bg8DNdfExo5sF5B0E0TI3CYByDwV/NdXHdhubE/Y966a74FadDsd7udiz6irGjEp8hZsDv7CGjyV+KVYMUoMGUFCjwlSq/ZI8agXQMEUiVA4ClBLuqHApwVKPDMBtTtGW1iVh8PeAoQeCYgZq/ZMbu9fh0UXMoRBZ5ZVmrnFqaSQIGnROk0Sce4qDEe2EoFBjwlhlk/tYMEBZ5ZgeqmlsB0ihkHgoQBsSLTSErYb4wFave7pFsnI0RSFoUzwpBkhY0hpYhRP6VE0hWFs8tLJF9RyEpTPymSsSSjrNmuT3wiOYuCnEC1SUska1GQKN261CeStSgkKP36QzIlbVGQwZyRGlPyF4W04JXpb6YrbUZbEwZWcfaYkrYoJL23z6CtKWmLwhmjkHzFJUwm839H0Yq3LrEvTmDfht2WfWjxCSKCAxAcIcgQy1O49cGeh74jdMZNEg5elh7Bln24Mi5bB9hkHdye2UcKCy7VYdFZgSXFsJD56rDoDLDi2JYLDo9mlceMzmIzS4dsprGJrFyDR2prF8cNS0L1HtE532NH6fHYo5v3GB97XOQ9JscevbzHzbFHP+8xPfYY5D1+HnuQjDEifbcFLln1hctdgYtShPsCl6wWAuWhwEVJ7GOBi5LZpwIXJbXPBS5Kbl8KXJTkzgpclOzO8QtITkRTyetrzqhkdJEzKrlc5ownGI0fKZXnEDhncapkLjOOy4z4vXcS9qbMOMfo8WyZX8EETV5LbIsS27LYllt48FamctLA+XTSyoxj7MbSYU/I2issnkgX/KjBUd+oiqmq+KkqblXFnaq4VxUPquJRVTypimdV8aIqZqpiHivgjFxU3jLjosy4PGHMVRiSXr3CuQqp0wKRxIfLySKOpYss4kRV3KiKqar4qSpuVcWdqrhXFQ+q4lFVPKmKZ1XxoipmqmIeK/qFRS2xLUpsy2JbrqL4qVW5pHPhjSuLrMnrkWZxpFl+1+Q7r3c8A++TbJnj19/JRa/MuCgzLk8Y88Oocxyc4/lSyaGqWRz5LL9r8p3XOjTiN2mWQ2Vnn6P1dA5LjIuylnhDWgQbDyO+zIoP7Tv7jT7Z4ZsbRJoHd454MwVLRBjfXgkZ7jGFhBc24m5Svm2TO0OjCb1tGON4gYgveDxO/y9w9R9QSwECFAAUAAAACACqctpckO8c1poBAABtBwAAEwAAAAAAAAAAACAAtoEAAAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQIUABQAAAAIAKpy2ly1VTAj7gAAAEwCAAALAAAAAAAAAAAAIAC2gcsBAABfcmVscy8ucmVsc1BLAQIUABQAAAAIAKpy2lyz66gDnwEAAGIDAAAQAAAAAAAAAAAAIAC2geICAABkb2NQcm9wcy9hcHAueG1sUEsBAhQAFAAAAAgAqnLaXMzuGzo2AQAAUQIAABEAAAAAAAAAAAAgALaBrwQAAGRvY1Byb3BzL2NvcmUueG1sUEsBAhQAFAAAAAgAqnLaXE1B1tIaAQAAewQAABoAAAAAAAAAAAAgALaBFAYAAHhsL19yZWxzL3dvcmtib29rLnhtbC5yZWxzUEsBAhQAFAAAAAgAqnLaXOIrf3u7AAAAMwEAADIAAAAAAAAAAAAgALaBZgcAAHhsL3Bpdm90Q2FjaGUvX3JlbHMvcGl2b3RDYWNoZURlZmluaXRpb24xLnhtbC5yZWxzUEsBAhQAFAAAAAgAqnLaXEGSY6XAAwAA8BAAACcAAAAAAAAAAAAgALaBcQgAAHhsL3Bpdm90Q2FjaGUvcGl2b3RDYWNoZURlZmluaXRpb24xLnhtbFBLAQIUABQAAAAIAKpy2lwbHnppCgEAAIICAAAkAAAAAAAAAAAAIAC2gXYMAAB4bC9waXZvdENhY2hlL3Bpdm90Q2FjaGVSZWNvcmRzMS54bWxQSwECFAAUAAAACACqctpcCkEM6r0AAABHAQAAKQAAAAAAAAAAACAAtoHCDQAAeGwvcGl2b3RUYWJsZXMvX3JlbHMvcGl2b3RUYWJsZTEueG1sLnJlbHNQSwECFAAUAAAACACqctpcUggKQzAGAAC7KQAAHgAAAAAAAAAAACAAtoHGDgAAeGwvcGl2b3RUYWJsZXMvcGl2b3RUYWJsZTEueG1sUEsBAhQAFAAAAAgAqnLaXMHu+u1LBAAAXBMAAA0AAAAAAAAAAAAgALaBMhUAAHhsL3N0eWxlcy54bWxQSwECFAAUAAAACACqctpcwofb8lEGAADXGwAAEwAAAAAAAAAAACAAtoGoGQAAeGwvdGhlbWUvdGhlbWUxLnhtbFBLAQIUABQAAAAIAKpy2lx3QfEhEwMAAC8HAAAPAAAAAAAAAAAAIAC2gSogAAB4bC93b3JrYm9vay54bWxQSwECFAAUAAAACACqctpcyKG4+rgAAAA0AQAAIwAAAAAAAAAAACAAtoFqIwAAeGwvd29ya3NoZWV0cy9fcmVscy9zaGVldDIueG1sLnJlbHNQSwECFAAUAAAACACqctpco84MNXsDAABQCwAAGAAAAAAAAAAAACAAtoFjJAAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1sUEsBAhQAFAAAAAgAqnLaXADBjELzBQAAXBgAABgAAAAAAAAAAAAgALaBFCgAAHhsL3dvcmtzaGVldHMvc2hlZXQyLnhtbFBLBQYAAAAAEAAQAH8EAAA9LgAAAAA= xl/worksheets/sheet1.xml xl/worksheets/sheet3.xml 1 0 WARNING: This report does not display transactions for which accounting has not yet been generated 1 WARNING: The totals and differences will not be correct in cases where the revaluation rate is missing. 2 Operating Unit 3 (All) 4 Ledger 5 Balancing Segment 6 Account Segment 7 Accounting Flexfield 8 Customer Name 9 Customer Number 10 Customer City 11 Trx. Number 12 Trx. Type 13 Trx. Date 14 Due Date 15 Currency 16 Open Original Amount 17 Exchange Rate 18 Revaluation Rate 19 Missing Revaluation Rates 20 Open Functional Amount (A) 21 Revaluation Open Amount (B) 22 Diff (B-A) 23 Open Revalued Adjustment 24 NA 25 NA Total 26 Grand Total data A1 1 data B1 1 data C1 1 data D1 1 data E1 1 data F1 1 data G1 1 data H1 1 data I1 1 data J1 1 data K1 1 data L 2 data L1 1 data M 2 data M1 1 data N1 1 data O 4 data O1 1 data P 4 data P1 1 data Q 4 data Q1 1 data R 4 data R1 1 data S 4 data S1 1 data T 4 data T1 1 data U 4 data U1 1 data V1 1 parameter A1 1 parameter A10 1 parameter A11 1 parameter A12 1 parameter A13 1 parameter A2 1 parameter A3 1 parameter A4 1 parameter A5 1 parameter A6 1 parameter A7 1 parameter A9 1 parameter B3 3 S Site C9CCCFD1C867EFEB04F2185842816DA2