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_RET_PAY_LATEST_DETAILS

Object Details

Object Name:	HXC_RET_PAY_LATEST_DETAILS
Object Type:	TABLE
Owner:	HXC
FND Design Data:	HXC.HXC_RET_PAY_LATEST_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_RET_PAY_LATEST_DETAILS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TIME_BUILDING_BLOCK_ID OBJECT_VERSION_NUMBER
HXC_RET_PAY_LATEST_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID
HXC_RET_PAY_LATEST_DETAILS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RETRO_BATCH_ID
HXC_RET_PAY_LATEST_DETAILS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TIMECARD_ID
HXC_RET_PAY_LATEST_DETAILS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	START_TIME STOP_TIME
HXC_RET_PAY_LATEST_DETAILS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID
HXC_RET_PAY_LATEST_DETAILS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PBL_ID
HXC_RET_PAY_LATEST_DETAILS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OLD_PBL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RESOURCE_ID	NUMBER	(15)	Yes	This field stores data bout resource_id
TIME_BUILDING_BLOCK_ID	NUMBER	(15)	Yes	This field stores data about time building block id
APPROVAL_STATUS	VARCHAR2	(30)	Yes	This field stores data about approval status
START_TIME	DATE		Yes	This field stores data about start time of timecard
STOP_TIME	DATE		Yes	This field stores data about end time of timecard
ORG_ID	NUMBER	(15)		This field stores data about org_id
BUSINESS_GROUP_ID	NUMBER	(15)		This field stores data about business group id
TIMECARD_ID	NUMBER	(15)		This field stores data about timecard_id
ATTRIBUTE1	VARCHAR2	(240)		attribute information about timecard
ATTRIBUTE2	VARCHAR2	(240)		attribute information about timecard
ATTRIBUTE3	VARCHAR2	(240)		attribute information about timecard
MEASURE	NUMBER			The numerical magnitude of UNIT_OF_MEASURE.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object Version Number of the timecard
OLD_OVN	NUMBER	(9)		Previous Object Version Number of timecard
OLD_MEASURE	NUMBER			This field stores data about old measure
OLD_ATTRIBUTE1	VARCHAR2	(240)		The field stores information about OLD_ATTRIBUTE1
OLD_ATTRIBUTE2	VARCHAR2	(240)		The field stores information about OLD_ATTRIBUTE2
OLD_ATTRIBUTE3	VARCHAR2	(240)		The field stores information about OLD_ATTRIBUTE3
PBL_ID	NUMBER			The field stores information about PBL_ID
RETRO_PBL_ID	NUMBER			The field stores information about RETRO_PBL_ID
OLD_PBL_ID	NUMBER			The field stores information about OLD_PBL_ID
BATCH_ID	NUMBER			The field stores information about BATCH_ID
RETRO_BATCH_ID	NUMBER			The field stores information about RETRO_BATCH_ID
OLD_BATCH_ID	NUMBER	(15)		The field stores information about OLD_BATCH_ID
REQUEST_ID	NUMBER	(15)		The field stores information about REQUEST_ID
OLD_REQUEST_ID	NUMBER	(15)		The field stores information about OLD_REQUEST_ID
APPLICATION_SET_ID	NUMBER	(15)		The field stores information about APPLICATION_SET_ID
COMMENT_TEXT	VARCHAR2	(2000)		The field stores information about COMMENT_TEXT
HXT_ATTRIBUTE2	VARCHAR2	(150)		The field stores information about HXT_ATTRIBUTE2
HXT_ATTRIBUTE3	VARCHAR2	(150)		The field stores information about HXT_ATTRIBUTE3
HXT_BATCH_ID	NUMBER	(15)		The field stores information about HXT_BATCH_ID
HXT_ELEMENT_ID	NUMBER	(15)		The field stores information about HXT_ELEMENT_ID
HXT_MEASURE	NUMBER	(15)		The field stores information about HXT_MEASURE
HXT_REQUEST_ID	NUMBER	(15)		The field stores information about HXT_REQUEST_ID
LAST_UPDATE_DATE	DATE			The field stores information about LAST_UPDATE_DATE
RESOURCE_TYPE	VARCHAR2	(50)		The field stores information about RESOURCE_TYPE

Query Text

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


SELECT RESOURCE_ID
,      TIME_BUILDING_BLOCK_ID
,      APPROVAL_STATUS
,      START_TIME
,      STOP_TIME
,      ORG_ID
,      BUSINESS_GROUP_ID
,      TIMECARD_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      MEASURE
,      OBJECT_VERSION_NUMBER
,      OLD_OVN
,      OLD_MEASURE
,      OLD_ATTRIBUTE1
,      OLD_ATTRIBUTE2
,      OLD_ATTRIBUTE3
,      PBL_ID
,      RETRO_PBL_ID
,      OLD_PBL_ID
,      BATCH_ID
,      RETRO_BATCH_ID
,      OLD_BATCH_ID
,      REQUEST_ID
,      OLD_REQUEST_ID
,      APPLICATION_SET_ID
,      COMMENT_TEXT
,      HXT_ATTRIBUTE2
,      HXT_ATTRIBUTE3
,      HXT_BATCH_ID
,      HXT_ELEMENT_ID
,      HXT_MEASURE
,      HXT_REQUEST_ID
,      LAST_UPDATE_DATE
,      RESOURCE_TYPE
FROM HXC.HXC_RET_PAY_LATEST_DETAILS;

Dependencies

[top of page]

HXC.HXC_RET_PAY_LATEST_DETAILS does not reference any database object

HXC.HXC_RET_PAY_LATEST_DETAILS is referenced by following:

HXC: HXC_RET_PAY_LATEST_DETAILS#