View: HR_DM_MIGRATION_RANGES_V

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

View Text

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

Columns