<ROOT>
 <APPS_INITIALIZE_DATA>
  <USER_NAME>ENGINATICS</USER_NAME>
  <RESPONSIBILITY_KEY>SYSTEM_ADMINISTRATOR</RESPONSIBILITY_KEY>
  <APPLICATION_SHORT_NAME>SYSADMIN</APPLICATION_SHORT_NAME>
 </APPS_INITIALIZE_DATA>
<REPORTS>
<!-- loader xml for Enginatics Blitz Report: XLA Subledger Accounting Rules Detail Listing -->
 <REPORTS_ROW>
  <GUID>C6E085D472CC51A9E05362FB09050512</GUID>
  <SQL_TEXT>       SELECT sr.name name_adr, 
       sr.segment_rule_type_dsp, 
       sr.segment_rule_code,
       sr.description adr_description,
       decode(sr.flexfield_assign_mode_code,&apos;A&apos;, &apos;Flexfield&apos;, &apos;V&apos;, &apos;Value Set&apos;, &apos;S&apos;, &apos;Segment&apos;) flexfield_assign_mode_code,
       sr.flexfield_segment_name,
       sr.flexfield_segment_code,
       sr.flex_value_set_id,
       sr.flex_value_set_name,
       sd.user_sequence adr_priority,
       decode(sd.value_type_code,&apos;A&apos;, &apos;Account Derivation Rule&apos;, &apos;S&apos;, &apos;Source&apos;, &apos;M&apos;, &apos;Mapping Set&apos;, &apos;C&apos;, &apos;Constant&apos;) output_value_type_code,
       sd.value_source_type_code,
       sd.value_source_code,
       sd.value_constant,
       sd.value_code_combination_id,
       sd.value_mapping_set_code,
       sd.value_flexfield_segment_code,
       sd.value_segment_rule_code,
       sd.input_source_type_code,
       sd.input_source_code,
       xla_conditions_pkg.Display_condition_substr(sd.application_id,:P_AMB_CONTEXT_CODE,NULL,NULL,NULL,NULL,sd.segment_rule_detail_id,NULL,NULL,&apos;S&apos;,1,4000) adr_condition,
	   xla_conditions_pkg.Display_condition_substr(sd.application_id,:P_AMB_CONTEXT_CODE,NULL,NULL,NULL,NULL,sd.segment_rule_detail_id,NULL,NULL,&apos;S&apos;,4001,4000) adr_condition_2,
	   xla_conditions_pkg.Display_condition_substr(sd.application_id,:P_AMB_CONTEXT_CODE,NULL,NULL,NULL,NULL,sd.segment_rule_detail_id,NULL,NULL,&apos;S&apos;,8001,4000) adr_condition_3,
	   xla_conditions_pkg.Display_condition_substr(sd.application_id,:P_AMB_CONTEXT_CODE,NULL,NULL,NULL,NULL,sd.segment_rule_detail_id,NULL,NULL,&apos;S&apos;,12001,4000) adr_condition_4,
	   xla_conditions_pkg.Display_condition_substr(sd.application_id,:P_AMB_CONTEXT_CODE,NULL,NULL,NULL,NULL,sd.segment_rule_detail_id,NULL,NULL,&apos;S&apos;,16001,4000) adr_condition_5,
	   xla_conditions_pkg.Display_condition_substr(sd.application_id,:P_AMB_CONTEXT_CODE,NULL,NULL,NULL,NULL,sd.segment_rule_detail_id,NULL,NULL,&apos;S&apos;,20001,4000) adr_condition_6,
	   xla_conditions_pkg.Display_condition_substr(sd.application_id,:P_AMB_CONTEXT_CODE,NULL,NULL,NULL,NULL,sd.segment_rule_detail_id,NULL,NULL,&apos;S&apos;,24001,4000) adr_condition_7,
	   xla_conditions_pkg.Display_condition_substr(sd.application_id,:P_AMB_CONTEXT_CODE,NULL,NULL,NULL,NULL,sd.segment_rule_detail_id,NULL,NULL,&apos;S&apos;,28001,4000) adr_condition_8,
	   xla_conditions_pkg.Display_condition_substr(sd.application_id,:P_AMB_CONTEXT_CODE,NULL,NULL,NULL,NULL,sd.segment_rule_detail_id,NULL,NULL,&apos;S&apos;,32001,4000) adr_condition_9,
	   XLA_RPT_SARDLR_PKG.populate_fields
		    (sd.value_type_code                 ,
			 sd.value_source_application_id     ,
			 sd.value_source_type_code          ,
			 sd.value_source_code               ,     
			 sd.value_mapping_set_code          ,
			 value_code_combination_id          ,
			 sd.amb_context_code                ,
			 sd.value_segment_rule_appl_id      ,
			 sd.value_segment_rule_type_code    ,
			 sd.value_segment_rule_code         ,
			 sr.flexfield_assign_mode_code      ,
			 sd.value_constant                  ,
			 sr.flex_value_set_id               ,  
			 input_source_code                  ,
			 input_source_application_id        ,
			 input_source_type_code             ,
			 value_flexfield_segment_code       ,
			 transaction_coa_id                 ,
			 accounting_coa_id                  ,
			 1
			 ) adr_value,
         XLA_RPT_SARDLR_PKG.populate_fields
		    (sd.value_type_code                 ,
			 sd.value_source_application_id     ,
			 sd.value_source_type_code          ,
			 sd.value_source_code               ,     
			 sd.value_mapping_set_code          ,
			 value_code_combination_id          ,
			 sd.amb_context_code                ,
			 sd.value_segment_rule_appl_id      ,
			 sd.value_segment_rule_type_code    ,
			 sd.value_segment_rule_code         ,
			 sr.flexfield_assign_mode_code      ,
			 sd.value_constant                  ,
			 sr.flex_value_set_id               ,  
			 input_source_code                  ,
			 input_source_application_id        ,
			 input_source_type_code             ,
			 value_flexfield_segment_code       ,
			 transaction_coa_id                 ,
			 accounting_coa_id                  ,
			 2
			 ) adr_input,
		XLA_RPT_SARDLR_PKG.populate_fields
		   (sd.value_type_code                 ,
			sd.value_source_application_id     ,
			sd.value_source_type_code          ,
			sd.value_source_code               ,
			sd.value_mapping_set_code          ,
			value_code_combination_id          ,
			sd.amb_context_code                ,
			sd.value_segment_rule_appl_id      ,
			sd.value_segment_rule_type_code    ,
			sd.value_segment_rule_code         ,
			sr.flexfield_assign_mode_code      ,
			sd.value_constant                  ,
			sr.flex_value_set_id               ,
			input_source_code                  ,
			input_source_application_id        ,
			input_source_type_code             ,
			value_flexfield_segment_code       ,
			transaction_coa_id                 ,
			accounting_coa_id                  ,
			3
			) adr_segment
