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 ...
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
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 |
|