EGP_ITEM_WHERE_USED
This is permanent table used by implosion process to identify the component items usage in structures.
Details
-
Schema: FUSION
-
Object owner: EGP
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
EGP_ITEM_WHERE_USED_PK |
BATCH_ID, SORT_CODE, SEQUENCE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BATCH_ID | NUMBER | 18 | Yes | Batch identifier for the implosion | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| IMPLODED_COMPONENT_ID | NUMBER | 18 | Yes | Inventory Id of the component that is Imploded | |
| IMPLODED_COMP_ORG_ID | NUMBER | 18 | Organization Id of the component that is Imploded | ||
| SEQUENCE_ID | NUMBER | 18 | Yes | Sequence Identifier to group the rows. | |
| CURRENT_LEVEL | NUMBER | Yes | Current level of the component. | ||
| NODE_SEQUENCE | NUMBER | 18 | Sequence Number for the node inside the tree. | ||
| SORT_CODE | VARCHAR2 | 2000 | Yes | Sort code which uniquely identifies the node in implosion hierarchy. | |
| CURRENT_OBJ_NAME | VARCHAR2 | 50 | Yes | Object Name of the component row. | |
| CURRENT_PK1_VALUE | NUMBER | 18 | Yes | Pk1 value for the . For Item this is inventory item id. | |
| CURRENT_PK2_VALUE | NUMBER | 18 | Pk2 value of the component. For Item this value is Organization Id. | ||
| CURRENT_PK3_VALUE | NUMBER | 18 | Used to refer any other identifiers from other tables. | ||
| CURRENT_PK4_VALUE | NUMBER | 18 | Used to refer any other identifiers from other tables. | ||
| CURRENT_PK5_VALUE | NUMBER | 18 | Used to refer any other identifiers from other tables. | ||
| PARENT_SORT_CODE | VARCHAR2 | 2000 | Parent's sort code in the implosion hierarchy. | ||
| PARENT_OBJ_NAME | VARCHAR2 | 50 | Object Name of the parent row (Component's object name, which is part of current structure object). | ||
| PARENT_PK1_VALUE | NUMBER | 18 | Identifier representing inventory_item_id of the parent item. | ||
| PARENT_PK2_VALUE | NUMBER | 18 | Identifier representing Organization_id of the parent item. | ||
| PARENT_PK3_VALUE | NUMBER | 18 | Used to refer any other identifiers from other tables. | ||
| PARENT_PK4_VALUE | NUMBER | 18 | Used to refer any other identifiers from other tables. | ||
| PARENT_PK5_VALUE | NUMBER | 18 | Used to refer any other identifiers from other tables. | ||
| ALTERNATE_DESIGNATOR_ID | NUMBER | 18 | Alternate Designator Identifier for the structure. | ||
| COMPONENT_PATH | VARCHAR2 | 4000 | The path of the current node in the implosion hierarchy. | ||
| COMPONENT_SEQUENCE_ID | NUMBER | 18 | Component Sequence Id of the component. | ||
| OPERATION_SEQ_NUM | NUMBER | Find Number of the component. | |||
| EFFECTIVITY_DATE | TIMESTAMP | Effectivity Date of the component. | |||
| DISABLE_DATE | TIMESTAMP | Date at the end of a date range during which a given record is be available for transacting. Use for date effective entities only. | |||
| FROM_END_ITEM_UNIT_NUMBER | VARCHAR2 | 30 | From End Item Unit Number of the component. | ||
| TO_END_ITEM_UNIT_NUMBER | VARCHAR2 | 30 | To End Item Unit Number of the component. | ||
| FROM_END_ITEM_SERIAL_NUMBER | VARCHAR2 | 30 | From End Item Serial Number of the component. | ||
| TO_END_ITEM_SERIAL_NUMBER | VARCHAR2 | 30 | To End Item Serial Number of the component. | ||
| FROM_END_ITEM_REVISION | VARCHAR2 | 18 | From End Item Revision of the component. | ||
| TO_END_ITEM_REVISION | VARCHAR2 | 18 | To End Item Revision of the component. | ||
| EFFECTIVITY_CONTROL | NUMBER | Effectivity control of the structure. | |||
| COMPONENT_QUANTITY | NUMBER | Quantity of component item used. | |||
| REVISED_ITEM_SEQUENCE_ID | NUMBER | 18 | Revised Item Sequence Id of the component. | ||
| CHANGE_NOTICE | VARCHAR2 | 50 | Change notice of the component change. | ||
| IMPLEMENTED_FLAG | VARCHAR2 | 1 | Whether the component is implemented or not. | ||
| TOP_ITEM_FLAG | VARCHAR2 | 1 | Whether the component is a top item or not. | ||
| LOOP_EXISTS_FLAG | VARCHAR2 | 1 | Whether there is a loop in this path or not. | ||
| EXCLUDED_BY_RULE_FLAG | VARCHAR2 | 1 | Whether this component is excluded by rule or not. | ||
| ACCESS_FLAG | VARCHAR2 | 1 | Whether the user has access to view or not. | ||
| IMPL_FROM_DATE | TIMESTAMP | From Date for which the implosion needs to be done. | |||
| IMPL_TO_DATE | TIMESTAMP | To Date for which the implosion needs to be done. | |||
| IMPL_FROM_END_ITEM_UNIT_NUMBER | VARCHAR2 | 30 | From End Item Unit Number for which implosion needs to be done. | ||
| IMPL_TO_END_ITEM_UNIT_NUMBER | VARCHAR2 | 30 | To End Item Unit Number for which implosion needs to be done. | ||
| COMPONENT_ITEM_REVISION_ID | NUMBER | 18 | Component Item Revision Id of the component. | ||
| BASIS_TYPE | VARCHAR2 | 80 | Identifies component usage as fixed or variable. You can specify component usage as a fixed rate per job for activities such as setup and tear down, and variable rates for components whose usage depends on the number of units processed. For lot based components you choose the Lot basis type and your usage rate is fixed, and for item based components you choose the Item basis type to indicate that your usage rate is variable. | ||
| ITEM_ICON | VARCHAR2 | 30 | Icon to indicate whether the component item is a sub assembly or component only. | ||
| CONTEXT_ITEM_ICON | VARCHAR2 | 30 | Icon to indicate the current context item. | ||
| ITEM_NAME | VARCHAR2 | 300 | Item Name of the component item | ||
| ITEM_DESCRIPTION | VARCHAR2 | 240 | Item Description of the component item | ||
| ORGANIZATION_NAME | VARCHAR2 | 240 | Organization Name to which the component item belongs to. | ||
| ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | 80 | Structure Name of the parent item. | ||
| STRUCTURE_NAME | VARCHAR2 | 80 | Name given to a specific variation of a Structure type. | ||
| ITEM_CLASS | VARCHAR2 | 250 | Id of the class to which the item belongs. | ||
| REVISION | VARCHAR2 | 18 | Revision of the Item or Component. | ||
| ITEM_TYPE | VARCHAR2 | 80 | Indicator or classification for an item, such as finished or purchased. | ||
| INVENTORY_ITEM_STATUS_CODE | VARCHAR2 | 240 | Code used to control the transaction activity of an item. | ||
| APPROVAL_STATUS | VARCHAR2 | 80 | Approval Status of the component item. | ||
| PRIMARY_UOM_CODE | VARCHAR2 | 25 | Primary Unit Of Measure of the Item. | ||
| PEER_FLAG | VARCHAR2 | 1 | Indicates whether the item is a peer for the item for which the implosion is performed. | ||
| BILL_SEQUENCE_ID | NUMBER | 18 | Bill Sequence Id of the structure. | ||
| COMP_BILL_SEQUENCE_ID | NUMBER | 18 | Bill Sequence Id of the component. | ||
| SCHEDULED_DATE | TIMESTAMP | Scheduled Date of the change order. | |||
| ORGANIZATION_CODE | VARCHAR2 | 18 | Organization Code of the organization to which the item belongs to. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates 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. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| SUBSTITUTE_FOR_COMPONENT_ID | NUMBER | 18 | Inventory Item Id of the component, for which the current row is a substitute. | ||
| SUBSTITUTE_FOR_COMPONENT_NAME | VARCHAR2 | 300 | Item Name of the component, for which the current row is a substitute. | ||
| ITEM_NUM | NUMBER | Item Sequence of the component | |||
| SUGGESTED_OPERATION_SEQ_NUM | NUMBER | Suggested Operation Sequence Number of the component |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| EGP_ITEM_WHERE_USED_N1 | Non Unique | Default | SEQUENCE_ID |
| EGP_ITEM_WHERE_USED_N2 | Non Unique | Default | FROM_END_ITEM_UNIT_NUMBER |
| EGP_ITEM_WHERE_USED_N3 | Non Unique | Default | FROM_END_ITEM_SERIAL_NUMBER |
| EGP_ITEM_WHERE_USED_N4 | Non Unique | Default | EFFECTIVITY_DATE |
| EGP_ITEM_WHERE_USED_N5 | Non Unique | Default | ORGANIZATION_CODE |
| EGP_ITEM_WHERE_USED_N7 | Non Unique | Default | IMPLODED_COMPONENT_ID, IMPLODED_COMP_ORG_ID |
| EGP_ITEM_WHERE_USED_U1 | Unique | Default | BATCH_ID, SORT_CODE, SEQUENCE_ID |