General Ledger - EBS (MOSC)

MOSC Banner

R11 - Relationship between GL tables and Cost tables (Drilldown)

edited Mar 19, 2013 11:34AM in General Ledger - EBS (MOSC) 3 commentsAnswered ✓
 Hi, all.

My company is on version 11.5.10.2

I must develop a report about the general ledger journal completing it with the source information from each journal.
I am facing some problems to find the relationship between the tables gl_je_lines/gl_interface and cst_ae_lines, to this relation i am using the column gl_sl_link_id, but  this id is not unique and query i getting duplicate rows.

My query:

select *
  from gl_interface gi
     , cst_ae_lines cal
 where gi.set_of_books_id = 204
   and gi.user_je_source_name = 'Periodic Inventory'
   and gi.gl_sl_link_id = cal.gl_sl_link_id

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