VIEW: APPS.HR_DM_MIGRATION_RANGES_V

Source

View Text - Preformatted

SELECT h1.range_id ,h1.phase_item_id ,h1.starting_process_sequence ,h1.ending_process_sequence ,h1.status ,h2.batch_id ,h2.table_name ,h1.start_time ,h1.end_time ,h1.row_count ,h1.last_update_date ,h1.last_updated_by ,h1.last_update_login ,h1.created_by ,h1.creation_date ,hr_general.decode_lookup('HR_DM_STATUS', h1.status) status_meaning FROM hr_dm_migration_ranges h1 ,hr_dm_phase_items h2 WHERE h1.phase_item_id = h2.phase_item_id

View Text - HTML Formatted

SELECT H1.RANGE_ID
, H1.PHASE_ITEM_ID
, H1.STARTING_PROCESS_SEQUENCE
, H1.ENDING_PROCESS_SEQUENCE
, H1.STATUS
, H2.BATCH_ID
, H2.TABLE_NAME
, H1.START_TIME
, H1.END_TIME
, H1.ROW_COUNT
, H1.LAST_UPDATE_DATE
, H1.LAST_UPDATED_BY
, H1.LAST_UPDATE_LOGIN
, H1.CREATED_BY
, H1.CREATION_DATE
, HR_GENERAL.DECODE_LOOKUP('HR_DM_STATUS'
, H1.STATUS) STATUS_MEANING
FROM HR_DM_MIGRATION_RANGES H1
, HR_DM_PHASE_ITEMS H2
WHERE H1.PHASE_ITEM_ID = H2.PHASE_ITEM_ID