Opening Bal. of Debtor

Hi

We have a customised report in Apps to get the opening Balance of a Debtor as :

SELECT NVL(SUM(rac.acctd_amount),0) open_amt

FROM gl_je_headers glh,

gl_je_lines gll,

GL_CODE_COMBINATIONS cc,

gl_import_references gir,

ra_cust_trx_line_gl_dist_all rac,

ra_customer_trx_all trx

WHERE glh.DEFAULT_EFFECTIVE_DATE < :P_FROM_DATE

AND glh.je_source = 'Receivables'

AND gll.je_header_id = glh.je_header_id

AND gll.set_of_books_id = glh.set_of_books_id

AND gll.status = 'P'

AND cc.CODE_COMBINATION_ID= gll.code_combination_id