EGP_COMPONENTS_B
EGP_COMPONENTS_B stores information about bills of material components. This table only stores single-level components. COMPONENT_SEQUENCE_ID uniquely identifies each row. There is one row per component on an operation within a given date range. . This table is the main child table of EGP_STRUCTURES_B and references the parent using BILL_SEQUENCE_ID. It uses EFFECTIVITY_DATE and DISABLE_DATE to time phase components into a bill of material. The Bill of Material window enforces that only one row for a component in an operation is effective at a given time. . REVISED_ITEM_SEQUENCE_ID points to the revised item on an ECO that affects a particular component row. If IMPLEMENTATION_DATE is null, the component is pending on an engineering change that has not yet been implemented. IMPLEMENTATION_DATE is either NULL (pending on ECO) or equals EFFECTIVITY_DATE (implemented). OLD_COMPONENT_SEQUENCE_ID points to the original component row affected by this component row through an engineering change. . This table also contains certain columns relating to shipping, billing and accounting for revenue on a customer order through Oracle Order Management. CHECK_ATP determines if an ATP check is required for this item when placing an order and overrides the Item level ATP flag. LOW_QUANTITY and HIGH_QUANTITY define minimum and maximum quantities of this component item that can be placed on an order if the customer chooses to override COMPONENT_QUANTITY. OPTIONAL decides if a component is a required option class you have to choose from (for Option Class items) or a required item (for Standard items) when taking an order. For Option Class items, MUTUALLY_EXCLUSIVE_OPTIONS decides if one or more of its components can be placed on an order when you pick this option class. . OPERATION_LEAD_TIME_PERCENT is denormalized for performance from BOM_OPERATION_SEQUENCES when rolling up cumulative leadtimes. . The ORGANIZATION_ID for the component can be derived from the BOM_BILL_OF_MATERIALS table using BILL_SEQUENCE_ID.
Details
-
Schema: FUSION
-
Object owner: EGP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
EGP_COMPONENTS_B_PK |
COMPONENT_SEQUENCE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
---|---|---|---|---|---|---|
OPERATION_SEQ_NUM | NUMBER | Yes | A number that orders component operations in a routing relative to each other. | |||
PRIMARY_UOM_CODE | VARCHAR2 | 3 | Unit which is primarily used to measure quantities of the item. | |||
SHOW_IN_SALES | NUMBER | Show in Sales is displayed for model structures. | ||||
INSTANTIABILITY_CODE | VARCHAR2 | 30 | Indicates the instance usage of a component item in a model item structure. | |||
CHANGE_ID | NUMBER | Attribute indicates whether to check available to promise and/or capable to promise information when placing demand. | ||||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
ITEM_NUM | NUMBER | Indicates the sequence of the item on an item structure. It is used to sort components when presenting item structure details. | ||||
COMPONENT_QUANTITY | NUMBER | Yes | Quantity of component in bill of material | |||
COMPONENT_YIELD_FACTOR | NUMBER | Yes | Factor used to multiply component quantity with to obtain required component quantity | |||
COMPONENT_REMARKS | VARCHAR2 | 240 | Remarks or comments related to the component | |||
EFFECTIVITY_DATE | DATE | Yes | Date at the beginning of the date range during which a given record will be available for transacting for date effective entities. | |||
IMPLEMENTATION_DATE | DATE | Date on which engineering change order was implemented | ||||
DISABLE_DATE | DATE | Date at the end of a date range during which a given record is be available for transacting. Use for date effective entities only. | ||||
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE26 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE27 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE28 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE29 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
ATTRIBUTE30 | VARCHAR2 | 4000 | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | ||
PLANNING_FACTOR | NUMBER | Yes | Factor used to multiply component quantity with to obtain planning quantity | |||
QUANTITY_RELATED | NUMBER | Yes | Identifier to indicate if this component has quantity related reference designators | |||
SO_BASIS | NUMBER | Quantity basis used by Oracle Order Management to determine how many units of component to put on an order | ||||
OPTIONAL | NUMBER | Flag indicating if component is optional in bill | ||||
MUTUALLY_EXCLUSIVE_OPTIONS | NUMBER | Flag indicating if one or more children of component can be picked when taking an order | ||||
CHECK_ATP | NUMBER | Yes | Flag indicating if ATP check is required | |||
SHIPPING_ALLOWED | NUMBER | Flag indicating if component is allowed to ship | ||||
REQUIRED_TO_SHIP | NUMBER | Flag indicating if component is required to ship | ||||
REQUIRED_FOR_REVENUE | NUMBER | Flag indicating if component is required for revenue | ||||
INCLUDE_ON_SHIP_DOCS | NUMBER | Flag indicating if component is displayed on shipping documents | ||||
INCLUDE_ON_BILL_DOCS | NUMBER | Attribute indicates whether record should be included in billing documentation, such as invoices. | ||||
LOW_QUANTITY | NUMBER | Minimum quantity allowed on an order | ||||
HIGH_QUANTITY | NUMBER | Maximum quantity allowed on an order | ||||
ACD_TYPE | NUMBER | Add, change, or disable code for component on an engineering change order | ||||
OLD_COMPONENT_SEQUENCE_ID | NUMBER | 18 | Identifier of original component row an ECO effects | |||
COMPONENT_SEQUENCE_ID | NUMBER | 18 | Yes | Sequence id of the Component Item. This is the ID column of the table EGP_COMPONENTS_B | ||
BILL_SEQUENCE_ID | NUMBER | 18 | Yes | Bill of material unique identifier | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
WIP_SUPPLY_TYPE | NUMBER | A bill of material component field that controls issue transactions from inventory to work in process | ||||
PICK_COMPONENTS | NUMBER | An indicator that defines an item as a pick to order item. This attribute works in conjunction with structure item type attribute. | ||||
SUPPLY_SUBINVENTORY | VARCHAR2 | 10 | Subdivision of an organization, representing either a physical area or a logical grouping of items, such as a storeroom or receiving dock. | |||
SUPPLY_LOCATOR_ID | NUMBER | 18 | Physical area within a sub inventory where you store material, such as a row, aisle, bin, or shelf. | |||
OPERATION_LEAD_TIME_PERCENT | NUMBER | Operation offset from first operation in routing (denormalized from corresponding column in BOM_OPERATION_SEQUNCES) | ||||
REVISED_ITEM_SEQUENCE_ID | NUMBER | Engineering change order revised item identifier | ||||
BOM_ITEM_TYPE | NUMBER | Type of item (denormalized from BOM Item Type in EGP_SYSTEM_ITEMS) | ||||
FROM_END_ITEM_UNIT_NUMBER | VARCHAR2 | 30 | Unit number at the beginning of the end item (or root item) unit number range during which a given record is available. | |||
TO_END_ITEM_UNIT_NUMBER | VARCHAR2 | 30 | Unit number at the end of the end item (or root item) unit number range during which a given record is available. | |||
COMPONENT_ITEM_REVISION_ID | NUMBER | Item revision Identifier of the component | ||||
ORIGINAL_SYSTEM_REFERENCE | VARCHAR2 | 50 | Original system that data for the current record has come from | |||
DELETE_GROUP_NAME | VARCHAR2 | 10 | Delete group name for the entity type you are deleting | |||
DG_DESCRIPTION | VARCHAR2 | 240 | Description of the delete group | |||
ENFORCE_INT_REQUIREMENTS | NUMBER | Enforce integer requirement for component's calculated quantity or inverse quantity. | ||||
OPTIONAL_ON_MODEL | NUMBER | Flag indicating if component is optional on model bill (for ATO) | ||||
PARENT_BILL_SEQ_ID | NUMBER | Common bill sequence id of the model bill (for ATO) | ||||
MODEL_COMP_SEQ_ID | NUMBER | Component sequence identifier from model bill (for ATO) | ||||
PLAN_LEVEL | NUMBER | Plan level based on model bill (for ATO) | ||||
AUTO_REQUEST_MATERIAL | VARCHAR2 | 1 | Flag to indicate if the item is automatically requested or not | |||
SUGGESTED_VENDOR_NAME | VARCHAR2 | 240 | Suggested vendor name will be used for direct items for EAM BOMs | |||
VENDOR_ID | NUMBER | 18 | Identifier of the Suggested Vendor | |||
UNIT_PRICE | NUMBER | Unit Price for direct items used by EAM BOMs | ||||
OBJ_NAME | VARCHAR2 | 30 | Name of the object. Contains values like EGO_ITEM etc., | |||
PK1_VALUE | VARCHAR2 | 240 | Identifier representing inventory_item_id of the item. | |||
PK2_VALUE | VARCHAR2 | 240 | Identifier representing Organization_id of the item | |||
PK3_VALUE | VARCHAR2 | 240 | Used to refer any other identifiers from other tables | |||
PK4_VALUE | VARCHAR2 | 240 | Used to refer any other identifiers from other tables | |||
PK5_VALUE | VARCHAR2 | 240 | Used to refer any other identifiers from other tables | |||
FROM_END_ITEM_REV_ID | NUMBER | 18 | Revision at the beginning of the end item (or root item) revision range during which a given record is available. | |||
TO_END_ITEM_REV_ID | NUMBER | 18 | Revision at the end of the end item (or root item) revision range during which a given record is available. | |||
BASIS_TYPE | NUMBER | 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. | ||||
COMMON_COMPONENT_SEQUENCE_ID | NUMBER | 18 | Common Component Sequence Identifier | |||
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. | ||
PROGRAM_NAME | VARCHAR2 | 30 | Identifies the concurrent program. | |||
PROGRAM_APP_NAME | VARCHAR2 | 50 | Identifies the Application name spawning the Concurrent Request. | |||
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. | |||
CHANGE_LINE_ID | NUMBER | Engineering change order number | ||||
VERSION_ID | NUMBER | Yes | Under a version control env this column represents the version id of this component | |||
CHANGE_BIT_MAP | VARCHAR2 | 420 | Bit Map of the changed attributes | |||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | |||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | |||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | |||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | |||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | |||
ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | |||
ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | |||
ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | |||
ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | |||
ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | |||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | |||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | |||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | |||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | |||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | |||
ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | |||
ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | |||
ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | |||
ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | |||
ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | EGP_COMPONENT_DFF (EGP_COMPONENT_DFF) | |||
REPLACED_FOR_COMPONENT | NUMBER | 18 | The inventory item of the component which is replaced by the current component. | |||
REPLACED_BY_COMPONENT | NUMBER | 18 | The inventory item of the component which is replacing the current component. | |||
REPLACED_FOR_COMP_SEQ_ID | NUMBER | 18 | The component sequence id of the component which was replaced. | |||
USE_PLACEHOLDER | NUMBER | Flag indicating if Use Placeholder for Optional Components to identify Option classes that hold large set of options. | ||||
SUGGESTED_OPERATION_SEQ_NUM | NUMBER | Operation sequence number suggested by the design engineer to be included in work definition. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
EGP_COMPONENTS_B | ego_change_lines_b | CHANGE_LINE_ID |
EGP_COMPONENTS_B | egp_structures_b | BILL_SEQUENCE_ID |
EGP_COMPONENTS_B | egp_components_b | OLD_COMPONENT_SEQUENCE_ID |
egp_substitute_components | egp_components_b | COMPONENT_SEQUENCE_ID |
egp_components_b | egp_components_b | OLD_COMPONENT_SEQUENCE_ID |
egp_component_operations | egp_components_b | COMPONENT_SEQUENCE_ID |
egp_reference_designators | egp_components_b | COMPONENT_SEQUENCE_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
EGP_COMPONENTS_B_N10 | Non Unique | Default | COMMON_COMPONENT_SEQUENCE_ID |
EGP_COMPONENTS_B_N12 | Non Unique | Default | PK1_VALUE, PK2_VALUE |
EGP_COMPONENTS_B_N13 | Non Unique | Default | CHANGE_ID |
EGP_COMPONENTS_B_N14 | Non Unique | Default | REQUEST_ID |
EGP_COMPONENTS_B_N3 | Non Unique | Default | REVISED_ITEM_SEQUENCE_ID |
EGP_COMPONENTS_B_N4 | Non Unique | Default | OLD_COMPONENT_SEQUENCE_ID |
EGP_COMPONENTS_B_N6 | Non Unique | Default | BILL_SEQUENCE_ID, FROM_END_ITEM_UNIT_NUMBER |
EGP_COMPONENTS_B_N8 | Non Unique | Default | BILL_SEQUENCE_ID, EFFECTIVITY_DATE, OPERATION_SEQ_NUM, FROM_END_ITEM_UNIT_NUMBER |
EGP_COMPONENTS_B_N9 | Non Unique | Default | CHANGE_LINE_ID |
EGP_COMPONENTS_B_U2 | Unique | Default | COMPONENT_SEQUENCE_ID |