View: CE_XLA_TRANSACTIONS_V

Product:	CE - Cash Management
Description:	This view retrieves Subledger Accounting transaction information.
Implementation/DBA Data:	APPS.CE_XLA_TRANSACTIONS_V

View Text

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(+)

Columns