[Home] [Help]
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
Name |
CASHFLOW_NUMBER |
CF_BANK_ACCOUNT_NUM |
CF_CURRENCY |
PAYMENT_TRX_REFERENCE_NUM |
CF_BANK_ACCOUNT_NAME |
CF_BA_CURRENCY |
STATEMENT_NUMBER |
STATEMENT_DATE |