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_PA_LATEST_DETAILS

Object Details

Object Name:	HXC_RET_PA_LATEST_DETAILS
Object Type:	TABLE
Owner:	HXC
FND Design Data:	HXC.HXC_RET_PA_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_PA_LATEST_DETAILS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TIME_BUILDING_BLOCK_ID OBJECT_VERSION_NUMBER
HXC_RET_PA_LATEST_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID
HXC_RET_PA_LATEST_DETAILS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TIMECARD_ID
HXC_RET_PA_LATEST_DETAILS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	START_TIME STOP_TIME
HXC_RET_PA_LATEST_DETAILS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RESOURCE_ID	NUMBER	(15)	Yes	The field stores information about:HXC_RET_PA_LATEST_DETAILS.RESOURCE_ID
TIME_BUILDING_BLOCK_ID	NUMBER	(15)	Yes	The field stores information about:HXC_RET_PA_LATEST_DETAILS.TIME_BUILDING_BLOCK_ID
APPROVAL_STATUS	VARCHAR2	(30)	Yes	The field stores information about:HXC_RET_PA_LATEST_DETAILS.APPROVAL_STATUS
START_TIME	DATE		Yes	The field stores information about:HXC_RET_PA_LATEST_DETAILS.START_TIME
STOP_TIME	DATE		Yes	The field stores information about:HXC_RET_PA_LATEST_DETAILS.STOP_TIME
ORG_ID	NUMBER	(15)		The field stores information about:HXC_RET_PA_LATEST_DETAILS.ORG_ID
BUSINESS_GROUP_ID	NUMBER	(15)		The field stores information about:HXC_RET_PA_LATEST_DETAILS.BUSINESS_GROUP_ID
TIMECARD_ID	NUMBER	(15)		The field stores information about:HXC_RET_PA_LATEST_DETAILS.TIMECARD_ID
ATTRIBUTE1	VARCHAR2	(240)		The field stores information about:HXC_RET_PA_LATEST_DETAILS.ATTRIBUTE1
ATTRIBUTE2	VARCHAR2	(240)		The field stores information about:HXC_RET_PA_LATEST_DETAILS.ATTRIBUTE2
ATTRIBUTE3	VARCHAR2	(240)		The field stores information about:HXC_RET_PA_LATEST_DETAILS.ATTRIBUTE3
MEASURE	NUMBER			The field stores information about:HXC_RET_PA_LATEST_DETAILS.MEASURE
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	The field stores information about:HXC_RET_PA_LATEST_DETAILS.OBJECT_VERSION_NUMBER
OLD_OVN	NUMBER	(9)		The field stores information about:HXC_RET_PA_LATEST_DETAILS.OLD_OVN
OLD_MEASURE	NUMBER			The field stores information about:HXC_RET_PA_LATEST_DETAILS.OLD_MEASURE
OLD_ATTRIBUTE1	VARCHAR2	(240)		The field stores information about:HXC_RET_PA_LATEST_DETAILS.OLD_ATTRIBUTE1
OLD_ATTRIBUTE2	VARCHAR2	(240)		The field stores information about:HXC_RET_PA_LATEST_DETAILS.OLD_ATTRIBUTE2
OLD_ATTRIBUTE3	VARCHAR2	(240)		The field stores information about:HXC_RET_PA_LATEST_DETAILS.OLD_ATTRIBUTE3
PEI_ID	NUMBER			The field stores information about:HXC_RET_PA_LATEST_DETAILS.PEI_ID
RETRO_PEI_ID	NUMBER			The field stores information about:HXC_RET_PA_LATEST_DETAILS.RETRO_PEI_ID
OLD_PEI_ID	NUMBER			The field stores information about:HXC_RET_PA_LATEST_DETAILS.OLD_PEI_ID
REQUEST_ID	NUMBER			The field stores information about:HXC_RET_PA_LATEST_DETAILS.REQUEST_ID
RETRO_EXP_GROUP	VARCHAR2	(400)		The field stores information about:HXC_RET_PA_LATEST_DETAILS.RETRO_EXP_GROUP
EXP_GROUP	VARCHAR2	(400)		The field stores information about:HXC_RET_PA_LATEST_DETAILS.EXP_GROUP
OLD_REQUEST_ID	NUMBER	(15)		The field stores information about:HXC_RET_PA_LATEST_DETAILS.OLD_REQUEST_ID
OLD_EXP_GROUP	VARCHAR2	(400)		The field stores information about:HXC_RET_PA_LATEST_DETAILS.OLD_EXP_GROUP

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
,      PEI_ID
,      RETRO_PEI_ID
,      OLD_PEI_ID
,      REQUEST_ID
,      RETRO_EXP_GROUP
,      EXP_GROUP
,      OLD_REQUEST_ID
,      OLD_EXP_GROUP
FROM HXC.HXC_RET_PA_LATEST_DETAILS;

Dependencies

[top of page]

HXC.HXC_RET_PA_LATEST_DETAILS does not reference any database object

HXC.HXC_RET_PA_LATEST_DETAILS is referenced by following:

HXC: HXC_RET_PA_LATEST_DETAILS#