[Home] [Help] [Dependency Information]

TABLE: HXC.HXC_ARCHIVE_TEMP

Object Details

Object Name:	HXC_ARCHIVE_TEMP
Object Type:	TABLE
Owner:	HXC
FND Design Data:	HXC.HXC_ARCHIVE_TEMP
Subobject Name:
Status:	VALID

Temporary Table Details

HXC.HXC_ARCHIVE_TEMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Primary Key: HXC_ARCHIVE_TEMP_PK

1. DETAIL_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
HXC_ARCHIVE_TEMP_PK	NORMAL	UNIQUE		DETAIL_ID
HXC_ARCHIVE_TEMP_FK1	NORMAL	NONUNIQUE		MASTER_ID
HXC_ARCHIVE_TEMP_FK2	NORMAL	NONUNIQUE		THREAD_ID

Columns

Query Text

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

SELECT DETAIL_ID
,      MASTER_ID
,      REF_ROWID
,      THREAD_ID
FROM HXC.HXC_ARCHIVE_TEMP;

Dependencies

[top of page]

HXC.HXC_ARCHIVE_TEMP does not reference any database object

HXC.HXC_ARCHIVE_TEMP is referenced by following:

APPS

HXC_ARCHIVE_TEMP