View: CE_CE_CASHFLOWS_V

Product:	CE - Cash Management
Description:
Implementation/DBA Data:	APPS.CE_CE_CASHFLOWS_V

View Text

SELECT CF.CASHFLOW_ID
, CF.CASHFLOW_DIRECTION
, CF.CASHFLOW_AMOUNT
, NVL(CF.BASE_AMOUNT
, CF.CASHFLOW_AMOUNT * CEP_STANDARD.GET_CONVERSION_RATE(CF.CASHFLOW_LEDGER_ID
, CF.CASHFLOW_CURRENCY_CODE
, CF.CASHFLOW_DATE
, SYS.CASHFLOW_EXCHANGE_RATE_TYPE))
, TXN.TRANSACTION_SUB_TYPE_NAME
, CF.CASHFLOW_CURRENCY_CODE
, TRUNC(CF.CASHFLOW_DATE)
, TRUNC(CF.ACTUAL_VALUE_DATE)
, TRUNC(CF.CLEARED_DATE)
, CF.CASHFLOW_STATUS_CODE
, TXN.TRXN_SUBTYPE_CODE_ID
, CF.CASHFLOW_BANK_ACCOUNT_ID
, TRUNC(NVL(CF.ACTUAL_VALUE_DATE
, CF.CASHFLOW_DATE))
, CASHFLOW_LEGAL_ENTITY_ID
, SOURCE_TRXN_TYPE
, DESCRIPTION
, CASHFLOW_LEDGER_ID
, COUNTERPARTY_PARTY_ID
, COUNTERPARTY_BANK_ACCOUNT_ID
FROM CE_CASHFLOWS CF
, CE_TRXNS_SUBTYPE_CODES TXN
, CE_SYSTEM_PARAMETERS SYS
WHERE TXN.TRXN_SUBTYPE_CODE_ID(+) = CF.SOURCE_TRXN_SUBTYPE_CODE_ID
AND CF.CASHFLOW_STATUS_CODE IN ('CREATED'
, 'CLEARED'
, 'RECONCILED')
AND SYS.LEGAL_ENTITY_ID = CF.CASHFLOW_LEGAL_ENTITY_ID

Columns