Payables and Cash Management - EBS (MOSC)

MOSC Banner

query to select Reconciled Receipt

edited Aug 20, 2021 7:43AM in Payables and Cash Management - EBS (MOSC) 16 commentsAnswered

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center