[Home] [Help] [Dependency Information]
Object Name: | HXC_RPT_TC_RESOURCE_TEMP |
---|---|
Object Type: | TABLE |
Owner: | HXC |
FND Design Data: | HXC.HXC_RPT_TC_RESOURCE_TEMP |
Subobject Name: | |
Status: | VALID |
Temp table to hold the timecard level info for active resources while loading the timecard snapshot for reporting
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HXC_RPT_TC_RESOURCE_TEMP_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LAYOUT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCE_ID | NUMBER | (15) | Resource_id | |
TC_START_TIME | DATE | TC_START_TIME | ||
TC_STOP_TIME | DATE | TC_STOP_TIME | ||
TC_BB_ID | NUMBER | (15) | TC_BB_ID | |
LAYOUT_ID | NUMBER | (15) | Layout Id | |
ALIAS_DEFINITION_ID | NUMBER | (15) | Alias_Definition_id | |
REQUEST_ID | VARCHAR2 | (30) | Request_id | |
HISTORY_FROM_DATE | DATE | History_from_date | ||
TC_COMMENTS | VARCHAR2 | (2000) | Tc_comments | |
RESOURCE_NAME | VARCHAR2 | (300) | Resource_name |
Cut, paste (and edit) the following text to query this object:
SELECT RESOURCE_ID
, TC_START_TIME
, TC_STOP_TIME
, TC_BB_ID
, LAYOUT_ID
, ALIAS_DEFINITION_ID
, REQUEST_ID
, HISTORY_FROM_DATE
, TC_COMMENTS
, RESOURCE_NAME
FROM HXC.HXC_RPT_TC_RESOURCE_TEMP;
HXC.HXC_RPT_TC_RESOURCE_TEMP does not reference any database object
HXC.HXC_RPT_TC_RESOURCE_TEMP is referenced by following:
|
|
|