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: HXC.HXC_TEMP_TIMECARDS

Object Details

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

The HXC_TEMP_TIMECARDS table holds timecards temporarily for the 'Run Timecard Migration' and 'Worker Timecard Migration' concurrent programs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
WORKER_ID	NUMBER	(15)	Indicates the Concurrent Request Id of the Worker Concurrent program
SCOPE	VARCHAR2	(30)	Indicates the Scope of the Building Block.
TIME_BUILDING_BLOCK_ID	NUMBER	(15)	The timecard id
OBJECT_VERSION_NUMBER	NUMBER	(9)	The object version number of the timecard
PROCESSED	VARCHAR2	(1)	Flag to indicate if the timecard has been processed

Query Text

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


SELECT WORKER_ID
,      SCOPE
,      TIME_BUILDING_BLOCK_ID
,      OBJECT_VERSION_NUMBER
,      PROCESSED
FROM HXC.HXC_TEMP_TIMECARDS;

Dependencies

[top of page]

HXC.HXC_TEMP_TIMECARDS does not reference any database object

HXC.HXC_TEMP_TIMECARDS is referenced by following:

APPS: HXC_TEMP_TIMECARDS