[Home] [Help] [Dependency Information]
Object Name: | HXC_TEMPLATE_SUMMARY |
---|---|
Object Type: | TABLE |
Owner: | HXC |
FND Design Data: | HXC.HXC_TEMPLATE_SUMMARY |
Subobject Name: | |
Status: | VALID |
HXC_TEMPLATE_SUMMARY table stores Timecard Template summary information
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HXC_TEMPLATE_SUMMARY_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | TEMPLATE_ID |
HXC_TEMPLATE_SUMMARY_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RESOURCE_ID |
HXC_TEMPLATE_SUMMARY_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LAYOUT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEMPLATE_ID | NUMBER | (15) | Yes | Template Id |
TEMPLATE_OVN | NUMBER | (9) | Yes | Template Object Version Number |
TEMPLATE_NAME | VARCHAR2 | (150) | Yes | Template Name |
DESCRIPTION | VARCHAR2 | (150) | Template Description | |
TEMPLATE_TYPE | VARCHAR2 | (150) | Template Type | |
RECORDED_HOURS | NUMBER | Recorded Hours | ||
LAYOUT_ID | NUMBER | (15) | Layout Id | |
RESOURCE_ID | NUMBER | (15) | Yes | Resource Id |
LAST_UPDATED_BY_RESOURCE_ID | NUMBER | (15) | Yes | Last updated by resource Id |
RECURRING_PERIOD_ID | NUMBER | (15) | Recurring period Id | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Business Group Id |
START_TIME | DATE | Start Time | ||
STOP_TIME | DATE | Stop Time |
Cut, paste (and edit) the following text to query this object:
SELECT TEMPLATE_ID
, TEMPLATE_OVN
, TEMPLATE_NAME
, DESCRIPTION
, TEMPLATE_TYPE
, RECORDED_HOURS
, LAYOUT_ID
, RESOURCE_ID
, LAST_UPDATED_BY_RESOURCE_ID
, RECURRING_PERIOD_ID
, BUSINESS_GROUP_ID
, START_TIME
, STOP_TIME
FROM HXC.HXC_TEMPLATE_SUMMARY;
HXC.HXC_TEMPLATE_SUMMARY does not reference any database object
HXC.HXC_TEMPLATE_SUMMARY is referenced by following:
|
|
|