GL Wise Report

GL Wise Report

SELECT GJH.DEFAULT_EFFECTIVE_DATE VOCHERDATE,

       GJH.DOC_SEQUENCE_VALUE VOCHER_NUM,

       GJH.DESCRIPTION,

       GJL.ACCOUNTED_CR ACC_CR,

       GJL.ACCOUNTED_DR ACC_DR,

       GJL.ACCOUNTED_DR F_CURRENCY_AMOUNT,

       GCC.CONCATENATED_SEGMENTS

  FROM GL_JE_HEADERS GJH,

       GL_JE_LINES GJL,

       GL_CODE_COMBINATIONS_KFV GCC

 WHERE GJH.JE_HEADER_ID=GJL.JE_HEADER_ID

   AND GJL.CODE_COMBINATION_ID=GCC.CODE_COMBINATION_ID

   AND GJH.JE_HEADER_ID = NVL(:P_HEADER_ID,GJH.JE_HEADER_ID)