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: APPS.HXC_TEMP_TCD

Object Details

Object Name:	HXC_TEMP_TCD
Object Type:	TABLE
Owner:	APPS
FND Design Data:	HXT.HXC_TEMP_TCD
Subobject Name:
Status:	VALID

Temporary Table Details

APPS.HXC_TEMP_TCD 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

Columns

Name	Datatype	Length
RESOURCE_ID	NUMBER
START_TIME	DATE
STOP_TIME	DATE
APPROVAL_STATUS	VARCHAR2	(50)
USER_ID	NUMBER
RECURRING_PERIOD_ID	NUMBER
TIMECARD_EXIST	VARCHAR2	(1)
PERSON_NUMBER	VARCHAR2	(240)
FULL_NAME	VARCHAR2	(240)
PAYROLL_NAME	VARCHAR2	(240)
ORGANIZATION_NAME	VARCHAR2	(240)
LOCATION_NAME	VARCHAR2	(240)
SUPERVISOR_NAME	VARCHAR2	(240)
PERSON_TYPE	VARCHAR2	(240)
TIMECARD_ID	NUMBER
TIMECARD_OVN	NUMBER
LAST_MODIFIED_BY	VARCHAR2	(240)
LAST_MODIFIED_DATE	DATE
APPLICATION	VARCHAR2	(240)
SUPERVISOR_ID	NUMBER	(15)
PERIOD_EXIST	VARCHAR2	(1)
APPLICATION_PERIOD_ID	NUMBER
NOTIFICATION_ID	NUMBER
MEANING	VARCHAR2	(50)
ASSG_START_DATE	DATE
ASSG_END_DATE	DATE
PERIOD_START_DATE	DATE
PERIOD_END_DATE	DATE

Query Text

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


SELECT RESOURCE_ID
,      START_TIME
,      STOP_TIME
,      APPROVAL_STATUS
,      USER_ID
,      RECURRING_PERIOD_ID
,      TIMECARD_EXIST
,      PERSON_NUMBER
,      FULL_NAME
,      PAYROLL_NAME
,      ORGANIZATION_NAME
,      LOCATION_NAME
,      SUPERVISOR_NAME
,      PERSON_TYPE
,      TIMECARD_ID
,      TIMECARD_OVN
,      LAST_MODIFIED_BY
,      LAST_MODIFIED_DATE
,      APPLICATION
,      SUPERVISOR_ID
,      PERIOD_EXIST
,      APPLICATION_PERIOD_ID
,      NOTIFICATION_ID
,      MEANING
,      ASSG_START_DATE
,      ASSG_END_DATE
,      PERIOD_START_DATE
,      PERIOD_END_DATE
FROM APPS.HXC_TEMP_TCD;

Dependencies

[top of page]

APPS.HXC_TEMP_TCD does not reference any database object

APPS.HXC_TEMP_TCD is referenced by following:

APPS: HXC_SUPERVISOR_DASHBOARD - show dependent code