EGO_CHANGE_TYPES

Details

Schema: FUSION
Object owner: EGO
Object type: VIEW

Columns

Name
CHANGE_TYPE_ID OBJECT_VERSION_NUMBER CHANGE_MGMT_TYPE_CODE BASE_CHANGE_MGMT_TYPE_CODE TYPE_CLASSIFICATION TYPE_NAME DESCRIPTION TAB_TEXT START_DATE DISABLE_DATE SUBJECT_INTERNAL_NAME DEFAULT_ASSIGNEE_FROM_ROLE_ID DEFAULT_ASSIGNEE_ID AUTO_NUMBERING_METHOD DEFAULT_ASSIGNEE_TYPE XML_DATA_SOURCE_CODE APPLICATION_ID SEEDED_FLAG REQUEST_ID PROGRAM_NAME PROGRAM_APP_NAME LAST_UPDATED_BY LAST_UPDATE_LOGIN LAST_UPDATE_DATE CREATED_BY CREATION_DATE TYPE_INTERNAL_NAME JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE EFFECTIVITY_INCREMENT_DAYS EFFECTIVE_IMMEDIATELY_FLAG COPIED_FROM AUTO_COMPLETE_ON_CANCEL_FLAG PRIORITY_CODE DEFAULT_ASSIGNEE_ROLE_ID REASON_CODE MANDATE_COMNT_ON_APPR_REMOVE BASE_TYPE_FLAG CHANGE_TYPE_CATEGORY_CODE

Name

CHANGE_TYPE_ID

OBJECT_VERSION_NUMBER

CHANGE_MGMT_TYPE_CODE

BASE_CHANGE_MGMT_TYPE_CODE

TYPE_CLASSIFICATION

TYPE_NAME

DESCRIPTION

TAB_TEXT

START_DATE

DISABLE_DATE

SUBJECT_INTERNAL_NAME

DEFAULT_ASSIGNEE_FROM_ROLE_ID

DEFAULT_ASSIGNEE_ID

AUTO_NUMBERING_METHOD

DEFAULT_ASSIGNEE_TYPE

XML_DATA_SOURCE_CODE

APPLICATION_ID

SEEDED_FLAG

REQUEST_ID

PROGRAM_NAME

PROGRAM_APP_NAME

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

LAST_UPDATE_DATE

CREATED_BY

CREATION_DATE

TYPE_INTERNAL_NAME

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

EFFECTIVITY_INCREMENT_DAYS

EFFECTIVE_IMMEDIATELY_FLAG

COPIED_FROM

AUTO_COMPLETE_ON_CANCEL_FLAG

PRIORITY_CODE

DEFAULT_ASSIGNEE_ROLE_ID

REASON_CODE

MANDATE_COMNT_ON_APPR_REMOVE

BASE_TYPE_FLAG

CHANGE_TYPE_CATEGORY_CODE

Query

