GL Transactions with AA Details

SELECT  A.aaGLHdrID,
        A.JRNENTRY,
        A.RCTRXSEQ,
        A.YEAR1,
        A.GLPOSTDT,
        B.INTERID,
        B.ACTINDX,
        F.ACTNUMST,
        B.CURNCYID,
        C.DEBITAMT,
        C.CRDTAMNT,
        C.ORDBTAMT,
        C.ORCRDAMT,
        E.aaTrxDimCode,
        E.aaTrxDimCodeDescr,
        'Open Year' AS YEARSTATUS,
        B.SEQNUMBR,
        ( SELECT TOP 1
                    F.SOURCDOC
          FROM      dbo.GL20000 F
          WHERE     F.JRNENTRY = A.JRNENTRY
                    AND F.RCTRXSEQ = A.RCTRXSEQ
        ) AS SOURCDOC,
        ( SELECT TOP 1
                    F.REFRENCE
          FROM      dbo.GL20000 F
          WHERE     F.JRNENTRY = A.JRNENTRY
                    AND F.RCTRXSEQ = A.RCTRXSEQ
        ) AS REFERENCE,
        ( SELECT TOP 1
                    F.USWHPSTD
          FROM      dbo.GL20000 F
          WHERE     F.JRNENTRY = A.JRNENTRY
                    AND F.RCTRXSEQ = A.RCTRXSEQ
        ) AS USERPOSTED,
        ( SELECT TOP 1
                    F.TRXSORCE
          FROM      dbo.GL20000 F
          WHERE     F.JRNENTRY = A.JRNENTRY
                    AND F.RCTRXSEQ = A.RCTRXSEQ
        ) AS AUDITTRAIL,
        ( SELECT TOP 1
                    F.DSCRIPTN
          FROM      dbo.GL20000 F
          WHERE     F.JRNENTRY = A.JRNENTRY
                    AND F.RCTRXSEQ = A.RCTRXSEQ
        ) AS TRXDESC
FROM    dbo.AAG30000 A
        INNER JOIN dbo.AAG30001 B ON A.aaGLHdrID = B.aaGLHdrID
        INNER JOIN dbo.AAG30002 C ON B.aaGLHdrID = C.aaGLHdrID
                                     AND B.aaGLDistID = C.aaGLDistID
        INNER JOIN dbo.AAG30003 D ON C.aaGLHdrID = D.aaGLHdrID
                                     AND C.aaGLDistID = D.aaGLDistID
                                     AND C.aaGLAssignID = D.aaGLAssignID
        INNER JOIN dbo.AAG00401 E ON D.aaTrxDimID = E.aaTrxDimID
                                     AND D.aaTrxCodeID = E.aaTrxDimCodeID
        INNER JOIN dbo.GL00105 F ON B.ACTINDX = F.ACTINDX
UNION ALL
SELECT  A.aaGLHdrID,
        A.JRNENTRY,
        A.RCTRXSEQ,
        A.YEAR1,
        A.GLPOSTDT,
        B.INTERID,
        B.ACTINDX,
        F.ACTNUMST,
        B.CURNCYID,
        C.DEBITAMT,
        C.CRDTAMNT,
        C.ORDBTAMT,
        C.ORCRDAMT,
        E.aaTrxDimCode,
        E.aaTrxDimCodeDescr,
        'Historical Year' AS YEARSTATUS,
        B.SEQNUMBR,
        ( SELECT TOP 1
                    F.SOURCDOC
          FROM      dbo.GL30000 F
          WHERE     F.JRNENTRY = A.JRNENTRY
                    AND F.RCTRXSEQ = A.RCTRXSEQ
        ) AS SOURCDOC,
        ( SELECT TOP 1
                    F.REFRENCE
          FROM      dbo.GL30000 F
          WHERE     F.JRNENTRY = A.JRNENTRY
                    AND F.RCTRXSEQ = A.RCTRXSEQ
        ) AS REFERENCE,
        ( SELECT TOP 1
                    F.USWHPSTD
          FROM      dbo.GL30000 F
          WHERE     F.JRNENTRY = A.JRNENTRY
                    AND F.RCTRXSEQ = A.RCTRXSEQ
        ) AS USERPOSTED,
        ( SELECT TOP 1
                    F.TRXSORCE
          FROM      dbo.GL30000 F
          WHERE     F.JRNENTRY = A.JRNENTRY
                    AND F.RCTRXSEQ = A.RCTRXSEQ
        ) AS AUDITTRAIL,
        ( SELECT TOP 1
                    F.DSCRIPTN
          FROM      dbo.GL30000 F
          WHERE     F.JRNENTRY = A.JRNENTRY
                    AND F.RCTRXSEQ = A.RCTRXSEQ
        ) AS TRXDESC
FROM    dbo.AAG40000 A
        INNER JOIN dbo.AAG40001 B ON A.aaGLHdrID = B.aaGLHdrID
        INNER JOIN dbo.AAG40002 C ON B.aaGLHdrID = C.aaGLHdrID
                                     AND B.aaGLDistID = C.aaGLDistID
        INNER JOIN dbo.AAG40003 D ON C.aaGLHdrID = D.aaGLHdrID
                                     AND C.aaGLDistID = D.aaGLDistID
                                     AND C.aaGLAssignID = D.aaGLAssignID
        INNER JOIN dbo.AAG00401 E ON D.aaTrxDimID = E.aaTrxDimID
                                     AND D.aaTrxCodeID = E.aaTrxDimCodeID
        INNER JOIN dbo.GL00105 F ON B.ACTINDX = F.ACTINDX