GL to XLA link
XLA_AE_HEADERS to GL_IMPORT_REFERENCES Link query select xal.AE_HEADER_ID, xal.ACCOUNTING_CLASS_CODE, xal.DESCRIPTION, gir.PERIOD_NAME from XLA_AE_LINES xal, GL_IMPORT_REFERENCES gir where xal.GL_SL_LINK_ID=gir.GL_SL_LINK_ID and xal.GL_SL_LINK_TABLE=gir.GL_SL_LINK_TABLE group by xal.AE_HEADER_ID, xal.ACCOUNTING_CLASS_CODE, xal.DESCRIPTION, gir.PERIOD_NAME Output