VIEW: APPS.CEBV_ECT

Source

View Text - Preformatted

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

View Text - HTML Formatted

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