DBA Data[Home] [Help] [Dependency Information]

TABLE: HXC.HXC_RDB_PRE_TC_DETAILS

Object Details
Object Name: HXC_RDB_PRE_TC_DETAILS
Object Type: TABLE
Owner: HXC
FND Design Data: TableHXC.HXC_RDB_PRE_TC_DETAILS
Subobject Name:
Status: VALID


Used for Retrieval Dashboard Pre Retrieval Timecard Details


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HXC_RDB_PRE_TC_DETAILS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRET_USER_ID
ColumnTIMECARD_ID
Columns
Name Datatype Length Mandatory Comments
TIME_BUILDING_BLOCK_ID NUMBER (15)
Time building block id of a timecard
OBJECT_VERSION_NUMBER NUMBER (15)
Object verstion number of the detail building block
DATE_WORKED DATE

Date worked
MEASURE NUMBER (15)
The numerical magnitude of UNIT_OF_MEASURE.
ATTRIBUTE1 VARCHAR2 (400)
Attribute Information of the timecard
ATTRIBUTE2 VARCHAR2 (400)
Attribute Information attached to timecard
ATTRIBUTE3 VARCHAR2 (400)
Attribute Information attached to timecard
ATTRIBUTE_NAME VARCHAR2 (2000)
attribute name attached to building block
START_TIME VARCHAR2 (400)
start date of timecard
STOP_TIME VARCHAR2 (400)
end date of timecard
TIMECARD_ID NUMBER (15)
Timecard id attach to building block
RET_USER_ID NUMBER (15)
user id is foreign key to FND_USER.USER_ID
Query Text

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


SELECT TIME_BUILDING_BLOCK_ID
,      OBJECT_VERSION_NUMBER
,      DATE_WORKED
,      MEASURE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE_NAME
,      START_TIME
,      STOP_TIME
,      TIMECARD_ID
,      RET_USER_ID
FROM HXC.HXC_RDB_PRE_TC_DETAILS;

Dependencies

[top of page]

HXC.HXC_RDB_PRE_TC_DETAILS does not reference any database object

HXC.HXC_RDB_PRE_TC_DETAILS is referenced by following:

SchemaHXC
ViewHXC_RDB_PRE_TC_DETAILS#