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_BUILDING_BLOCKS

Object Details

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

HXC_TIME_BUILDING_BLOCKS stores the Building Blocks that make up timecard definitions.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HXC_TIME_BUILDING_BLOCKS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TIME_BUILDING_BLOCK_ID OBJECT_VERSION_NUMBER
HXC_TIME_BUILDING_BLOCKS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPROVAL_STYLE_ID
HXC_TIME_BUILDING_BLOCKS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID SCOPE START_TIME STOP_TIME
HXC_TIME_BUILDING_BLOCKS_FK3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_BUILDING_BLOCK_ID PARENT_BUILDING_BLOCK_OVN
HXC_TIME_BUILDING_BLOCKS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SCOPE
HXC_TIME_BUILDING_BLOCKS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DATA_SET_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TIME_BUILDING_BLOCK_ID	NUMBER	(15)	Yes	Primary Key from Sequence
TYPE	VARCHAR2	(30)	Yes	Indicates the Type of the Building Block.
MEASURE	NUMBER			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 of Building Block.
STOP_TIME	DATE			End time of Building Block.
PARENT_BUILDING_BLOCK_ID	NUMBER	(15)		Self-referential Key.
PARENT_BUILDING_BLOCK_OVN	NUMBER	(9)		Self-referential Key.
SCOPE	VARCHAR2	(30)	Yes	Indicates the Scope of the Building Block.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object Version Number
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).
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)		Foreign Key to HXC_APPROVAL_STYLES.
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 with building block
DATA_SET_ID	NUMBER	(15)		Data Set Id
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_TIME_BUILDING_BLOCKS;

Dependencies

[top of page]

HXC.HXC_TIME_BUILDING_BLOCKS does not reference any database object

HXC.HXC_TIME_BUILDING_BLOCKS is referenced by following:

APPS: HXC_TIME_BUILDING_BLOCKS; HXC_TIME_BUILDING_BLOCKS_WHO