VIEW: APPS.FIIBV_PROJ_TASK_LCV

Source

View Text - Preformatted

SELECT pt.task_id || '-' || ins.instance_code, pt.task_name || ', ' || pa.segment1 , pt.task_name, pt.task_number, pt.top_task_id || '-' || ins.instance_code, ins.instance_code, pt.start_date, pt.completion_date, pt.service_type_code, decode(pt.task_id,pt.top_task_id,'',pt.LABOR_COST_MULTIPLIER_NAME), pt.carrying_out_organization_id || '-' || ins.instance_code, pt.last_update_date, '_DF:PA:PA_TASKS_DESC_FLEX:pt' 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.segment1, pa.name, pa.segment1, pa.project_id || '-' || ins.instance_code || '-PJ-PRJ', ins.instance_code, to_date( null ), to_date( null ), to_char( null ), to_char( null ), pa.carrying_out_organization_id || '-' || ins.instance_code, pa.last_update_date, '_DF:_DUMMY:PA:PA_TASKS_DESC_FLEX:pt' from pa_projects_all pa, edw_local_instance ins UNION ALL /* Seiban Numbers */ 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-PRJ', eli.instance_code, to_date( null ), to_date( null ), to_char( null ), to_char( null ), 'NA_EDW', sb.last_update_date, '_DF:_DUMMY:PA:PA_TASKS_DESC_FLEX:pt' from pjm_seiban_numbers sb, edw_local_instance eli

View Text - HTML Formatted

SELECT PT.TASK_ID || '-' || INS.INSTANCE_CODE
, PT.TASK_NAME || '
, ' || PA.SEGMENT1
, PT.TASK_NAME
, PT.TASK_NUMBER
, PT.TOP_TASK_ID || '-' || INS.INSTANCE_CODE
, INS.INSTANCE_CODE
, PT.START_DATE
, PT.COMPLETION_DATE
, PT.SERVICE_TYPE_CODE
, DECODE(PT.TASK_ID
, PT.TOP_TASK_ID
, ''
, PT.LABOR_COST_MULTIPLIER_NAME)
, PT.CARRYING_OUT_ORGANIZATION_ID || '-' || INS.INSTANCE_CODE
, PT.LAST_UPDATE_DATE
, '_DF:PA:PA_TASKS_DESC_FLEX:PT'
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.SEGMENT1
, PA.NAME
, PA.SEGMENT1
, PA.PROJECT_ID || '-' || INS.INSTANCE_CODE || '-PJ-PRJ'
, INS.INSTANCE_CODE
, TO_DATE( NULL )
, TO_DATE( NULL )
, TO_CHAR( NULL )
, TO_CHAR( NULL )
, PA.CARRYING_OUT_ORGANIZATION_ID || '-' || INS.INSTANCE_CODE
, PA.LAST_UPDATE_DATE
, '_DF:_DUMMY:PA:PA_TASKS_DESC_FLEX:PT'
FROM PA_PROJECTS_ALL PA
, EDW_LOCAL_INSTANCE INS UNION ALL /* SEIBAN NUMBERS */ 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-PRJ'
, ELI.INSTANCE_CODE
, TO_DATE( NULL )
, TO_DATE( NULL )
, TO_CHAR( NULL )
, TO_CHAR( NULL )
, 'NA_EDW'
, SB.LAST_UPDATE_DATE
, '_DF:_DUMMY:PA:PA_TASKS_DESC_FLEX:PT'
FROM PJM_SEIBAN_NUMBERS SB
, EDW_LOCAL_INSTANCE ELI