View HLPDTEST.STATEGPS.T_REPORTING_PLAN_TASKS_V Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
TASK_ID number 22  √  null
T_REPORTING_PLAN_TASKS.TASK_ID Implied Constraint R
HISTORY_ID number 22  √  null
T_GPS_WF_INSTANCE_HISTORY.HISTORY_ID Implied Constraint R
JS_GANTT_CHART_TASK varchar2 4000  √  null
TASK_ORDER number 22  √  null
TASK_TYPE varchar2 50  √  null
WORKFLOW_ID number 22  √  null
MODULE varchar2 4000  √  null
TAG varchar2 4000  √  null
TOTAL_TASKS number 22  √  null
TASKS_COMPLETED number 22  √  null
START_DATE date 7  √  null
FINISH_DATE date 7  √  null
TAG_TYPE varchar2 255  √  null

Analyzed at Wed Dec 08 01:06 IST 2021

View Definition:
SELECT T_REPORTING_PLAN_TASKS.TASK_ID, T_REPORTING_PLAN_TASKS.HISTORY_ID, T_REPORTING_PLAN_TASKS.JS_GANTT_CHART_TASK, T_REPORTING_PLAN_TASKS.TASK_ORDER, T_REPORTING_PLAN_TASKS.TASK_TYPE, CASE WHEN T_REPORTING_PLAN_TASKS.WORKFLOW_ID IS NULL AND TASK_ORDER = 0 THEN - 1 ELSE T_REPORTING_PLAN_TASKS.WORKFLOW_ID END, T_REPORTING_PLAN_TASKS.MODULE, T_REPORTING_PLAN_TASKS.TAG, TOTAL_TASKS, TASKS_COMPLETED, TRUNC(T_REPORTING_PLAN_TASKS.START_DATE)START_DATE, CASE WHEN T_REPORTING_PLAN_TASKS.WORKFLOW_ID IS NULL AND TASK_ORDER = 0 THEN CASE WHEN T_REPORTING_PLAN_HISTORY.PROJECT_BUFFER_END_DATE IS NOT NULL AND T_REPORTING_PLAN_HISTORY.PROJECT_BUFFER_END_DATE > T_REPORTING_PLAN_TASKS.END_DATE THEN TRUNC(T_REPORTING_PLAN_HISTORY.PROJECT_BUFFER_END_DATE) ELSE TRUNC(T_REPORTING_PLAN_TASKS.END_DATE) END WHEN T_REPORTING_PLAN_TASKS.WORKFLOW_ID IS NOT NULL AND T_REPORTING_PLAN_TASKS.MODULE IS NULL AND T_REPORTING_PLAN_TASKS.TAG IS NULL THEN CASE WHEN T_REPORTING_PLAN_TASKS.END_DATE <= (SELECT MAX(TD.END_DATE) FROM T_REPORTING_PLAN_TASK_DETAILS TD WHERE TD.EXECUTION_ID = T_REPORTING_PLAN_TASKS.HISTORY_ID AND TD.WORKFLOW_ID = T_REPORTING_PLAN_TASKS.WORKFLOW_ID AND TD.MODULE IS NULL AND TD.TAG IS NULL) THEN (SELECT TRUNC(MAX(TD.END_DATE)) FROM T_REPORTING_PLAN_TASK_DETAILS TD WHERE TD.EXECUTION_ID = T_REPORTING_PLAN_TASKS.HISTORY_ID AND TD.WORKFLOW_ID = T_REPORTING_PLAN_TASKS.WORKFLOW_ID AND TD.MODULE IS NULL AND TD.TAG IS NULL) WHEN T_REPORTING_PLAN_TASKS.END_DATE < ( SELECT MAX(TO_DATE(PROPERTY_VALUE,'DD/MM/YYYY')) FROM T_GPS_WFT_PROPERTIES WHERE PROPERTY_NAME = 'wfFinishDate' AND WORKFLOW_TYPE_ID = T_REPORTING_PLAN_TASKS.WORKFLOW_ID )THEN ( SELECT MAX(TO_DATE(PROPERTY_VALUE,'DD/MM/YYYY')) FROM T_GPS_WFT_PROPERTIES WHERE PROPERTY_NAME = 'wfFinishDate' AND WORKFLOW_TYPE_ID = T_REPORTING_PLAN_TASKS.WORKFLOW_ID ) ELSE TRUNC(T_REPORTING_PLAN_TASKS.END_DATE) END ELSE TRUNC(T_REPORTING_PLAN_TASKS.END_DATE) END FINISH_DATE, 'Task' FROM STATEGPS.T_REPORTING_PLAN_HISTORY T_REPORTING_PLAN_HISTORY, STATEGPS.T_REPORTING_PLAN_TASKS T_REPORTING_PLAN_TASKS WHERE T_REPORTING_PLAN_HISTORY.HISTORY_ID = T_REPORTING_PLAN_TASKS.HISTORY_ID UNION ALL SELECT BUFFER_TASK.TASK_ID, T_REPORTING_PLAN_HISTORY.HISTORY_ID, BUFFER_TASK.JS_CHART_TASK, BUFFER_TASK.TASK_ORDER, NULL TASK_TYPE, BUFFER_TASK.WORKFLOW_ID, NULL, BUFFER_TASK.TAG, NULL, NULL, NULL, NULL, BUFFER_TASK.TAG_TYPE FROM T_REPORTING_PLAN_HISTORY T_REPORTING_PLAN_HISTORY, TABLE(GET_PROJECT_BUFFER_TASK(T_REPORTING_PLAN_HISTORY.HISTORY_ID)) BUFFER_TASK
 
Possibly Referenced Tables/Views:


Close relationships: