Link Between AP(Account Payable),GL(General Ledger) and SLA(Sub Ledger Accounting _XLA)

Complete relation Query for SLA(Sub Ledger Accounting _XLA), AP(Account Payable) and GL(General Ledger) Links in oracle apps r12 

Or 

Link Between AP(Account Payable), GL(General Ledger) and SLA(Sub Ledger Accounting _XLA)

SELECT DISTINCT GJH.PERIOD_NAME, TRUNC (GJH.CREATION_DATE) GL_DATE,

                GJH.JE_SOURCE, GJH.JE_CATEGORY, GJH.CURRENCY_CODE,

                GJL.DESCRIPTION, GJL.REFERENCE_5, GJL.REFERENCE_10,

                GJL.ACCOUNTED_CR, GJL.ACCOUNTED_DR, GJL.EFFECTIVE_DATE,

                GJL.REFERENCE_1, GCC.SEGMENT1, GCC.SEGMENT2, GCC.SEGMENT3,

                GCC.SEGMENT4, GCC.SEGMENT5, GCC.SEGMENT6, GCC.SEGMENT7,

                AERLA.JUSTIFICATION, AERLA.PROJECT_NUMBER,

                AERLA.EXPENDITURE_ITEM_DATE, AERLA.RECEIPT_CURRENCY_CODE

           FROM APPS.GL_JE_HEADERS GJH,

                APPS.GL_JE_LINES GJL,

                APPS.GL_CODE_COMBINATIONS GCC,

                APPS.GL_IMPORT_REFERENCES GIR,

                APPS.XLA_AE_LINES XAL,

                APPS.XLA_AE_HEADERS XAH,

                APPS.AP_INVOICES_ALL AIA,

                APPS.AP_INVOICE_LINES_ALL AILA,

                APPS.AP_INVOICE_DISTRIBUTIONS_ALL AIDA,

                APPS.AP_EXPENSE_REPORT_HEADERS_ALL AERHA,

                APPS.AP_EXPENSE_REPORT_LINES_ALL AERLA

--APPS.XLA_EVENTS XE,

--XLA.XLA_TRANSACTION_ENTITIES XTE,

--APPS.XLA_DISTRIBUTION_LINKS XDL,

WHERE           GJH.JE_HEADER_ID = GJL.JE_HEADER_ID

            AND GJL.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID

            AND GJL.JE_HEADER_ID = GIR.JE_HEADER_ID

            AND GJL.JE_LINE_NUM = GIR.JE_LINE_NUM

            AND GIR.GL_SL_LINK_ID = XAL.GL_SL_LINK_ID

            AND GIR.GL_SL_LINK_TABLE = XAL.GL_SL_LINK_TABLE

            AND XAL.APPLICATION_ID = XAH.APPLICATION_ID

            AND AIA.INVOICE_ID = AILA.INVOICE_ID

            AND AIA.INVOICE_ID = AIDA.INVOICE_ID

            AND AILA.LINE_NUMBER = AIDA.DISTRIBUTION_LINE_NUMBER

            AND AERHA.REPORT_HEADER_ID = AERLA.REPORT_HEADER_ID

            AND AIA.INVOICE_ID = AERHA.VOUCHNO

            AND AIDA.INVOICE_LINE_NUMBER = AERLA.DISTRIBUTION_LINE_NUMBER

            AND AIDA.ACCOUNTING_EVENT_ID = XAH.EVENT_ID

            AND XAL.AE_HEADER_ID = XAH.AE_HEADER_ID

            AND (    GJH.JE_SOURCE = 'Payables'

                 AND GJH.JE_CATEGORY = 'Purchase Invoices'

                )

            AND GJH.CURRENCY_CODE = 'INR'

--AND XAH.EVENT_ID=XE.EVENT_ID

--AND XAH.APPLICATION_ID=XE.APPLICATION_ID

--AND XE.ENTITY_ID=XTE.ENTITY_ID

--AND XE.APPLICATION_ID=XTE.APPLICATION_ID

--AND XTE.SOURCE_ID_INT_1=AIA.INVOICE_ID

--AND XAH.APPLICATION_ID=XTE.APPLICATION_ID

--AND XAH.ENTITY_ID=XTE.ENTITY_ID

--AND XDL.APPLICATION_ID=XAH.APPLICATION_ID

--AND AIDA.INVOICE_DISTRIBUTION_ID=XDL.SOURCE_DISTRIBUTION_ID_NUM_1

--AND XDL.AE_HEADER_ID=XAH.AE_HEADER_ID

--AND XE.EVENT_ID=AIDA.ACCOUNTING_EVENT_ID

--AND AERHA.INVOICE_NUM LIKE '%12345%'

--AND GJH.PERIOD_NAME = 'AUG-15'

“A GUIDE FOR ORACLE E-BUSINESS SUITE” –A complete Solution and Learning platform For Oracle Apps R12/11i, Training, India Localization, Technical, P2P, O2C, Drop-shipment, AR/AP Cycle, Implementation, Bug or error in Oracle Apps R12/11i, Up-gradation, Support, Alert, Personalization, Discoverer management, OracleApps R12/11i Module, Finance, SCM, MRP, ASCP, WIP, BOM, FA, AP, AR, OM, INV, AOL, MOAC, TCA structure, Project Accounting, CM, Functional,Oracle DBA, ERP, Techno-functional, OAF, Oracle Apps Interview Question and Error in Oracle apps R12/11i. For More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide