As Part of regular Designing and Trouble shooting of General Ledger and Subledger Accounting Analysis it is required to have knowledge of Technical Drill Down and Link between GL and Subledger Tables.
Please see the Below mentioned select Statement to Identify relation between various tables for DrillDown from GL To Subledger and Vice Verse.
select
GL.NAME,GJH.JE_HEADER_ID,GJH.JE_CATEGORY,GJH.JE_SOURCE,GJH.NAME,GJH.STATUS, GLL.JE_LINE_NUM,GCC.CONCATENATED_SEGMENTS,XAL.ACCOUNTING_CLASS_CODE,xal.*
,8,GIR.*,8,XAH.*,8,XAL.*,8,XDL.*--,8,PCD.*
from
APPS.GL_JE_HEADERS GJH,
APPS.GL_JE_LINES GLL,
APPS.GL_CODE_COMBINATIONS_KFV GCC,
APPS.GL_IMPORT_REFERENCES GIR,
APPS.GL_LEDGERS GL,
APPS.XLA_AE_LINES XAL,
APPS.XLA_AE_HEADERS XAH,
APPS.XLA_DISTRIBUTION_LINKS XDL
WHERE 1=1
AND GJH.LEDGER_ID = GL.LEDGER_ID
AND GJH.JE_HEADER_ID = GLL.JE_HEADER_ID
AND GJH.JE_HEADER_ID = GIR.JE_HEADER_ID
AND GLL.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID
AND GLL.JE_LINE_NUM = GIR.JE_LINE_NUM
AND GIR.GL_SL_LINK_ID = XAL.GL_SL_LINK_ID
AND XAL.AE_HEADER_ID = XAH.AE_HEADER_ID
AND XAL.AE_HEADER_ID = XDL.AE_HEADER_ID
AND XAL.AE_LINE_NUM = XDL.AE_LINE_NUM
--AND XDL.SOURCE_DISTRIBUTION_ID_NUM_1 = PCD.EXPENDITURE_ITEM_ID
--AND TRUNC(GJH.CREATION_DATE) > TRUNC(SYSDATE-10)
--AND GCC.SEGMENT6 != '000'
--AND UPPER(GJH.JE_CATEGORY) LIKE UPPER('PROJECT%')
--AND UPPER(GJH.JE_SOURCE) LIKE UPPER('Project Accounting%')
and gjh.je_header_id = <je header ID>
and gll.je_line_num =<JE LINE NUMBER>
