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_STMT_INT_TMP

Object Details

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.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CE_STMT_INT_TMP_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	REC_NO

Columns

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

Query Text

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
FROM CE.CE_STMT_INT_TMP;

Dependencies

[top of page]

CE.CE_STMT_INT_TMP does not reference any database object

CE.CE_STMT_INT_TMP is referenced by following:

APPS: CE_STMT_INT_TMP