VIEW: APPS.CE_XLA_TRANSACTIONS_V

Source

View Text - Preformatted

SELECT cf.cashflow_id, bacf.bank_account_num, cf.cashflow_currency_code, cf.trxn_reference_number, bacf.bank_account_name, bacf.currency_code, sh.statement_number, sh.statement_date from ce_cashflows cf, ce_bank_accounts bacf, ce_statement_lines sl, ce_statement_headers sh WHERE cf.cashflow_bank_account_id = bacf.bank_account_id and sl.statement_line_id(+) = cf.statement_line_id and sl.statement_header_id = sh.statement_header_id(+)

View Text - HTML Formatted

SELECT CF.CASHFLOW_ID
, BACF.BANK_ACCOUNT_NUM
, CF.CASHFLOW_CURRENCY_CODE
, CF.TRXN_REFERENCE_NUMBER
, BACF.BANK_ACCOUNT_NAME
, BACF.CURRENCY_CODE
, SH.STATEMENT_NUMBER
, SH.STATEMENT_DATE
FROM CE_CASHFLOWS CF
, CE_BANK_ACCOUNTS BACF
, CE_STATEMENT_LINES SL
, CE_STATEMENT_HEADERS SH
WHERE CF.CASHFLOW_BANK_ACCOUNT_ID = BACF.BANK_ACCOUNT_ID
AND SL.STATEMENT_LINE_ID(+) = CF.STATEMENT_LINE_ID
AND SL.STATEMENT_HEADER_ID = SH.STATEMENT_HEADER_ID(+)