XLA Subledger Accounting Rules Detail Listing
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
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 |