View: HR_DM_MIGRATION_SUMMARY_V

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

View Text

SELECT PHASE_ID
, (SELECT COUNT(*)
FROM HR_DM_PHASE_ITEMS PI
WHERE PI.STATUS ='C'
AND PI.PHASE_ID = PH.PHASE_ID) PI_C
, (SELECT COUNT(*)
FROM HR_DM_PHASE_ITEMS PI
WHERE PI.STATUS ='NS'
AND PI.PHASE_ID = PH.PHASE_ID) PI_NS
, (SELECT COUNT(*)
FROM HR_DM_PHASE_ITEMS PI
WHERE PI.STATUS ='S'
AND PI.PHASE_ID = PH.PHASE_ID) PI_S
, (SELECT COUNT(*)
FROM HR_DM_PHASE_ITEMS PI
WHERE PI.STATUS ='E'
AND PI.PHASE_ID = PH.PHASE_ID) PI_E
, (SELECT COUNT(*)
FROM HR_DM_MIGRATION_RANGES MR
, HR_DM_PHASE_ITEMS PI2
WHERE MR.STATUS ='C'
AND MR.PHASE_ITEM_ID = PI2.PHASE_ITEM_ID
AND PI2.PHASE_ID = (SELECT PH2.PHASE_ID
FROM HR_DM_PHASES PH2
WHERE PH2.PHASE_NAME = 'R'
AND PH2.MIGRATION_ID = PH.MIGRATION_ID)
AND PH.PHASE_NAME IN ('DP'
, 'UP'
, 'D')) RNG_C
, (SELECT COUNT(*)
FROM HR_DM_MIGRATION_RANGES MR
, HR_DM_PHASE_ITEMS PI2
WHERE MR.STATUS ='NS'
AND MR.PHASE_ITEM_ID = PI2.PHASE_ITEM_ID
AND PI2.PHASE_ID = (SELECT PH2.PHASE_ID
FROM HR_DM_PHASES PH2
WHERE PH2.PHASE_NAME = 'R'
AND PH2.MIGRATION_ID = PH.MIGRATION_ID)
AND PH.PHASE_NAME IN ('DP'
, 'UP'
, 'D')) RNG_NS
, (SELECT COUNT(*)
FROM HR_DM_MIGRATION_RANGES MR
, HR_DM_PHASE_ITEMS PI2
WHERE MR.STATUS ='S'
AND MR.PHASE_ITEM_ID = PI2.PHASE_ITEM_ID
AND PI2.PHASE_ID = (SELECT PH2.PHASE_ID
FROM HR_DM_PHASES PH2
WHERE PH2.PHASE_NAME = 'R'
AND PH2.MIGRATION_ID = PH.MIGRATION_ID)
AND PH.PHASE_NAME IN ('DP'
, 'UP'
, 'D')) RNG_S
, (SELECT COUNT(*)
FROM HR_DM_MIGRATION_RANGES MR
, HR_DM_PHASE_ITEMS PI2
WHERE MR.STATUS ='E'
AND MR.PHASE_ITEM_ID = PI2.PHASE_ITEM_ID
AND PI2.PHASE_ID = (SELECT PH2.PHASE_ID
FROM HR_DM_PHASES PH2
WHERE PH2.PHASE_NAME = 'R'
AND PH2.MIGRATION_ID = PH.MIGRATION_ID)
AND PH.PHASE_NAME IN ('DP'
, 'UP'
, 'D')) RNG_E
, (SELECT COUNT(*)
FROM HR_DM_MIGRATION_REQUESTS REQ
, FND_CONCURRENT_REQUESTS CR
WHERE CR.STATUS_CODE ='C'
AND CR.REQUEST_ID = REQ.REQUEST_ID
AND REQ.PHASE_ID = PH.PHASE_ID
AND REQ.ENABLED_FLAG = 'Y'
AND REQ.PHASE_ID IS NOT NULL) REQ_C
, (SELECT COUNT(*)
FROM HR_DM_MIGRATION_REQUESTS REQ
, FND_CONCURRENT_REQUESTS CR
WHERE CR.STATUS_CODE IN ('P'
, 'Q')
AND CR.REQUEST_ID = REQ.REQUEST_ID
AND REQ.PHASE_ID = PH.PHASE_ID
AND REQ.ENABLED_FLAG = 'Y'
AND REQ.PHASE_ID IS NOT NULL) REQ_NS
, (SELECT COUNT(*)
FROM HR_DM_MIGRATION_REQUESTS REQ
, FND_CONCURRENT_REQUESTS CR
WHERE CR.STATUS_CODE IN ('R'
, 'I')
AND CR.REQUEST_ID = REQ.REQUEST_ID
AND REQ.PHASE_ID = PH.PHASE_ID
AND REQ.ENABLED_FLAG = 'Y'
AND REQ.PHASE_ID IS NOT NULL) REQ_S
, (SELECT COUNT(*)
FROM HR_DM_MIGRATION_REQUESTS REQ
, FND_CONCURRENT_REQUESTS CR
WHERE CR.STATUS_CODE IN ('E'
, 'D'
, 'U'
, 'M'
, 'X'
, 'T')
AND CR.REQUEST_ID = REQ.REQUEST_ID
AND REQ.PHASE_ID = PH.PHASE_ID
AND REQ.ENABLED_FLAG = 'Y'
AND REQ.PHASE_ID IS NOT NULL) REQ_E
FROM HR_DM_PHASES PH

Columns