[Home] [Help]
View: 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
Name |
MIGRATION_REQUEST_ID |
MIGRATION_ID |
PHASE_ID |
PHASE_ITEM_ID |
REQUEST_ID |
ENABLED_FLAG |
MASTER_SLAVE |
MASTER_SLAVE_MEANING |
START_DATE |
END_DATE |
STATUS |
STATUS_MEANING |
PROGRAM_NAME |
MIGRATION_CODE |