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

Object Details

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

The HXC_APP_PERIOD_SUMMARY table denormalizes information about application period scope building blocks from the HXC_TIME_BUILDING_BLOCKS table. Further, it stores information for and is used by the entry level approval functionality.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HXC_APP_PERIOD_SUMMARY_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	APPLICATION_PERIOD_ID
HXC_APP_PERIOD_SUMMARY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_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;

Dependencies

[top of page]

HXC.HXC_APP_PERIOD_SUMMARY does not reference any database object

HXC.HXC_APP_PERIOD_SUMMARY is referenced by following:

APPS: HXC_APP_PERIOD_SUMMARY