FROM   xla_seg_rules_fvl sr           ,
       xla_seg_rule_details sd
WHERE  sd.application_id             = :P_APPLICATION_ID
   AND sr.application_id             = sd.application_id
   AND sr.enabled_flag = &apos;Y&apos;
   AND sr.segment_rule_type_code     = sd.segment_rule_type_code
   AND sr.segment_rule_code          = sd.segment_rule_code
   AND sr.amb_context_code            = :P_AMB_CONTEXT_CODE
   AND sd.amb_context_code            = :P_AMB_CONTEXT_CODE
   AND (sr.segment_rule_type_code, sr.segment_rule_code) IN   
(   
SELECT DISTINCT adr.segment_rule_type_code, 
                adr.segment_rule_code 
FROM   xla_acctg_method_rules slam, 
       xla_product_rules_fvl aad, 
       xla_aad_line_defn_assgns jld, 
       xla_line_defn_adr_assgns_f_v adr, 
       xla_line_definitions_vl jld_2 
WHERE  accounting_method_code = :P_SLAM_CODE 
       AND slam.application_id = :P_APPLICATION_ID 
       AND slam.accounting_method_type_code = :P_SLAM_TYPE_CODE 
       AND slam.amb_context_code = :P_AMB_CONTEXT_CODE 
       AND aad.amb_context_code = :P_AMB_CONTEXT_CODE 
       AND Trunc(SYSDATE) BETWEEN (slam.start_date_active) AND Trunc(Nvl(slam.end_date_active,To_date(&apos;31/12/9714&apos;,&apos;DD/MM/YYYY&apos;))) 
       AND aad.application_id = slam.application_id 
       AND aad.product_rule_type_code = slam.product_rule_type_code 
       AND aad.product_rule_code = slam.product_rule_code 
       AND aad.product_rule_type_code = jld.product_rule_type_code 
       AND aad.product_rule_code = jld.product_rule_code 
       AND aad.enabled_flag = &apos;Y&apos; 
       AND jld.application_id = :P_APPLICATION_ID 
       AND jld.amb_context_code = :P_AMB_CONTEXT_CODE 
       AND jld.event_class_code = adr.event_class_code 
       AND jld.event_type_code = adr.event_type_code 
       AND jld.line_definition_owner_code = adr.line_definition_owner_code 
       AND jld.line_definition_code = adr.line_definition_code 
       AND adr.amb_context_code = :P_AMB_CONTEXT_CODE 
       AND adr.application_id = :P_APPLICATION_ID 
       AND jld.event_class_code = Nvl(:P_EVENT_CLASS_CODE,jld.event_class_code) 
       AND jld.event_type_code = Nvl(:P_EVENT_TYPE_CODE,jld.event_type_code) 
       AND adr.event_class_code = Nvl(:P_EVENT_CLASS_CODE,adr.event_class_code) 
       AND adr.event_type_code = Nvl(:P_EVENT_TYPE_CODE,adr.event_type_code) 
       AND adr.segment_rule_code IS NOT NULL 
       AND jld_2.enabled_flag = &apos;Y&apos; 
       AND jld_2.event_class_code = Nvl(:P_EVENT_CLASS_CODE,jld_2.event_class_code) 
       AND jld_2.event_type_code = Nvl(:P_EVENT_TYPE_CODE,jld_2.event_type_code) 
       AND jld_2.application_id = :P_APPLICATION_ID 
       AND jld_2.amb_context_code = :P_AMB_CONTEXT_CODE 
       AND jld.event_class_code = jld_2.event_class_code 
       AND jld.event_type_code = jld_2.event_type_code 
       AND jld.line_definition_owner_code = jld_2.line_definition_owner_code 
       AND jld.line_definition_code = jld_2.line_definition_code)
   order by name_adr, adr_priority
