Procurement - EBS (MOSC)

MOSC Banner

SQL query for expense account rules

edited Sep 2, 2019 5:00AM in Procurement - EBS (MOSC) 2 commentsAnswered
 Hello Gurus,
I wish to export all expense account rules and reorganize them.
However Oracle has not given export button on that web form.

I tried below SQL

SELECT * FROM PO_RULE_EXPENSE_ACCOUNTS

but it does not give me the category name.

can anyone give me the SQL, such that i can export all the expense account rules as shown in the oracle web form as shown below.

Account Rule Type Account Rule Value Segment Name Segment Value

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center