VIEW: APPS.HR_DM_MIGRATIONS_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)