[Home] [Help] [Dependency Information]

TABLE: JE.JE_ES_MESSAGES_ALL

Object Details

Object Name:	JE_ES_MESSAGES_ALL
Object Type:	TABLE
Owner:	JE
FND Design Data:	JE.JE_ES_MESSAGES_ALL
Subobject Name:
Status:	VALID

The Temporary Messages table is used during Spanish Withholding
Tax processing in Oracle Payables and Oracle Receivables.
Beginning in Release 11, this table is now partitioned by
ORG_ID, so that Withholding Tax can be run simultaneously by users
utilizing different operating units.
During each processing, records from previous processing are first
deleted before new ones are inserted.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JE_ES_MESSAGES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	STEP ORG_ID

Columns

Query Text

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

SELECT STEP
,      MESSAGE
,      ORG_ID
FROM JE.JE_ES_MESSAGES_ALL;

Dependencies

[top of page]

JE.JE_ES_MESSAGES_ALL does not reference any database object

JE.JE_ES_MESSAGES_ALL is referenced by following:

APPS

JE_ES_MESSAGES_ALL