Oracle Fusion · Data dictionary
EGP_COMPONENTS_B
SharedUsed in 6 subject areas51 reporting columns
Product Hub / Items (EGP), base table, language-neutral data (paired with _TL labels and the _VL view).
Likely primary key: COMPONENT_SEQUENCE_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ABSOLUTE_YIELD | ● | Absolute yield. | |
| AUTO_REQUEST_MATERIAL | ● | Auto request material. | |
| BASIS_TYPE | ● | Type of basis. | |
| BOM_ITEM_TYPE | ● | Type of bom item. | |
| CHANGE_ID | ● | Identifier for the change. | |
| CHECK_ATP | ● | Check atp. | |
| COMPLETION_TYPE | ● | Type of completion. | |
| COMPONENT_QUANTITY | ● | Component quantity. | |
| COMPONENT_REMARKS | ● | Component remarks. | |
| COMPONENT_SEQUENCE_ID | PK? | ● | Identifier for the component sequence. |
| COMPONENT_TYPE | ● | Type of component. | |
| COMPONENT_YIELD_FACTOR | ● | Component yield factor. | |
| CONTRIBUTE_TO_YIELD | ● | Contribute to yield. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DELETE_GROUP_NAME | ● | Name of the delete group. | |
| DG_DESCRIPTION | ● | Description of the dg. | |
| DISABLE_DATE | ● | Disable date. | |
| EFFECTIVITY_DATE | ● | Effectivity date. | |
| ENFORCE_INT_REQUIREMENTS | ● | Enforce int requirements. | |
| HIGH_QUANTITY | ● | High quantity. | |
| IMPLEMENTATION_DATE | ● | Implementation date. | |
| INCLUDE_ON_BILL_DOCS | ● | Include on bill docs. | |
| INCLUDE_ON_SHIP_DOCS | ● | Include on shipment docs. | |
| INSTANTIABILITY_CODE | ● | Code identifying the instantiability. | |
| ITEM_NUM | ● | Item number. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| LOW_QUANTITY | ● | Low quantity. | |
| MUTUALLY_EXCLUSIVE_OPTIONS | ● | Mutually exclusive options. | |
| OBJ_NAME | ● | Name of the obj. | |
| OPERATION_LEAD_TIME_PERCENT | ● | Operation lead time percentage. | |
| OPERATION_SEQ_NUM | ● | Operation seq number. | |
| OPTIONAL | ● | Optional. | |
| OPTIONAL_ON_MODEL | ● | Optional on model. | |
| PICK_COMPONENTS | ● | Pick components. | |
| PK2_VALUE | ● | Pk2 value. | |
| PLANNING_FACTOR | ● | Planning factor. | |
| PRIMARY_UOM_CODE | ● | Code identifying the primary unit of measure. | |
| PRODUCT_TYPE | ● | Type of product. | |
| REPLACED_BY_COMPONENT | ● | Replaced by component. | |
| REPLACED_FOR_COMPONENT | ● | Replaced for component. | |
| REQUIRED_FOR_REVENUE | ● | Required for revenue. | |
| REQUIRED_TO_SHIP | ● | Required to shipment. | |
| SHIPPING_ALLOWED | ● | Shipping allowed. | |
| SHOW_IN_SALES | ● | Show in sales. | |
| SO_BASIS | ● | So basis. | |
| SUGGESTED_OPERATION_SEQ_NUM | ● | Suggested operation seq number. | |
| SUPPLY_SUBINVENTORY | ● | Supply subinventory. | |
| UNIT_PRICE | ● | Unit price. | |
| WIP_SUPPLY_TYPE | ● | Type of work in process supply. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.
- Manufacturing - Work Definitions Real Time
- Product Management - Components Real Time
- Product Management - Organization Hierarchy Real Time
- Product Management - Structures Real Time
- Product Management - Structures and Components Real Time
- Product Management - Where Used Real Time
Need the extract + dbt staging for EGP_COMPONENTS_B?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table