</SQL_TEXT>
  <ENABLED>Y</ENABLED>
  <XDO_APPLICATION_SHORT_NAME>XLA</XDO_APPLICATION_SHORT_NAME>
  <XDO_DATA_SOURCE_CODE>XLASARDLR</XDO_DATA_SOURCE_CODE>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <REPORT_NAME>XLA تقرير قائمة تفاصيل القواعد المحاسبية للأستاذ الفرعي</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Application: محاسبة الأستاذ الفرعي
Source: تقرير قائمة تفاصيل القواعد المحاسبية للأستاذ الفرعي
Short Name: XLASARDLR
DB package: XLA_RPT_SARDLR_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>XLA Regeln für die Nebenbuchkontierung - Details</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Application: Subledger Accounting
Source: Regeln für die Nebenbuchkontierung - Details
Short Name: XLASARDLR
DB package: XLA_RPT_SARDLR_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>E</LANGUAGE>
    <REPORT_NAME>XLA Informe Listado de Detalles de Reglas Contables de Libro Auxiliar</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Application: Subledger Accounting
Source: Informe Listado de Detalles de Reglas Contables de Libro Auxiliar
Short Name: XLASARDLR
DB package: XLA_RPT_SARDLR_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>XLA Etat Liste détaillée des règles de comptabilité auxiliaire</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Application: Subledger Accounting
Source: Etat Liste détaillée des règles de comptabilité auxiliaire
Short Name: XLASARDLR
DB package: XLA_RPT_SARDLR_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>I</LANGUAGE>
    <REPORT_NAME>XLA Rapporto sull&apos;elenco dei dettagli delle regole contabili del sezionale</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Application: Subledger Accounting
Source: Rapporto sull&apos;elenco dei dettagli delle regole contabili del sezionale
Short Name: XLASARDLR
DB package: XLA_RPT_SARDLR_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>JA</LANGUAGE>
    <REPORT_NAME>XLA 補助元帳会計ルール詳細リスト・レポート</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Application: Subledger Accounting
Source: 補助元帳会計ルール詳細リスト・レポート
Short Name: XLASARDLR
DB package: XLA_RPT_SARDLR_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>KO</LANGUAGE>
    <REPORT_NAME>XLA 보조원장 회계 규칙 상세 목록 보고서</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Application: Subledger Accounting
Source: 보조원장 회계 규칙 상세 목록 보고서
Short Name: XLASARDLR
DB package: XLA_RPT_SARDLR_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>PTB</LANGUAGE>
    <REPORT_NAME>XLA Relatório de Listagens Detalhado de Regras Contábeis do Sub-Razão</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Application: Subledger Accounting
Source: Relatório de Listagens Detalhado de Regras Contábeis do Sub-Razão
Short Name: XLASARDLR
DB package: XLA_RPT_SARDLR_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>RU</LANGUAGE>
    <REPORT_NAME>XLA Список сведений о правилах учета на основе субкниг</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Application: Учет на основе субкниг
Source: Список сведений о правилах учета на основе субкниг
Short Name: XLASARDLR
DB package: XLA_RPT_SARDLR_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>S</LANGUAGE>
    <REPORT_NAME>XLA Sidoordnad redovisning, lista över regeldetaljer - rapport</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Application: Sidoordnad redovisning
Source: Sidoordnad redovisning, lista över regeldetaljer - rapport
Short Name: XLASARDLR
DB package: XLA_RPT_SARDLR_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>TR</LANGUAGE>
    <REPORT_NAME>XLA Cari Hesap Muhasebe Kuralları Detay Listesi Raporu</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Application: Cari Hesap Muhasebesi
Source: Cari Hesap Muhasebe Kuralları Detay Listesi Raporu
Short Name: XLASARDLR
DB package: XLA_RPT_SARDLR_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>XLA Subledger Accounting Rules Detail Listing</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Application: Subledger Accounting
Source: Subledger Accounting Rules Detail Listing Report
Short Name: XLASARDLR
DB package: XLA_RPT_SARDLR_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>ZHS</LANGUAGE>
    <REPORT_NAME>XLA 子分类帐会计规则明细列表报表</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Application: 子分类帐会计系统
