VIEW: APPS.HR_DM_MIGRATION_REQUESTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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