XLA Subledger Accounting Rules Detail Listing

Description
Categories: BI Publisher
Columns: Name Adr, Segment Rule Type Dsp, Segment Rule Code, Adr Description, Flexfield Assign Mode Code, Flexfield Segment Name, Flexfield Segment Code, Flex Value Set Id, Flex Value Set Name, Adr Priority ...
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
Owner
 
LOV Oracle
Subledger Accounting Method
 
LOV Oracle
Application
 
LOV Oracle
Event Class
 
LOV Oracle
Event Type
 
LOV Oracle
P_SLAM_TYPE_NAME
 
XLA_SRS_AMB_CONTEXT_CODES
 
LOV Oracle
P_SLAM_NAME
 
P_APPLICATION_NAME
 
P_AAD
 
P_AAD_OWNER
 
P_EVENT_CLASS_NAME
 
P_EVENT_TYPE_NAME