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: HRI.HRI_ADM_MTHD_ACTIONS

Object Details

Object Name:	HRI_ADM_MTHD_ACTIONS
Object Type:	TABLE
Owner:	HRI
Subobject Name:
Status:	VALID

This table stores the multithreading actions. An action can have multiple ranges, which are processed by the collection programs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HRI_ADM_MTHD_ACTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROCESS_NAME
HRI_ADM_MTHD_ACTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID
HRI_ADM_MTHD_ACTIONS_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MTHD_ACTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
MTHD_ACTION_ID	NUMBER		Yes	MTHD_ACTION_ID
PROGRAM	VARCHAR2	(100)		PROGRAM
REQUEST_ID	NUMBER			REQUEST_ID
COLLECT_FROM_DATE	DATE			COLLECT_FROM_DATE
COLLECT_TO_DATE	DATE			COLLECT_TO_DATE
BUSINESS_GROUP_ID	NUMBER			BUSINESS_GROUP_ID
FULL_REFRESH_FLAG	VARCHAR2	(30)		FULL_REFRESH_FLAG
DEBUG_FLAG	VARCHAR2	(30)		DEBUG_FLAG
FOUNDATION_HR_FLAG	VARCHAR2	(30)		FOUNDATION_HR_FLAG
ATTRIBUTE1	VARCHAR2	(100)		ATTRIBUTES
ATTRIBUTE2	VARCHAR2	(100)		ATTRIBUTES
ATTRIBUTE3	VARCHAR2	(100)		ATTRIBUTES
ATTRIBUTE4	VARCHAR2	(100)		ATTRIBUTES
ATTRIBUTE5	VARCHAR2	(100)		ATTRIBUTES
ATTRIBUTE6	VARCHAR2	(100)		ATTRIBUTES
ATTRIBUTE7	VARCHAR2	(100)		ATTRIBUTES
ATTRIBUTE8	VARCHAR2	(100)		ATTRIBUTES
ATTRIBUTE9	VARCHAR2	(100)		ATTRIBUTES
ATTRIBUTE10	VARCHAR2	(100)		ATTRIBUTES
ATTRIBUTE11	VARCHAR2	(100)		ATTRIBUTES
ATTRIBUTE12	VARCHAR2	(100)		ATTRIBUTES
ATTRIBUTE13	VARCHAR2	(100)		ATTRIBUTES
ATTRIBUTE14	VARCHAR2	(100)		ATTRIBUTES
ATTRIBUTE15	VARCHAR2	(100)		ATTRIBUTES
ATTRIBUTE16	VARCHAR2	(100)		ATTRIBUTES
ATTRIBUTE17	VARCHAR2	(100)		ATTRIBUTES
ATTRIBUTE18	VARCHAR2	(100)		ATTRIBUTES
ATTRIBUTE19	VARCHAR2	(100)		ATTRIBUTES
ATTRIBUTE20	VARCHAR2	(100)		ATTRIBUTES
STATUS	VARCHAR2	(30)		STATUS
START_TIME	DATE			START_TIME
END_TIME	DATE			END_TIME
LAST_UPDATE_DATE	DATE			LAST_UPDATE_DATE
LAST_UPDATED_BY	NUMBER			LAST_UPDATED_BY
LAST_UPDATE_LOGIN	NUMBER			LAST_UPDATE_LOGIN
CREATED_BY	VARCHAR2	(30)		CREATED_BY
CREATION_DATE	DATE			CREATION_DATE
PROCESS_NAME	VARCHAR2	(30)		PROCESS_NAME
PROCESS_TYPE	VARCHAR2	(30)		PROCESS_TYPE
HIERARCHICAL_PROCESS_FLAG	VARCHAR2	(30)		HIERARCHICAL_PROCESS_FLAG
HIERARCHICAL_PROCESS_TYPE	VARCHAR2	(30)		HIERARCHICAL_PROCESS_TYPE

Query Text

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


SELECT MTHD_ACTION_ID
,      PROGRAM
,      REQUEST_ID
,      COLLECT_FROM_DATE
,      COLLECT_TO_DATE
,      BUSINESS_GROUP_ID
,      FULL_REFRESH_FLAG
,      DEBUG_FLAG
,      FOUNDATION_HR_FLAG
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      STATUS
,      START_TIME
,      END_TIME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      PROCESS_NAME
,      PROCESS_TYPE
,      HIERARCHICAL_PROCESS_FLAG
,      HIERARCHICAL_PROCESS_TYPE
FROM HRI.HRI_ADM_MTHD_ACTIONS;

Dependencies

[top of page]

HRI.HRI_ADM_MTHD_ACTIONS does not reference any database object

HRI.HRI_ADM_MTHD_ACTIONS is referenced by following:

HRI: HRI_ADM_MTHD_ACTIONS#