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_TIME_CATEGORY_COMPS

Object Details

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

HXC_TIME_CATEGORY_COMPS stores the components of a time category. Time categories are used to differentiate the number of hours entered on a timecard.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HXC_TIME_CATEGORY_COMPS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TIME_CATEGORY_COMP_ID OBJECT_VERSION_NUMBER
HXC_TIME_CATEGORY_COMPS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TIME_CATEGORY_ID COMPONENT_TYPE_ID
HXC_TIME_CATEGORY_COMPS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TIME_CATEGORY_ID REF_TIME_CATEGORY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TIME_CATEGORY_COMP_ID	NUMBER	(15)	Yes	Primary Key from sequence
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes	Object Version Number
TIME_CATEGORY_ID	NUMBER	(15)	Yes	Foreign Key to HXC_TIME_CATEGORIES
REF_TIME_CATEGORY_ID	NUMBER	(15)		Self-Referencing Foreign Key to HXC_TIME_CATEGORIES
MAPPING_COMPONENT_ID	NUMBER	(15)		Mapping Component Id
FLEX_VALUE_SET_ID	NUMBER	(15)		Foreign Key to FND_FLEX_VALUE_SETS
VALUE_ID	VARCHAR2	(150)		ID Based on the Flex Value Set chosen
CREATED_BY	NUMBER	(15)		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
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			Standard Who column - date when a user last updated this 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).
SPECIFY_VALUE	VARCHAR2	(1)		Specify Value Flag
COMPONENT_TYPE_ID	NUMBER	(15)		Foreign Key to HXC_MAPPING_COMPONENTS
IS_NULL	VARCHAR2	(1)		Indicates if a Time Category Component is specific to a value or not.
EQUAL_TO	VARCHAR2	(1)		Equal To Flag
TYPE	VARCHAR2	(10)		Time Category Component Type

Query Text

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


SELECT TIME_CATEGORY_COMP_ID
,      OBJECT_VERSION_NUMBER
,      TIME_CATEGORY_ID
,      REF_TIME_CATEGORY_ID
,      MAPPING_COMPONENT_ID
,      FLEX_VALUE_SET_ID
,      VALUE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SPECIFY_VALUE
,      COMPONENT_TYPE_ID
,      IS_NULL
,      EQUAL_TO
,      TYPE
FROM HXC.HXC_TIME_CATEGORY_COMPS;

Dependencies

[top of page]

HXC.HXC_TIME_CATEGORY_COMPS does not reference any database object

HXC.HXC_TIME_CATEGORY_COMPS is referenced by following:

APPS: HXC_TIME_CATEGORY_COMPS; HXC_TIME_CATEGORY_COMPS_WHO