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_LOADER_PHASE_ITEMS

Object Details

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

This entity contains the migration specific configuration data for the AOL loader files.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Primary Key: HR_DM_LOADER_PHASE_ITEMS_PK

LOADER_PHASE_ITEM_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_DM_LOADER_PHASE_ITEMS_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	LOADER_PHASE_ITEM_ID
HR_DM_LOADER_PHASE_ITEMS_FK1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	DA_PHASE_ITEM_ID
HR_DM_LOADER_PHASE_ITEMS_FK2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	UA_PHASE_ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LOADER_PHASE_ITEM_ID	NUMBER	(15)	Yes	System-generated primary key column.
DA_PHASE_ITEM_ID	NUMBER	(15)	Yes	Phase_item_id of the DA phase
UA_PHASE_ITEM_ID	NUMBER	(15)	Yes	Phase_item_id of the UA phase
LOADER_NAME	VARCHAR2	(30)	Yes	The description of the loader used for migration of AOL data.
LOADER_CONC_PROGRAM	VARCHAR2	(30)	Yes	The name of the loader concurrent program
LOADER_CONFIG_FILE	VARCHAR2	(30)	Yes	The name of the loader configuration file used for migration of AOL data.
LOADER_APPLICATION	VARCHAR2	(50)	Yes	The application short name for the loader used for migration of AOL data.
APPLICATION_ID	NUMBER	(15)	Yes	The application_id from the table FND_APPLICATION.
FILENAME	VARCHAR2	(30)		The filename used for the downloaded data file
PARAMETER_1	VARCHAR2	(100)		The parameter name / value pairs as required for the specified configuration file.
PARAMETER_2	VARCHAR2	(100)		The parameter name / value pairs as required for the specified configuration file.
PARAMETER_3	VARCHAR2	(100)		The parameter name / value pairs as required for the specified configuration file.
PARAMETER_4	VARCHAR2	(100)		The parameter name / value pairs as required for the specified configuration file.
PARAMETER_5	VARCHAR2	(100)		The parameter name / value pairs as required for the specified configuration file.
PARAMETER_6	VARCHAR2	(100)		The parameter name / value pairs as required for the specified configuration file.
PARAMETER_7	VARCHAR2	(100)		The parameter name / value pairs as required for the specified configuration file.
PARAMETER_8	VARCHAR2	(100)		The parameter name / value pairs as required for the specified configuration file.
PARAMETER_9	VARCHAR2	(100)		The parameter name / value pairs as required for the specified configuration file.
PARAMETER_10	VARCHAR2	(100)		The parameter name / value pairs as required for the specified configuration file.
CUSTOM_CODE_SPECIFIED	VARCHAR2	(1)	Yes	Y indicates that custom code specified that the flexfield be downloaded.
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 LOADER_PHASE_ITEM_ID
,      DA_PHASE_ITEM_ID
,      UA_PHASE_ITEM_ID
,      LOADER_NAME
,      LOADER_CONC_PROGRAM
,      LOADER_CONFIG_FILE
,      LOADER_APPLICATION
,      APPLICATION_ID
,      FILENAME
,      PARAMETER_1
,      PARAMETER_2
,      PARAMETER_3
,      PARAMETER_4
,      PARAMETER_5
,      PARAMETER_6
,      PARAMETER_7
,      PARAMETER_8
,      PARAMETER_9
,      PARAMETER_10
,      CUSTOM_CODE_SPECIFIED
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      SECURITY_GROUP_ID
FROM HR.HR_DM_LOADER_PHASE_ITEMS;

Dependencies

[top of page]

HR.HR_DM_LOADER_PHASE_ITEMS does not reference any database object

HR.HR_DM_LOADER_PHASE_ITEMS is referenced by following:

APPS: HR_DM_LOADER_PHASE_ITEMS; HR_DM_LOADER_PHASE_ITEMS_WHO
PUBLIC: HR_DM_LOADER_PHASE_ITEMS