DBA Data[Home] [Help]

VIEW: APPS.HR_DM_EXP_MIGRATIONS_V

Source

View Text - Preformatted

SELECT exp_imp_id, table_name, pval001 MIGRATION_ID, pval002 SOURCE_DATABASE_INSTANCE, pval003 DESTINATION_DATABASE_INSTANCE, pval004 MIGRATION_TYPE, pval005 APPLICATION_ID, pval006 BUSINESS_GROUP_ID , pval007 MIGRATION_START_DATE , pval008 MIGRATION_END_DATE, pval009 STATUS, pval010 EFFECTIVE_DATE, pval011 MIGRATION_COUNT , pval012 SELECTIVE_MIGRATION_CRITERIA, pval013 ACTIVE_GROUP, pval014 LAST_UPDATE_DATE, pval015 LAST_UPDATED_BY , pval016 LAST_UPDATE_LOGIN , pval017 CREATION_DATE , pval018 CREATED_BY, pval019 BUSINESS_GROUP_NAME from hr_dm_exp_imps WHERE table_name = 'HR_DM_MIGRATIONS'
View Text - HTML Formatted

SELECT EXP_IMP_ID
, TABLE_NAME
, PVAL001 MIGRATION_ID
, PVAL002 SOURCE_DATABASE_INSTANCE
, PVAL003 DESTINATION_DATABASE_INSTANCE
, PVAL004 MIGRATION_TYPE
, PVAL005 APPLICATION_ID
, PVAL006 BUSINESS_GROUP_ID
, PVAL007 MIGRATION_START_DATE
, PVAL008 MIGRATION_END_DATE
, PVAL009 STATUS
, PVAL010 EFFECTIVE_DATE
, PVAL011 MIGRATION_COUNT
, PVAL012 SELECTIVE_MIGRATION_CRITERIA
, PVAL013 ACTIVE_GROUP
, PVAL014 LAST_UPDATE_DATE
, PVAL015 LAST_UPDATED_BY
, PVAL016 LAST_UPDATE_LOGIN
, PVAL017 CREATION_DATE
, PVAL018 CREATED_BY
, PVAL019 BUSINESS_GROUP_NAME
FROM HR_DM_EXP_IMPS
WHERE TABLE_NAME = 'HR_DM_MIGRATIONS'