View: EDW_PROJECT_MPV

Product:	FII - Financial Intelligence
Description:	EDW_PROJECT_MPV is the view for data validity on source side.
Implementation/DBA Data:	APPS.EDW_PROJECT_MPV

View Text

SELECT PT.TASK_ID || '-' || INS.INSTANCE_CODE
, PT.LAST_UPDATE_DATE
FROM PA_TASKS PT
, PA_PROJECTS_ALL PA
, EDW_LOCAL_INSTANCE INS
WHERE PA.PROJECT_ID = PT.PROJECT_ID
AND ( NOT EXISTS ( SELECT '*'
FROM PA_TASKS
WHERE PARENT_TASK_ID = PT.TASK_ID ) OR PT.PARENT_TASK_ID IS NULL ) UNION ALL SELECT PA.PROJECT_ID || '-' || INS.INSTANCE_CODE || '-PJ-PRJ'
, PA.LAST_UPDATE_DATE
FROM PA_PROJECTS_ALL PA
, EDW_LOCAL_INSTANCE INS UNION ALL /* SEIBAN NUMBERS */ SELECT SB.PROJECT_ID || '-' || ELI.INSTANCE_CODE || '-PJ-PRJ'
, SB.LAST_UPDATE_DATE
FROM PJM_SEIBAN_NUMBERS SB
, EDW_LOCAL_INSTANCE ELI

Columns