SQL_Statement
SELECT EGO_CHANGE_TYPES_B.CHANGE_TYPE_ID CHANGE_TYPE_ID, EGO_CHANGE_TYPES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, EGO_CHANGE_TYPES_B.CHANGE_MGMT_TYPE_CODE CHANGE_MGMT_TYPE_CODE, EGO_CHANGE_TYPES_B.BASE_CHANGE_MGMT_TYPE_CODE BASE_CHANGE_MGMT_TYPE_CODE, EGO_CHANGE_TYPES_B.TYPE_CLASSIFICATION TYPE_CLASSIFICATION, EGO_CHANGE_TYPES_TL.TYPE_NAME TYPE_NAME, EGO_CHANGE_TYPES_TL.DESCRIPTION DESCRIPTION, EGO_CHANGE_TYPES_TL.TAB_TEXT TAB_TEXT, EGO_CHANGE_TYPES_B.START_DATE START_DATE, EGO_CHANGE_TYPES_B.DISABLE_DATE DISABLE_DATE, EGO_CHANGE_TYPES_B.SUBJECT_INTERNAL_NAME SUBJECT_INTERNAL_NAME, EGO_CHANGE_TYPES_B.DEFAULT_ASSIGNEE_FROM_ROLE_ID DEFAULT_ASSIGNEE_FROM_ROLE_ID, EGO_CHANGE_TYPES_B.DEFAULT_ASSIGNEE_ID DEFAULT_ASSIGNEE_ID, EGO_CHANGE_TYPES_B.AUTO_NUMBERING_METHOD AUTO_NUMBERING_METHOD, EGO_CHANGE_TYPES_B.DEFAULT_ASSIGNEE_TYPE DEFAULT_ASSIGNEE_TYPE, EGO_CHANGE_TYPES_B.XML_DATA_SOURCE_CODE XML_DATA_SOURCE_CODE, EGO_CHANGE_TYPES_B.APPLICATION_ID APPLICATION_ID, EGO_CHANGE_TYPES_B.SEEDED_FLAG SEEDED_FLAG, EGO_CHANGE_TYPES_B.REQUEST_ID REQUEST_ID, EGO_CHANGE_TYPES_B.PROGRAM_NAME PROGRAM_NAME, EGO_CHANGE_TYPES_B.PROGRAM_APP_NAME PROGRAM_APP_NAME, EGO_CHANGE_TYPES_B.LAST_UPDATED_BY LAST_UPDATED_BY, EGO_CHANGE_TYPES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, EGO_CHANGE_TYPES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, EGO_CHANGE_TYPES_B.CREATED_BY CREATED_BY, EGO_CHANGE_TYPES_B.CREATION_DATE CREATION_DATE, EGO_CHANGE_TYPES_B.TYPE_INTERNAL_NAME TYPE_INTERNAL_NAME, EGO_CHANGE_TYPES_B.JOB_DEFINITION_NAME JOB_DEFINITION_NAME, EGO_CHANGE_TYPES_B.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE, EGO_CHANGE_TYPES_B.EFFECTIVITY_INCREMENT_DAYS EFFECTIVITY_INCREMENT_DAYS, EGO_CHANGE_TYPES_B.EFFECTIVE_IMMEDIATELY_FLAG EFFECTIVE_IMMEDIATELY_FLAG, EGO_CHANGE_TYPES_B.COPIED_FROM COPIED_FROM, EGO_CHANGE_TYPES_B.AUTO_COMPLETE_ON_CANCEL_FLAG, EGO_CHANGE_TYPES_B.PRIORITY_CODE, EGO_CHANGE_TYPES_B.DEFAULT_ASSIGNEE_ROLE_ID DEFAULT_ASSIGNEE_ROLE_ID, EGO_CHANGE_TYPES_B.REASON_CODE, EGO_CHANGE_TYPES_B.MANDATE_COMNT_ON_APPR_REMOVE, EGO_CHANGE_TYPES_B.BASE_TYPE_FLAG, EGO_CHANGE_TYPES_B.CHANGE_TYPE_CATEGORY_CODE FROM EGO_CHANGE_TYPES_B, EGO_CHANGE_TYPES_TL WHERE EGO_CHANGE_TYPES_B.CHANGE_TYPE_ID = EGO_CHANGE_TYPES_TL.CHANGE_TYPE_ID AND EGO_CHANGE_TYPES_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

EGO_CHANGE_TYPES_B.CHANGE_TYPE_ID CHANGE_TYPE_ID,

EGO_CHANGE_TYPES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

EGO_CHANGE_TYPES_B.CHANGE_MGMT_TYPE_CODE CHANGE_MGMT_TYPE_CODE,

EGO_CHANGE_TYPES_B.BASE_CHANGE_MGMT_TYPE_CODE BASE_CHANGE_MGMT_TYPE_CODE,

EGO_CHANGE_TYPES_B.TYPE_CLASSIFICATION TYPE_CLASSIFICATION,

