DBA Data[Home] [Help]

VIEW: APPS.HR_DM_PHASES_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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