[Home] [Help]
View: CEFV_ECT
Product: | CE - Cash Management |
Description: | Business View |
Implementation/DBA Data: |
APPS.CEFV_ECT
|
View Text
SELECT IV.TRX_ID
, BA.BANK_ACCOUNT_NUM
, BA.BANK_ACCOUNT_NAME
, IV.TRX_TYPE_DSP
, IV.TRX_NUMBER
, IV.TRX_DATE
, IV.CURRENCY_CODE
, IV.STATUS_DSP
, DC.USER_CONVERSION_TYPE
, IV.EXCHANGE_RATE_DATE
, IV.EXCHANGE_RATE
, IV.AMOUNT
, IV.CLEARED_AMOUNT
, IV.CHARGES_AMOUNT
, IV.GL_DATE
, IV.CREATION_DATE
, IV.CREATED_BY
, IV.LAST_UPDATE_DATE
, IV.LAST_UPDATED_BY
FROM CE_999_INTERFACE_V IV
, GL_DAILY_CONVERSION_TYPES DC
, CE_BANK_ACCOUNTS BA
WHERE DC.CONVERSION_TYPE (+) = IV.EXCHANGE_RATE_TYPE
AND BA.BANK_ACCOUNT_ID = IV.BANK_ACCOUNT_ID WITH READ ONLY
Columns
Name |
TRANSACTION_ID |
BANK_ACCOUNT_NUMBER |
BANK_ACCOUNT_NAME |
TRANSACTION_TYPE |
TRANSACTION_NUMBER |
TRANSACTION_DATE |
CURRENCY_CODE |
STATUS |
EXCHANGE_RATE_TYPE |
EXCHANGE_RATE_DATE |
EXCHANGE_RATE |
AMOUNT |
CLEARED_AMOUNT |
CHARGES |
GL_DATE |
CREATED_DATE |
CREATED_BY |
LAST_UPDATED_DATE |
LAST_UPDATED_BY |