DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.HR_DM_MIGRATION_SUMMARY_V

Object Details
Object Name: HR_DM_MIGRATION_SUMMARY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HR_DM_MIGRATION_SUMMARY_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_ID NUMBER (15) Yes column from hr_dm_phase_items
PI_C NUMBER

calculation based on column from hr_dm_phase_items
PI_NS NUMBER

calculation based on column from hr_dm_phase_items
PI_S NUMBER

calculation based on column from hr_dm_phase_items
PI_E NUMBER

calculation based on column from hr_dm_phase_items
RNG_C NUMBER

calculation based on column from hr_dm_migration_ranges
RNG_NS NUMBER

calculation based on column from hr_dm_migration_ranges
RNG_S NUMBER

calculation based on column from hr_dm_migration_ranges
RNG_E NUMBER

calculation based on column from hr_dm_migration_ranges
REQ_C NUMBER

calculation based on column from hr_dm_migration_requests
REQ_NS NUMBER

calculation based on column from hr_dm_migration_requests
REQ_S NUMBER

calculation based on column from hr_dm_migration_requests
REQ_E NUMBER

calculation based on column from hr_dm_migration_requests
Query Text

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


SELECT PHASE_ID
,      PI_C
,      PI_NS
,      PI_S
,      PI_E
,      RNG_C
,      RNG_NS
,      RNG_S
,      RNG_E
,      REQ_C
,      REQ_NS
,      REQ_S
,      REQ_E
FROM APPS.HR_DM_MIGRATION_SUMMARY_V;

Dependencies

[top of page]

APPS.HR_DM_MIGRATION_SUMMARY_V references the following:

SchemaAPPS
SynonymFND_CONCURRENT_REQUESTS
SynonymHR_DM_MIGRATION_RANGES
SynonymHR_DM_MIGRATION_REQUESTS
SynonymHR_DM_PHASES
SynonymHR_DM_PHASE_ITEMS

APPS.HR_DM_MIGRATION_SUMMARY_V is not referenced by any database object