VIEW: APPS.CE_CE_CASHFLOWS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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