1. Tables and Views for SCM
  2. EGO_ROUTE_PEOPLE_BI_V

EGO_ROUTE_PEOPLE_BI_V

Details

  • Schema: FUSION

  • Object owner: EGO

  • Object type: VIEW

Columns

Name

ROUTE_PEOPLE_ID

ASSIGNEE_NAME

RESPONSE_REQUIRED_FROM

OBJECT_VERSION_NUMBER

STEP_ID

ASSIGNEE_TYPE_CODE

ASSIGNEE_ID

ADHOC_PEOPLE_FLAG

WF_SUBTASK_INSTANCE_ID

RESPONSE_CODE

RESPONSE_DATE

ORIGINAL_ASSIGNEE_TYPE

ORIGINAL_ASSIGNEE_ID

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

OBJECT_NAME

OBJECT_PK1

OBJECT_PK2

OBJECT_PK3

OBJECT_PK4

OBJECT_PK5

TASK_START_TIME

TASK_COMPLETE_TIME

REASSIGNED_TO

Query

SQL_Statement

SELECT

ego_route_people.ROUTE_PEOPLE_ID ROUTE_PEOPLE_ID,

ego_route_people.ASSIGNEE_NAME ASSIGNEE_NAME,

ego_route_people.RESPONSE_REQUIRED_FROM RESPONSE_REQUIRED_FROM,

ego_route_people.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

ego_route_people.STEP_ID STEP_ID,

ego_route_people.ASSIGNEE_TYPE_CODE ASSIGNEE_TYPE_CODE,

ego_route_people.ASSIGNEE_ID ASSIGNEE_ID,

ego_route_people.ADHOC_PEOPLE_FLAG ADHOC_PEOPLE_FLAG,

ego_route_people.WF_SUBTASK_INSTANCE_ID WF_SUBTASK_INSTANCE_ID,

ego_route_people.RESPONSE_CODE RESPONSE_CODE,

ego_route_people.RESPONSE_DATE RESPONSE_DATE,

ego_route_people.ORIGINAL_ASSIGNEE_TYPE ORIGINAL_ASSIGNEE_TYPE,

ego_route_people.ORIGINAL_ASSIGNEE_ID ORIGINAL_ASSIGNEE_ID,

ego_route_people.CREATION_DATE CREATION_DATE,

ego_route_people.CREATED_BY CREATED_BY,

ego_route_people.LAST_UPDATE_DATE LAST_UPDATE_DATE,

ego_route_people.LAST_UPDATED_BY LAST_UPDATED_BY,

ego_route_people.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

ego_route_people.OBJECT_NAME OBJECT_NAME,

ego_route_people.OBJECT_PK1 OBJECT_PK1,

ego_route_people.OBJECT_PK2 OBJECT_PK2,

ego_route_people.OBJECT_PK3 OBJECT_PK3,

ego_route_people.OBJECT_PK4 OBJECT_PK4,

ego_route_people.OBJECT_PK5 OBJECT_PK5,

ego_route_people.TASK_START_TIME TASK_START_TIME,

ego_route_people.TASK_COMPLETE_TIME TASK_COMPLETE_TIME,

regexp_substr( ego_route_people.reassigned_to, '[^,]+', 1, splitrows.column_value) as REASSIGNED_TO

FROM

ego_route_people,

table(cast(multiset(select level from dual connect by level <= length (regexp_replace(ego_route_people.REASSIGNED_TO, '[^,]+')) + 1) as sys.OdciNumberList)) splitrows