Payables and Cash Management - EBS (MOSC)

MOSC Banner

How to Get the Group_Id From Payables To General Ledger?

edited Mar 10, 2011 7:00PM in Payables and Cash Management - EBS (MOSC) 2 commentsAnswered
Hello!

I am working in one customized version of the Accounting Entries Report and the user request that need include in the report the group_id that is write by oracle payables in the table gl_interface.
The group_id is stored in some table in oracle payables during the gl transfer? Where can I get this column information from oracle payables's tables?
Next the query of the report:

select a.set_of_books_id, a.set_of_books_id, g.user_je_category_name, .user_je_category_name, d.accounting_date, .accounting_date, h.displayed_field event_type, .displayed_field event_type

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