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_AR

Object Details

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

HXC_TIME_BUILDING_BLOCKS_AR holds the archived entries of HXC_TIME_BUILDING_BLOCKS.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HXC_TIME_BUILDING_BLOCKS_AR_PK	NORMAL	UNIQUE	APPS_TS_ARCHIVE	TIME_BUILDING_BLOCK_ID OBJECT_VERSION_NUMBER
HXC_TIME_BLDNG_BLOCKS_AR_FK2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	SCOPE DATA_SET_ID
HXC_TIME_BLDNG_BLOCKS_AR_FK3	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	PARENT_BUILDING_BLOCK_ID PARENT_BUILDING_BLOCK_OVN
HXC_TIME_BLDNG_BLOCKS_AR_FK4	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	SCOPE STOP_TIME
HXC_TIME_BLDNG_BLOCKS_AR_FK5	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	DATA_SET_ID SCOPE

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)		Backup of 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_AR;

Dependencies

[top of page]

HXC.HXC_TIME_BUILDING_BLOCKS_AR does not reference any database object

HXC.HXC_TIME_BUILDING_BLOCKS_AR is referenced by following:

APPS: HXC_TIME_BUILDING_BLOCKS_AR; HXC_TIME_BUILDING_BLOCKS_A_WHO