View: HR_DM_MIGRATIONS_V

Product:	PER - Human Resources
Description:	View to support DM UI - hr_dm_migrations
Implementation/DBA Data:	APPS.HR_DM_MIGRATIONS_V

View Text

SELECT H1.MIGRATION_ID
, H1.SOURCE_DATABASE_INSTANCE
, H1.DESTINATION_DATABASE_INSTANCE
, H1.MIGRATION_TYPE
, H1.BUSINESS_GROUP_ID
, H1.BUSINESS_GROUP_NAME
, H1.MIGRATION_START_DATE
, H1.MIGRATION_END_DATE
, H1.STATUS
, H1.MIGRATION_PROCESS
, H1.EFFECTIVE_DATE
, H1.MIGRATION_COUNT
, H1.SELECTIVE_MIGRATION_CRITERIA
, H1.APPLICATION_ID
, F1.APPLICATION_NAME
, H1.LAST_UPDATED_BY
, H1.LAST_UPDATE_DATE
, H1.LAST_UPDATE_LOGIN
, H1.CREATION_DATE
, H1.CREATED_BY
, HR_GENERAL.DECODE_LOOKUP('HR_DM_MIGRATION_STATUS'
, H1.STATUS) STATUS_MEANING
, HR_GENERAL.DECODE_LOOKUP('HR_DM_MIGRATION_TYPE'
, H1.MIGRATION_TYPE) MIGRATION_TYPE_MEANING
, H2.REQUEST_ID
FROM HR_DM_MIGRATIONS H1
, HR_DM_MIGRATION_REQUESTS H2
, FND_APPLICATION_VL F1
WHERE (H1.MIGRATION_ID = H2.MIGRATION_ID (+)
AND H2.MASTER_SLAVE (+) = 'M')
AND (H1.APPLICATION_ID = F1.APPLICATION_ID)
AND (H2.REQUEST_ID = ( SELECT MAX(REQUEST_ID)
FROM HR_DM_MIGRATION_REQUESTS H3
WHERE H3.MIGRATION_ID = H2.MIGRATION_ID
AND H3.MASTER_SLAVE = 'M') OR H2.MIGRATION_ID IS NULL)

Columns