Source: 子分类帐会计规则明细列表报表
Short Name: XLASARDLR
DB package: XLA_RPT_SARDLR_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
  </REPORT_TRANSLATIONS>
  <CATEGORY_ASSIGNMENTS>
   <CATEGORY_ASSIGNMENTS_ROW>
    <CATEGORY>BI Publisher</CATEGORY>
   </CATEGORY_ASSIGNMENTS_ROW>
  </CATEGORY_ASSIGNMENTS>
  <ANCHORS>
   <ANCHORS_ROW>
    <ANCHOR>:p_amb_context_code</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_application_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_application_name</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_event_class_code</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_event_class_name</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_event_type_code</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_event_type_name</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_slam_code</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_slam_name</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_slam_type_code</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_slam_type_name</ANCHOR>
   </ANCHORS_ROW>
  </ANCHORS>
  <PARAMETERS>
   <PARAMETERS_ROW>
    <SORT_ORDER>1</SORT_ORDER>
    <DISPLAY_SEQUENCE>-80</DISPLAY_SEQUENCE>
    <ANCHOR>:p_slam_type_name</ANCHOR>
    <PARAMETER_TYPE_DSP>Char</PARAMETER_TYPE_DSP>
    <DEFAULT_VALUE>SELECT :$flex$.owner.VALUE FROM DUAL</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>P_SLAM_TYPE_NAME</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>2</SORT_ORDER>
    <DISPLAY_SEQUENCE>-70</DISPLAY_SEQUENCE>
    <ANCHOR>:p_amb_context_code</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>XLA_SRS_AMB_CONTEXT_CODES</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
lk.lookup_code id,
lk.meaning value,
null description
from
xla_lookups lk
where lookup_type=&apos;XLA_AMB_CONTEXT_TYPE&apos;
and lookup_code=fnd_profile.value(&apos;XLA_AMB_CONTEXT&apos;)
order by value,description</LOV_QUERY_DSP>
    <DEFAULT_VALUE>select meaning from xla_lookups where lookup_type = &apos;XLA_AMB_CONTEXT_TYPE&apos; and lookup_code = FND_PROFILE.VALUE(&apos;XLA_AMB_CONTEXT&apos;)</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>XLA_SRS_AMB_CONTEXT_CODES</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>3</SORT_ORDER>
    <DISPLAY_SEQUENCE>-60</DISPLAY_SEQUENCE>
    <ANCHOR>:p_slam_name</ANCHOR>
    <PARAMETER_TYPE_DSP>Char</PARAMETER_TYPE_DSP>
    <DEFAULT_VALUE>SELECT :$flex$.subledger_accounting_method.VALUE FROM DUAL</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>P_SLAM_NAME</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>4</SORT_ORDER>
    <DISPLAY_SEQUENCE>-50</DISPLAY_SEQUENCE>
    <ANCHOR>:p_application_name</ANCHOR>
    <PARAMETER_TYPE_DSP>Char</PARAMETER_TYPE_DSP>
    <DEFAULT_VALUE>SELECT :$flex$.application.VALUE FROM DUAL</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>P_APPLICATION_NAME</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>5</SORT_ORDER>
    <DISPLAY_SEQUENCE>-40</DISPLAY_SEQUENCE>
    <ANCHOR>:p_aad</ANCHOR>
    <PARAMETER_TYPE_DSP>Char</PARAMETER_TYPE_DSP>
    <DEFAULT_VALUE>SELECT AAD.PRODUCT_RULE_CODE FROM xla_acctg_method_rules_fvl slam, xla_product_rules_fvl aad, xla_acctg_methods_fvl slam2 WHERE slam.accounting_method_code = :$flex$.subledger_accounting_method AND slam.application_id = :$flex$.application  AND slam.accounting_method_type_code = :$flex$.owner  AND slam.amb_context_code = :$FLEX$.XLA_SRS_AMB_CONTEXT_CODES AND aad.amb_context_code = :$FLEX$.XLA_SRS_AMB_CONTEXT_CODES  AND Trunc(SYSDATE) BETWEEN (slam.start_date_active) AND Trunc(Nvl(slam.end_date_active,To_date(&apos;31/12/9714&apos;,&apos;DD/MM/YYYY&apos;))) AND aad.application_id = slam.application_id AND aad.product_rule_type_code = slam.product_rule_type_code  AND aad.product_rule_code = slam.product_rule_code  AND aad.enabled_flag = &apos;Y&apos;  AND slam.accounting_method_code = slam2.accounting_method_code AND slam.accounting_method_type_code = slam2.accounting_method_type_code</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>P_AAD</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>6</SORT_ORDER>
    <DISPLAY_SEQUENCE>-30</DISPLAY_SEQUENCE>
    <ANCHOR>:p_aad_owner</ANCHOR>
    <PARAMETER_TYPE_DSP>Char</PARAMETER_TYPE_DSP>
    <DEFAULT_VALUE>SELECT AAD.PRODUCT_RULE_TYPE_CODE FROM xla_acctg_method_rules_fvl slam, xla_product_rules_fvl aad, xla_acctg_methods_fvl slam2 WHERE slam.accounting_method_code = :$flex$.subledger_accounting_method AND slam.application_id = :$flex$.application  AND slam.accounting_method_type_code = :$flex$.owner  AND slam.amb_context_code = :$FLEX$.XLA_SRS_AMB_CONTEXT_CODES AND aad.amb_context_code = :$FLEX$.XLA_SRS_AMB_CONTEXT_CODES  AND Trunc(SYSDATE) BETWEEN (slam.start_date_active) AND Trunc(Nvl(slam.end_date_active,To_date(&apos;31/12/9714&apos;,&apos;DD/MM/YYYY&apos;))) AND aad.application_id = slam.application_id AND aad.product_rule_type_code = slam.product_rule_type_code  AND aad.product_rule_code = slam.product_rule_code  AND aad.enabled_flag = &apos;Y&apos;  AND slam.accounting_method_code = slam2.accounting_method_code AND slam.accounting_method_type_code = slam2.accounting_method_type_code</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>P_AAD_OWNER</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>7</SORT_ORDER>
    <DISPLAY_SEQUENCE>-20</DISPLAY_SEQUENCE>
    <ANCHOR>:p_event_class_name</ANCHOR>
    <PARAMETER_TYPE_DSP>Char</PARAMETER_TYPE_DSP>
    <DEFAULT_VALUE>SELECT :$flex$.event_class.VALUE FROM DUAL</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>P_EVENT_CLASS_NAME</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>8</SORT_ORDER>
    <DISPLAY_SEQUENCE>-10</DISPLAY_SEQUENCE>
    <ANCHOR>:p_event_type_name</ANCHOR>
    <PARAMETER_TYPE_DSP>Char</PARAMETER_TYPE_DSP>
    <DEFAULT_VALUE>SELECT :$flex$.event_type.VALUE FROM DUAL</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>P_EVENT_TYPE_NAME</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>9</SORT_ORDER>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <ANCHOR>:p_slam_type_code</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>XLA_SARDLR_SLAM_OWNER</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
