EGO_CHANGE_ACTIONS

Details

Schema: FUSION
Object owner: EGO
Object type: VIEW

Columns

Name
ACTION_ID OBJECT_VERSION_NUMBER ACTION_TYPE OBJECT_NAME OBJECT_ID1 OBJECT_ID2 OBJECT_ID3 OBJECT_ID4 OBJECT_ID5 DESCRIPTION STATUS_CODE PRIORITY_CODE ASSIGNEE_ID RESPONSE_BY_DATE PARENT_ACTION_ID PARENT_STATUS_CODE ORIGINAL_SYSTEM_REFERENCE IMPLEMENTATION_REQ_ID LOCAL_ORGANIZATION_ID PARTY_ID_LIST REQUEST_ID PROGRAM_NAME PROGRAM_APP_NAME CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE WF_PROCESS_INSTANCE_ID WF_PROCESS_TEMPLATE SOURCE_CHANGE_ID TARGET_CHANGE_ID IS_UPGRADED

Name

ACTION_ID

OBJECT_VERSION_NUMBER

ACTION_TYPE

OBJECT_NAME

OBJECT_ID1

OBJECT_ID2

OBJECT_ID3

OBJECT_ID4

OBJECT_ID5

DESCRIPTION

STATUS_CODE

PRIORITY_CODE

ASSIGNEE_ID

RESPONSE_BY_DATE

PARENT_ACTION_ID

PARENT_STATUS_CODE

ORIGINAL_SYSTEM_REFERENCE

IMPLEMENTATION_REQ_ID

LOCAL_ORGANIZATION_ID

PARTY_ID_LIST

REQUEST_ID

PROGRAM_NAME

PROGRAM_APP_NAME

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

WF_PROCESS_INSTANCE_ID

WF_PROCESS_TEMPLATE

SOURCE_CHANGE_ID

TARGET_CHANGE_ID

IS_UPGRADED

Query

SQL_Statement
SELECT EGO_CHANGE_ACTIONS_B.ACTION_ID ACTION_ID, EGO_CHANGE_ACTIONS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, EGO_CHANGE_ACTIONS_B.ACTION_TYPE ACTION_TYPE, EGO_CHANGE_ACTIONS_B.OBJECT_NAME OBJECT_NAME, EGO_CHANGE_ACTIONS_B.OBJECT_ID1 OBJECT_ID1, EGO_CHANGE_ACTIONS_B.OBJECT_ID2 OBJECT_ID2, EGO_CHANGE_ACTIONS_B.OBJECT_ID3 OBJECT_ID3, EGO_CHANGE_ACTIONS_B.OBJECT_ID4 OBJECT_ID4, EGO_CHANGE_ACTIONS_B.OBJECT_ID5 OBJECT_ID5, EGO_CHANGE_ACTIONS_TL.DESCRIPTION DESCRIPTION, EGO_CHANGE_ACTIONS_B.STATUS_CODE STATUS_CODE, EGO_CHANGE_ACTIONS_B.PRIORITY_CODE PRIORITY_CODE, EGO_CHANGE_ACTIONS_B.ASSIGNEE_ID ASSIGNEE_ID, EGO_CHANGE_ACTIONS_B.RESPONSE_BY_DATE RESPONSE_BY_DATE, EGO_CHANGE_ACTIONS_B.PARENT_ACTION_ID PARENT_ACTION_ID, EGO_CHANGE_ACTIONS_B.PARENT_STATUS_CODE PARENT_STATUS_CODE, EGO_CHANGE_ACTIONS_B.ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE, EGO_CHANGE_ACTIONS_B.IMPLEMENTATION_REQ_ID IMPLEMENTATION_REQ_ID, EGO_CHANGE_ACTIONS_B.LOCAL_ORGANIZATION_ID LOCAL_ORGANIZATION_ID, EGO_CHANGE_ACTIONS_B.PARTY_ID_LIST PARTY_ID_LIST, EGO_CHANGE_ACTIONS_B.REQUEST_ID REQUEST_ID, EGO_CHANGE_ACTIONS_B.PROGRAM_NAME PROGRAM_NAME, EGO_CHANGE_ACTIONS_B.PROGRAM_APP_NAME PROGRAM_APP_NAME, EGO_CHANGE_ACTIONS_B.CREATED_BY CREATED_BY, EGO_CHANGE_ACTIONS_B.CREATION_DATE CREATION_DATE, EGO_CHANGE_ACTIONS_B.LAST_UPDATED_BY LAST_UPDATED_BY, EGO_CHANGE_ACTIONS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, EGO_CHANGE_ACTIONS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, EGO_CHANGE_ACTIONS_B.JOB_DEFINITION_NAME JOB_DEFINITION_NAME, EGO_CHANGE_ACTIONS_B.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE, EGO_CHANGE_ACTIONS_B.WF_PROCESS_INSTANCE_ID WF_PROCESS_INSTANCE_ID, EGO_CHANGE_ACTIONS_B.WF_PROCESS_TEMPLATE WF_PROCESS_TEMPLATE, EGO_CHANGE_ACTIONS_B.SOURCE_CHANGE_ID, EGO_CHANGE_ACTIONS_B.TARGET_CHANGE_ID, EGO_CHANGE_ACTIONS_B.IS_UPGRADED FROM EGO_CHANGE_ACTIONS_B, EGO_CHANGE_ACTIONS_TL WHERE EGO_CHANGE_ACTIONS_B.ACTION_ID = EGO_CHANGE_ACTIONS_TL.ACTION_ID AND EGO_CHANGE_ACTIONS_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

