XLA Subledger Accounting Rules Detail Listing

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Subledger Accounting
Source: Subledger Accounting Rules Detail Listing Report
Short Name: XLASARDLR
DB package: XLA_RPT_SARDLR_PKG
Run XLA Subledger Accounting Rules Detail Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
       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
Download
Related Blitz Reports
XLA Validate Application Accounting Definitions- Not Supported: Reserved For Future Use GL Account Analysis (Distributions) GL Account Analysis (Distributions) 11g XLA Trial Balance - Manual SLA AP Amounts XLA Create Accounting GMF Create Accounting GL Account Analysis CST Create Accounting - Receiving CST Create Accounting - Cost Management
Blitz Report™

Blitz Report™ provides multiple benefits:

Blitz Report™