[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 |