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

TABLE: HXC.HXC_TEMPLATE_SUMMARY

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


HXC_TEMPLATE_SUMMARY table stores Timecard Template summary information


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HXC_TEMPLATE_SUMMARY_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTEMPLATE_ID
HXC_TEMPLATE_SUMMARY_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESOURCE_ID
HXC_TEMPLATE_SUMMARY_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLAYOUT_ID
Columns
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
Query Text

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;

Dependencies

[top of page]

HXC.HXC_TEMPLATE_SUMMARY does not reference any database object

HXC.HXC_TEMPLATE_SUMMARY is referenced by following:

SchemaHXC
ViewHXC_TEMPLATE_SUMMARY#