Oracle Fusion · Data dictionary
EGP_SYSTEM_ITEMS_B
SharedUsed in 76 subject areas97 reporting columns
Product Hub / Items (EGP), base table, language-neutral data (paired with _TL labels and the _VL view).
Primary key: not yet catalogued for EGP_SYSTEM_ITEMS_B, reference Oracle Tables & Views guide.
Joins (inferred from key columns): INVENTORY_ITEM_ID → INV_LICENSE_PLATE_NUMBERS · ORGANIZATION_ID → INV_ORGANIZATION_DEFINITIONS_V
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ALLOWED_UNITS_LOOKUP_CODE | ● | Lookup code for the allowed units. | |
| ALLOW_EXPRESS_DELIVERY_FLAG | ● | Indicator (Y/N) for the allow express delivery. | |
| ALLOW_SUBSTITUTE_RECEIPTS_FLAG | ● | Indicator (Y/N) for the allow substitute receipts. | |
| ALLOW_UNORDERED_RECEIPTS_FLAG | ● | Indicator (Y/N) for the allow unordered receipts. | |
| APPROVAL_STATUS | ● | Status of the approval. | |
| ASSET_CATEGORY_ID | ● | Identifier for the asset category. | |
| ATP_COMPONENTS_FLAG | ● | Indicator (Y/N) for the atp components. | |
| ATP_FLAG | ● | Indicator (Y/N) for the atp. | |
| BOM_ITEM_TYPE | ● | Type of bom item. | |
| BULK_PICKED_FLAG | ● | Indicator (Y/N) for the bulk picked. | |
| CHARGE_PERIODICITY_CODE | ● | Code identifying the charge periodicity. | |
| COLLATERAL_FLAG | ● | Indicator (Y/N) for the collateral. | |
| CONFIG_MODEL_TYPE | ● | Type of config model. | |
| CONTAINER_ITEM_FLAG | ● | Indicator (Y/N) for the container item. | |
| CONTAINER_TYPE_CODE | ● | Code identifying the container type. | |
| COSTING_ENABLED_FLAG | ● | Indicator (Y/N) for the costing enabled. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CUSTOMER_ORDER_ENABLED_FLAG | ● | Indicator (Y/N) for the customer order enabled. | |
| CUSTOMER_ORDER_FLAG | ● | Indicator (Y/N) for the customer order. | |
| CYCLE_COUNT_ENABLED_FLAG | ● | Indicator (Y/N) for the cycle count enabled. | |
| DEFAULT_INCLUDE_IN_ROLLUP_FLAG | ● | Indicator (Y/N) for the default include in rollup. | |
| DIMENSION_UOM_CODE | ● | Code identifying the dimension unit of measure. | |
| DOWNLOADABLE_FLAG | ● | Indicator (Y/N) for the downloadable. | |
| DUAL_UOM_CONTROL | ● | Dual unit of measure control. | |
| EFFECTIVITY_CONTROL | ● | Effectivity control. | |
| ELECTRONIC_FLAG | ● | Indicator (Y/N) for the electronic. | |
| ELIGIBILITY_COMPATIBILITY_RULE | ● | Eligibility compatibility rule. | |
| EQUIPMENT_TYPE | ● | Type of equipment. | |
| EVENT_FLAG | ● | Indicator (Y/N) for the event. | |
| GRADE_CONTROL_FLAG | ● | Indicator (Y/N) for the grade control. | |
| HAZARD_CLASS_ID | ● | Identifier for the hazard class. | |
| HOLD_DAYS | ● | Hold days. | |
| INDIVISIBLE_FLAG | ● | Indicator (Y/N) for the indivisible. | |
| INTERNAL_ORDER_ENABLED_FLAG | ● | Indicator (Y/N) for the internal order enabled. | |
| INTERNAL_ORDER_FLAG | ● | Indicator (Y/N) for the internal order. | |
| INVENTORY_ASSET_FLAG | ● | Indicator (Y/N) for the inventory asset. | |
| INVENTORY_ITEM_ID | ● | Identifier for the inventory item. | |
| INVOICEABLE_ITEM_FLAG | ● | Indicator (Y/N) for the invoiceable item. | |
| INVOICE_ENABLED_FLAG | ● | Indicator (Y/N) for the invoice enabled. | |
| INVOICE_MATCH_OPTION | ● | Invoice match option. | |
| ITEM_NUMBER | ● | Item number. | |
| ITEM_TYPE | ● | Type of item. | |
| LIST_PRICE_PER_UNIT | ● | List price per unit. | |
| LOCATION_CONTROL_CODE | ● | Code identifying the location control. | |
| LOT_CONTROL_CODE | ● | Code identifying the lot control. | |
| LOT_STATUS_ENABLED | ● | Lot status enabled. | |
| LOT_TRANSLATE_ENABLED | ● | Lot translate enabled. | |
| MARKET_PRICE | ● | Market price. | |
| MATCH_APPROVAL_LEVEL | ● | Match approval level. | |
| MATURITY_DAYS | ● | Maturity days. | |
| MTL_TRANSACTIONS_ENABLED_FLAG | ● | Indicator (Y/N) for the mtl transactions enabled. | |
| ONT_PRICING_QTY_SOURCE | ● | Ont pricing quantity source. | |
| ORGANIZATION_ID | ● | Identifier for the organization. | |
| OUTSIDE_OPERATION_FLAG | ● | Indicator (Y/N) for the outside operation. | |
| OUTSIDE_OPERATION_UOM_TYPE | ● | Type of outside operation unit of measure. | |
| OUTSOURCED_ASSEMBLY | ● | Outsourced assembly. | |
| PICK_COMPONENTS_FLAG | ● | Indicator (Y/N) for the pick components. | |
| PRIMARY_UOM_CODE | ● | Code identifying the primary unit of measure. | |
| PURCHASING_ENABLED_FLAG | ● | Indicator (Y/N) for the purchasing enabled. | |
| PURCHASING_ITEM_FLAG | ● | Indicator (Y/N) for the purchasing item. | |
| PURCHASING_TAX_CODE | ● | Code identifying the purchasing tax. | |
| QTY_RCV_EXCEPTION_CODE | ● | Code identifying the quantity receiving exception. | |
| RECEIPT_DAYS_EXCEPTION_CODE | ● | Code identifying the receipt days exception. | |
| RECEIVING_ROUTING_ID | ● | Identifier for the receiving routing. | |
| RESERVABLE_TYPE | ● | Type of reservable. | |
| RESTRICT_LOCATORS_CODE | ● | Code identifying the restrict locators. | |
| RESTRICT_SUBINVENTORIES_CODE | ● | Code identifying the restrict subinventories. | |
| RETURNABLE_FLAG | ● | Indicator (Y/N) for the returnable. | |
| RETURN_INSPECTION_REQUIREMENT | ● | Return inspection requirement. | |
| REVISION_QTY_CONTROL_CODE | ● | Code identifying the revision quantity control. | |
| SALES_PRODUCT_TYPE | ● | Type of sales product. | |
| SECONDARY_UOM_CODE | ● | Code identifying the secondary unit of measure. | |
| SERIAL_NUMBER_CONTROL_CODE | ● | Code identifying the serial number control. | |
| SERIAL_STATUS_ENABLED | ● | Serial status enabled. | |
| SHELF_LIFE_CODE | ● | Code identifying the shelf life. | |
| SHELF_LIFE_DAYS | ● | Shelf life days. | |
| SHIPPABLE_ITEM_FLAG | ● | Indicator (Y/N) for the shippable item. | |
| SHIP_MODEL_COMPLETE_FLAG | ● | Indicator (Y/N) for the shipment model complete. | |
| SOURCE_ORGANIZATION_ID | ● | Identifier for the source organization. | |
| SO_TRANSACTIONS_FLAG | ● | Indicator (Y/N) for the so transactions. | |
| STOCK_ENABLED_FLAG | ● | Indicator (Y/N) for the stock enabled. | |
| STYLE_ITEM_FLAG | ● | Indicator (Y/N) for the style item. | |
| STYLE_ITEM_ID | ● | Identifier for the style item. | |
| TAXABLE_FLAG | ● | Indicator (Y/N) for the taxable. | |
| TAX_CODE | ● | Code identifying the tax. | |
| TRACKING_QUANTITY_IND | ● | Tracking quantity ind. | |
| TRADE_ITEM_DESCRIPTOR | ● | Trade item descriptor. | |
| UNIT_HEIGHT | ● | Unit height. | |
| UNIT_LENGTH | ● | Unit length. | |
| UNIT_OF_ISSUE | ● | Unit of issue. | |
| UNIT_VOLUME | ● | Unit volume. | |
| UNIT_WEIGHT | ● | Unit weight. | |
| UNIT_WIDTH | ● | Unit width. | |
| UN_NUMBER_ID | ● | Identifier for the un number. | |
| VEHICLE_ITEM_FLAG | ● | Indicator (Y/N) for the vehicle item. | |
| VOLUME_UOM_CODE | ● | Code identifying the volume unit of measure. | |
| WEIGHT_UOM_CODE | ● | Code identifying the weight unit of measure. |
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.
- Costing - COGS and Gross Margin Real Time
- Costing - Cost Accounting Real Time
- Costing - Inventory Valuation Real Time
- Costing - Item Cost Real Time
- Costing - Receipt Accounting Real Time
- Distributed Order Orchestration - Fulfillment Lines Real Time
- Distributed Order Orchestration - Order Holds Real Time
- Distributed Order Orchestration - Order Lines Real Time
- Distributed Order Orchestration - Price Adjustments Real Time
- Inventory - Inventory Balance Real Time
- Inventory - Inventory Supply Real Time
- Inventory - Inventory Transactions Real Time
- Maintenance Management - Asset Equipment Qualification Real Time
- Maintenance Management - Asset Failure Analysis Real Time
- Maintenance Management - Asset History Real Time
- Maintenance Management - Asset Real Time
- Maintenance Management - Forecast Real Time
- Maintenance Management - Maintenance Exception Real Time
- Maintenance Management - Material Usage Real Time
- Maintenance Management - Purchased Item Usage Real Time
Need the extract + dbt staging for EGP_SYSTEM_ITEMS_B?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table