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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: CE.CE_UK_VALIDATIONS_INTERFACE

Object Details

Object Name:	CE_UK_VALIDATIONS_INTERFACE
Object Type:	TABLE
Owner:	CE
FND Design Data:	CE.CE_UK_VALIDATIONS_INTERFACE
Subobject Name:
Status:	VALID

The CE_UK_VALIDATIONS_INTERFACE table is the loader target for data from text files provided by Vocalink for UK Domestic Account Validations.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CE_UK_VALIDATIONS_INTERFACE_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INTERFACE_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INTERFACE_LINE_ID	NUMBER	(15)	Yes	Record Number. Unique Identifier.
SOURCE_VALUE1	VARCHAR2	(10)		Value from column 1 of validation data file.
SOURCE_VALUE2	VARCHAR2	(10)		Value from column 2 of validation data file.
SOURCE_VALUE3	VARCHAR2	(10)		Value from column 3 of validation data file.
SOURCE_VALUE4	VARCHAR2	(10)		Value from column 4 of validation data file.
SOURCE_VALUE5	VARCHAR2	(10)		Value from column 5 of validation data file.
SOURCE_VALUE6	VARCHAR2	(10)		Value from column 6 of validation data file.
SOURCE_VALUE7	VARCHAR2	(10)		Value from column 7 of validation data file.
SOURCE_VALUE8	VARCHAR2	(10)		Value from column 8 of validation data file.
SOURCE_VALUE9	VARCHAR2	(10)		Value from column 9 of validation data file.
SOURCE_VALUE10	VARCHAR2	(10)		Value from column 10 of validation data file.
SOURCE_VALUE11	VARCHAR2	(10)		Value from column 11 of validation data file.
SOURCE_VALUE12	VARCHAR2	(10)		Value from column 12 of validation data file.
SOURCE_VALUE13	VARCHAR2	(10)		Value from column 13 of validation data file.
SOURCE_VALUE14	VARCHAR2	(10)		Value from column 14 of validation data file.
SOURCE_VALUE15	VARCHAR2	(10)		Value from column 15 of validation data file.
SOURCE_VALUE16	VARCHAR2	(10)		Value from column 16 of validation data file.
SOURCE_VALUE17	VARCHAR2	(10)		Value from column 17 of validation data file.
SOURCE_VALUE18	VARCHAR2	(10)		Value from column 18 of validation data file.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INTERFACE_LINE_ID
,      SOURCE_VALUE1
,      SOURCE_VALUE2
,      SOURCE_VALUE3
,      SOURCE_VALUE4
,      SOURCE_VALUE5
,      SOURCE_VALUE6
,      SOURCE_VALUE7
,      SOURCE_VALUE8
,      SOURCE_VALUE9
,      SOURCE_VALUE10
,      SOURCE_VALUE11
,      SOURCE_VALUE12
,      SOURCE_VALUE13
,      SOURCE_VALUE14
,      SOURCE_VALUE15
,      SOURCE_VALUE16
,      SOURCE_VALUE17
,      SOURCE_VALUE18
FROM CE.CE_UK_VALIDATIONS_INTERFACE;

Dependencies

[top of page]

CE.CE_UK_VALIDATIONS_INTERFACE does not reference any database object

CE.CE_UK_VALIDATIONS_INTERFACE is referenced by following:

CE: CE_UK_VALIDATIONS_INTERFACE#