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_AR_TC_IDS_TEMP

Object Details

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

For Multi-threaded A&R

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HXC_AR_TC_IDS_TEMP_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TIME_BUILDING_BLOCK_ID OBJECT_VERSION_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
TIME_BUILDING_BLOCK_ID	NUMBER	(15)	Yes	Archieve/Restored Timecard's Time building block id
TYPE	VARCHAR2	(30)	Yes	Indicates the Type of the Building Block. RANGE OR MEASURE
MEASURE	NUMBER	(22)		The numerical magnitude of UNIT_OF_MEASURE.
UNIT_OF_MEASURE	VARCHAR2	(30)		The unit of measure that forms the basis of this Building Block.
START_TIME	DATE			Start time for the row
STOP_TIME	DATE			End time for the row
PARENT_BUILDING_BLOCK_ID	NUMBER	(15)		Self-referential Key. Building block id of parent component
PARENT_BUILDING_BLOCK_OVN	NUMBER	(9)		Self-referential Key. Object version number of parent component
SCOPE	VARCHAR2	(30)	Yes	Scope of the timecard.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	System generated version of row. Increments by one with each update.
CREATED_BY	NUMBER	(15)		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE			creation date of the row
LAST_UPDATED_BY	NUMBER	(15)		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE			Last Update Date for the Row
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
APPROVAL_STATUS	VARCHAR2	(30)	Yes	Indicates the Approval Status of the Building Block.
RESOURCE_ID	NUMBER	(15)		Implicit Foreign Key based on Resource Type.
RESOURCE_TYPE	VARCHAR2	(30)		The type of Resource associated with the Building Block.
APPROVAL_STYLE_ID	NUMBER	(15)		Indicates the Approval style id attached to the building block.
DATE_FROM	DATE		Yes	Start date of row.
DATE_TO	DATE		Yes	End date of row.
COMMENT_TEXT	VARCHAR2	(2000)		Comment Text
APPLICATION_SET_ID	NUMBER	(15)		Indicates the Application Set ID attached to the building block.
DATA_SET_ID	NUMBER	(15)		Indicates the Data Set Id attached to the building block.
TRANSLATION_DISPLAY_KEY	VARCHAR2	(240)		Holds middle tier display key information.

Query Text

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


SELECT TIME_BUILDING_BLOCK_ID
,      TYPE
,      MEASURE
,      UNIT_OF_MEASURE
,      START_TIME
,      STOP_TIME
,      PARENT_BUILDING_BLOCK_ID
,      PARENT_BUILDING_BLOCK_OVN
,      SCOPE
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      APPROVAL_STATUS
,      RESOURCE_ID
,      RESOURCE_TYPE
,      APPROVAL_STYLE_ID
,      DATE_FROM
,      DATE_TO
,      COMMENT_TEXT
,      APPLICATION_SET_ID
,      DATA_SET_ID
,      TRANSLATION_DISPLAY_KEY
FROM HXC.HXC_AR_TC_IDS_TEMP;

Dependencies

[top of page]

HXC.HXC_AR_TC_IDS_TEMP does not reference any database object

HXC.HXC_AR_TC_IDS_TEMP is referenced by following:

HXC: HXC_AR_TC_IDS_TEMP#