Table query for Account Combination Rule and Segment Rules
Summary:
Hi All,
Now I'd like to query accounting method->rule set-> account combination rule and segment rule in task 'Manage Accounting Method'.
but cant find table about Account Combination Rule and Segment Rules
Do you know which table(s) store those information?
I already have following sql to query about accounting method and rule set:
select
--xse.ACCOUNTING_METHOD_CODE ,
xamt.name method_name,
xs.JE_SOURCE_NAME,
jt.name rule_set_name,
--xl.accounting_line_code
xjt.name rule_name
from
XLA_SLAM_JE_RULE_SETS xse,
xla_subledgers xs,
XLA_JE_RULE_SETS_TL jt,
XLA_JERS_JLT_LINES xl,
0