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_RDB_POST_DETAILS

Object Details

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

Used for Retrieval Dashboard Post Tab

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HXC_RDB_POST_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RET_USER_ID TIMECARD_ID
HXC_RDB_POST_DETAILS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RET_USER_ID HRS_PM
HXC_RDB_POST_DETAILS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RET_USER_ID ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3
HXC_RDB_POST_DETAILS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RET_USER_ID BATCH_ID
HXC_RDB_POST_DETAILS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RET_USER_ID RETRO_BATCH_ID
HXC_RDB_POST_TC_DETAILS_FK	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TIMECARD_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RESOURCE_ID	NUMBER	(15)	Yes	Id of a person whose timecard is retreived
TIME_BUILDING_BLOCK_ID	NUMBER	(15)	Yes	time building detail block id which is retrieved
OVN	NUMBER	(9)	Yes	Object version number of the detail retrieved
TIMECARD_ID	NUMBER	(15)		Timecard id of timecard whose detail building block is picked up in retrieval
DATE_WORKED	DATE		Yes	Worked date of a timecard
MEASURE	NUMBER	(15)		The numerical magnitude of UNIT_OF_MEASURE.
HRS_PM	NUMBER	(15)		HRS_PM
RET_USER_ID	NUMBER	(15)		User id is foreign key to FND_USER.USER_ID
ATTRIBUTE1	VARCHAR2	(500)		Attribute information of a timecard retrieved
ATTRIBUTE2	VARCHAR2	(500)		Attribute information of a timecard retrieved
ATTRIBUTE3	VARCHAR2	(500)		Attribute information of a timecard retrieved
REC_LINE_ID	NUMBER	(15)		Batch line id
REC_RETRO_LINE_ID	NUMBER	(15)		Line id for Retro batch
OLD_MEASURE	NUMBER	(15)		Previous numerical magnitude of UNIT_OF_MEASURE.
OLD_ATTRIBUTE1	VARCHAR2	(500)		Previous Attribute information of a timecard retrieved
OLD_ATTRIBUTE2	VARCHAR2	(500)		Previous Attribute information of a timecard retrieved
OLD_ATTRIBUTE3	VARCHAR2	(500)		Previous Attribute information of a timecard retrieved
BATCH_ID	VARCHAR2	(400)		Batch_id of the processed batch
RETRO_BATCH_ID	VARCHAR2	(400)		Retro Batch Id of the Retro batch
ADJ_REC_LINE_ID	NUMBER	(15)		Batch Lined Id
OLD_BATCH_ID	VARCHAR2	(400)		Prvious Batch Id
REQUEST_ID	NUMBER	(15)		Request Id of the current processing batch
OLD_REQUEST_ID	NUMBER	(15)		Previous Request Id of the Processed Batch

Query Text

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


SELECT RESOURCE_ID
,      TIME_BUILDING_BLOCK_ID
,      OVN
,      TIMECARD_ID
,      DATE_WORKED
,      MEASURE
,      HRS_PM
,      RET_USER_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      REC_LINE_ID
,      REC_RETRO_LINE_ID
,      OLD_MEASURE
,      OLD_ATTRIBUTE1
,      OLD_ATTRIBUTE2
,      OLD_ATTRIBUTE3
,      BATCH_ID
,      RETRO_BATCH_ID
,      ADJ_REC_LINE_ID
,      OLD_BATCH_ID
,      REQUEST_ID
,      OLD_REQUEST_ID
FROM HXC.HXC_RDB_POST_DETAILS;

Dependencies

[top of page]

HXC.HXC_RDB_POST_DETAILS does not reference any database object

HXC.HXC_RDB_POST_DETAILS is referenced by following:

HXC: HXC_RDB_POST_DETAILS#