eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: CE_999_INTERFACE_V

Product:	CE - Cash Management
Description:	Open interface view for reconciliation
Implementation/DBA Data:	APPS.CE_999_INTERFACE_V

View Text

SELECT T.ROWID
, TO_NUMBER(DUMMY)
, TO_NUMBER(DUMMY)
, DUMMY
, DUMMY
, DUMMY
, TO_DATE(DUMMY
, 'YYYY/MM/DD')
, DUMMY
, DUMMY
, DUMMY
, DUMMY
, TO_DATE(DUMMY
, 'YYYY/MM/DD')
, TO_NUMBER(DUMMY)
, TO_NUMBER(DUMMY)
, TO_NUMBER(DUMMY)
, TO_NUMBER(DUMMY)
, TO_NUMBER(DUMMY)
, TO_NUMBER(DUMMY)
, TO_NUMBER(DUMMY)
, TO_NUMBER(DUMMY)
, TO_NUMBER(DUMMY)
, TO_DATE(DUMMY
, 'YYYY/MM/DD')
, TO_DATE(DUMMY
, 'YYYY/MM/DD')
, TO_DATE(DUMMY
, 'YYYY/MM/DD')
, TO_NUMBER(DUMMY)
, TO_DATE(DUMMY
, 'YYYY/MM/DD')
, TO_NUMBER(DUMMY)
FROM SYS.DUAL T
WHERE 1 = 2

Columns

Name
ROW_ID
TRX_ID
BANK_ACCOUNT_ID
TRX_TYPE
TRX_TYPE_DSP
TRX_NUMBER
TRX_DATE
CURRENCY_CODE
STATUS
STATUS_DSP
EXCHANGE_RATE_TYPE
EXCHANGE_RATE_DATE
EXCHANGE_RATE
AMOUNT
CLEARED_AMOUNT
CHARGES_AMOUNT
ERROR_AMOUNT
ACCTD_AMOUNT
ACCTD_CLEARED_AMOUNT
ACCTD_CHARGES_AMOUNT
ACCTD_ERROR_AMOUNT
GL_DATE
CLEARED_DATE
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY