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_RPT_TC_DETAILS_ALL

Object Details

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

Master table for all detail, day and timecard level information from time building blocks and time attributes, created to hold all the above information as a snapshot of the timecards, to be used for reporting.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HXC_RPT_TC_DETAILS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	DETAIL_BB_ID DETAIL_BB_OVN
HXC_RPT_TC_DETAILS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID TC_START_TIME TC_STOP_TIME
HXC_RPT_TC_DETAILS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TC_BB_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RESOURCE_ID	NUMBER	(15)		Person/resource_id
TC_START_TIME	DATE			timecard start time
TC_STOP_TIME	DATE			timecard stop time
TC_BB_ID	NUMBER	(15)		timecard's time_building_block_id
TC_BB_OVN	NUMBER	(15)		timecard's OVN
DAY_BB_ID	NUMBER	(15)		day's time_building_block_id
DAY_BB_OVN	NUMBER	(15)		day's OVN
DAY_START_TIME	DATE			day's start_time
DAY_STOP_TIME	DATE			day's stop_time
DETAIL_BB_ID	NUMBER	(15)	Yes	detail's time_building_block_id
DETAIL_BB_OVN	NUMBER	(15)	Yes	detail's OVN
LAYOUT_ID	NUMBER	(15)		layout id for the timecard
TRANSACTION_ID	NUMBER	(22)		transaction_id for DEPOSIT
TRANSACTION_DETAIL_ID	NUMBER	(15)		transaction_detail_id for DEPOSIT
REQUEST_ID	VARCHAR2	(30)		Concurrent request id
CREATION_DATE	DATE			from hxc_time_building_blocks
LAST_UPDATE_DATE	DATE			from hxc_time_building_blocks
DATE_FROM	DATE			from hxc_time_building_blocks
DATE_TO	DATE			from hxc_time_building_blocks
DAY_DATE_TO	DATE			from hxc_time_building_blocks, from DAY scope
DETAIL_COMMENTS	VARCHAR2	(2000)		from hxc_time_building_blocks, DETAIL scope
TC_COMMENTS	VARCHAR2	(2000)		from hxc_time_building_blocks, TIMECARD scope
HOURS_MEASURE	NUMBER			from hxc_time_building_blocks, DETAIL scope
ATTRIBUTE1	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE2	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE3	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE4	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE5	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE6	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE7	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE8	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE9	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE10	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE11	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE12	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE13	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE14	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE15	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE16	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE17	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE18	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE19	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE20	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE21	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE22	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE23	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE24	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE25	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE26	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE27	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE28	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE29	VARCHAR2	(150)		Layout attribute(component)
ATTRIBUTE30	VARCHAR2	(150)		Layout attribute(component)
CREATED_BY	NUMBER	(15)		Standard who, from hxc_time_building_blocks
LAST_UPDATED_BY	NUMBER	(15)		Standard who, from hxc_time_building_blocks
CLA_REASON	VARCHAR2	(150)		Translated CLA reason
CLA_COMMENTS	VARCHAR2	(150)		CLA comments
CLA_TYPE	VARCHAR2	(150)		LATE or CHANGE
CREATED_BY_USER	VARCHAR2	(400)		Username of created_by
LAST_UPDATED_BY_USER	VARCHAR2	(400)		Username of last_updated_by
RESOURCE_NAME	VARCHAR2	(300)		full_name of resource_id
STATUS	VARCHAR2	(30)		from hxc_time_building_blocks

Query Text

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


SELECT RESOURCE_ID
,      TC_START_TIME
,      TC_STOP_TIME
,      TC_BB_ID
,      TC_BB_OVN
,      DAY_BB_ID
,      DAY_BB_OVN
,      DAY_START_TIME
,      DAY_STOP_TIME
,      DETAIL_BB_ID
,      DETAIL_BB_OVN
,      LAYOUT_ID
,      TRANSACTION_ID
,      TRANSACTION_DETAIL_ID
,      REQUEST_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      DATE_FROM
,      DATE_TO
,      DAY_DATE_TO
,      DETAIL_COMMENTS
,      TC_COMMENTS
,      HOURS_MEASURE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      CREATED_BY
,      LAST_UPDATED_BY
,      CLA_REASON
,      CLA_COMMENTS
,      CLA_TYPE
,      CREATED_BY_USER
,      LAST_UPDATED_BY_USER
,      RESOURCE_NAME
,      STATUS
FROM HXC.HXC_RPT_TC_DETAILS_ALL;

Dependencies

[top of page]

HXC.HXC_RPT_TC_DETAILS_ALL does not reference any database object

HXC.HXC_RPT_TC_DETAILS_ALL is referenced by following:

HXC: HXC_RPT_TC_DETAILS_ALL#