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 , ARD.SOURCE_ID , LG.LEDGER_ID FROM FND_CURRENCIES CUR , GL_LEDGERS_PUBLIC_V LG , XLA_AE_HEADERS HED , XLA_AE_LINES LIN , XLA_DISTRIBUTION_LINKS LNK , AR_DISTRIBUTIONS_ALL ARD 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 = LIN.AE_HEADER_ID AND LIN.ACCOUNTING_CLASS_CODE = ARD.SOURCE_TYPE AND LIN.APPLICATION_ID = 222 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 = 'AR_DISTRIBUTIONS_ALL' AND LNK.SOURCE_DISTRIBUTION_ID_NUM_1 = ARD.LINE_ID AND ARD.SOURCE_TABLE = 'ADJ' AND ARD.SOURCE_TYPE = 'ADJ' WITH READ ONLY