You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Table query for Account Combination Rule and Segment Rules

Accepted answer
54
Views
4
Comments

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!