XLA Subledger Accounting Rules Detail Listing

Description
Categories: BI Publisher, Financials
Application: Subledger Accounting
Source: Subledger Accounting Rules Detail Listing Report
Short Name: XLASARDLR
DB package: XLA_RPT_SARDLR_PKG
       SELECT sr.name name_adr, 
       sr.segment_rule_type_dsp, 
       sr.segment_rule_code,
       sr.description adr_description,
       decode(sr.flexfield_assign_mode_code,'A', 'Flexfield', 'V', 'Value Set', 'S', 'Segment') 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,'A', 'Account Derivation Rule', 'S', 'Source', 'M', 'Mapping Set', 'C', 'Constant') 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,'S',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,'S',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,'S',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,'S',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,'S',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,'S',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,'S',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,'S',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,'S',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 = 'Y'
   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('31/12/9714','DD/MM/YYYY'))) 
       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 = 'Y' 
       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 = 'Y' 
       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
Parameter Name SQL text Validation
P_EVENT_TYPE_NAME
 
P_EVENT_CLASS_NAME
 
P_AAD_OWNER
 
P_AAD
 
P_APPLICATION_NAME
 
P_SLAM_NAME
 
XLA_SRS_AMB_CONTEXT_CODES
 
LOV Oracle
P_SLAM_TYPE_NAME
 
Event Type
 
LOV Oracle
Event Class
 
LOV Oracle
Application
 
LOV Oracle
Subledger Accounting Method
 
LOV Oracle
Owner
 
LOV Oracle