XLA Subledger Accounting Rules Detail Listing

➜ Back to Library
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 
 
Download
Related Blitz Reports
XLA Validate Application Accounting Definitions - draft GMF Create Accounting JL Create Accounting for Latin American AR and AP FA Create Accounting - Assets JL Create Accounting for Latin American FA JA Create Accounting for Asia/Pacific AR and AP JA Create Accounting for Asia/Pacific FA CST Create Accounting - Receiving CST Create Accounting - Cost Management
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: