[Home] [Help]
View: HR_DM_PHASES_V
Product: | PER - Human Resources |
Description: | View to support DM UI - hr_dm_phases |
Implementation/DBA Data: |
APPS.HR_DM_PHASES_V
|
View Text
SELECT H1.PHASE_ID
, H1.MIGRATION_ID
, H1.PHASE_NAME
, HR_GENERAL.DECODE_LOOKUP('HR_DM_MIGRATION_PHASE'
, H1.PHASE_NAME) PHASE_NAME_MEANING
, H1.STATUS
, H1.START_TIME
, H1.END_TIME
, H1.LAST_UPDATED_BY
, H1.LAST_UPDATE_LOGIN
, H1.CREATED_BY
, H1.CREATION_DATE
, H1.LAST_UPDATE_DATE
, HR_GENERAL.DECODE_LOOKUP('HR_DM_STATUS'
, H1.STATUS) STATUS_MEANING
FROM HR_DM_PHASES H1
Columns
Name |
PHASE_ID |
MIGRATION_ID |
PHASE_NAME |
PHASE_NAME_MEANING |
STATUS |
START_TIME |
END_TIME |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |
LAST_UPDATE_DATE |
STATUS_MEANING |