VIEW: APPS.EDW_PROJECT_MPV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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