VIEW: APPS.FIIBV_PROJ_TOP_TASK_LCV

Source

View Text - Preformatted

SELECT t.task_id || '-' || eli.instance_code, t.task_name || ', ' || pa.segment1, t.task_name, t.task_number, t.project_id || '-' || eli.instance_code || '-' || 'PJ', eli.instance_code, t.start_date, t.completion_date, t.service_type_code, t.LABOR_COST_MULTIPLIER_NAME, t.last_update_date, '_DF:PA:PA_TASKS_DESC_FLEX:t' from pa_tasks t, pa_projects_all pa, edw_local_instance eli WHERE t.task_id = t.top_task_id and t.project_id = pa.project_id UNION ALL select pa.project_id || '-' || eli.instance_code || '-PJ-PRJ', pa.segment1, pa.name, pa.segment1, pa.project_id || '-' || eli.instance_code || '-PJ', eli.instance_code, to_date( null ), to_date( null ), to_char( null ), to_char( null ), pa.last_update_date, '_DF:_DUMMY:PA:PA_TASKS_DESC_FLEX:t' from pa_projects_all pa, edw_local_instance eli UNION ALL select sb.project_id || '-' || eli.instance_code || '-PJ-PRJ', sb.project_number, sb.project_name, sb.project_number, sb.project_id || '-' || eli.instance_code || '-PJ', eli.instance_code, to_date( null ), to_date( null ), to_char( null ), to_char( null ), sb.last_update_date, '_DF:_DUMMY:PA:PA_TASKS_DESC_FLEX:t' from pjm_seiban_numbers sb, edw_local_instance eli

View Text - HTML Formatted

SELECT T.TASK_ID || '-' || ELI.INSTANCE_CODE
, T.TASK_NAME || '
, ' || PA.SEGMENT1
, T.TASK_NAME
, T.TASK_NUMBER
, T.PROJECT_ID || '-' || ELI.INSTANCE_CODE || '-' || 'PJ'
, ELI.INSTANCE_CODE
, T.START_DATE
, T.COMPLETION_DATE
, T.SERVICE_TYPE_CODE
, T.LABOR_COST_MULTIPLIER_NAME
, T.LAST_UPDATE_DATE
, '_DF:PA:PA_TASKS_DESC_FLEX:T'
FROM PA_TASKS T
, PA_PROJECTS_ALL PA
, EDW_LOCAL_INSTANCE ELI
WHERE T.TASK_ID = T.TOP_TASK_ID
AND T.PROJECT_ID = PA.PROJECT_ID UNION ALL SELECT PA.PROJECT_ID || '-' || ELI.INSTANCE_CODE || '-PJ-PRJ'
, PA.SEGMENT1
, PA.NAME
, PA.SEGMENT1
, PA.PROJECT_ID || '-' || ELI.INSTANCE_CODE || '-PJ'
, ELI.INSTANCE_CODE
, TO_DATE( NULL )
, TO_DATE( NULL )
, TO_CHAR( NULL )
, TO_CHAR( NULL )
, PA.LAST_UPDATE_DATE
, '_DF:_DUMMY:PA:PA_TASKS_DESC_FLEX:T'
FROM PA_PROJECTS_ALL PA
, EDW_LOCAL_INSTANCE ELI UNION ALL SELECT SB.PROJECT_ID || '-' || ELI.INSTANCE_CODE || '-PJ-PRJ'
, SB.PROJECT_NUMBER
, SB.PROJECT_NAME
, SB.PROJECT_NUMBER
, SB.PROJECT_ID || '-' || ELI.INSTANCE_CODE || '-PJ'
, ELI.INSTANCE_CODE
, TO_DATE( NULL )
, TO_DATE( NULL )
, TO_CHAR( NULL )
, TO_CHAR( NULL )
, SB.LAST_UPDATE_DATE
, '_DF:_DUMMY:PA:PA_TASKS_DESC_FLEX:T'
FROM PJM_SEIBAN_NUMBERS SB
, EDW_LOCAL_INSTANCE ELI