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_DBI_TOT_WMV_CHGS

Object Details

Object Name:	HRI_DBI_TOT_WMV_CHGS
Object Type:	TABLE
Owner:	HRI
FND Design Data:	HRI.HRI_DBI_TOT_WMV_CHGS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HRI_DBI_TOT_WMV_CHGS_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	SUPERVISOR_ID EFFECTIVE_DATE
HRI_DBI_TOT_WMV_CHGS_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	EVENT_ASSIGNMENT_ID CHANGE_TYPE EFFECTIVE_DATE

Columns

Name	Datatype	Length	Mandatory
SUPERVISOR_ID	NUMBER	(10)	Yes
EVENT_ASSIGNMENT_ID	NUMBER
EFFECTIVE_DATE	DATE		Yes
NEW_HIRE	NUMBER
TERMINATION	NUMBER
TERM_VOL	NUMBER
TERM_INVOL	NUMBER
TRANSFER_IN	NUMBER
TRANSFER_OUT	NUMBER
CHANGE_TYPE	VARCHAR2	(30)
DIRECT_SUPERVISOR_FLAG	VARCHAR2	(30)
JOB_ID	NUMBER
CURRENCY	VARCHAR2	(240)
SALARY	NUMBER

Query Text

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


SELECT SUPERVISOR_ID
,      EVENT_ASSIGNMENT_ID
,      EFFECTIVE_DATE
,      NEW_HIRE
,      TERMINATION
,      TERM_VOL
,      TERM_INVOL
,      TRANSFER_IN
,      TRANSFER_OUT
,      CHANGE_TYPE
,      DIRECT_SUPERVISOR_FLAG
,      JOB_ID
,      CURRENCY
,      SALARY
FROM HRI.HRI_DBI_TOT_WMV_CHGS;

Dependencies

[top of page]

HRI.HRI_DBI_TOT_WMV_CHGS does not reference any database object

HRI.HRI_DBI_TOT_WMV_CHGS is referenced by following:

APPS: HRI_DBI_TOT_WMV_CHGS