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_APP_PERIOD_SUMMARY_AR

Object Details

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

The HXC_APP_PERIOD_SUMMARY_AR table holds the archived entries of HXC_APP_PERIOD_SUMMARY.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HXC_APP_PERIOD_SUMMARY_AR_PK	NORMAL	UNIQUE	APPS_TS_ARCHIVE	APPLICATION_PERIOD_ID

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_PERIOD_ID	NUMBER		Yes	The application period id
APPLICATION_PERIOD_OVN	NUMBER		Yes	The application period object version number
APPROVAL_STATUS	VARCHAR2	(30)	Yes	The approval status
TIME_RECIPIENT_ID	NUMBER		Yes	The time recipient id
TIME_CATEGORY_ID	NUMBER			The time category id
START_TIME	DATE		Yes	The start time of the approval period
STOP_TIME	DATE		Yes	The stop time of the approval period
RESOURCE_ID	NUMBER		Yes	The resource id
RECIPIENT_SEQUENCE	NUMBER			The sequence of time recipients
CATEGORY_SEQUENCE	NUMBER			The sequence of categories (within a time recipient)
CREATION_DATE	DATE		Yes	The creation date of the approval period.
NOTIFICATION_STATUS	VARCHAR2	(30)	Yes	The status of the associated notification
APPROVER_ID	NUMBER			The approver id
APPROVAL_COMP_ID	NUMBER			The approval component id which caused the generation of this application period
APPROVAL_ITEM_TYPE	VARCHAR2	(8)		Item Type corresponding to Notification
APPROVAL_PROCESS_NAME	VARCHAR2	(30)		Notification Process
APPROVAL_ITEM_KEY	VARCHAR2	(240)		Item Key Corresponding to Notification
DATA_SET_ID	NUMBER	(15)		Data Set Id

Query Text

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


SELECT APPLICATION_PERIOD_ID
,      APPLICATION_PERIOD_OVN
,      APPROVAL_STATUS
,      TIME_RECIPIENT_ID
,      TIME_CATEGORY_ID
,      START_TIME
,      STOP_TIME
,      RESOURCE_ID
,      RECIPIENT_SEQUENCE
,      CATEGORY_SEQUENCE
,      CREATION_DATE
,      NOTIFICATION_STATUS
,      APPROVER_ID
,      APPROVAL_COMP_ID
,      APPROVAL_ITEM_TYPE
,      APPROVAL_PROCESS_NAME
,      APPROVAL_ITEM_KEY
,      DATA_SET_ID
FROM HXC.HXC_APP_PERIOD_SUMMARY_AR;

Dependencies

[top of page]

HXC.HXC_APP_PERIOD_SUMMARY_AR does not reference any database object

HXC.HXC_APP_PERIOD_SUMMARY_AR is referenced by following:

APPS: HXC_APP_PERIOD_SUMMARY_AR