SELECT ROUND(LNK.UNROUNDED_ACCOUNTED_DR/NVL(CUR.MINIMUM_ACCOUNTABLE_UNIT , POWER(10 , (-1*CUR.PRECISION))) )* NVL(CUR.MINIMUM_ACCOUNTABLE_UNIT , POWER(10 , (-1*CUR.PRECISION))) ACCOUNTED_DR , ROUND(LNK.UNROUNDED_ACCOUNTED_CR/NVL(CUR.MINIMUM_ACCOUNTABLE_UNIT , POWER(10 , (-1*CUR.PRECISION))) )* NVL(CUR.MINIMUM_ACCOUNTABLE_UNIT , POWER(10 , (-1*CUR.PRECISION))) ACCOUNTED_CR , '_LA:DECODE(HED.GL_TRANSFER_STATUS_CODE , ''Y'' , ''Y'' , ''N''):AR_LOOKUPS:YES/NO:MEANING' , LG.NAME , CT.TRX_NUMBER , CTLD.CUST_TRX_LINE_GL_DIST_ID , LG.LEDGER_ID , CTLD.CUSTOMER_TRX_ID FROM FND_CURRENCIES CUR , GL_LEDGERS_PUBLIC_V LG , XLA_AE_HEADERS HED , XLA_AE_LINES LIN , XLA_DISTRIBUTION_LINKS LNK , RA_CUST_TRX_LINE_GL_DIST_ALL CTLD , RA_CUSTOMER_TRX_ALL CT WHERE CUR.CURRENCY_CODE = LG.CURRENCY_CODE AND LG.LEDGER_CATEGORY_CODE = 'ALC' AND LG.LEDGER_ID = HED.LEDGER_ID AND HED.APPLICATION_ID = 222 AND HED.AE_HEADER_ID = LNK.AE_HEADER_ID AND LIN.APPLICATION_ID = 222 AND LIN.ACCOUNTING_CLASS_CODE = CTLD.ACCOUNT_CLASS AND LIN.AE_HEADER_ID = LNK.AE_HEADER_ID AND LIN.AE_LINE_NUM = LNK.AE_LINE_NUM AND LNK.APPLICATION_ID = 222 /* FILTER OUT REVERSAL LINKS */ AND LNK.AE_HEADER_ID = LNK.REF_AE_HEADER_ID /* FILTER OUT LINKS BEING REVERSED BY ANOTHER LINK */ AND NOT EXISTS (SELECT 'REVERSED' FROM XLA_DISTRIBUTION_LINKS LNK2 WHERE LNK2.APPLICATION_ID = 222 AND LNK2.REF_AE_HEADER_ID = LNK.AE_HEADER_ID AND LNK2.REF_TEMP_LINE_NUM = LNK.TEMP_LINE_NUM) AND LNK.SOURCE_DISTRIBUTION_TYPE = 'RA_CUST_TRX_LINE_GL_DIST_ALL' AND LNK.SOURCE_DISTRIBUTION_ID_NUM_1 = CTLD.CUST_TRX_LINE_GL_DIST_ID AND CTLD.ACCOUNT_CLASS = 'TAX' AND CTLD.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID WITH READ ONLY