View: HR_DM_MIGRATION_REQUESTS_V

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

View Text

SELECT H1.MIGRATION_REQUEST_ID
, H1.MIGRATION_ID
, H1.PHASE_ID
, H1.PHASE_ITEM_ID
, H1.REQUEST_ID
, H1.ENABLED_FLAG
, H1.MASTER_SLAVE
, DECODE(H1.MASTER_SLAVE
, 'M'
, 'MASTER'
, 'S'
, 'SLAVE') MASTER_SLAVE_MEANING
, F1.ACTUAL_START_DATE START_DATE
, F1.ACTUAL_COMPLETION_DATE END_DATE
, F1.STATUS_CODE STATUS
, LV1.MEANING || ' (' || LV2.MEANING || ')' STATUS_MEANING
, F3.DESCRIPTION PROGRAM_NAME
, F1.PHASE_CODE
FROM HR_DM_MIGRATION_REQUESTS H1
, FND_CONCURRENT_REQUESTS F1
, FND_CONCURRENT_PROGRAMS F2
, FND_CONCURRENT_PROGRAMS_VL F3
, FND_LOOKUP_VALUES_VL LV1
, FND_LOOKUP_VALUES_VL LV2
WHERE H1.REQUEST_ID = F1.REQUEST_ID
AND F1.CONCURRENT_PROGRAM_ID = F2.CONCURRENT_PROGRAM_ID
AND H1.PHASE_ID IS NOT NULL
AND F2.CONCURRENT_PROGRAM_ID = F3.CONCURRENT_PROGRAM_ID
AND LV1.LOOKUP_TYPE = 'CP_PHASE_CODE'
AND LV1.LOOKUP_CODE = F1.PHASE_CODE
AND LV2.LOOKUP_TYPE = 'CP_STATUS_CODE'
AND LV2.LOOKUP_CODE = F1.STATUS_CODE

Columns