EGO_CHANGE_ACTIONS_B.ACTION_ID ACTION_ID,

EGO_CHANGE_ACTIONS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

EGO_CHANGE_ACTIONS_B.ACTION_TYPE ACTION_TYPE,

EGO_CHANGE_ACTIONS_B.OBJECT_NAME OBJECT_NAME,

EGO_CHANGE_ACTIONS_B.OBJECT_ID1 OBJECT_ID1,

EGO_CHANGE_ACTIONS_B.OBJECT_ID2 OBJECT_ID2,

EGO_CHANGE_ACTIONS_B.OBJECT_ID3 OBJECT_ID3,

EGO_CHANGE_ACTIONS_B.OBJECT_ID4 OBJECT_ID4,

EGO_CHANGE_ACTIONS_B.OBJECT_ID5 OBJECT_ID5,

EGO_CHANGE_ACTIONS_TL.DESCRIPTION DESCRIPTION,

EGO_CHANGE_ACTIONS_B.STATUS_CODE STATUS_CODE,

EGO_CHANGE_ACTIONS_B.PRIORITY_CODE PRIORITY_CODE,

EGO_CHANGE_ACTIONS_B.ASSIGNEE_ID ASSIGNEE_ID,

EGO_CHANGE_ACTIONS_B.RESPONSE_BY_DATE RESPONSE_BY_DATE,

EGO_CHANGE_ACTIONS_B.PARENT_ACTION_ID PARENT_ACTION_ID,

EGO_CHANGE_ACTIONS_B.PARENT_STATUS_CODE PARENT_STATUS_CODE,

EGO_CHANGE_ACTIONS_B.ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE,

EGO_CHANGE_ACTIONS_B.IMPLEMENTATION_REQ_ID IMPLEMENTATION_REQ_ID,

EGO_CHANGE_ACTIONS_B.LOCAL_ORGANIZATION_ID LOCAL_ORGANIZATION_ID,

EGO_CHANGE_ACTIONS_B.PARTY_ID_LIST PARTY_ID_LIST,

EGO_CHANGE_ACTIONS_B.REQUEST_ID REQUEST_ID,

EGO_CHANGE_ACTIONS_B.PROGRAM_NAME PROGRAM_NAME,

EGO_CHANGE_ACTIONS_B.PROGRAM_APP_NAME PROGRAM_APP_NAME,

EGO_CHANGE_ACTIONS_B.CREATED_BY CREATED_BY,

EGO_CHANGE_ACTIONS_B.CREATION_DATE CREATION_DATE,

EGO_CHANGE_ACTIONS_B.LAST_UPDATED_BY LAST_UPDATED_BY,

EGO_CHANGE_ACTIONS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

EGO_CHANGE_ACTIONS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

EGO_CHANGE_ACTIONS_B.JOB_DEFINITION_NAME JOB_DEFINITION_NAME,

EGO_CHANGE_ACTIONS_B.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE,

EGO_CHANGE_ACTIONS_B.WF_PROCESS_INSTANCE_ID WF_PROCESS_INSTANCE_ID,

EGO_CHANGE_ACTIONS_B.WF_PROCESS_TEMPLATE WF_PROCESS_TEMPLATE,

EGO_CHANGE_ACTIONS_B.SOURCE_CHANGE_ID,

EGO_CHANGE_ACTIONS_B.TARGET_CHANGE_ID,

EGO_CHANGE_ACTIONS_B.IS_UPGRADED

FROM

EGO_CHANGE_ACTIONS_B,

EGO_CHANGE_ACTIONS_TL

WHERE

EGO_CHANGE_ACTIONS_B.ACTION_ID = EGO_CHANGE_ACTIONS_TL.ACTION_ID AND EGO_CHANGE_ACTIONS_TL.LANGUAGE = USERENV('LANG')