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]

VIEW: APPS.HR_DM_PHASE_ITEMS_V

Object Details

Object Name:	HR_DM_PHASE_ITEMS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HR_DM_PHASE_ITEMS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PHASE_ITEM_ID	NUMBER	(15)	Yes	column from hr_dm_phase_items
PHASE_ID	NUMBER	(15)	Yes	column from hr_dm_phase_items
LOADER_NAME	VARCHAR2	(30)		lookup based on column from hr_dm_phase_items
BATCH_ID	NUMBER	(15)		column from hr_dm_phase_items
BATCH_NAME	VARCHAR2	(80)		lookup based on column from hr_dm_phase_items
GROUP_ID	NUMBER	(15)		column from hr_dm_phase_items
GROUP_DESCRIPTION	VARCHAR2	(240)		lookup based on column from hr_dm_phase_items
TABLE_NAME	VARCHAR2	(30)		column from hr_dm_phase_items
STATUS	VARCHAR2	(30)	Yes	column from hr_dm_phase_items
STATUS_MEANING	VARCHAR2	(4000)		lookup based on column from hr_dm_phase_items
START_TIME	DATE			column from hr_dm_phase_items
END_TIME	DATE			column from hr_dm_phase_items
LAST_UPDATE_DATE	DATE			column from hr_dm_phase_items
LAST_UPDATED_BY	NUMBER	(15)		column from hr_dm_phase_items
LAST_UPDATE_LOGIN	NUMBER	(15)		column from hr_dm_phase_items
CREATED_BY	NUMBER	(15)		column from hr_dm_phase_items
CREATION_DATE	DATE			column from hr_dm_phase_items
TABLE_DESCRIPTION	VARCHAR2	(240)		lookup based on column from hr_dm_phase_items
LOADER_DESCRIPTION	VARCHAR2	(30)		lookup based on column from hr_dm_phase_items

Query Text

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


SELECT PHASE_ITEM_ID
,      PHASE_ID
,      LOADER_NAME
,      BATCH_ID
,      BATCH_NAME
,      GROUP_ID
,      GROUP_DESCRIPTION
,      TABLE_NAME
,      STATUS
,      STATUS_MEANING
,      START_TIME
,      END_TIME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      TABLE_DESCRIPTION
,      LOADER_DESCRIPTION
FROM APPS.HR_DM_PHASE_ITEMS_V;

Dependencies

[top of page]

APPS.HR_DM_PHASE_ITEMS_V references the following:

APPS: HR_DM_GROUPS; HR_DM_PHASE_ITEMS; HR_DM_TABLES; HR_GENERAL - show dependent code; HR_PUMP_BATCH_HEADERS

APPS.HR_DM_PHASE_ITEMS_V is referenced by following:

PUBLIC: HR_DM_PHASE_ITEMS_V