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 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;
No comments:
Post a Comment