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_XML_STATEMENT_LIST

Object Details

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

Internal temporary table to store the XML Bank Statements received via the XML Gateway Interface.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
ITEM_KEY	VARCHAR2	(20)	Yes	Unique item key to specify for Workflow process.
STATEMENT_NUMBER	VARCHAR2	(50)	Yes	Statement number for the XML bank statement.
TRADING_PARTNER	VARCHAR2	(50)		Trading partner (sender) of the XML bank statement.
BANK_ACCOUNT_NUM	VARCHAR2	(50)	Yes	Bank account number for the XML bank statement.

Query Text

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


SELECT ITEM_KEY
,      STATEMENT_NUMBER
,      TRADING_PARTNER
,      BANK_ACCOUNT_NUM
FROM CE.CE_XML_STATEMENT_LIST;

Dependencies

[top of page]

CE.CE_XML_STATEMENT_LIST does not reference any database object

CE.CE_XML_STATEMENT_LIST is referenced by following:

APPS: CE_XML_STATEMENT_LIST