query to select Reconciled Receipt
Dear All,
I'm trying to implement a query to retrieve all reconciled receipt but something wrong happened and all the statement are retrieved
below is my query:
SELECT
csl.STATEMENT_LINE_ID ar_STATEMENT_LINE_ID,
CSH.BANK_ACCOUNT_ID ar_BANK_ACCOUNT_ID,
csl.STATEMENT_HEADER_ID ar_STATEMENT_HEADER_ID,
csl.TRX_TYPE ar_TRX_TYPE,
csl.TRX_CODE ar_TRX_CODE,
csl.AMOUNT ar_AMOUNT,
csl.TRX_CODE_ID ar_code,
CSH.statement_number ar_statement_number,
CSl.LINE_NUMBER ar_line_number
FROM
CE_STATEMENT_LINES csl,
CE_STATEMENT_HEADERS csh,
CE_BANK_ACCOUNTS CE,
ce_statement_reconcils_all csr,