lookup_code id,
meaning value,
null description
from
xla_lookups
where
lookup_type=&apos;XLA_OWNER_TYPE&apos;
order by value,description</LOV_QUERY_DSP>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>المالك</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Verantwortlicher</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>E</LANGUAGE>
      <PARAMETER_NAME>Propietario</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Propriétaire</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Proprietario</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>JA</LANGUAGE>
      <PARAMETER_NAME>所有者</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>KO</LANGUAGE>
      <PARAMETER_NAME>소유자</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>PTB</LANGUAGE>
      <PARAMETER_NAME>Proprietário</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>RU</LANGUAGE>
      <PARAMETER_NAME>Владелец</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>S</LANGUAGE>
      <PARAMETER_NAME>Ägare</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>TR</LANGUAGE>
      <PARAMETER_NAME>Sahip</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Owner</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>责任人</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>10</SORT_ORDER>
    <DISPLAY_SEQUENCE>20</DISPLAY_SEQUENCE>
    <ANCHOR>:p_slam_code</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>XLA_SARDLR_SLAMS</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
accounting_method_code id,
name value,
null description
from
xla_acctg_methods_fvl
where
accounting_method_type_code=:$flex$.xla_sardlr_slam_owner
and enabled_flag=&apos;Y&apos;
order by value,description</LOV_QUERY_DSP>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>الطريقة المحاسبية للأستاذ الفرعي</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Nebenbuch-Rechnungslegungsart</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>E</LANGUAGE>
      <PARAMETER_NAME>Método de Contabilidad Auxiliar</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Méthode de comptabilité auxiliaire</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Metodo contabilità sezionale</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>JA</LANGUAGE>
      <PARAMETER_NAME>補助元帳会計処理基準</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>KO</LANGUAGE>
      <PARAMETER_NAME>보조원장 회계 방법</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>PTB</LANGUAGE>
      <PARAMETER_NAME>Método Contábil do Sub-razão</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>RU</LANGUAGE>
      <PARAMETER_NAME>Метод учета на основе субкниг</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>S</LANGUAGE>
      <PARAMETER_NAME>Metod för sidoordnad redovisning</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>TR</LANGUAGE>
      <PARAMETER_NAME>Cari Hesap Muhasebesi Yöntemi</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Subledger Accounting Method</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>子分类帐会计方法</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>11</SORT_ORDER>
    <DISPLAY_SEQUENCE>30</DISPLAY_SEQUENCE>
    <ANCHOR>:p_application_id</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>XLA_SARDLR_APPLICATIONS</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
