[Home] [Help] [Dependency Information]

TABLE: HXC.HXC_ABS_RET_TEMP

Object Details

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

Temporary Table Details

HXC.HXC_ABS_RET_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

Indexes

Index	Type	Uniqueness	Tablespace	Column
HXC_ABS_RET_TEMP_FK1	NORMAL	NONUNIQUE		ABSENCE_ATTENDANCE_ID
HXC_ABS_RET_TEMP_N1	NORMAL	NONUNIQUE		TIME_BUILDING_BLOCK_ID OBJECT_VERSION_NUMBER
HXC_ABS_RET_TEMP_N2	NORMAL	NONUNIQUE		RESOURCE_ID DAY_START DAY_STOP
HXC_ABS_RET_TEMP_N3	NORMAL	NONUNIQUE		TIME_BUILDING_BLOCK_ID LINK_TIME_BUILDING_BLOCK_ID

Columns

Query Text

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

SELECT TIME_BUILDING_BLOCK_ID
,      OBJECT_VERSION_NUMBER
,      RESOURCE_ID
,      IN_TIME
,      OUT_TIME
,      ABSENCE_ATTENDANCE_TYPE_ID
,      UOM
,      COST_ALLOCATION_KEYFLEX_ID
,      ABSENCE_ATTENDANCE_ID
,      DAY_START
,      DAY_STOP
,      RETRIEVAL_STATUS
,      ABSENCES_ACTION
,      ELEMENT_TYPE_ID
,      LINK_TIME_BUILDING_BLOCK_ID
FROM HXC.HXC_ABS_RET_TEMP;

Dependencies

[top of page]

HXC.HXC_ABS_RET_TEMP does not reference any database object

HXC.HXC_ABS_RET_TEMP is referenced by following:

APPS

HXC_ABS_RET_TEMP