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）限制的操作单元。 DC5391446924B1E1E05362FB0905FD5A PN Lease Category Y select meaning value, description description from fnd_lookup_values_vl where lookup_type='PN_ECC_LEASE_CATEGORY' and view_application_id=240 and enabled_flag='Y' order by value,description US DB30F634EE790870E05362FB0905493A PN Lease Name Report Y select name value, lease_num || ' (' || object_type || ')' description from pn_rep_leases_v where status='F' and lease_status in ('ACT','TER') and lease_class_code='DIRECT' order by value,description US Source Value Set: PN_LEASE_NUM_REP Lease Number and Lease Name For Lease Report for Both Equipment and property Restricted to Expense Leases in FInal Approval Status and Active or Terminated Lease Status DB30F634EE7A0870E05362FB0905493A PN Lease Number Report Y select lease_num value, name || ' (' || object_type || ')' description from pn_rep_leases_v where status='F' and lease_status in ('ACT','TER') and lease_class_code='DIRECT' order by value,description US Source Value Set: PN_LEASE_NUM_REP Lease Number and Lease Name For Lease Report for Both Equipment and property Restricted to Expense Leases in FInal Approval Status and Active or Terminated Lease Status DC4992923320B4D1E05362FB0905A6E0 PN Report Periods Y select gps.period_name value, gps.end_date description from gl_period_statuses gps, gl_ledgers gl where gl.name = nvl(:$flex$.Ledger,gl.name) and gps.application_id=101 and gps.set_of_books_id in (select nvl(psso.set_of_books_id,pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID')) from pn_system_setup_options psso, hr_operating_units hou where psso.org_id=hou.organization_id and (:$flex$.Operating_unit is null or hou.name=:$flex$.Operating_unit) union select nvl(psso.set_of_books_id,pnp_eqp_util_func.get_profile_value('PN_SET_OF_BOOKS_ID')) from pn_eqp_system_setup_options psso, hr_operating_units hou where psso.org_id=hou.organization_id and (:$flex$.Operating_unit is null or hou.name=:$flex$.Operating_unit) ) and gl.ledger_id=gps.set_of_books_id and gps.period_type=gl.accounted_period_type and gps.adjustment_period_flag='N' and gps.start_date>=to_date('01-01-2017','dd-mm-yyyy') and gps.end_date<= (select max(gps2.end_date) from gl_period_statuses gps2, gl_ledgers gl2 where gl2.name = nvl(:$flex$.Ledger,gl.name) and gps2.application_id=101 and gps2.set_of_books_id in (select nvl(psso.set_of_books_id,pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID')) from pn_system_setup_options psso, hr_operating_units hou where psso.org_id=hou.organization_id and (:$flex$.Operating_unit is null or hou.name=:$flex$.Operating_unit) union select nvl(psso.set_of_books_id,pnp_eqp_util_func.get_profile_value('PN_SET_OF_BOOKS_ID')) from pn_eqp_system_setup_options psso, hr_operating_units hou where psso.org_id=hou.organization_id and (:$flex$.Operating_unit is null or hou.name=:$flex$.Operating_unit) ) and gl2.ledger_id=gps2.set_of_books_id and gps2.period_type=gl2.accounted_period_type and gps2.adjustment_period_flag='N' and gps2.start_date>=to_date('01-01-2017','dd-mm-yyyy') and sysdate+400 between gps2.start_date and gps2.end_date ) order by gps.start_date desc US 82288223F3A23869E053B46B63588994Y with q_lease_detail as ( select --Q1 pla.org_id, pla.lease_id lease_id, pla.lease_num, pla.name lease_name, plda.lease_commencement_date lease_commencement_date, plda.lease_termination_date lease_termination_date, months_between(plda.lease_termination_date + 1, plda.lease_commencement_date) duration_in_months, ((pn_streams_util.get_interest_rate(pla.discount_rate_index_id, trunc(xxen_pn.get_as_of_date(pla.lease_id))) * 100) + nvl(pla.adder_rate, 0)) discount_rate, ppta.currency_code currency, xxen_util.meaning('PROPERTY','PN_ECC_LEASE_CATEGORY',240) lease_category, decode(pla.payment_term_proration_rule,365,'365 Days/Year',360,'360 Days/Year',999,'Days/Month',null) payment_term_proration_rule, pla.accounting_method accounting_method, xxen_util.meaning(pla.accounting_method,'PN_ACCT_METHOD_TYPE',0) representation, xxen_pn.get_as_of_date(pla.lease_id) as_of_date from pn_leases_all pla, pn_lease_details_all plda, pn_payment_terms_all ppta where pla.lease_id = plda.lease_id and pla.lease_id = ppta.lease_id and nvl(pla.accounting_method,'BOTH') = decode(nvl(:p_representation,'BOTH'),'BOTH',nvl(pla.accounting_method,'BOTH'),:p_representation) and pla.org_id = :p_org_id and pla.lease_status = 'ACT' and pla.status = 'F' and pla.lease_class_code = 'DIRECT' union select --Q2 pla.org_id, pla.lease_id lease_id, pla.lease_num, pla.name lease_name, plda.lease_commencement_date lease_commencement_date, plda.lease_termination_date lease_termination_date, months_between(plda.lease_termination_date + 1, plda.lease_commencement_date) duration_in_months, ((pn_streams_util.get_interest_rate(pla.discount_rate_index_id, trunc(xxen_pn.get_as_of_date(pla.lease_id))) * 100) + nvl(pla.adder_rate, 0)) discount_rate, nvl(poa.currency_code, pn_lease_pvt.get_functional_currency(pla.org_id)) currency_code, xxen_util.meaning('PROPERTY','PN_ECC_LEASE_CATEGORY',240) lease_category, decode(pla.payment_term_proration_rule,365,'365 Days/Year',360,'360 Days/Year',999,'Days/Month',null) payment_term_proration_rule, pla.accounting_method accounting_method, xxen_util.meaning(pla.accounting_method,'PN_ACCT_METHOD_TYPE',0) representation, xxen_pn.get_as_of_date(pla.lease_id) as_of_date from pn_leases_all pla, pn_lease_details_all plda, pn_options_all poa where pla.lease_id = plda.lease_id and pla.lease_id = poa.lease_id and nvl(pla.accounting_method,'BOTH') = decode(nvl(:p_representation,'BOTH'),'BOTH',nvl(pla.accounting_method,'BOTH'),:p_representation) and pla.org_id = :p_org_id and pla.lease_status = 'ACT' and pla.status = 'F' and pla.lease_class_code = 'DIRECT' union select --Q3 pla.org_id, pla.lease_id lease_id, pla.lease_num, pla.name lease_name, plda.lease_commencement_date lease_commencement_date, plda.lease_termination_date lease_termination_date, months_between(plda.lease_termination_date + 1, plda.lease_commencement_date) duration_in_months, ((pn_streams_util.get_interest_rate(pla.discount_rate_index_id, trunc(xxen_pn.get_as_of_date(pla.lease_id))) * 100) + nvl(pla.adder_rate, 0)) discount_rate, ppta.currency_code currency, xxen_util.meaning('EQUIPMENT','PN_ECC_LEASE_CATEGORY',240) lease_category, decode(pla.payment_term_proration_rule,365,'365 Days/Year',360,'360 Days/Year',999,'Days/Month',null) payment_term_proration_rule, pla.accounting_method accounting_method, xxen_util.meaning(pla.accounting_method,'PN_ACCT_METHOD_TYPE',0) representation, xxen_pn.get_as_of_date(pla.lease_id) as_of_date from pn_eqp_leases_all pla, pn_eqp_lease_details_all plda, pn_eqp_payment_terms_all ppta where pla.lease_id = plda.lease_id and pla.lease_id = ppta.lease_id and nvl(pla.accounting_method,'BOTH') = decode(nvl(:p_representation,'BOTH'),'BOTH',nvl(pla.accounting_method,'BOTH'),:p_representation) and pla.org_id = :p_org_id and pla.lease_status = 'ACT' and pla.status = 'F' and pla.lease_class_code = 'DIRECT' union select --Q4 pla.org_id, pla.lease_id lease_id, pla.lease_num, pla.name lease_name, plda.lease_commencement_date lease_commencement_date, plda.lease_termination_date lease_termination_date, months_between(plda.lease_termination_date + 1, plda.lease_commencement_date) duration_in_months, ((pn_streams_util.get_interest_rate(pla.discount_rate_index_id, trunc(xxen_pn.get_as_of_date(pla.lease_id))) * 100) + nvl(pla.adder_rate, 0)) discount_rate, poa.currency_code, xxen_util.meaning('EQUIPMENT','PN_ECC_LEASE_CATEGORY',240) lease_category, decode(pla.payment_term_proration_rule,365,'365 Days/Year',360,'360 Days/Year',999,'Days/Month',null) payment_term_proration_rule, pla.accounting_method accounting_method, xxen_util.meaning(pla.accounting_method,'PN_ACCT_METHOD_TYPE',0) representation, xxen_pn.get_as_of_date(pla.lease_id) as_of_date from pn_eqp_leases_all pla, pn_eqp_lease_details_all plda, pn_eqp_options_all poa where pla.lease_id = plda.lease_id and pla.lease_id = poa.lease_id and nvl(pla.accounting_method,'BOTH') = decode(nvl(:p_representation,'BOTH'),'BOTH',nvl(pla.accounting_method,'BOTH'),:p_representation) and pla.org_id = :p_org_id and pla.lease_status = 'ACT' and pla.status = 'F' and pla.lease_class_code = 'DIRECT' ) -- -- Main Query Starts Here -- select :p_legal_entity legal_entity, :p_ledger_name ledger, :p_org_name operating_unit, :p_functional_currency functional_currency, :p_as_of_period as_of_period, qld.as_of_date as_of_date, qld.lease_num, qld.lease_name, qld.lease_category, qld.lease_commencement_date commencement_date, qld.lease_termination_date termination_date, qld.duration_in_months, qld.payment_term_proration_rule days_convention, qld.discount_rate discount_rate_pct, qld.representation representation, qld.currency currency, -- pn_transaction_util.get_lease_liability (p_lease_id => qld.lease_id, p_org_id => qld.org_id, p_currency => qld.currency, p_as_of_date => trunc(qld.as_of_date), p_termination_date => trunc(qld.lease_termination_date), p_month => 12, p_mode => 'U' ) undisc_liability_le_1yr, pn_transaction_util.get_lease_liability (p_lease_id => qld.lease_id, p_org_id => qld.org_id, p_currency => qld.currency, p_as_of_date => trunc(qld.as_of_date), p_termination_date => trunc(qld.lease_termination_date), p_month => 60, p_mode => 'U' ) undisc_liability_le_5yr, pn_transaction_util.get_liability_more (p_lease_id => qld.lease_id, p_org_id => qld.org_id, p_currency => qld.currency, p_as_of_date => trunc(qld.as_of_date), p_termination_date => trunc(qld.lease_termination_date), p_month => 60, p_mode => 'U' ) undisc_liability_gt_5yr, pn_transaction_util.get_lease_liability (p_lease_id => qld.lease_id, p_org_id => qld.org_id, p_currency => qld.currency, p_as_of_date => trunc(qld.as_of_date), p_termination_date => trunc(qld.lease_termination_date), p_month => 12, p_mode => 'D' ) disc_liability_le_1yr, pn_transaction_util.get_lease_liability (p_lease_id => qld.lease_id, p_org_id => qld.org_id, p_currency => qld.currency, p_as_of_date => trunc(qld.as_of_date), p_termination_date => trunc(qld.lease_termination_date), p_month => 60, p_mode => 'D' ) disc_liability_le_5yr, pn_transaction_util.get_liability_more (p_lease_id => qld.lease_id, p_org_id => qld.org_id, p_currency => qld.currency, p_as_of_date => trunc(qld.as_of_date), p_termination_date => trunc(qld.lease_termination_date), p_month => 60, p_mode => 'D' ) disc_liability_gt_5yr, qld.accounting_method, :p_source source, qld.lease_num || ' - ' || qld.lease_name lease_num_name_label, qld.lease_name || ' (' || qld.lease_num || ')' lease_name_num_label from q_lease_detail qld where 1=1 and :p_org_name = :p_org_name and qld.lease_category = nvl(:p_lease_category,qld.lease_category) order by qld.lease_num #,##0.00;[Red]-#,##0.00 XXEN_PN AR PN تكوين تقرير تحليل عقد الإيجار Application: مدير الممتلكات Source: تكوين تقرير تحليل عقد الإيجار Short Name: PNLAR_XML DB package: D PN Auswertung "Vertragsanalyse" generieren Application: Property Manager Source: Auswertung "Vertragsanalyse" generieren Short Name: PNLAR_XML DB package: F PN Générer un état d'analyse de bail Application: Property Manager Source: Générer un état d'analyse de bail Short Name: PNLAR_XML DB package: US PN Generate Lease Analysis Application: Property Manager Source: Generate Lease Analysis Report Short Name: PNLAR_XML DB package: XXEN_PN ZHS PN 生成租赁分析报表 Application: 物业管理系统 Source: 生成租赁分析报表 Short Name: PNLAR_XML DB package: Enginatics R12 only 1=1 :p_as_of_date_eqp :p_as_of_date_prp :p_as_of_date_start_eqp :p_as_of_date_start_prp :p_as_of_period :p_end_date :p_functional_currency :p_include_manual_gl :p_include_rev_exp_acc :p_lease_category :p_lease_category_code :p_lease_name :p_lease_name_from :p_lease_name_to :p_lease_num :p_lease_num_from :p_lease_num_to :p_ledger_id :p_ledger_name :p_legal_entity :p_org_id :p_org_name :p_period_end_date :p_period_start_date :p_regime :p_report_code :p_representation :p_show_amt_by_gl_account :p_show_amt_by_sla_acc_class :p_show_amt_by_sla_account :p_show_amt_by_stream_type :p_show_amt_by_trm_optn_type :p_show_in_ledger_curr :p_source :p_source_code :p_to_date 1 -10 :p_report_code Char PNLAR_XML Y F Code du rapport US Report Code 2 10 :p_org_name 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)) Y F Unité d'exploitation US Operating Unit 3 20 :p_as_of_period LOV PN Report Periods DC4992923320B4D1E05362FB0905A6E0 Y select gps.period_name value, gps.end_date description from gl_period_statuses gps, gl_ledgers gl where gl.name = nvl(:$flex$.Ledger,gl.name) and gps.application_id=101 and gps.set_of_books_id in (select nvl(psso.set_of_books_id,pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID')) from pn_system_setup_options psso, hr_operating_units hou where psso.org_id=hou.organization_id and (:$flex$.Operating_unit is null or hou.name=:$flex$.Operating_unit) union select nvl(psso.set_of_books_id,pnp_eqp_util_func.get_profile_value('PN_SET_OF_BOOKS_ID')) from pn_eqp_system_setup_options psso, hr_operating_units hou where psso.org_id=hou.organization_id and (:$flex$.Operating_unit is null or hou.name=:$flex$.Operating_unit) ) and gl.ledger_id=gps.set_of_books_id and gps.period_type=gl.accounted_period_type and gps.adjustment_period_flag='N' and gps.start_date>=to_date('01-01-2017','dd-mm-yyyy') and gps.end_date<= (select max(gps2.end_date) from gl_period_statuses gps2, gl_ledgers gl2 where gl2.name = nvl(:$flex$.Ledger,gl.name) and gps2.application_id=101 and gps2.set_of_books_id in (select nvl(psso.set_of_books_id,pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID')) from pn_system_setup_options psso, hr_operating_units hou where psso.org_id=hou.organization_id and (:$flex$.Operating_unit is null or hou.name=:$flex$.Operating_unit) union select nvl(psso.set_of_books_id,pnp_eqp_util_func.get_profile_value('PN_SET_OF_BOOKS_ID')) from pn_eqp_system_setup_options psso, hr_operating_units hou where psso.org_id=hou.organization_id and (:$flex$.Operating_unit is null or hou.name=:$flex$.Operating_unit) ) and gl2.ledger_id=gps2.set_of_books_id and gps2.period_type=gl2.accounted_period_type and gps2.adjustment_period_flag='N' and gps2.start_date>=to_date('01-01-2017','dd-mm-yyyy') and sysdate+400 between gps2.start_date and gps2.end_date ) order by gps.start_date desc select gps.period_name value, gps.end_date description from gl_period_statuses gps where gps.application_id=101 and gps.adjustment_period_flag='N' and (gps.set_of_books_id,gps.period_type,gps.end_date) in ( select gps.set_of_books_id,gps.period_type,max(gps.end_date) from gl_period_statuses gps, gl_ledgers gl where gl.name = nvl(:$flex$.Ledger,gl.name) and gps.application_id=101 and gps.set_of_books_id in (select nvl(psso.set_of_books_id,pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID')) from pn_system_setup_options psso, hr_operating_units hou where psso.org_id=hou.organization_id and (:$flex$.Operating_unit is null or hou.name=:$flex$.Operating_unit) union select nvl(psso.set_of_books_id,pnp_eqp_util_func.get_profile_value('PN_SET_OF_BOOKS_ID')) from pn_eqp_system_setup_options psso, hr_operating_units hou where psso.org_id=hou.organization_id and (:$flex$.Operating_unit is null or hou.name=:$flex$.Operating_unit) ) and gl.ledger_id=gps.set_of_books_id and gps.period_type=gl.accounted_period_type and gps.adjustment_period_flag='N' and add_months(trunc(sysdate),-1) between gps.start_date and gps.end_date group by gps.set_of_books_id,gps.period_type ) Y AR اعتبارًا من تاريخ D Vom F Au début de la période US As of Period ZHS 截止日期 4 30 :p_representation LOV Oracle PN_REP_DISPLAY_METHODS Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type=(case when pn_lease_utils.is_federal_enabled='Y' then 'PN_ACCT_METHOD_FED_TYPE' else 'PN_ACCT_METHOD_TYPE' end) and upper(lookup_code)<>'EXCLUDED' order by value,description AR التمثيل D Darstellung F Représentation US Representation ZHS 表示 5 40 1=1 qld.lease_num=:p_lease_num LOV PN Lease Number Report DB30F634EE7A0870E05362FB0905493A Y select lease_num value, name || ' (' || object_type || ')' description from pn_rep_leases_v where status='F' and lease_status in ('ACT','TER') and lease_class_code='DIRECT' order by value,description F Numéro de bail US Lease Number 6 50 1=1 qld.lease_num>=:p_lease_num_from LOV PN Lease Number Report DB30F634EE7A0870E05362FB0905493A Y select lease_num value, name || ' (' || object_type || ')' description from pn_rep_leases_v where status='F' and lease_status in ('ACT','TER') and lease_class_code='DIRECT' order by value,description F Numéro du bail De US Lease Number From 7 60 1=1 qld.lease_num<=:p_lease_num_to LOV PN Lease Number Report DB30F634EE7A0870E05362FB0905493A Y select lease_num value, name || ' (' || object_type || ')' description from pn_rep_leases_v where status='F' and lease_status in ('ACT','TER') and lease_class_code='DIRECT' order by value,description F Numéro de bail à US Lease Number To 8 70 1=1 qld.lease_name=:p_lease_name LOV PN Lease Name Report DB30F634EE790870E05362FB0905493A Y select name value, lease_num || ' (' || object_type || ')' description from pn_rep_leases_v where status='F' and lease_status in ('ACT','TER') and lease_class_code='DIRECT' order by value,description F Nom du bail US Lease Name 9 80 1=1 qld.lease_name>=:p_lease_name_from LOV PN Lease Name Report DB30F634EE790870E05362FB0905493A Y select name value, lease_num || ' (' || object_type || ')' description from pn_rep_leases_v where status='F' and lease_status in ('ACT','TER') and lease_class_code='DIRECT' order by value,description F Nom du bail De US Lease Name From 10 90 1=1 qld.lease_name<=:p_lease_name_to LOV PN Lease Name Report DB30F634EE790870E05362FB0905493A Y select name value, lease_num || ' (' || object_type || ')' description from pn_rep_leases_v where status='F' and lease_status in ('ACT','TER') and lease_class_code='DIRECT' order by value,description F Nom du bail jusqu'à US Lease Name To 11 100 :p_lease_category LOV PN Lease Category DC5391446924B1E1E05362FB0905FD5A Y select meaning value, description description from fnd_lookup_values_vl where lookup_type='PN_ECC_LEASE_CATEGORY' and view_application_id=240 and enabled_flag='Y' order by value,description F Catégorie de bail US Lease Category 423709AB0EF03DC257E977E2C8169882 Pivot: Default SYSADMIN 6 AS_OF_DATE 5 AS_OF_PERIOD 10 COMMENCEMENT_DATE 16 CURRENCY 13 DAYS_CONVENTION 14 DISCOUNT_RATE_PCT 22 DISC_LIABILITY_GT_5YR 20 DISC_LIABILITY_LE_1YR 21 DISC_LIABILITY_LE_5YR 12 DURATION_IN_MONTHS 4 FUNCTIONAL_CURRENCY 9 LEASE_CATEGORY 8 LEASE_NAME 7 LEASE_NUM 2 LEDGER 1 LEGAL_ENTITY 3 OPERATING_UNIT 15 REPRESENTATION 23 SOURCE 11 TERMINATION_DATE 19 UNDISC_LIABILITY_GT_5YR 17 UNDISC_LIABILITY_LE_1YR 18 UNDISC_LIABILITY_LE_5YR DISC_LIABILITY_GT_5YR VALUE 6 SUM DISC_LIABILITY_LE_1YR VALUE 4 SUM DISC_LIABILITY_LE_5YR VALUE 5 SUM LEASE_CATEGORY ROW 2 LEASE_NAME ROW 5 LEASE_NUM ROW 4 OPERATING_UNIT ROW 1 REPRESENTATION ROW 3 UNDISC_LIABILITY_GT_5YR VALUE 3 SUM UNDISC_LIABILITY_LE_1YR VALUE 1 SUM UNDISC_LIABILITY_LE_5YR VALUE 2 SUM PN Generate Lease Analysis - Pivot Default Template.xlsx US UEsDBBQAAAAIADOnD12Q7xzWmgEAAG0HAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbM2V30/CMBDH3038H5a+mq2AiTGGwQPqoxLFP6CsB2vY2qZXEP57bx34g0yQgNGXtVt79/20d7vr9pdlES3AoTI6Ze2kxSLQmZFKT1P2MrqPr1mEXmgpCqMhZStA1u+dn3VHKwsYkbXGlOXe2xvOMcuhFJgYC5pWJsaVwtOrm3IrspmYAu+0Wlc8M9qD9rGvfLBe9xYmYl746G5Jn2sSBwWyaFBvrLRSJqwtVCY8rfOFllsq8VohIcuwB3Nl8YIwGG9UqFa+F1jbPdLVOCUhGgrnH0RJGHxZ8FfjZmNjZsluJw2UZjJRGUiTzUs6WILWgZCYA/iySMKYlELpDfcO/bAZeRjaJwapzhccH8jR+Sccl3/EYdXC+IGg34B/TCm7lVZVSp46TE0aeyLWSPgEmXESfw9vLbCHzVP1AB6ex6MEN3sE0a8KwBPnSu10n3IuHMhn76jOnhzgs++fpMNIjIm4ztgwP/72v9a1D8+7cKgoDp2xSO3BweFB2dT/yjq25AicV7sD8a5IreVwwa1SDlXzkiAbtHlolr03UEsDBBQAAAAIADOnD121VTAj7gAAAEwCAAALAAAAX3JlbHMvLnJlbHONks9OwzAMxu9IvEPk++puSAihpbtMSLshVB7AJO4ftY2jJED39oQDgkpj29H2588/W97u5mlUHxxiL07DuihBsTNie9dqeK2fVg+gYiJnaRTHGo4cYVfd3mxfeKSUm2LX+6iyi4saupT8I2I0HU8UC/HscqWRMFHKYWjRkxmoZdyU5T2Gvx5QLTzVwWoIB3sHqj76PPmytzRNb3gv5n1il06MQJ4TO8t25UNmC6nP26iaQstJgxXznNMRyfsiYwOeJtpcT/T/tjhxIkuJ0Ejg8zzfinNA6+uBLp9oqfi9zjzip4ThTWT4YcHFD1RfUEsDBBQAAAAIADOnD10S3mldngEAAGwDAAAQAAAAZG9jUHJvcHMvYXBwLnhtbJ2TTU/cMBCG75X6HyzfWQe2QtXKMULQlgO0K22As+tMNhaOHdlDtMuv7yTRZrOlh4rbfLx584zHlle7xrEOYrLB5/x8kXEG3oTS+m3OH4vvZ185S6h9qV3wkPM9JH6lPn+S6xhaiGghMbLwKec1YrsSIpkaGp0W1PbUqUJsNFIatyJUlTVwG8xrAx7FRZZdCtgh+BLKs3Yy5KPjqsOPmpbB9Hzpqdi3BKxkEVC7wjagMimOibxuW2eNRppePVgTQwoVsm87A06KeVMS9QbMa7S47z3mqdwY7eCGfqgq7RJIcSzIO9D9Ya61jUnJDlcdGAyRJftGx3nB2W+doMfMeaej1R4Jt5eNyRC7NmFUzyG+pBoAkxRTcQjn2nlsv6jlIKDgVDh8NYBQ4xSxsOgg/arWOuI/iJdz4gFs5B0Z1z/ZD/AQNQK7B5qMXXvt9smeME/y/5AQhm4A6Ya+m/rA/xfxvfUv6bEtwi1RHDZyWpSbWkcoaYnTxqaCvKNlRNeb3NTab6E8aN43+vvzND4edX65yJYZXY1ZTYrjM1F/AFBLAwQUAAAACAAzpw9dvUtLpTIBAABRAgAAEQAAAGRvY1Byb3BzL2NvcmUueG1slZLNasMwEITvhb6D0d2W7DQlCNuBtuTUQKEpDb0JaZOIWj9Iap28fWU7cRLIpcfdmf00u6ic71WT/ILz0ugK5RlBCWhuhNTbCn2sFukMJT4wLVhjNFToAB7N6/u7klvKjYM3Zyy4IMEnkaQ95bZCuxAsxdjzHSjms+jQUdwYp1iIpdtiy/g32wIuCHnECgITLDDcAVM7EtERKfiItD+u6QGCY2hAgQ4e51mOz94ATvmbA71y4VQyHGzc6Rj3ki34II7uvZejsW3brJ30MWL+HK+Xr+/9qqnU3a04oLoUnHIHLBhXlzHtuYiHa5gPy3jjjQTxdIj6jZ7gfdxhDkQSA9Ah7kn5nDy/rBaoLkhRpOQhLaarglAypWT21T15Nd8FGhrq+PB/iJNL4gkw5L7+BPUfUEsDBBQAAAAIADOnD11NQdbSGgEAAHsEAAAaAAAAeGwvX3JlbHMvd29ya2Jvb2sueG1sLnJlbHO9lMFKxDAQhu+C7xDmbtN2dRXZdA8uwl51fYDQTtuwbRIycbVvb6zQWljqHoqXwMwk//8xzGSz/WwbdkJHymgBSRQDQ52bQulKwNvh+eYBGHmpC9kYjQI6JNhm11ebF2ykD4+oVpZYUNEkoPbePnJOeY2tpMhY1KFSGtdKH0JXcSvzo6yQp3G85u63BmQTTbYvBLh9sQJ26Gxw/lvblKXKcWfy9xa1P2PBP4w7Uo3og6h0FXoBQ4p4X1lFgRj4eZj7JWGolg6LV+9Cr2kEmqTnYNIlYS7oTDoHk/wzTDIHs14ShnzXhKEfBuYnnrO/W9Leh1XC0b0PeX/OtuB2SQarTsY/ybDVOyyVVt97PyKNVX7u4oDJJ19G9gVQSwMEFAAAAAgAM6cPXeIrf3u7AAAAMwEAADIAAAB4bC9waXZvdENhY2hlL19yZWxzL3Bpdm90Q2FjaGVEZWZpbml0aW9uMS54bWwucmVsc4WPwWrDMBBE74X+g9h7LTuHUIrlHBICuQbnAxZpbYvYWqFVQvz30TGhhR6HYd7MtLvHMqs7JfEcDDRVDYqCZefDaODSH7++QUnG4HDmQAZWEth1nx/tmWbMJSSTj6IKJYiBKef4o7XYiRaUiiOF4gycFsxFplFHtFccSW/qeqvTKwO6N6Y6OQPp5BpQ/RpL8/9sHgZv6cD2tlDIf1To6O+c91jmnclyclLgmEbKBn5ZTVWmg+5a/Xa1ewJQSwMEFAAAAAgAM6cPXYliaXmMBQAA3hQAACcAAAB4bC9waXZvdENhY2hlL3Bpdm90Q2FjaGVEZWZpbml0aW9uMS54bWzdWG1z4jYQ/t6Z/geNvzvY2LyYCbkhhFwzDQmFvLQfFVuAJ7bMSHIOpnP/vY9lMOK45OCu12vrYYDVrlf7viudvlumCXlhQsYZ71ruiWMRxsMsivmsa93fXdpti0hFeUSTjLOutWLSenf280+ni/glU30aztkFm8Y8VmBAwIzLrjVXatGp1SSQKZUn2YJxYKaZSKkCKGY1uRCMRnLOmEqTWt1xmrWUxtwqOXTEITyy6TQO2UUW5injqmQiWEILSeQ8XsgNtzQ8hF1KxXO+sMMsXYDFU5zEaqWZWiQNO1czngn6lMAES7FhvNyXM41Dkclsqk7AqFaKuKet60PQl7iwuUVEJ466lriKXPxnU8Hk/JZfZxSL2xUWna+6Vi9X8wy7r8lYdEEVBPL9Zqt14nnNwG8HjbbnNSwSwr6KRQ8bz0KL6q1qsQXVYj4uNy2UqzBeQR5mIupnOVddq473l6KTF6L+6awfG7+94suxL/HoryYsVjwfrbPTsIiOSZaLkBG1WkDSD5l41k4Htvq/poB40NDtPNYhlibqWqMb8p5xJqAKuWZUMtLjNFnJWFq1s9OascF6t8uYJZEk4VpqbyOFXiecphDims1oQgZcwcEW4Xl6maor6OWAGGYQLLpSLJXVBvpdk3/FJ5oxeOPrOdwuCtWQauQeCfQGp41CbiEieelaDzp4yJoB4l3bw5B+Y53XhL/MeVgkCizRz4VAzn+TLXqS3E7JiIk4i77FIiWfIqxNLm7T3/UN7MEV6oWcsDQexksW3SG+UHlQvjaom4yX6WGslQtIq+p9JXSlAw0yoUTXnXrddnzbc+4cp6M/wNKliW3YjrvFHhAqReze5OkBPkaqrZ3s1n2n8Kv2OADXANreFvAaBsZrmUBgAL5rAp4JmAx8k4G/wyCobzf1A0MCP/BNTMMEmlug4ZqAtwO0DLKGCbQMoOltAc8E2iYQNL12xQ1AcGxylKXmBtXiEH81Nv7qnV+Tixh1U1W79+7vPl16ZFIl9JmRAZXqkwzWnn7ccClLXsXrnLFwTn6Jk2RdC9FQye1o8HtF8TgaGqgHKuKiqJMx2uNrNGNikzuRM3K/MEns0gTFDg9jG6mEKpHuEGB5QEWyIndMIHV0160I1uXpl9/IKAEjytU+coJVSvoJFbR671fKJZWkj8oMs0kk51O+w3iCbKWLTLAdNOlDQ5TiTa5M0PsUFDdZfErTC1O4mH0gf6AnkSGFVW3S7w23rtsjMNSD6DNGbumzJBNViOM623was+hDlkWlGiXad3UQlv6lyTMTZJTFXOmN7WGcICgwX5FewoTSxVyT9kaDIcR6FT9YYrSCn9a9MdR9DyaqGGzdOBJsQVfFpFQhB31y64I9fkcCQ5qAuEPKodkeWf0wMu9NsmP6Uyl4HwV5lom3WtNea9yocmzS97MUaoda9x/cgdwgCGxnt8fsdCAH7cd26kd0ICNLf7ByGBB923Vfba8eNCs+Ryh3kRdjFIrUFSdDTAZzjP6vTmWHzA6T7VhQjRN5+sQw7xvDwxWKDiZAvYYS+ECTHONDcV6gyzXgerpllpPqa7PYBV2h5mX8BZGnjwRfP1Gi4ukaQMbFyDxCJ/pxhsApZGsIPRK8bYYxw6FQwgZlL3lTcH0oqabh7Rxddcxjas3fMQDf8wimJ9fouPrkiJJM3NXO6QDD3M4B43sHYjm1bgKxqY9lX/bC5xRp/C8Uea/Iv0mRA3xRZPM/HFLbOrYbPg7GaK9+4rXRmvTz5Ujal/67m//7Sf/fC57yWuWIZmJUZ3l2ypbqWir9S3IR49qnVW/0BvXewA5wKrT99hOzz+vnvu0PzoOWf9n3nLb/sboac/29S7eD7sacoBaUd4Fnp0vX73zunrFoJZCr/NZS1j5HdvYXUEsDBBQAAAAIADOnD11MvwPolgMAAEQnAAAkAAAAeGwvcGl2b3RDYWNoZS9waXZvdENhY2hlUmVjb3JkczEueG1s7VpRb5swEH6ftP+AeNoeCLZJSIiSVNOqSXuYNq3tpD1ScBq0gJFNovTfz5iWA4LTpE21TnKUB8iFE/78+e4+n2cXu3RtbSkXCcvmNh4g26JZxOIku5vbN9dfnIltiSLM4nDNMjq376mwLxbv383yZMuKz2G0oj9pxHgsLOkpE3N7VRT51HWFtKShGLCcZtKyZDwNC3nL71yRcxrGYkVpka5dgpDvpmGS2ZWHKT/GB1suk4hesmiT0qyonHC6Dgs5DrFKcvHoLY2OcZeG/M8mdyKW5tLFbbJOinvl1LbSaPr1LmM8vF3L8e/4o+Pd/numScSZYMtiIB251SvujRYP5YtukxJw24rYJivmNvHtxYwvZsLazu1fymZ9zymvhmO7Oov14ebq08fSviufRPU/b64u6+tPOXcIKW/j8k8EEeKgoeOha4Sm6tt2AK7gSj2JgyBw0MhBuPXkg1fpEuOu16x8zh/X7+L5I+syvBfubxry8lf1h5F+BMquXvD0K4XmD87iTVTiaMVhEZaeXIn0GwAb16OGKzVSA3Ymzs1sxX/FZ7gCsOVKR5LWOmYHDiaO12a9oiMmsOQMtSGOeE+hPXaQp0EbSxtxyKQVYwzaB6L2sEYbcG9xe6LnNvZ03B6rhaJiqKE2UBtyFcDeAlvmR12KxDLI7CXeKkWaONJXj/g1szslwmPNcYjZSMdsT7k1zO4Uf6pKUykSYO+GERmbe4u/ktl+b/FH1DIxYHfAntRgA+wG7AfBc+7iL6jBBtgN2K8ENoZcCbgfXY4QXdA2GbJXseOGiuzo+GNypIFbprsTNkgwqMcG8obdrxVLQNA0kDdwvxbcIGnwM6SkCSYnBhMQNVgjJo2+Od/mNgZZg42c3OsynLvoxiBsGsh3tkrkvqpGUGq7CRipIt4oyo6ixKBtGtC38Jbq3T+w6zoye9ynlIKgbhrQH1ubIG1PwWyY9AqdqtOitqewRlfK5uRzWjgmmvR0ggnoygbyTXaXW346uKVN2zEzcPfB3ehP9nWDCXoCbs3uq9np7msrkEZ/sr8dTA6Q29OT23tpzwz7shNdHcioWp6d+4YF+V7gkYE3kacy1Ace0pugzfR2z0VUCbDq1fer0JfPjjqD8o1lxeroQyjeqDUznVuYGOL5gT8ZDGE+9n/5L6YBNFJjRpoZ4J9MAxmVS6Ketc5tc+WMAowH/lgtKPlRYfVhUWlNT06Mu3fubfEXUEsDBBQAAAAIADOnD10KQQzqvQAAAEcBAAApAAAAeGwvcGl2b3RUYWJsZXMvX3JlbHMvcGl2b3RUYWJsZTEueG1sLnJlbHOFj8EKwjAMhu+C71Byt908iMg6D4rgVfQBQpdtxS0tbRV9e+ttA8FjyJ/vz1ftX+MgnhSidayhlAUIYuMay52G2/W02oKICbnBwTFpeFOEfb1cVBcaMOWj2FsfRaZw1NCn5HdKRdPTiFE6T5w3rQsjpjyGTnk0d+xIrYtio8KUAfWMKc6NhnBuShDXt8/N/9muba2hozOPkTj9qFDePl06YH7vSK1l+xXIfAwdJQ1STgI/s6XMOqDqSs306w9QSwMEFAAAAAgAM6cPXWD0AbmQBQAAPRgAAB4AAAB4bC9waXZvdFRhYmxlcy9waXZvdFRhYmxlMS54bWztWN9P4zgQfj/p/oco79nUIS20arvqUqpFx92ihd17NonbWpfEUeJAq9X97zcet4ndJhxwHOJhkYB6Mp0f34ztyTf+uEkT554VJRfZxCUfeq7DskjEPFtN3G+3C+/MdUpJs5gmImMTd8tK9+P011/GOb8X8pbeJWzOljzjEgw4YCwrJ+5aynzk+2W0ZiktP4icZfBkKYqUSlgWK7/MC0bjcs2YTBM/6PUGfkp55moLozR6ipGUFn9VuReJNKeS3/GEyy3acp00Gl2uMlGo+Cbuptgb3hRHhlMeFaIUS/kBDPliueQRO4qPhH7B7rlCCUwVo4rHE/dHb/fjwf9T9afn9Yj6Y/z87ToZTSGI6xow4joRBWwuwQY5PYMlzfNk+0eV3rFioVGauFAJFH8SRdwiXohMHuleUylZkR3JZwlfZSlr+cafPJbrz4yv1o01CCimkp7TXBV14n6nSQVld6ocxCz+vu+WU8CZZ1/ZsmDlWiFdPzkB5ZLNKil0KBLbCexyydLrgmfylsuEQZYKC2gF0yyUj2cxBIsYYHUj6/McgsNnaZVInidswVkSL3gCuSNw03EiImgJ6MiCLSfuLBj9dgKelrwo5WdoPFZ8FQ9oAkXKIAr2OkpwLpKJ23f9qW519FFCOJUKLDgBJ43cilJUMuFqr4D5ci0eZgkYgs8xW1II+Ka6k0JSlFnGX8cI3XDAQP2FjGz4ugIrRSFvtzlETMuIZWrvt0Y7Havy1RgQgEAJnM0uFR8fT8d+A8w7BclsqheX6+2QDgaHUO9xJ6qF9ovAXJyYi9BcYE/vvzMwF6fm4sxcDM0FwcatQ7BiIFYQxIqCWGEQKw5iBUKsSIgVCrFiCaxYAhsPKxbYsiZWViwBxvJv/fuGBe93FtxGzUbUrlJnAwRPx+WRSttYH1TMrrvdE1alH2ssq+zdzf2cfn6jEh+clEFrNeEa2V0JT2m+Vzmyfho5vnVfaVe/15KrSQ5nFz1rGdPUiy++nybfNZYvr7ExuMEYV4gHe+hVl9JStZKa+PA8rld4VNcrfdHXSzzw6xVe7X5tHP1cmnNlMFTH5XS8Ab3DXx/k3IGXODV/b5x7VQilpj6h02MFDFSr4mVzrIGX1aMaaBo19LxxbAMvIdTYjRKHcSII2gSGfGwCgdEaGPOxBqKsNTDmYw3MUGt0wKGHN50txtQCaYOpvtZbVAxUOxDRs5921BVLg6vWbnHUANsBis6i6YUWGw2yeuhsUWmg1RNsi0qDrR5IW1qtwbYjHV17DLajGXXtdTodjaKLjyodFdTFR42OAuqJFzWMZIyRRG0yNbeoHagzPXioXv+sh6sCaCJDqPY4buzpOBKJfZSoL9cngqcRr5VQ3zoS8P3HdMfVxj+uOogxZtwATY1AXJ8XRmFAHO61jQ4FsTrp7M2sotslU19/9ZuwCq+W7uieb/AeXSJbwGLnilNNTzkPXK555pAtUFJLvJSB7rijpeYwkCdQK+UKF1mVLlKpmKIQm+t5bvqNGyBrXt/NF2AOHcMJkIX/wcn8aYAN/zcnTSZwzL96JsIGC46C57jwm7bbkSpIvt7IbcIus6UwWUYU/s5iXqUAluKggAvSvJem3JQI+K1DEWjdyILnipjbkVegdSi6oqUEcZUqwlj1JNvIq1Lif6cqYPv8GA6Ci0V/Trz++Szwwmh44p1dLEJv/mnRP+/1w5PhPABiVJO9GxK+jJTtDf2hpo1ht5Jw1EpJr3nMNIG5Z/h2XmF/HfDUrUww20TMZKjVSQWJmtmehqezARmEHjnrz7ywNz/3zmazvrfokT4J+qQ374dNtnkM1N9TPB9y5GSg57PdS2NCtzDBq9TBYmvuZOBcZKpJ4j3nWAJXrzhILG8t/JLditx4UqeoEsXKascHbP/0H1BLAwQUAAAACAAzpw9djvfMTfIDAAAcDgAADQAAAHhsL3N0eWxlcy54bWzNV9uO2zYQfS/QfxD4LutiybEMy8H6IiBAGhTYLZCHfaElyibCi0DRWzlF/71DSrblzWW1RhL0xSaH5JlDzuEMNX/bcOY8EVVTKVIUjHzkEJHLgopdiv56yNwpcmqNRYGZFCRFR1Kjt4vff5vX+sjI/Z4Q7QCEqFO017qaeV6d7wnH9UhWRMBIKRXHGrpq59WVIriozSLOvND3Jx7HVKAWYcbzISAcq0+Hys0lr7CmW8qoPlos5PB89m4npMJbBlSbIMK50wQTFTqNOjmx1i/8cJorWctSjwDXk2VJc/Il3cRLPJxfkAD5NqQg9vzwau+NuhEp8hR5oiZ8aDEXB55xXTu5PAidovBsctqRdwXEeBIhp43KShZwTkXxOOL8cXQ8Iu8EcTU//tb8R2e/n3E+q2uz0uu8L+alFH0SEAM489knIf8WmRkCEsDMzFrM68/OE2Zg8Q1GLplUjgYFAbHA8sGctDNWmNGtosZYYk7ZsTWHxmBF183jFCRgCbUe2t+tmfXTfVmXNfikjJ3DEJnNgmExB8VqokQGHadrPxwr2KqAy9VStvNemL1T+BiE8fAFtWS0MCx2K3vAardNUZZt7jZZZmG23QAVBWkIqAREYuj0CA8l99xXF0wQnaZGlP7oTZIk02AynU6TaBxEkY3gaxjYU4JT3kpVQOo6yd2cc2tazBkpNaAqutubfy0r40NqDdd7MS8o3kmBmdniaUV/JaQ8yG4p4qSgBw6wrS6fn45xcuVj4DpgcyIzcEXL/GXi11seCP7z6QwkYqNlgzVwwY9l3kkBhJUTxu6NBD6WZ3WZlNWUvcQIpdLcdpNTTRMk2TVbJbUdo7A+Wovdh/VvwnWa8uzgW6yCC6sQOX1W59UOrip2NEnZpNuuBzvpku8Vclc4XtrxM+wPB74lKrP15uuotrz8YNRoUHBeSfUWzGFH+0rkij5JvTxASjBvNqOxARIY9yUAsT4J6HsSaMeWVs8XgdwxuhOctJpZzKEst11nLxX9DKE0ZTkHA2nLcFO+niAI9v9NEI7z1xK0aQQSRy87XeWmc5ZxzJMpRR/MlWM9ltsDZVCCv5KXALNoLpnOZi1tHtE2B569gEoLUuID0w/nwRRd2n/YagmR62b9aWRqIVJ0abezEuODNPp9DQkf/p2Doin6Z7N8k6w3WehO/eXUjcYkdpN4uXbjaLVcr7PED/3Vv72n/G2PZt885O2XBwgziGY1g+e+6jbbkb+/2FLU67w3NcreOQ9o97kn4cS/iwPfzcZ+4EYTPHWnk3HsZnEQrifRchNncY97fBv3wPeC4EI+nmnKCaPiFKtThPpWCBJ0v7MJsxUbCe/yWbf4D1BLAwQUAAAACAAzpw9dvaC/vRwHAAAdIgAAEwAAAHhsL3RoZW1lL3RoZW1lMS54bWztWktvGzcQvhfofyD2nliyJccyIgeWLMVJ/IKtpMiRWlG7tLjLBUnZ0a1IjgUKFE2LXgr01kPRNkAC9JL+Grcp2hTIX+iQqwcpUbGcB/qyA8RL7jfD4bw4O/T1Gw8Shk6IkJSn1aB4tRAgkoa8Q9OoGtxtNa+sBUgqnHYw4ympBgMigxsbH35wHa+rmCQEAX0q13E1iJXK1peWZAjTWF7lGUnhXZeLBCsYimipI/Ap8E3Y0nKhsLqUYJoGKMUJsN3vdmlIUEuzDDZGzBsMhqmSeiJk4kizJg6FwXZ6Rf1LDmSdCXSCWTWAdTr8tEUeqAAxLBW8qAYF8xMsbVxfGhMxNYfWomuanyHdkKDTWzZriqg9XrTYLFWubY35GwBTs7hGo1FvFMf8DACHIew0l8XmWWquFWsjnhYof5zlXS+UCyUXb/FfmeFfqdVq5cpQlpypAeWPpRn8WmG1tLns4A0ox5dn5a9t1uurDt6AcvzqDL55rbJacvEGFDOa9mbQ2p5jy4whXc62vfA1gK+NHGCCAm8Ye5deostTNc/XEnzMRRMAxrhY0RSpQUa6OAQvruOkLSgOUIZTLmGisFxoFlbgf/2vZJ5KWhd4nWCLLp8K5cyUlgTJUNBMVYPbwDWwIK+ef//q+VP06vmTs4fPzh7+dPbo0dnDH3NeDuE2TiOb8OW3n/359cfoj6ffvHz8hR8vbfyvP3zyy8+f+4EQX5P9v/jyyW/Pnrz46tPfv3vsgW8K3LbhLZoQifbIKTrkCezNIzlpi4tRtGJMHQocA28P64aKHeDeADMfrkZc5d0TkFp8wJv9Y0fWo1j0FfWsfCdOHOAu56zGhVcBd/RaloZb/TTyLy76Nu4Q4xPf2nWcOqZt9DPIqeCys7qvx8QR84DhVOGIpEQh/Y73CPGQ3afU0esuDQWXvKvQfYpqmHpV0qJtx5EmRNs0AbsMfAKCqR3d7N5DNc58u94iJy4SAgIzj/Atwhw13sR9hRMfyxZOmK3wHaxin5BHAxHauIZUYOmIMI4aHSKlj2ZfwH4to9/BkM28Zt9lg8RFCkV7Pp47mHMbucV79RgnmVdmmsY29pbsgYtidMCVD77L3QjRY7ADTuea+x4ljrnPTwR3aeSINHEQ/aYvPLa8SbgbjwPWxcSXZTZF4iTWTcjhPu+o9SPHtXcIYfgUdwhBd295JKjxzNH5ROjbMWSVbeJzrNvY9VU9TomE2kgXM7NhukOl47JHJOJz5NkdTCWeAU4TLOZx3gOrO64LZ5s3le6zsGcD9yjUfOAvXqXsS+BhOXdjHteDGDunlh5Lv78OhGO/RWIM4vL4onEJNOTCNJDYF9ZNCzNngYnDtDBFO750CySO+Sck+lw1ZH0vXdcN2okZoBpyipyEpq+reBgFA05VPOXLiicv2aYrnnmZZXuqzpmH+xdWN1u4nx4QOFBmU9dlcXNZ3AT/+eJmXixfljSXJc1lSeP7CHsvJc2kioECZ9LhMc2SZG67p0sZO1IDRnak6fhI+LDpNGHSDEw/ctz+y2J4HHa6HFwksKFBgquPqIqPYpxBc6hompeRHLKOJMq4hJ6RmfbyNo1RCi0h0+Msj7qZgMZql3fy6RW7yzlmY3qekemkjhZa0QwWXWzl2rB1+oaLFXOpFtxa0YhmKgZna+Mtw2Zmt2Z2ONQmfDEj+M4GLa9Cs1lzgz4alNcdrfe8Azwyi9HJuzSRjOGbcGgjve/ZjRSNkUa+MnIjj410x/IcrVmrVTTbt1htESPZy5XmLDey3ttYaaSdiZV03E6FI0vt4GQpOq0GlfJyOUAhzqpBFxq08JhkYHWpv3cwi+CWI1Qid8Rzg9mgJtas+N2yCD33OdZ0lsiEVFtYxrlrmFejS4DUtJON/MtlUOu72kDu6W8gxcoaOMPfJgXI7JqWdLskVLaxrRnTTzeAYfDzviLiKO6cojbri0MM5teuCvvpUAmfZSYj6AFcCmltm5GbnIdBZ1/FGFw+j1kW42G61SE6iuQcbnQ+lsGMLPHGI7ObiexTw0W3YkL+HW3FduP/2Vb0eQKt7ZWOuYmBO0mBkY7XasCFijlkoSymYVPAhYzxAPAWuFiE16B8uBk1vwU50b/zmMt5mLCGDqU6pBESFM4jFQtCDiAtGe87h1lxeHblLEeM8pieiCuzXOw2OSGspXPIqj7bAxSPsskwDRjctP+546HbtSNdsPxTK588mC9aHkwqn5x+wVqkZCV96yiovJ0IFzxq84w1s+Pl8sJHbQYXFHAvqcAnQipCaDSa0hes3OKHkDrRuKJE4NVX8sID6QSZP7WhcMonc2fSrN5vGTWpdMfrvsfi0zrmx8WZu5wTi6+vPi+m7KGGHV3bla5H1WCA6RDV5dHoQ8YYxvx9hv0nFLx9DIbegsvqPlMyv4Z+ANdRcGTl190Q/LlxDenGX1BLAwQUAAAACAAzpw9dPWd/6dICAAB5BgAADwAAAHhsL3dvcmtib29rLnhtbKVVUW/aMBB+n7T/4FlIewqJTYA0AqpSyobUVUjt2kdkEkOsJnbkGAiq+t93DoRCUaWqi8DhfL7vvu98Nr3LMkvRmutCKNnHpOlhxGWkYiGXffz3YewEGBWGyZilSvI+3vICXw6+f+ttlH6eK/WMAEAWfZwYk4euW0QJz1jRVDmX4FkonTEDpl66Ra45i4uEc5OlLvW8jpsxIfEOIdSfwVCLhYj4SEWrjEuzA9E8ZQboF4nIixotiz4DlzH9vMqdSGU5QMxFKsy2AsUoi8LJUirN5inILkkblRo+HfgSDwZaZwLXWapMRFoVamGaAO3uSJ/pJ55LyEkJyvMafA7JhyKshd3DAyvd+SIrW9AdFlRhtzVW8n+jEWitGo5+Ea194EbxoLcQKX/ctS5ieX7HMrtTKUYpK8xNLAyP+7gLptrwkwm9yocrkYKXtj0aYHdwaOepRgBruJ5qsWbRFs4ERjFfsFVqHqC164QwT31KOza21GFdsqnRCH5PRrdA4Z6tgRDIjvf9OoGMpDWTkQ7J7GVM/IsgGBOn5Q2Hjj+8uHGCbmvstAltdQM6avvB9SvUTHfCSLGVSfZaLXQf+yDszPWHlbWHeOFKxG80Xrz949j3u6H2vVo59lQ/Cr4p3qpiTVQ+CRmrDRQt6ASgalvbDqFgbirvk4hNAksuPP8w95uLZQKUSTuwkywyYs0f2LyqLZwkS7SPTwiOdgTH8FTDCUH3iGF1nQDT6o1k1QLTO/SLS66Z4eiWs4KjK8nSbSHgdqjWVfuAkQ5tXj2JiZV9jPBhFJz6QxR9HzVlGvJD7xznaR1FtGyEW1OGrhKSx7ZtQcCRtZcxK1OZNWfjqh1HzLA5SLHdHLH0vpYB9UxEHHN7eePBz4+l//zRuGqQsPHUID33KBkQOiUC6BGcAvuq6kQpJVWBcrFW5prBBQ903wxYCVPV0m5wXFW/UnsS5db/GoN/UEsDBBQAAAAIADOnD13Iobj6uAAAADQBAAAjAAAAeGwvd29ya3NoZWV0cy9fcmVscy9zaGVldDIueG1sLnJlbHOFj8EKwjAQRO+C/xD2btJ6EJGmvYjgVeoHrOm2DbZJyEbRvzfHCoK32R32zU7VvOZJPCmy9U5DKQsQ5IzvrBs0XNvTZg+CE7oOJ+9Iw5sYmnq9qi40YcpHPNrAIlMcaxhTCgel2Iw0I0sfyGWn93HGlMc4qIDmjgOpbVHsVFwyoP5iinOnIZ67EkT7Djn5P9v3vTV09OYxk0s/IlSwT59avE2UqRgHShqkXKx5oUuZfwdVV+qra/0BUEsDBBQAAAAIADOnD12cQC9QcQMAAO0KAAAYAAAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1snVZNb+M2EL0X6H8geOgtkqhY8UdtLxYJ3F1gWwRN2z3T0sgmQokCSSdxiv73DilRVpAWkBI4GkojPr6ZeeJw/emlkuQJtBGq3lAWJZRAnatC1IcN/fOP3dWCEmN5XXCpatjQMxj6afvjD+tnpR/NEcASRKjNhh6tbVZxbPIjVNxEqoEaPaXSFbd4qw+xaTTwwk+qZJwmyU1ccVHTFmGlx2CoshQ53Kn8VEFtWxANklvkb46iMQGtysfAVVw/npqrXFUNQuyFFPbsQSmp8tXXQ60030uM+4XNeE5eNP5S/L8Oy/jn71aqRK6VUaWNEDluOb8PfxkvY573SO/jHwXDZpiAJ+EKeIFKP0aJZT1WegG7/iCYq0xLzKVLr06i2NC/k+7vCi1zl+RyCb5/6HZdCKywm0w0lBv6ma2+p3Mab9deQH8JeDaDMXF63Cv16BxfcZ0EIRpeAzk/NFhV1DYlVjXfoLS3ICUCYoQ8t+IJ7vG1Dd0ra1Xl/F7xFh+VWr1C7dcECfguknGYb15Gb9xTGo4DvZ3/BO41KaDkJ2lvlfwuCntESiyapdl8wdKMBu/v6vkLiMPRMU6jOTq8xFbF+Q5MjprH0KLUccqVxCXwSirhvl2ULH/x9rmDn0WLLJvdLBzKHozddXnITwZDDSQ6rBYFk+JR0AaU5XQUrLdHQRtQxlOYdZPRhsmL6RRwPU8BbUBBNiOz4D5/NxltmMyiOUuW1xNSOe9A0F5AJhcE919PBW2Hki4mU1l2IGj7ekRsltw44Y3MCcPW0AoMB4FKMpkK63U6EOp8MpmgUzYQ6gdUwoJS3SCk5ibK5sm1/yjH5iZolg1EO4/SRcaySTkOqmUD2WaDTWIsnyBgNlBwMjnJQcFsID7cfCZHFeTHLvpLk+lRpUGB6UA6i+l80n6TeyOey1Y8MstpEI8b9JvMWPHE7f7tW8cdtzy0jnbMT1bthLSgL+0Po/7PLrr83y6KXaLhB/iV64OoDZHY3Fz7wLrqtsX4MbZFP3J6900w3B3xuAZ4LEkiDLBUCtm0Nx3uA9hTgx2xAf0gXrEtYn2VFtik/HlsQyUeHE2OfkqO6HhV6JF3jXDt2Z06rcj7e8Rs19v5hbZrVRRf/IPtT7xqfr69/438AjVobM3kG3AD5HPN5dkIs44v767jtyhxf1Dd/gtQSwMEFAAAAAgAM6cPXVaLGl6LBwAAuCoAABgAAAB4bC93b3Jrc2hlZXRzL3NoZWV0Mi54bWydmtty4kYQhu9TlXegdG9gdDJQxqm1geiQVG1lc7iWhTAqAyKSfEoq755uCcH0iGnQunYB6+vpmfk1av1Gc/fTx3bTe0vyIs12U0P0h0Yv2cXZMt09T40/fl/cjIxeUUa7ZbTJdsnU+EwK46f7H3+4e8/yl2KdJGUPMuyKqbEuy/1kMCjidbKNin62T3ZAVlm+jUr4NX8eFPs8iZZVo+1mYA6H7mAbpTujzjDJr8mRrVZpnMyy+HWb7Mo6SZ5sohLGX6zTfdFk28bXpNtG+cvr/ibOtntI8ZRu0vKzSmr0tvHEf95lefS0gXl/CDuKex85/DPhv9V0Ux1v9bRN4zwrslXZh8yDeszt6Y8H40EUHzO1539VGmGDAG8pnsBTKvP7hiScYy7zlMz6zmR4ZuqBoVz55DVdTo1/h4efG3gX+DK8GQp8kX7+M+7vlimcYWzcy5PV1PgiJqEljMH9XbWA/kyT90L63Cujp2/JJonLBDoRRg/X51OWvWCgD4eGkHIf7ZLe57c9nOWpARMss/0vyap8TDYb6AAGGcVl+pZ8hbCp8ZSVZbZFXl0BJRxa5dk/ya4aQ9UVDg5z0uA6ySlp8Xc9AQsbDo6jlz83M1lUV8vXvLdMVtHrpnzMNn+ly3INMxJ923RuR8J0jIb+lr17Sfq8hskIs38LoFqNk+XnLCliuDxg1n0Te42zDXQBr71tipc5rO7oo5bpkN7tjxzHdkeY5SkpygVKBDx+LUCFZhCHXHUWELDKAu9NFrt7FlC9ygLvTZZR3xw5wnFxqleOxT5kgfdDFhM+XtkYuqmGAO9N47Gk9pVZsGRglttTltu+sIddpgHFtsoB781IIO2VAxg3ZxVqeNP6egXFcVGcVoVp9Z3boVWtOX4Qg3qFVYt7FpXR/V2evfegokGyAi4RuD+ICXZRLVZICxffOo1fHrJ6mZ1buA5csTHmWGCSSlgILuDo2/3wbvAGF1B8iPi5jhhV6xObePWB8fGA384haI5AzRFKOQYwneOcYMGTOZ296g4D+YLBUwPO4nHsJu33oR1h0YjHdoRNI2btCIdGzNsRLo1YYEFs9L1V9JXZiDJPZmPKfJkJ5aQFBCpnIyTwJBk5EVAzrj8REHycnlAUfiBQEfeRQEXXGYGKpHMCFU0XOPqpYZ9dzwzzGOYzLGBYeJ4RsaGeXi32DIJPYisLZk6gsmIW2I1OFYZ5DPMZFjAsPM+IKlDIrlcFq15zhZnK1TAnULkaFtiNThWGeQzzGRYwLDzPiCpQ7q5XhdRGpTjOCVRVwW50qjDMY5jPsIBh4XlGVIEb2PWqyHc7UylXcwKVcrXAbnSqMMxjmM+wgGHheUZUwT8wZYfA3U1nEHy6gtRbHIHq3Q270anCMI9hPsMChoXnGVEFzNz1qkDwSRXlNjMnUCnFC+xGpwrDPIb5DAsYFp5nRBUB1vZ6WTD6pItyo5kTainVeFH1pFOGgx4HfQ4GHAw1kMqjum32WkI7fpTHUmrrnFKlLC+Q6uVhoMe19DkYcDDUQCpPF+M+E7IDtdQKTKlagpHq5WGgx7X0ORhwMNRAKk8XOz0Tsre11FJMqVqLkerl4bwv19LnYMDBUAOpPJ0MsJBNrqXWZErVooxULw9ngrmWPgcDDoYaSOXp5ISF7HatVmmWqd0qzZwZxsQ67TwO+hwMOBhqIJWnkyUWsu21W6WZ0FZp5lwxJtbLw/lirmXAwVADqTydvLGQ/a/dKs2EtkozZ48xsV4eziBzLQMOhhpI5elkkoVshO1WaSa0VZo5n4yJ9fJwTplrGXAw1EAqTye3LGRHbLdKM6Gt0swZZkysl4ezzFzLgIOhBtLvKzu5ZlN2zbZamgl11NKMVHvn4qDHQZ+DAQdDDaTydHLNpuyaHbU0U6qWZqR6eTjXzLX0ORhwMNRAKk8n12zKrtlRSzOlamlGqpeHc81cS5+DAQdDDaTydHLNpuyandZ39IS2vp/nXDMm1tYeDvocDDgYaiCVp5Nrxod2xz9JHbU0U6qWZqT61cO5Zq6lz8GAg6EGUnk6uWZ8DneSp1WaZeq2SjPnmjGxfvVwXyJzLQMOhhpI5enkmk3ZF7ut0kxoqzTL3le41V4E9RnYxRAPR6DT0SdQDF1rbJl9azQ+/ChPIztFh5qOqZidPLYpu2i3VcgJbRVy2SlbzjktL0V42L9eShmaljt2R33VqgQkgyYo1HRDhevkvk3ZX7utEk9oq8TLHtp0cBmqi/BShIf964WToXCdMewrcW+bnTfqE3GS6lJ0qOmYStnFqT+ashd31eenSI8TNc3hObUuhngki6K2T6CwXRf23/Qd+3DFKnegoFN0qOmYPuDu4twfLNm5u+r9EekFuS6HeCRElYvAi3J1ig41HVO5ujj5L7Cb7HQ3ddXn0EgvyXUxxCNZWnLJ7S/L1SUat8qdqwK1XPUmtHqfzjbJn6vNakUvzl5xz5gJOxKOR+vNdwsxgR01sLlGOe7Dprzq+OCUBrfZPSe/Rvlzuit6G9g/h9vQoGDn9Va16jPsvKs+4caiap9d89sadogmsIFn2AdDu8qysvkFOznuOb3/H1BLAQIUABQAAAAIADOnD12Q7xzWmgEAAG0HAAATAAAAAAAAAAAAIAC2gQAAAABbQ29udGVudF9UeXBlc10ueG1sUEsBAhQAFAAAAAgAM6cPXbVVMCPuAAAATAIAAAsAAAAAAAAAAAAgALaBywEAAF9yZWxzLy5yZWxzUEsBAhQAFAAAAAgAM6cPXRLeaV2eAQAAbAMAABAAAAAAAAAAAAAgALaB4gIAAGRvY1Byb3BzL2FwcC54bWxQSwECFAAUAAAACAAzpw9dvUtLpTIBAABRAgAAEQAAAAAAAAAAACAAtoGuBAAAZG9jUHJvcHMvY29yZS54bWxQSwECFAAUAAAACAAzpw9dTUHW0hoBAAB7BAAAGgAAAAAAAAAAACAAtoEPBgAAeGwvX3JlbHMvd29ya2Jvb2sueG1sLnJlbHNQSwECFAAUAAAACAAzpw9d4it/e7sAAAAzAQAAMgAAAAAAAAAAACAAtoFhBwAAeGwvcGl2b3RDYWNoZS9fcmVscy9waXZvdENhY2hlRGVmaW5pdGlvbjEueG1sLnJlbHNQSwECFAAUAAAACAAzpw9diWJpeYwFAADeFAAAJwAAAAAAAAAAACAAtoFsCAAAeGwvcGl2b3RDYWNoZS9waXZvdENhY2hlRGVmaW5pdGlvbjEueG1sUEsBAhQAFAAAAAgAM6cPXUy/A+iWAwAARCcAACQAAAAAAAAAAAAgALaBPQ4AAHhsL3Bpdm90Q2FjaGUvcGl2b3RDYWNoZVJlY29yZHMxLnhtbFBLAQIUABQAAAAIADOnD10KQQzqvQAAAEcBAAApAAAAAAAAAAAAIAC2gRUSAAB4bC9waXZvdFRhYmxlcy9fcmVscy9waXZvdFRhYmxlMS54bWwucmVsc1BLAQIUABQAAAAIADOnD11g9AG5kAUAAD0YAAAeAAAAAAAAAAAAIAC2gRkTAAB4bC9waXZvdFRhYmxlcy9waXZvdFRhYmxlMS54bWxQSwECFAAUAAAACAAzpw9djvfMTfIDAAAcDgAADQAAAAAAAAAAACAAtoHlGAAAeGwvc3R5bGVzLnhtbFBLAQIUABQAAAAIADOnD129oL+9HAcAAB0iAAATAAAAAAAAAAAAIAC2gQIdAAB4bC90aGVtZS90aGVtZTEueG1sUEsBAhQAFAAAAAgAM6cPXT1nf+nSAgAAeQYAAA8AAAAAAAAAAAAgALaBTyQAAHhsL3dvcmtib29rLnhtbFBLAQIUABQAAAAIADOnD13Iobj6uAAAADQBAAAjAAAAAAAAAAAAIAC2gU4nAAB4bC93b3Jrc2hlZXRzL19yZWxzL3NoZWV0Mi54bWwucmVsc1BLAQIUABQAAAAIADOnD12cQC9QcQMAAO0KAAAYAAAAAAAAAAAAIAC2gUcoAAB4bC93b3Jrc2hlZXRzL3NoZWV0MS54bWxQSwECFAAUAAAACAAzpw9dVosaXosHAAC4KgAAGAAAAAAAAAAAACAAtoHuKwAAeGwvd29ya3NoZWV0cy9zaGVldDIueG1sUEsFBgAAAAAQABAAfwQAAK8zAAAAAA== xl/worksheets/sheet1.xml xl/worksheets/sheet3.xml 1 0 Lease Liability - Undiscounted 1 Lease Liability - Discounted 2 Operating Unit 3 Lease Category 4 Representation 5 Lease Num 6 Lease Name 7 Undiscounted Liability within 1yr 8 Undiscounted Liability within 5yr 9 Undiscounted Liability Over 5yr 10 Discounted Liability within 1yr 11 Discounted Liability within 5yr 12 Discounted Liability over 5yr 13 Vision Operations 14 Property 15 Operating Lease 16 1240 17 ABL Direct 18 1241 19 AUT Direct 20 1283 21 Westlake East Operations 22 1351 23 1371 24 WL Direct Lease 25 1391 26 Beech Hill Lease for OPEX 27 1411 28 WPM Lease for Variable Rent 29 1431 30 WPM Lease for VR - True Up 31 1451 32 WPM-Lease for VR-Non Cum 33 1471 34 WPM-VR-Early Termination 35 1491 36 Vision HQ Pleasanton 37 1492 38 Vision Santa Clara 39 1493 40 Kansas City Distribution 41 1494 42 Singapore Distribution Center 43 1495 44 Seattle Distribution Center 45 1496 46 Acme New York Mall - CAM 47 1516 48 Acme New York Mall 49 1536 50 Vintage Oaks Store 101 51 1537 52 Redwood City Store 419 53 1557 54 Walker Point Mall-Milestone Alerts 55 1577 56 APEM - Milestone Alerts 57 1637 58 Expense Lease Accounting 59 3637 60 Lease for Prepayment 61 8637 62 EC O1 - EC Property Management 63 9638 64 EC O2 - EC Property Management 65 9639 66 EC O3 - EC Property Management 67 Operating Lease Total 68 Property Total 69 Grand Total data A1 1 data B1 1 data C1 1 data D1 1 data E1 1 data F 2 data F1 1 data G1 1 data H1 1 data I1 1 data J 2 data J1 1 data K 2 data K1 1 data L1 1 data M1 1 data N1 1 data O1 1 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 V 4 data V1 1 data W1 1 parameter A1 1 parameter A10 1 parameter A11 1 parameter A12 1 parameter A2 1 parameter A3 1 parameter A4 1 parameter A5 1 parameter A6 1 parameter A7 1 parameter A8 1 parameter B1 5 parameter B10 5 parameter B11 5 parameter B12 5 parameter B2 5 parameter B3 3 parameter B4 5 parameter B5 5 parameter B6 5 parameter B7 5 parameter B8 5 S Site 423709AB0EF03DC257E977E2C8169882