application_id id,
application_name value,
null description
from
xla_subledgers_fvl
where
application_id=decode(fnd_global.resp_appl_id,101,application_id,fnd_global.resp_appl_id)
and application_id in ((select slam.application_id from xla_acctg_method_rules_fvl slam,
xla_product_rules_fvl aad
where slam.accounting_method_code=:$flex$.xla_sardlr_slams
and slam.accounting_method_type_code=:$flex$.xla_sardlr_slam_owner
and slam.amb_context_code=:$flex$.xla_srs_amb_context_codes
and aad.amb_context_code=:$flex$.xla_srs_amb_context_codes
and trunc(sysdate) between (slam.start_date_active) and trunc(nvl(slam.end_date_active,to_date(&apos;31/12/9714&apos;,&apos;DD/MM/YYYY&apos;)))
and aad.application_id=slam.application_id
and aad.product_rule_type_code=slam.product_rule_type_code
and aad.product_rule_code=slam.product_rule_code
and aad.enabled_flag=&apos;Y&apos;)
)
order by value,description</LOV_QUERY_DSP>
    <DEFAULT_VALUE>SELECT application_name FROM XLA_SUBLEDGERS_FVL WHERE application_id = decode(fnd_global.RESP_APPL_ID,101,NULL,fnd_global.RESP_APPL_ID) and application_id in (select slam.APPLICATION_ID from xla_acctg_method_rules_fvl slam,        xla_product_rules_fvl aad        where  slam.accounting_method_code = :$flex$.subledger_accounting_method        AND slam.accounting_method_type_code = :$flex$.owner        AND slam.amb_context_code = :$FLEX$.XLA_SRS_AMB_CONTEXT_CODES        AND aad.amb_context_code = :$FLEX$.XLA_SRS_AMB_CONTEXT_CODES        AND Trunc(SYSDATE) BETWEEN (slam.start_date_active) AND Trunc(Nvl(slam.end_date_active,To_date(&apos;31/12/9714&apos;,&apos;DD/MM/YYYY&apos;)))        AND aad.application_id = slam.application_id        AND aad.product_rule_type_code = slam.product_rule_type_code        AND aad.product_rule_code = slam.product_rule_code        AND aad.enabled_flag = &apos;Y&apos;)</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>التطبيق</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Anwendung</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>E</LANGUAGE>
      <PARAMETER_NAME>Aplicación</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Applicazione</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>JA</LANGUAGE>
      <PARAMETER_NAME>アプリケーション</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>KO</LANGUAGE>
      <PARAMETER_NAME>애플리케이션</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>PTB</LANGUAGE>
      <PARAMETER_NAME>Aplicação</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>RU</LANGUAGE>
      <PARAMETER_NAME>Приложение</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>S</LANGUAGE>
      <PARAMETER_NAME>Applikation</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>TR</LANGUAGE>
      <PARAMETER_NAME>Uygulama Yazılımı</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Application</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>应用产品</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>12</SORT_ORDER>
    <DISPLAY_SEQUENCE>40</DISPLAY_SEQUENCE>
    <ANCHOR>:p_event_class_code</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>XLA_SARDLR_EVENTCLASS</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
event_class_code id,
event_class_name value,
null description
from
xla_event_classes_fvl
where
application_id=:$flex$.xla_sardlr_applications
and event_class_code in
(
select distinct ec.event_class_code from xla_aad_line_defn_assgns lda,xla_event_classes_fvl ec,xla_event_types_tl et
where
lda.application_id=:$flex$.xla_sardlr_applications
and ec.enabled_flag=&apos;Y&apos;
and lda.product_rule_code=(select aad.product_rule_code from xla_acctg_method_rules_fvl slam,xla_product_rules_fvl aad,xla_acctg_methods_fvl slam2 where slam.accounting_method_code=:$flex$.xla_sardlr_slams and slam.application_id=:$flex$.xla_sardlr_applications and slam.accounting_method_type_code=:$flex$.xla_sardlr_slam_owner and slam.amb_context_code=:$flex$.xla_srs_amb_context_codes and aad.amb_context_code=:$flex$.xla_srs_amb_context_codes and trunc(sysdate) between (slam.start_date_active) and trunc(nvl(slam.end_date_active,to_date(&apos;31/12/9714&apos;,&apos;DD/MM/YYYY&apos;))) and aad.application_id=slam.application_id and aad.product_rule_type_code=slam.product_rule_type_code and aad.product_rule_code=slam.product_rule_code and aad.enabled_flag=&apos;Y&apos; and slam.accounting_method_code=slam2.accounting_method_code and slam.accounting_method_type_code=slam2.accounting_method_type_code)
and lda.product_rule_type_code=(select aad.product_rule_type_code from xla_acctg_method_rules_fvl slam,xla_product_rules_fvl aad,xla_acctg_methods_fvl slam2 where slam.accounting_method_code=:$flex$.xla_sardlr_slams and slam.application_id=:$flex$.xla_sardlr_applications and slam.accounting_method_type_code=:$flex$.xla_sardlr_slam_owner and slam.amb_context_code=:$flex$.xla_srs_amb_context_codes and aad.amb_context_code=:$flex$.xla_srs_amb_context_codes and trunc(sysdate) between (slam.start_date_active) and trunc(nvl(slam.end_date_active,to_date(&apos;31/12/9714&apos;,&apos;DD/MM/YYYY&apos;))) and aad.application_id=slam.application_id and aad.product_rule_type_code=slam.product_rule_type_code and aad.product_rule_code=slam.product_rule_code and aad.enabled_flag=&apos;Y&apos; and slam.accounting_method_code=slam2.accounting_method_code and slam.accounting_method_type_code=slam2.accounting_method_type_code)
and lda.amb_context_code=:$flex$.xla_srs_amb_context_codes
and ec.application_id=lda.application_id
and ec.event_class_code=lda.event_class_code
and et.event_type_code=lda.event_type_code
and et.application_id=lda.application_id
and et.language=userenv(&apos;LANG&apos;)
and et.event_class_code=ec.event_class_code)
order by value,description</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>طبقة الحدث</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Ereignisklasse</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>E</LANGUAGE>
      <PARAMETER_NAME>Clase de Evento</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Classe d&apos;événement</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Classe evento</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>JA</LANGUAGE>
      <PARAMETER_NAME>イベント区分</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>KO</LANGUAGE>
      <PARAMETER_NAME>이벤트 분류</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>PTB</LANGUAGE>
      <PARAMETER_NAME>Classe do Evento</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>RU</LANGUAGE>
      <PARAMETER_NAME>Класс события</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>S</LANGUAGE>
      <PARAMETER_NAME>Händelseklass</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>TR</LANGUAGE>
      <PARAMETER_NAME>Olay Sınıfı</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Event Class</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>事件分类</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>13</SORT_ORDER>
    <DISPLAY_SEQUENCE>50</DISPLAY_SEQUENCE>
    <ANCHOR>:p_event_type_code</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>XLA_SARDLR_EVENTTYPE</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
