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: HR.HR_DM_EXP_IMPS

Object Details

Object Name:	HR_DM_EXP_IMPS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.HR_DM_EXP_IMPS
Subobject Name:
Status:	VALID

This table holds the data from various tables in the source database that will be moved to the destination database using the transportable tablespace for upload in the destination database

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Primary Key: HR_DM_EXP_IMPS_PK

EXP_IMP_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_DM_EXP_IMPS_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	EXP_IMP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
EXP_IMP_ID	NUMBER	(15)	Yes	System-generated primary key column.
TABLE_NAME	VARCHAR2	(30)	Yes	The name of the source / destination table
PVAL001	VARCHAR2	(2000)		The data from the source table.
PVAL002	VARCHAR2	(2000)		The data from the source table.
PVAL003	VARCHAR2	(2000)		The data from the source table.
PVAL004	VARCHAR2	(2000)		The data from the source table.
PVAL005	VARCHAR2	(2000)		The data from the source table.
PVAL006	VARCHAR2	(2000)		The data from the source table.
PVAL007	VARCHAR2	(2000)		The data from the source table.
PVAL008	VARCHAR2	(2000)		The data from the source table.
PVAL009	VARCHAR2	(2000)		The data from the source table.
PVAL010	VARCHAR2	(2000)		The data from the source table.
PVAL011	VARCHAR2	(2000)		The data from the source table.
PVAL012	VARCHAR2	(2000)		The data from the source table.
PVAL013	VARCHAR2	(2000)		The data from the source table.
PVAL014	VARCHAR2	(2000)		The data from the source table.
PVAL015	VARCHAR2	(2000)		The data from the source table.
PVAL016	VARCHAR2	(2000)		The data from the source table.
PVAL017	VARCHAR2	(2000)		The data from the source table.
PVAL018	VARCHAR2	(2000)		The data from the source table.
PVAL019	VARCHAR2	(2000)		The data from the source table.
PVAL020	VARCHAR2	(2000)		The data from the source table.
PVAL021	VARCHAR2	(2000)		The data from the source table.
PVAL022	VARCHAR2	(2000)		The data from the source table.
PVAL023	VARCHAR2	(2000)		The data from the source table.
PVAL024	VARCHAR2	(2000)		The data from the source table.
PVAL025	VARCHAR2	(2000)		The data from the source table.
PVAL026	VARCHAR2	(2000)		The data from the source table.
PVAL027	VARCHAR2	(2000)		The data from the source table.
PVAL028	VARCHAR2	(2000)		The data from the source table.
PVAL029	VARCHAR2	(2000)		The data from the source table.
PVAL030	VARCHAR2	(2000)		The data from the source table.
PVAL031	VARCHAR2	(2000)		The data from the source table.
PVAL032	VARCHAR2	(2000)		The data from the source table.
PVAL033	VARCHAR2	(2000)		The data from the source table.
PVAL034	VARCHAR2	(2000)		The data from the source table.
PVAL035	VARCHAR2	(2000)		The data from the source table.
PVAL036	VARCHAR2	(2000)		The data from the source table.
PVAL037	VARCHAR2	(2000)		The data from the source table.
PVAL038	VARCHAR2	(2000)		The data from the source table.
PVAL039	VARCHAR2	(2000)		The data from the source table.
PVAL040	VARCHAR2	(2000)		The data from the source table.
PVAL041	VARCHAR2	(2000)		The data from the source table.
PVAL042	VARCHAR2	(2000)		The data from the source table.
PVAL043	VARCHAR2	(2000)		The data from the source table.
PVAL044	VARCHAR2	(2000)		The data from the source table.
PVAL045	VARCHAR2	(2000)		The data from the source table.
PVAL046	VARCHAR2	(2000)		The data from the source table.
PVAL047	VARCHAR2	(2000)		The data from the source table.
PVAL048	VARCHAR2	(2000)		The data from the source table.
PVAL049	VARCHAR2	(2000)		The data from the source table.
PVAL050	VARCHAR2	(2000)		The data from the source table.
PVAL051	VARCHAR2	(2000)		The data from the source table.
PVAL052	VARCHAR2	(2000)		The data from the source table.
PVAL053	VARCHAR2	(2000)		The data from the source table.
PVAL054	VARCHAR2	(2000)		The data from the source table.
PVAL055	VARCHAR2	(2000)		The data from the source table.
PVAL056	VARCHAR2	(2000)		The data from the source table.
PVAL057	VARCHAR2	(2000)		The data from the source table.
PVAL058	VARCHAR2	(2000)		The data from the source table.
PVAL059	VARCHAR2	(2000)		The data from the source table.
PVAL060	VARCHAR2	(2000)		The data from the source table.
PVAL061	VARCHAR2	(2000)		The data from the source table.
PVAL062	VARCHAR2	(2000)		The data from the source table.
PVAL063	VARCHAR2	(2000)		The data from the source table.
PVAL064	VARCHAR2	(2000)		The data from the source table.
PVAL065	VARCHAR2	(2000)		The data from the source table.
PVAL066	VARCHAR2	(2000)		The data from the source table.
PVAL067	VARCHAR2	(2000)		The data from the source table.
PVAL068	VARCHAR2	(2000)		The data from the source table.
PVAL069	VARCHAR2	(2000)		The data from the source table.
PVAL070	VARCHAR2	(2000)		The data from the source table.
PVAL071	VARCHAR2	(2000)		The data from the source table.
PVAL072	VARCHAR2	(2000)		The data from the source table.
PVAL073	VARCHAR2	(2000)		The data from the source table.
PVAL074	VARCHAR2	(2000)		The data from the source table.
PVAL075	VARCHAR2	(2000)		The data from the source table.
PVAL076	VARCHAR2	(2000)		The data from the source table.
PVAL077	VARCHAR2	(2000)		The data from the source table.
PVAL078	VARCHAR2	(2000)		The data from the source table.
PVAL079	VARCHAR2	(2000)		The data from the source table.
PVAL080	VARCHAR2	(2000)		The data from the source table.
PVAL081	VARCHAR2	(2000)		The data from the source table.
PVAL082	VARCHAR2	(2000)		The data from the source table.
PVAL083	VARCHAR2	(2000)		The data from the source table.
PVAL084	VARCHAR2	(2000)		The data from the source table.
PVAL085	VARCHAR2	(2000)		The data from the source table.
PVAL086	VARCHAR2	(2000)		The data from the source table.
PVAL087	VARCHAR2	(2000)		The data from the source table.
PVAL088	VARCHAR2	(2000)		The data from the source table.
PVAL089	VARCHAR2	(2000)		The data from the source table.
PVAL090	VARCHAR2	(2000)		The data from the source table.
PVAL091	VARCHAR2	(2000)		The data from the source table.
PVAL092	VARCHAR2	(2000)		The data from the source table.
PVAL093	VARCHAR2	(2000)		The data from the source table.
PVAL094	VARCHAR2	(2000)		The data from the source table.
PVAL095	VARCHAR2	(2000)		The data from the source table.
PVAL096	VARCHAR2	(2000)		The data from the source table.
PVAL097	VARCHAR2	(2000)		The data from the source table.
PVAL098	VARCHAR2	(2000)		The data from the source table.
PVAL099	VARCHAR2	(2000)		The data from the source table.
PVAL100	VARCHAR2	(2000)		The data from the source table.
LAST_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
CREATED_BY	NUMBER	(15)		Standard Who column.
CREATION_DATE	DATE			Standard Who column.
SECURITY_GROUP_ID	NUMBER	(15)		Foreign Key to FND_SECURITY_GROUPS.

