SELECT distinct GCCK.CONCATENATED_SEGMENTS, gjh.PERIOD_NAME,gjh.name "Journal_Name",GjB.NAME "batch name",GLSOB.NAME "gl book",
DECODE(GJH.STATUS ,'P','POSTED','U','unposted',GJH.STATUS) STATUS,GCCK.CONCATENATED_SEGMENTS,gjh.creation_date,
(select USER_JE_CATEGORY_NAME from apps.gl_je_categories where JE_CATEGORY_NAME=GJH.JE_CATEGORY)CATEGORY,
(select USER_JE_SOURCE_NAME from apps.gl_je_sources where JE_SOURCE_NAME=GJH.JE_SOURCE)SOURCE,
GJL.JE_LINE_NUM,
GjH.RUNNING_TOTAL_DR "entered amount dr" , 
GjH.RUNNING_TOTAL_ACCOUNTED_DR "accounted amount dr" , 
GjH.RUNNING_TOTAL_CR "entered amount cr", 
GjH.RUNNING_TOTAL_ACCOUNTED_CR "accounted amount cr" ,
GJL.ENTERED_DR,
GJL.ENTERED_CR,
GJL.ACCOUNTED_DR,GJL.ACCOUNTED_CR,
gjh.description
      FROM APPS.GL_CODE_COMBINATIONS_KFV GCCK,
           APPS.GL_JE_HEADERS GJH,
           APPS.GL_JE_LINES   GJL,
           APPS.GL_JE_BATCHES GJB,apps.GL_SETS_OF_BOOKS GLSOB
      WHERE  GCCK.CODE_COMBINATION_ID=GJL.CODE_COMBINATION_ID and GJH.LEDGER_ID = GLSOB.SET_OF_BOOKS_ID 
      AND GJH.PERIOD_NAME ='DEC-20'
      AND GCCK.SEGMENT4 IN
('02950'
,'02980'
,'03481'
,'05900'
,'05980')
--AND    GJB.NAME=
      AND   GJB.JE_BATCH_ID=GJH.JE_BATCH_ID
      AND   GJL.JE_HEADER_ID=GJH.JE_HEADER_ID
order by GjB.NAME,GJL.JE_LINE_NUM asc