Adjustments query in receiving transactions -- oracle apps

SELECT
I.NAME ORG_NAME,
A.ORG_ID,
      H.GL_MONTH PERIOD_MONTH,
      H.GL_YEAR PERIOD_YEAR,
      H.GL_QUARTER PERIOD_QTR,
      'ADJUSTMENT' REVENUE_GROUP,
      E.SEGMENT5 ACCT_CODE,
      REPLACE(E.SEG5_DESC,'''','') ACCT_NAME,
      REPLACE(BG.SEG4_DESC,'''','') GRUP,
      REPLACE(E.SEG6_DESC,'''','') PRODUCT,
D.CUSTOMER_NUMBER CUSTOMER_CODE,
      REPLACE(D.CUSTOMER_NAME,'''','') CUSTOMER_NAME,
      SR.NAME ASE_NAME,
      SR.ATTRIBUTE2 ASE_EMAIL_ID,
      REPLACE(E.SEG3_DESC,'''','') INVOICE_LOCATION,
      J.SITE_USE_ID LOCATION_ID,
-- J.LOCATION LOCATION_NAME,
B.TRX_NUMBER INV_NO,
      B.TRX_DATE INV_DATE,
      A.GL_DATE,
      TRUNC(B.LAST_UPDATE_DATE) LUPDT_DATE,
      TRUNC(B.CREATION_DATE) CREATION_DATE,
      F.TYPE INV_TYPE,
SUM(A.ACCTD_AMOUNT) ACTAMT,
TRUNC(SYSDATE) PROC_EXEC_DATE
FROM
APPS.RA_HCUSTOMERS D,
AR.RA_CUSTOMER_TRX_ALL B,
AR.RA_CUSTOMER_TRX_LINES_ALL EX,
AR.RA_CUST_TRX_LINE_GL_DIST_ALL A,
GL_CODE_COMBINATIONS E,
AR.RA_CUST_TRX_TYPES_ALL F,
GL_PERIOD H,
--HR.HR_ALL_ORGANIZATION_UNITS I
HR_OPERATING_UNITS I,
AR.HZ_CUST_SITE_USES_ALL J,
JTF.JTF_RS_SALESREPS SR,
GL_CODE_COMBINATIONS BG
WHERE
D.CUSTOMER_ID = B.BILL_TO_CUSTOMER_ID
AND A.CUSTOMER_TRX_ID = B.CUSTOMER_TRX_ID
AND  I.ORGANIZATION_ID = A.ORG_ID
AND A.CUSTOMER_TRX_ID = EX.CUSTOMER_TRX_ID
AND EX.CUSTOMER_TRX_LINE_ID = A.CUSTOMER_TRX_LINE_ID
AND A.CODE_COMBINATION_ID = E.CODE_COMBINATION_ID
AND     B.CUST_TRX_TYPE_ID = F.CUST_TRX_TYPE_ID
AND   F.TYPE IN ('DM','CM')
AND   J.SITE_USE_ID = B.BILL_TO_SITE_USE_ID
AND   J.SITE_USE_CODE = 'BILL_TO'
AND         SR.ORG_ID = A.ORG_ID
AND         SR.SALESREP_ID = J.PRIMARY_SALESREP_ID
AND J.GL_ID_REV = BG.CODE_COMBINATION_ID
AND   A.GL_DATE BETWEEN H.GL_START_DATE AND H.GL_END_DATE
AND A.ACCOUNT_CLASS = 'REV'
AND B.COMPLETE_FLAG='Y'
AND E.SEGMENT5 IN ( '1234')
AND TRUNC(A.GL_DATE) BETWEEN :SDATE AND :EDATE
GROUP BY
I.NAME ,
A.ORG_ID,
      H.GL_MONTH ,
      H.GL_YEAR ,
      H.GL_QUARTER ,
      'ADJUSTMENT' ,
      E.SEGMENT5 ,
      E.SEG5_DESC,
      BG.SEG4_DESC,
      E.SEG6_DESC,
D.CUSTOMER_NUMBER ,
      D.CUSTOMER_NAME,
      SR.NAME ,
      SR.ATTRIBUTE2 ,
      E.SEG3_DESC,
      J.SITE_USE_ID ,
-- J.LOCATION LOCATION_NAME,
B.TRX_NUMBER ,
      B.TRX_DATE ,
      A.GL_DATE,
      B.LAST_UPDATE_DATE,
       B.CREATION_DATE,
      F.TYPE,
TRUNC(SYSDATE)