EGO_CHANGE_TYPES_B
EGO_CHANGE_ORDER_TYPES_B stores information about change/line types.
Details
-
Schema: FUSION
-
Object owner: EGO
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
EGO_CHANGE_TYPES_B_PK |
CHANGE_TYPE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CHANGE_TYPE_ID | NUMBER | 18 | Yes | Unique identifier of a change order type | |
| CHANGE_TYPE_CATEGORY_CODE | VARCHAR2 | 30 | It is used to populate category_code in fnd_ef_categories_b and tl tables | ||
| AUTO_COMPLETE_ON_CANCEL_FLAG | VARCHAR2 | 1 | Autocomplete Change Order When Change Line is Canceled | ||
| COPIED_FROM | VARCHAR2 | 30 | It contains the name of the base change type from which this is created/duplicated. | ||
| TYPE_INTERNAL_NAME | VARCHAR2 | 30 | Unique internal identifier determining the name of change object type | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CHANGE_MGMT_TYPE_CODE | VARCHAR2 | 30 | Code identifying the base change management type differentiating Change Order and New Item Request | ||
| BASE_CHANGE_MGMT_TYPE_CODE | VARCHAR2 | 30 | Code identifying the base change management type differentiating Change Order and New Item Request | ||
| TYPE_CLASSIFICATION | VARCHAR2 | 30 | Identifier to classify the change order type from header, line or category | ||
| START_DATE | DATE | Date from which the change object type will be enabled and active to be used | |||
| DISABLE_DATE | DATE | Date beyond which the change type stand disabled and inactive to be used | |||
| EFFECTIVE_IMMEDIATELY_FLAG | VARCHAR2 | 1 | This flag denotes whether the change order or new item request lines created for this change type should be effective immediately or effective in future. This flag is copied to ego_engineering_changes_b on row creation | ||
| SUBJECT_INTERNAL_NAME | VARCHAR2 | 30 | Column identifying whether the type row is for Change order OR new item request or new item line or change order line or change task | ||
| DEFAULT_ASSIGNEE_FROM_ROLE_ID | NUMBER | 18 | Role Identiifer of the default assignee on change order type | ||
| DEFAULT_ASSIGNEE_ID | VARCHAR2 | 64 | Identifier of the default user/role to which the change objects created of this change type is assigned to | ||
| DEFAULT_ASSIGNEE_ROLE_ID | VARCHAR2 | 64 | Stores the value of Default Assignee Role Id. | ||
| AUTO_NUMBERING_METHOD | VARCHAR2 | 30 | Change notice numbering method for change objects created of this type | ||
| DEFAULT_ASSIGNEE_TYPE | VARCHAR2 | 30 | This column identifies if the default assignee is role or user | ||
| XML_DATA_SOURCE_CODE | VARCHAR2 | 80 | No longer used. | ||
| APPLICATION_ID | NUMBER | Identifier of the application to which this change type belongs | |||
| SEEDED_FLAG | VARCHAR2 | 1 | Flag to indicate if the change order type is seeded or not | ||
| BASE_TYPE_FLAG | VARCHAR2 | 1 | Flag to indicate whether the change type is a base type. | ||
| EFFECTIVITY_INCREMENT_DAYS | NUMBER | To specify a number by which the current context date would be incremented and set as an effective date on the lines for the header instance for this change type. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| PROGRAM_NAME | VARCHAR2 | 30 | No longer used. | ||
| PROGRAM_APP_NAME | VARCHAR2 | 50 | No longer used. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| PRIORITY_CODE | VARCHAR2 | 30 | PriorityCode defines the default priority for the change order type. Any change order of this change order type will get this priority value set by default. PriorityCode refers the change order priority Lookup Table, where all priority values are defined. | ||
| REASON_CODE | VARCHAR2 | 30 | Reason Code defines the default Reason code for the change order type. Any change order of this change order type will get this Reason Code value set by default. Reason Code refers the change order Reason Code Lookup Table, where all Reason values are defined. | ||
| MANDATE_COMNT_ON_APPR_REMOVE | VARCHAR2 | 60 | Mandate Comments on Remove Approver value determines if the comments are mandatory while removing Approver in the Interim Approval and Approval status on the Change Object. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| ego_change_type_organizations | ego_change_types_b | CHANGE_TYPE_ID |
| ego_attr_display_config | ego_change_types_b | CHANGE_TYPE_ID |
| ego_engineering_changes_b | ego_change_types_b | CHANGE_TYPE_ID |
| ego_change_lines_b | ego_change_types_b | LINE_TYPE_ID |
| ego_change_type_team | ego_change_types_b | CHANGE_TYPE_ID |
| ego_change_subject_criteria | ego_change_types_b | CHANGE_LINE_TYPE_ID |
| ego_change_types_tl | ego_change_types_b | CHANGE_TYPE_ID |
| ego_change_type_associations | ego_change_types_b | CHANGE_TYPE_ID |
| ego_change_type_associations | ego_change_types_b | LINE_TYPE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| EGO_CHANGE_TYPES_B_N1 | Non Unique | FUSION_TS_TX_DATA | TYPE_INTERNAL_NAME |
| EGO_CHANGE_TYPES_B_N2 | Non Unique | FUSION_TS_TX_DATA | CHANGE_MGMT_TYPE_CODE, TYPE_CLASSIFICATION |
| EGO_CHANGE_TYPES_B_N3 | Non Unique | FUSION_TS_TX_DATA | COPIED_FROM |
| EGO_CHANGE_TYPES_B_PK | Unique | FUSION_TS_TX_DATA | CHANGE_TYPE_ID, ORA_SEED_SET1 |
| EGO_CHANGE_TYPES_B_PK1 | Unique | FUSION_TS_TX_DATA | CHANGE_TYPE_ID, ORA_SEED_SET2 |