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_TC_DETAILS

Object Details

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

Used in Retrieval Dashboard Processing

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
TIME_BUILDING_BLOCK_ID	NUMBER	(15)	detail building block id
OBJECT_VERSION_NUMBER	NUMBER	(15)	Object Version Number of the building block retrieved
DATE_WORKED	DATE		Date worked of the building block
MEASURE	NUMBER	(15)	The numerical magnitude of UNIT_OF_MEASURE.
ATTRIBUTE1	VARCHAR2	(400)	Attribute Information of retrieved timecard
ATTRIBUTE2	VARCHAR2	(400)	Attribute Information of retrieved timecard
ATTRIBUTE3	VARCHAR2	(400)	Attribute Information of retrieved timecard
ATTRIBUTE_NAME	VARCHAR2	(2000)	Attribute Name of the retrieved timecard
REC_LINE_ID	NUMBER	(15)	Batch Line Id of the building block retrieved
ADJ_REC_LINE_ID	NUMBER	(15)	Adjustment batch line id
BATCH_ID	VARCHAR2	(100)	Batch Id of the Batch being processed
BATCH_NAME	VARCHAR2	(400)	Batch name of the batch being processed
REQUEST_ID	NUMBER	(15)	Request Id of the concurrent retrieval process
TIMECARD_ID	NUMBER	(15)	Timecard id of the detail building block id being processed in batch
RET_USER_ID	NUMBER	(15)	User is foreign key to FND_USER.USER_ID
OLD_LINE_DETAILS	VARCHAR2	(500)	Original Batch Id + Batch Name and Request Id of Retro Batch
OLD_BATCH_ID	VARCHAR2	(100)	Original Batch Id of Retro Batch
OLD_REQUEST_ID	NUMBER	(15)	Request Id where Orignal Batch was processed

Query Text

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


SELECT TIME_BUILDING_BLOCK_ID
,      OBJECT_VERSION_NUMBER
,      DATE_WORKED
,      MEASURE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE_NAME
,      REC_LINE_ID
,      ADJ_REC_LINE_ID
,      BATCH_ID
,      BATCH_NAME
,      REQUEST_ID
,      TIMECARD_ID
,      RET_USER_ID
,      OLD_LINE_DETAILS
,      OLD_BATCH_ID
,      OLD_REQUEST_ID
FROM HXC.HXC_RDB_POST_TC_DETAILS;

Dependencies

[top of page]

HXC.HXC_RDB_POST_TC_DETAILS does not reference any database object

HXC.HXC_RDB_POST_TC_DETAILS is referenced by following:

HXC: HXC_RDB_POST_TC_DETAILS#