EGO_CHANGE_TYPES_TL.TYPE_NAME TYPE_NAME,

EGO_CHANGE_TYPES_TL.DESCRIPTION DESCRIPTION,

EGO_CHANGE_TYPES_TL.TAB_TEXT TAB_TEXT,

EGO_CHANGE_TYPES_B.START_DATE START_DATE,

EGO_CHANGE_TYPES_B.DISABLE_DATE DISABLE_DATE,

EGO_CHANGE_TYPES_B.SUBJECT_INTERNAL_NAME SUBJECT_INTERNAL_NAME,

EGO_CHANGE_TYPES_B.DEFAULT_ASSIGNEE_FROM_ROLE_ID DEFAULT_ASSIGNEE_FROM_ROLE_ID,

EGO_CHANGE_TYPES_B.DEFAULT_ASSIGNEE_ID DEFAULT_ASSIGNEE_ID,

EGO_CHANGE_TYPES_B.AUTO_NUMBERING_METHOD AUTO_NUMBERING_METHOD,

EGO_CHANGE_TYPES_B.DEFAULT_ASSIGNEE_TYPE DEFAULT_ASSIGNEE_TYPE,

EGO_CHANGE_TYPES_B.XML_DATA_SOURCE_CODE XML_DATA_SOURCE_CODE,

EGO_CHANGE_TYPES_B.APPLICATION_ID APPLICATION_ID,

EGO_CHANGE_TYPES_B.SEEDED_FLAG SEEDED_FLAG,

EGO_CHANGE_TYPES_B.REQUEST_ID REQUEST_ID,

EGO_CHANGE_TYPES_B.PROGRAM_NAME PROGRAM_NAME,

EGO_CHANGE_TYPES_B.PROGRAM_APP_NAME PROGRAM_APP_NAME,

EGO_CHANGE_TYPES_B.LAST_UPDATED_BY LAST_UPDATED_BY,

EGO_CHANGE_TYPES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

EGO_CHANGE_TYPES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

EGO_CHANGE_TYPES_B.CREATED_BY CREATED_BY,

EGO_CHANGE_TYPES_B.CREATION_DATE CREATION_DATE,

EGO_CHANGE_TYPES_B.TYPE_INTERNAL_NAME TYPE_INTERNAL_NAME,

EGO_CHANGE_TYPES_B.JOB_DEFINITION_NAME JOB_DEFINITION_NAME,

EGO_CHANGE_TYPES_B.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE,

EGO_CHANGE_TYPES_B.EFFECTIVITY_INCREMENT_DAYS EFFECTIVITY_INCREMENT_DAYS,

EGO_CHANGE_TYPES_B.EFFECTIVE_IMMEDIATELY_FLAG EFFECTIVE_IMMEDIATELY_FLAG,

EGO_CHANGE_TYPES_B.COPIED_FROM COPIED_FROM,

EGO_CHANGE_TYPES_B.AUTO_COMPLETE_ON_CANCEL_FLAG,

EGO_CHANGE_TYPES_B.PRIORITY_CODE,

EGO_CHANGE_TYPES_B.DEFAULT_ASSIGNEE_ROLE_ID DEFAULT_ASSIGNEE_ROLE_ID,

EGO_CHANGE_TYPES_B.REASON_CODE,

EGO_CHANGE_TYPES_B.MANDATE_COMNT_ON_APPR_REMOVE,

EGO_CHANGE_TYPES_B.BASE_TYPE_FLAG,

EGO_CHANGE_TYPES_B.CHANGE_TYPE_CATEGORY_CODE

FROM

EGO_CHANGE_TYPES_B,

EGO_CHANGE_TYPES_TL

WHERE

EGO_CHANGE_TYPES_B.CHANGE_TYPE_ID = EGO_CHANGE_TYPES_TL.CHANGE_TYPE_ID AND EGO_CHANGE_TYPES_TL.LANGUAGE = USERENV('LANG')