[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CE_UK_VALIDATIONS_INTERFACE_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | INTERFACE_LINE_ID |
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. |
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;
CE.CE_UK_VALIDATIONS_INTERFACE does not reference any database object
CE.CE_UK_VALIDATIONS_INTERFACE is referenced by following:
|
|
|