SLA

SLA:

SLA is a module which now sits between the sub ledgers Like AP/AR etc.. and GL.

SLA will act as Mediator between the Sub ledger and GL.

SLA Methods Query :

SELECT acct_mtd.NAME,

       act_mtd_rule.application_name,

       act_mtd_rule.product_rule_name,

       act_mtd_rule.start_date_active,

       ldf.event_class_name,

       ldf.event_type_name,

       ldf.validation_status,

       aad_lda.line_definition_name,

       aad_lda.line_definition_desc,

       djlt.accounting_line_name,

       djlt.accounting_line_owner,

       jldadr.flexfield_segment_name,

       jldadr.segment_rule_name,

       jldadr.segment_rule_owner,

       jldadr.segment_rule_desc,

       srf.NAME,

       DECODE ( srf.segment_rule_type_code,

                'S', 'Source',

                'C', 'Account Derivation Rule',

                srf.segment_rule_type_code

              ) "Value Type"

  FROM xla_acctg_methods_fvl acct_mtd,

       xla_acctg_method_rules_fvl act_mtd_rule,

       xla_product_rules_fvl prod_rule,

       xla_prod_acct_headers_fvl prod_acct,

       xla_aad_line_defn_assgns_f_v aad_lda,

       xla_line_definitions_f_v ldf,

       xla_line_defn_jlt_assgns_f_v djlt,

       xla_line_defn_adr_assgns_f_v jldadr,

       xla_seg_rules_fvl srf,

       xla_seg_rule_details srd

WHERE 1 = 1

   AND acct_mtd.accounting_method_code = act_mtd_rule.accounting_method_code

   AND prod_rule.product_rule_code = act_mtd_rule.product_rule_code

   AND prod_rule.product_rule_code = prod_acct.product_rule_code

   AND prod_acct.product_rule_code = aad_lda.product_rule_code

   AND prod_acct.event_type_code = aad_lda.event_type_code

   AND aad_lda.line_definition_code = ldf.line_definition_code

   AND aad_lda.event_type_code = ldf.event_type_code

   AND ldf.line_definition_code = djlt.line_definition_code

   AND djlt.accounting_line_code = jldadr.accounting_line_code

   AND jldadr.line_definition_code = djlt.line_definition_code

   AND srf.segment_rule_code = jldadr.segment_rule_code

   AND srf.segment_rule_code = srd.segment_rule_code

   AND acct_mtd.NAME = <Accounting Method Name>

   AND act_mtd_rule.product_rule_name = <Product Rule Name>

ORDER BY flexfield_segment_name;