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

VIEW: HR.HR_DM_MIGRATIONS#

Object Details
Object Name: HR_DM_MIGRATIONS#
Object Type: VIEW
Owner: HR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
MIGRATION_ID NUMBER (15) Yes
SOURCE_DATABASE_INSTANCE VARCHAR2 (30) Yes
DESTINATION_DATABASE_INSTANCE VARCHAR2 (30) Yes
MIGRATION_TYPE VARCHAR2 (30) Yes
APPLICATION_ID NUMBER (15) Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
BUSINESS_GROUP_NAME VARCHAR2 (240)
BUSINESS_GROUP_CREATED VARCHAR2 (1)
MIGRATION_START_DATE DATE

MIGRATION_END_DATE DATE

STATUS VARCHAR2 (30) Yes
MIGRATION_PROCESS VARCHAR2 (60)
EFFECTIVE_DATE DATE

MIGRATION_COUNT NUMBER (15)
SELECTIVE_MIGRATION_CRITERIA VARCHAR2 (2000)
ACTIVE_GROUP NUMBER (15)
LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
SECURITY_GROUP_ID NUMBER (15)
Query Text

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


SELECT MIGRATION_ID
,      SOURCE_DATABASE_INSTANCE
,      DESTINATION_DATABASE_INSTANCE
,      MIGRATION_TYPE
,      APPLICATION_ID
,      BUSINESS_GROUP_ID
,      BUSINESS_GROUP_NAME
,      BUSINESS_GROUP_CREATED
,      MIGRATION_START_DATE
,      MIGRATION_END_DATE
,      STATUS
,      MIGRATION_PROCESS
,      EFFECTIVE_DATE
,      MIGRATION_COUNT
,      SELECTIVE_MIGRATION_CRITERIA
,      ACTIVE_GROUP
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      SECURITY_GROUP_ID
FROM HR.HR_DM_MIGRATIONS#;

Dependencies

[top of page]

HR.HR_DM_MIGRATIONS# references the following:

SchemaHR
TableHR_DM_MIGRATIONS
HR.HR_DM_MIGRATIONS# is referenced by following:

SchemaAPPS
SynonymHR_DM_MIGRATIONS
TriggerHR_DM_MIGRATIONS_WHO