event_type_code id,
name value,
null description
from
xla_event_types_tl
where
application_id=:$flex$.xla_sardlr_applications
and language=userenv(&apos;LANG&apos;)
and event_type_code in
(
select distinct et.event_type_code from xla_aad_line_defn_assgns lda,xla_event_classes_fvl ec,xla_event_types_tl et
where
lda.application_id=:$flex$.xla_sardlr_applications
and lda.product_rule_code=(select aad.product_rule_code from xla_acctg_method_rules_fvl slam,xla_product_rules_fvl aad,xla_acctg_methods_fvl slam2 where slam.accounting_method_code=:$flex$.xla_sardlr_slams and slam.application_id=:$flex$.xla_sardlr_applications and slam.accounting_method_type_code=:$flex$.xla_sardlr_slam_owner and slam.amb_context_code=:$flex$.xla_srs_amb_context_codes and aad.amb_context_code=:$flex$.xla_srs_amb_context_codes and trunc(sysdate) between (slam.start_date_active) and trunc(nvl(slam.end_date_active,to_date(&apos;31/12/9714&apos;,&apos;DD/MM/YYYY&apos;))) and aad.application_id=slam.application_id and aad.product_rule_type_code=slam.product_rule_type_code and aad.product_rule_code=slam.product_rule_code and aad.enabled_flag=&apos;Y&apos; and slam.accounting_method_code=slam2.accounting_method_code and slam.accounting_method_type_code=slam2.accounting_method_type_code)
and lda.product_rule_type_code=(select aad.product_rule_type_code from xla_acctg_method_rules_fvl slam,xla_product_rules_fvl aad,xla_acctg_methods_fvl slam2 where slam.accounting_method_code=:$flex$.xla_sardlr_slams and slam.application_id=:$flex$.xla_sardlr_applications and slam.accounting_method_type_code=:$flex$.xla_sardlr_slam_owner and slam.amb_context_code=:$flex$.xla_srs_amb_context_codes and aad.amb_context_code=:$flex$.xla_srs_amb_context_codes and trunc(sysdate) between (slam.start_date_active) and trunc(nvl(slam.end_date_active,to_date(&apos;31/12/9714&apos;,&apos;DD/MM/YYYY&apos;))) and aad.application_id=slam.application_id and aad.product_rule_type_code=slam.product_rule_type_code and aad.product_rule_code=slam.product_rule_code and aad.enabled_flag=&apos;Y&apos; and slam.accounting_method_code=slam2.accounting_method_code and slam.accounting_method_type_code=slam2.accounting_method_type_code)
and lda.amb_context_code=:$flex$.xla_srs_amb_context_codes
and ec.application_id=lda.application_id
and ec.event_class_code=lda.event_class_code
and lda.event_class_code=:$flex$.xla_sardlr_eventclass.id
and et.event_type_code=lda.event_type_code
and et.application_id=lda.application_id
and et.language=userenv(&apos;LANG&apos;)
and et.event_class_code=ec.event_class_code)
order by value,description</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>نوع الحدث</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Ereignisart</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>E</LANGUAGE>
      <PARAMETER_NAME>Tipo de Evento</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Type d&apos;événement</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Tipo di evento</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>JA</LANGUAGE>
      <PARAMETER_NAME>イベント・タイプ</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>KO</LANGUAGE>
      <PARAMETER_NAME>이벤트 유형</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>PTB</LANGUAGE>
      <PARAMETER_NAME>Tipo de Evento</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>RU</LANGUAGE>
      <PARAMETER_NAME>Тип события</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>S</LANGUAGE>
      <PARAMETER_NAME>Händelsetyp</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>TR</LANGUAGE>
      <PARAMETER_NAME>Olay Tipi</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Event Type</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>事件类型</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
  </PARAMETERS>
  <PARAMETER_DEPENDENCIES>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$FLEX$.XLA_SRS_AMB_CONTEXT_CODES</FLEX_BIND>
    <PARAMETER_NAME>XLA_SRS_AMB_CONTEXT_CODES</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Application</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$FLEX$.XLA_SRS_AMB_CONTEXT_CODES</FLEX_BIND>
    <PARAMETER_NAME>XLA_SRS_AMB_CONTEXT_CODES</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>P_AAD</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$FLEX$.XLA_SRS_AMB_CONTEXT_CODES</FLEX_BIND>
    <PARAMETER_NAME>XLA_SRS_AMB_CONTEXT_CODES</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>P_AAD_OWNER</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.application</FLEX_BIND>
    <PARAMETER_NAME>Application</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>P_AAD</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.application</FLEX_BIND>
    <PARAMETER_NAME>Application</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>P_AAD_OWNER</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.application.VALUE</FLEX_BIND>
    <PARAMETER_NAME>Application</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>P_APPLICATION_NAME</DEPENDENT_PARAMETER_NAME>
    <ID_OR_VALUE>value</ID_OR_VALUE>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.event_class.VALUE</FLEX_BIND>
    <PARAMETER_NAME>Event Class</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>P_EVENT_CLASS_NAME</DEPENDENT_PARAMETER_NAME>
    <ID_OR_VALUE>value</ID_OR_VALUE>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.event_type.VALUE</FLEX_BIND>
    <PARAMETER_NAME>Event Type</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>P_EVENT_TYPE_NAME</DEPENDENT_PARAMETER_NAME>
    <ID_OR_VALUE>value</ID_OR_VALUE>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.owner</FLEX_BIND>
    <PARAMETER_NAME>Owner</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Application</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.owner</FLEX_BIND>
    <PARAMETER_NAME>Owner</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>P_AAD</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.owner</FLEX_BIND>
    <PARAMETER_NAME>Owner</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>P_AAD_OWNER</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.owner.VALUE</FLEX_BIND>
    <PARAMETER_NAME>Owner</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>P_SLAM_TYPE_NAME</DEPENDENT_PARAMETER_NAME>
    <ID_OR_VALUE>value</ID_OR_VALUE>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.subledger_accounting_method</FLEX_BIND>
    <PARAMETER_NAME>Subledger Accounting Method</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Application</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.subledger_accounting_method</FLEX_BIND>
    <PARAMETER_NAME>Subledger Accounting Method</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>P_AAD</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.subledger_accounting_method</FLEX_BIND>
    <PARAMETER_NAME>Subledger Accounting Method</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>P_AAD_OWNER</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.subledger_accounting_method.VALUE</FLEX_BIND>
    <PARAMETER_NAME>Subledger Accounting Method</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>P_SLAM_NAME</DEPENDENT_PARAMETER_NAME>
    <ID_OR_VALUE>value</ID_OR_VALUE>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.xla_sardlr_applications</FLEX_BIND>
    <PARAMETER_NAME>Application</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Event Class</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.xla_sardlr_applications</FLEX_BIND>
    <PARAMETER_NAME>Application</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Event Type</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.xla_sardlr_eventclass.id</FLEX_BIND>
    <PARAMETER_NAME>Event Class</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Event Type</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.xla_sardlr_slam_owner</FLEX_BIND>
    <PARAMETER_NAME>Owner</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Application</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.xla_sardlr_slam_owner</FLEX_BIND>
    <PARAMETER_NAME>Owner</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Event Class</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.xla_sardlr_slam_owner</FLEX_BIND>
    <PARAMETER_NAME>Owner</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Event Type</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.xla_sardlr_slam_owner</FLEX_BIND>
    <PARAMETER_NAME>Owner</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Subledger Accounting Method</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.xla_sardlr_slams</FLEX_BIND>
    <PARAMETER_NAME>Subledger Accounting Method</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Application</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.xla_sardlr_slams</FLEX_BIND>
    <PARAMETER_NAME>Subledger Accounting Method</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Event Class</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.xla_sardlr_slams</FLEX_BIND>
    <PARAMETER_NAME>Subledger Accounting Method</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Event Type</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.xla_srs_amb_context_codes</FLEX_BIND>
    <PARAMETER_NAME>XLA_SRS_AMB_CONTEXT_CODES</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Application</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.xla_srs_amb_context_codes</FLEX_BIND>
    <PARAMETER_NAME>XLA_SRS_AMB_CONTEXT_CODES</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Event Class</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.xla_srs_amb_context_codes</FLEX_BIND>
    <PARAMETER_NAME>XLA_SRS_AMB_CONTEXT_CODES</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Event Type</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
  </PARAMETER_DEPENDENCIES>
  <TEMPLATES>
  </TEMPLATES>
  <DEFAULT_TEMPLATES>
  </DEFAULT_TEMPLATES>
  <UPLOAD_COLUMNS>
  </UPLOAD_COLUMNS>
  <UPLOAD_PARAMETERS>
  </UPLOAD_PARAMETERS>
  <UPLOAD_SQLS>
  </UPLOAD_SQLS>
  <UPLOAD_DEPENDENCIES>
  </UPLOAD_DEPENDENCIES>
 </REPORTS_ROW>
</REPORTS>
</ROOT>
