Journal Voucher Query

SELECT A.JE_HEADER_ID,A.JE_BATCH_ID,GJB.ORG_ID,
C.SEGMENT3 LOCATION,
A.DOC_SEQUENCE_VALUE  VOUCHER_NO,
A.JE_CATEGORY CATEGORY,
D.USER_JE_CATEGORY_NAME CATEGORY_NAME,
A.DESCRIPTION,
A.CURRENCY_CODE CUR,
A.DEFAULT_EFFECTIVE_DATE EFFECTIVE_DATE,
C.SEGMENT1||'.'||C.SEGMENT2 ||'.'||C.SEGMENT3||'.'||C.SEGMENT4 ||'.'||C.SEGMENT5||'.'||C.SEGMENT6||'.'||C.SEGMENT7  ACCOUNTING_FLEXFIELD,
C.SEG1_desc||'.'||C.SEG2_desc ||'.'||REPLACE(seg3_desc,'/','') ||'.'||C.SEG4_desc ||'.'||REPLACE(seg5_desc,'/','') ||'.'||C.SEG6_desc||'.'||C.SEG7_desc Des,
C.SEG3_desc SEG2_desc,
B.DESCRIPTION NARRATION,
B.ACCOUNTED_DR ACCOUNTED_DEBIT,
B.ACCOUNTED_CR ACCOUNTED_CREDIT
FROM
GL_JE_HEADERS A,
GL_JE_LINES B,
GL_CODE_COMBINATIONS C,
GL_JE_CATEGORIES_TL D,
GL_JE_BATCHES  GJB
WHERE    
A.JE_HEADER_ID = B.JE_HEADER_ID
AND           B.CODE_COMBINATION_ID = C.CODE_COMBINATION_ID
AND           A.JE_CATEGORY = D.JE_CATEGORY_NAME
AND           A.DOC_SEQUENCE_VALUE between  nvl(:P_VOUCHER_NO_FROM, A.DOC_SEQUENCE_VALUE)  AND nvl(:P_VOUCHER_NO_TO,  A.DOC_SEQUENCE_VALUE)
AND           A.JE_CATEGORY = nvl( :P_CATEGORY,  A.JE_CATEGORY)
AND  A.DEFAULT_EFFECTIVE_DATE BETWEEN to_date('1-APR-'||substr(:P_FIN_YEAR,1,4)) and to_date('31-MAR-'||substr(:P_FIN_YEAR,6,9))
AND   A.JE_BATCH_ID=GJB.JE_BATCH_ID