Query Text

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


SELECT EXP_IMP_ID
,      TABLE_NAME
,      PVAL001
,      PVAL002
,      PVAL003
,      PVAL004
,      PVAL005
,      PVAL006
,      PVAL007
,      PVAL008
,      PVAL009
,      PVAL010
,      PVAL011
,      PVAL012
,      PVAL013
,      PVAL014
,      PVAL015
,      PVAL016
,      PVAL017
,      PVAL018
,      PVAL019
,      PVAL020
,      PVAL021
,      PVAL022
,      PVAL023
,      PVAL024
,      PVAL025
,      PVAL026
,      PVAL027
,      PVAL028
,      PVAL029
,      PVAL030
,      PVAL031
,      PVAL032
,      PVAL033
,      PVAL034
,      PVAL035
,      PVAL036
,      PVAL037
,      PVAL038
,      PVAL039
,      PVAL040
,      PVAL041
,      PVAL042
,      PVAL043
,      PVAL044
,      PVAL045
,      PVAL046
,      PVAL047
,      PVAL048
,      PVAL049
,      PVAL050
,      PVAL051
,      PVAL052
,      PVAL053
,      PVAL054
,      PVAL055
,      PVAL056
,      PVAL057
,      PVAL058
,      PVAL059
,      PVAL060
,      PVAL061
,      PVAL062
,      PVAL063
,      PVAL064
,      PVAL065
,      PVAL066
,      PVAL067
,      PVAL068
,      PVAL069
,      PVAL070
,      PVAL071
,      PVAL072
,      PVAL073
,      PVAL074
,      PVAL075
,      PVAL076
,      PVAL077
,      PVAL078
,      PVAL079
,      PVAL080
,      PVAL081
,      PVAL082
,      PVAL083
,      PVAL084
,      PVAL085
,      PVAL086
,      PVAL087
,      PVAL088
,      PVAL089
,      PVAL090
,      PVAL091
,      PVAL092
,      PVAL093
,      PVAL094
,      PVAL095
,      PVAL096
,      PVAL097
,      PVAL098
,      PVAL099
,      PVAL100
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      SECURITY_GROUP_ID
FROM HR.HR_DM_EXP_IMPS;

Dependencies

[top of page]

HR.HR_DM_EXP_IMPS does not reference any database object

HR.HR_DM_EXP_IMPS is referenced by following:

HR: HR_DM_EXP_IMPS#