[Home] [Help]
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
Name |
RANGE_ID |
PHASE_ITEM_ID |
STARTING_PROCESS_SEQUENCE |
ENDING_PROCESS_SEQUENCE |
STATUS |
BATCH_ID |
TABLE_NAME |
START_TIME |
END_TIME |
ROW_COUNT |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |
STATUS_MEANING |