R11 - Relationship between GL tables and Cost tables (Drilldown)
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
0