[Home] [Help]
[Dependency Information]
| Object Name: | HR_DM_MIGRATION_SUMMARY_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | PER.HR_DM_MIGRATION_SUMMARY_V
|
| Subobject Name: | |
| Status: | VALID |
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.
| 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 |
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;
APPS
FND_CONCURRENT_REQUESTS
HR_DM_MIGRATION_RANGES
HR_DM_MIGRATION_REQUESTS
HR_DM_PHASES
HR_DM_PHASE_ITEMS
PUBLIC
HR_DM_MIGRATION_SUMMARY_V
|
|
|
|