[Home] [Help] [Dependency Information]
Object Name: | CE_STMT_INT_TMP |
---|---|
Object Type: | TABLE |
Owner: | CE |
FND Design Data: | CE.CE_STMT_INT_TMP |
Subobject Name: | |
Status: | VALID |
The CE_STMT_INT_TMP table stores bank statement information loaded from bank flat file by SQL*Loader. This table is populated and deleted whenever the loading program is executed.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CE_STMT_INT_TMP_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE | REC_NO |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REC_NO | NUMBER | Yes | Record Number. Unique Identifier. | |
REC_ID_NO | VARCHAR2 | (30) | Yes | Record Identifier Number |
COLUMN1 | VARCHAR2 | (2000) | Column1 | |
COLUMN2 | VARCHAR2 | (255) | Column2 | |
COLUMN3 | VARCHAR2 | (255) | Column3 | |
COLUMN4 | VARCHAR2 | (255) | Column4 | |
COLUMN5 | VARCHAR2 | (255) | Column5 | |
COLUMN6 | VARCHAR2 | (255) | Column6 | |
COLUMN7 | VARCHAR2 | (255) | Column7 | |
COLUMN8 | VARCHAR2 | (255) | Column8 | |
COLUMN9 | VARCHAR2 | (255) | Column9 | |
COLUMN10 | VARCHAR2 | (255) | Column10 | |
COLUMN11 | VARCHAR2 | (255) | Column11 | |
COLUMN12 | VARCHAR2 | (255) | Column12 | |
COLUMN13 | VARCHAR2 | (255) | Column13 | |
COLUMN14 | VARCHAR2 | (255) | Column14 | |
COLUMN15 | VARCHAR2 | (255) | Column15 | |
COLUMN16 | VARCHAR2 | (255) | Column16 | |
COLUMN17 | VARCHAR2 | (255) | Column17 | |
COLUMN18 | VARCHAR2 | (255) | Column18 | |
COLUMN19 | VARCHAR2 | (255) | Column19 | |
COLUMN20 | VARCHAR2 | (255) | Column20 | |
COLUMN21 | VARCHAR2 | (255) | Column21 | |
COLUMN22 | VARCHAR2 | (255) | Column22 | |
COLUMN23 | VARCHAR2 | (255) | Column23 | |
COLUMN24 | VARCHAR2 | (255) | Column24 | |
COLUMN25 | VARCHAR2 | (255) | Column25 | |
COLUMN26 | VARCHAR2 | (255) | Column26 | |
COLUMN27 | VARCHAR2 | (255) | Column27 | |
COLUMN28 | VARCHAR2 | (255) | Column28 | |
COLUMN29 | VARCHAR2 | (255) | Column29 | |
COLUMN30 | VARCHAR2 | (255) | Column30 | |
COLUMN31 | VARCHAR2 | (255) | Column31 | |
COLUMN32 | VARCHAR2 | (255) | Column32 | |
COLUMN33 | VARCHAR2 | (255) | Column33 | |
COLUMN34 | VARCHAR2 | (255) | Column34 | |
COLUMN35 | VARCHAR2 | (255) | Column35 | |
CREATED_BY | NUMBER | (15) | Standard Who Column | |
CREATION_DATE | DATE | Standard Who Column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who Column | |
LAST_UPDATE_DATE | DATE | Standard Who Column | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
COLUMN36 | VARCHAR2 | (2000) | Column36 |
Cut, paste (and edit) the following text to query this object:
SELECT REC_NO
, REC_ID_NO
, COLUMN1
, COLUMN2
, COLUMN3
, COLUMN4
, COLUMN5
, COLUMN6
, COLUMN7
, COLUMN8
, COLUMN9
, COLUMN10
, COLUMN11
, COLUMN12
, COLUMN13
, COLUMN14
, COLUMN15
, COLUMN16
, COLUMN17
, COLUMN18
, COLUMN19
, COLUMN20
, COLUMN21
, COLUMN22
, COLUMN23
, COLUMN24
, COLUMN25
, COLUMN26
, COLUMN27
, COLUMN28
, COLUMN29
, COLUMN30
, COLUMN31
, COLUMN32
, COLUMN33
, COLUMN34
, COLUMN35
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, COLUMN36
FROM CE.CE_STMT_INT_TMP;
CE.CE_STMT_INT_TMP does not reference any database object
CE.CE_STMT_INT_TMP is referenced by following:
|
|
|