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