Now you can Subscribe using RSS

Submit your Email

Friday, 10 July 2015

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

KULDEEP CHAUHAN


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

KULDEEP CHAUHAN / Author & Editor

"A Guide for Oracle E-business Suit" . For any Query and help Please drop your mail on - Oracleappsguide.com@gmail.com . Thanks a lot for your visit on OracleAppsGuide.com .Please Subscribe and Comment our website feed and Youtube channel.

1 comments:

OracleAppsGuide.com © Coprights 2016,