Analytics Catalog/Data dictionary/EGP_SYSTEM_ITEMS_B_V
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

EGP_SYSTEM_ITEMS_B_V

SharedUsed in 112 subject areas272 reporting columns

Product Hub / Items (EGP) — denormalized view.

Primary key: not yet catalogued for EGP_SYSTEM_ITEMS_B_V — reference Oracle Tables & Views guide.

Columns

ColumnKeyIn reportsDescription (inferred)
ACCEPTABLE_EARLY_DAYS●Acceptable early days.
ACD_TYPE●Type of acd.
ALLOWED_UNITS_LOOKUP_CODE●Lookup code for the allowed units.
ALLOW_EXPRESS_DELIVERY_FLAG●Indicator (Y/N) for the allow express delivery.
ALLOW_ITEM_DESC_UPDATE_FLAG●Indicator (Y/N) for the allow item description update.
ALLOW_MAINTENANCE_ASSET_FLAG●Indicator (Y/N) for the allow maintenance asset.
ALLOW_SUBSTITUTE_RECEIPTS_FLAG●Indicator (Y/N) for the allow substitute receipts.
ALLOW_SUSPEND_FLAG●Indicator (Y/N) for the allow suspend.
ALLOW_TERMINATE_FLAG●Indicator (Y/N) for the allow terminate.
ALLOW_UNORDERED_RECEIPTS_FLAG●Indicator (Y/N) for the allow unordered receipts.
APPROVAL_STATUS●Status of the approval.
ASN_AUTOEXPIRE_FLAG●Indicator (Y/N) for the advance shipment notice autoexpire.
ASSET_CLASS●Asset class.
ASSET_CREATION_CODE●Code identifying the asset creation.
ASSET_TRACKED_FLAG●Indicator (Y/N) for the asset tracked.
ATO_FORECAST_CONTROL●Ato forecast control.
ATP_COMPONENTS_FLAG●Indicator (Y/N) for the atp components.
ATP_FLAG●Indicator (Y/N) for the atp.
AUTO_CREATED_CONFIG_FLAG●Indicator (Y/N) for the auto created config.
AUTO_LOT_ALPHA_PREFIX●Auto lot alpha prefix.
AUTO_SERIAL_ALPHA_PREFIX●Auto serial alpha prefix.
BACK_ORDERABLE_FLAG●Indicator (Y/N) for the back orderable.
BACK_TO_BACK_ENABLED●Back to back enabled.
BASE_ITEM_ID●Identifier for the base item.
BOM_ITEM_TYPE●Type of bom item.
BUILD_IN_WIP_FLAG●Indicator (Y/N) for the build in work in process.
BULK_PICKED_FLAG●Indicator (Y/N) for the bulk picked.
CARRYING_COST●Carrying cost.
CAS_NUMBER●Cas number.
CHARGE_PERIODICITY_CODE●Code identifying the charge periodicity.
CHECK_SHORTAGES_FLAG●Indicator (Y/N) for the check shortages.
CHILD_LOT_FLAG●Indicator (Y/N) for the child lot.
CHILD_LOT_PREFIX●Child lot prefix.
CHILD_LOT_STARTING_NUMBER●Child lot starting number.
CHILD_LOT_VALIDATION_FLAG●Indicator (Y/N) for the child lot validation.
COLLATERAL_FLAG●Indicator (Y/N) for the collateral.
COMMS_ACTIVATION_REQD_FLAG●Indicator (Y/N) for the comms activation reqd.
COMMS_NL_TRACKABLE_FLAG●Indicator (Y/N) for the comms nl trackable.
COMN_SUPPLY_PRJ_DEMAND_FLAG●Indicator (Y/N) for the comn supply prj demand.
COMPLETENESS_SCORE●Completeness score.
CONFIG_MATCH●Config match.
CONFIG_MODEL_TYPE●Type of config model.
CONFIG_ORGS●Config orgs.
CONSIGNED_FLAG●Indicator (Y/N) for the consigned.
CONTAINER_ITEM_FLAG●Indicator (Y/N) for the container item.
CONTAINER_TYPE_CODE●Code identifying the container type.
CONTRACT_MANUFACTURING●Contract manufacturing.
COPY_LOT_ATTRIBUTE_FLAG●Indicator (Y/N) for the copy lot attribute.
COSTING_ENABLED_FLAG●Indicator (Y/N) for the costing enabled.
COVERAGE_SCHEDULE_ID●Identifier for the coverage schedule.
CREATED_BY●User who created the row.
CREATE_FIXED_ASSET●Create fixed asset.
CREATE_SUPPLY_AFTER_DATE●Create supply after date.
CREATE_SUPPLY_FLAG●Indicator (Y/N) for the create supply.
CREATION_DATE●Date and time the row was created.
CSS_ENABLED_FLAG●Indicator (Y/N) for the css enabled.
CUMULATIVE_TOTAL_LEAD_TIME●Cumulative total lead time.
CUM_MANUFACTURING_LEAD_TIME●Cum manufacturing lead time.
CURRENT_PHASE_CODE●Code identifying the current phase.
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.
DAYS_EARLY_RECEIPT_ALLOWED●Days early receipt allowed.
DAYS_LATE_RECEIPT_ALLOWED●Days late receipt allowed.
DAYS_OF_COVER●Days of cover.
DEFAULT_GRADE●Default grade.
DEFAULT_INCLUDE_IN_ROLLUP_FLAG●Indicator (Y/N) for the default include in rollup.
DEFAULT_SHIPPING_ORG●Default shipping organization.
DEFAULT_SO_SOURCE_TYPE●Type of default so source.
DEFECT_TRACKING_ON_FLAG●Indicator (Y/N) for the defect tracking on.
DEMAND_PERIOD●Demand period.
DEMAND_TIME_FENCE_CODE●Code identifying the demand time fence.
DEMAND_TIME_FENCE_DAYS●Demand time fence days.
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.
DUAL_UOM_DEVIATION_HIGH●Dual unit of measure deviation high.
DUAL_UOM_DEVIATION_LOW●Dual unit of measure deviation low.
EAM_ACTIVITY_CAUSE_CODE●Code identifying the eam activity cause.
EAM_ACTIVITY_SOURCE_CODE●Code identifying the eam activity source.
EAM_ACTIVITY_TYPE_CODE●Code identifying the eam activity type.
EAM_ACT_NOTIFICATION_FLAG●Indicator (Y/N) for the eam act notification.
EAM_ACT_SHUTDOWN_STATUS●Status of the eam act shutdown.
EAM_ITEM_TYPE●Type of eam item.
EFFECTIVITY_CONTROL●Effectivity control.
ELECTRONIC_FLAG●Indicator (Y/N) for the electronic.
ELIGIBILITY_COMPATIBILITY_RULE●Eligibility compatibility rule.
ENABLE_GENEALOGY_TRACKING_FLAG●Indicator (Y/N) for the enable genealogy tracking.
ENABLE_IOT_FLAG●Indicator (Y/N) for the enable iot.
ENFORCE_SHIP_TO_LOCATION_CODE●Code identifying the enforce shipment to location.
ENGINEERED_ITEM_FLAG●Indicator (Y/N) for the engineered item.
EQUIPMENT_TYPE●Type of equipment.
EVENT_FLAG●Indicator (Y/N) for the event.
EXPENDITURE_TYPE_ID●Identifier for the expenditure type.
EXPIRATION_ACTION_INTERVAL●Expiration action interval.
FINANCING_ALLOWED_FLAG●Indicator (Y/N) for the financing allowed.
FIXED_DAYS_SUPPLY●Fixed days supply.
FIXED_LEAD_TIME●Fixed lead time.
FIXED_LOT_MULTIPLIER●Fixed lot multiplier.
FIXED_ORDER_QUANTITY●Fixed order quantity.
FORCE_PURCHASE_LEAD_TIME_FLAG●Indicator (Y/N) for the force purchase lead time.
FORECAST_HORIZON●Forecast horizon.
FULL_LEAD_TIME●Full lead time.
GRADE_CONTROL_FLAG●Indicator (Y/N) for the grade control.
HARD_PEGGING_LEVEL●Hard pegging level.
HAZARDOUS_MATERIAL_FLAG●Indicator (Y/N) for the hazardous material.
HAZARD_CLASS_ID●Identifier for the hazard class.
HOLD_DAYS●Hold days.
IB_ITEM_INSTANCE_CLASS●Ib item instance class.
INDIVISIBLE_FLAG●Indicator (Y/N) for the indivisible.
INSPECTION_REQUIRED_FLAG●Indicator (Y/N) for the inspection required.
INTERNAL_ORDER_ENABLED_FLAG●Indicator (Y/N) for the internal order enabled.
INTERNAL_ORDER_FLAG●Indicator (Y/N) for the internal order.
INTERNAL_VOLUME●Internal volume.
INVENTORY_ASSET_FLAG●Indicator (Y/N) for the inventory asset.
INVENTORY_CARRY_PENALTY●Inventory carry penalty.
INVENTORY_ITEM_FLAG●Indicator (Y/N) for the inventory item.
INVENTORY_ITEM_ID●Identifier for the inventory item.
INVENTORY_PLANNING_CODE●Code identifying the inventory planning.
INVOICEABLE_ITEM_FLAG●Indicator (Y/N) for the invoiceable item.
INVOICE_CLOSE_TOLERANCE●Invoice close tolerance.
INVOICE_ENABLED_FLAG●Indicator (Y/N) for the invoice enabled.
INVOICE_MATCH_OPTION●Invoice match option.
ITEM_NUMBER●Item number.
ITEM_OBJECT_TYPE●Type of item object.
ITEM_TYPE●Type of item.
LAST_UPDATED_BY●User who last updated the row.
LAST_UPDATE_DATE●Date and time the row was last updated (the incremental-extract key).
LEAD_TIME_LOT_SIZE●Lead time lot size.
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_DIVISIBLE_FLAG●Indicator (Y/N) for the lot divisible.
LOT_MERGE_ENABLED●Lot merge enabled.
LOT_SPLIT_ENABLED●Lot split enabled.
LOT_STATUS_ENABLED●Lot status enabled.
LOT_SUBSTITUTION_ENABLED●Lot substitution enabled.
LOT_TRANSLATE_ENABLED●Lot translate enabled.
MARKET_PRICE●Market price.
MATCH_APPROVAL_LEVEL●Match approval level.
MATERIAL_BILLABLE_FLAG●Indicator (Y/N) for the material billable.
MATURITY_DAYS●Maturity days.
MAXIMUM_LOAD_WEIGHT●Maximum load weight.
MAXIMUM_ORDER_QUANTITY●Maximum order quantity.
MAX_MINMAX_QUANTITY●Max minmax quantity.
MINIMUM_FILL_PERCENT●Minimum fill percentage.
MINIMUM_LICENSE_QUANTITY●Minimum license quantity.
MINIMUM_ORDER_QUANTITY●Minimum order quantity.
MIN_MINMAX_QUANTITY●Min minmax quantity.
MRP_CALCULATE_ATP_FLAG●Indicator (Y/N) for the mrp calculate atp.
MRP_PLANNING_CODE●Code identifying the mrp planning.
MTL_TRANSACTIONS_ENABLED_FLAG●Indicator (Y/N) for the mtl transactions enabled.
MUST_USE_APPROVED_VENDOR_FLAG●Indicator (Y/N) for the must use approved vendor.
NEGATIVE_MEASUREMENT_ERROR●Negative measurement error.
NEGOTIATION_REQUIRED_FLAG●Indicator (Y/N) for the negotiation required.
ONT_PRICING_QTY_SOURCE●Ont pricing quantity source.
OPERATION_SLACK_PENALTY●Operation slack penalty.
ORDERABLE_ON_WEB_FLAG●Indicator (Y/N) for the orderable on web.
ORDER_COST●Order cost.
ORDER_MODIFIER_START_QTY_FLAG●Indicator (Y/N) for the order modifier start quantity.
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.
OUTSIDE_PROCESS_SERVICE_FLAG●Indicator (Y/N) for the outside process service.
OUTSOURCED_ASSEMBLY●Outsourced assembly.
OVERCOMPLETION_TOLERANCE_TYPE●Type of overcompletion tolerance.
OVERCOMPLETION_TOLERANCE_VALUE●Overcompletion tolerance value.
OVER_RETURN_TOLERANCE●Over return tolerance.
OVER_SHIPMENT_TOLERANCE●Over shipment tolerance.
PARENT_CHILD_GENERATION_FLAG●Indicator (Y/N) for the parent child generation.
PARTS_SOURCING●Parts sourcing.
PICK_COMPONENTS_FLAG●Indicator (Y/N) for the pick components.
PLANNING_MAKE_BUY_CODE●Code identifying the planning make buy.
PLANNING_TIME_FENCE_CODE●Code identifying the planning time fence.
PLANNING_TIME_FENCE_DAYS●Planning time fence days.
POSITIVE_MEASUREMENT_ERROR●Positive measurement error.
POSTPROCESSING_LEAD_TIME●Postprocessing lead time.
PREPROCESSING_LEAD_TIME●Preprocessing lead time.
PRICE_TOLERANCE_PERCENT●Price tolerance percentage.
PRIMARY_UOM_CODE●Code identifying the primary unit of measure.
PROCESS_COSTING_ENABLED_FLAG●Indicator (Y/N) for the process costing enabled.
PROCESS_EXECUTION_ENABLED_FLAG●Indicator (Y/N) for the process execution enabled.
PROCESS_QUALITY_ENABLED_FLAG●Indicator (Y/N) for the process quality enabled.
PROCESS_SUPPLY_SUBINVENTORY●Process supply subinventory.
PROCESS_YIELD_LOCATOR_ID●Identifier for the process yield locator.
PROCESS_YIELD_SUBINVENTORY●Process yield subinventory.
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.
QTY_RCV_TOLERANCE●Quantity receiving tolerance.
RECEIPT_DAYS_EXCEPTION_CODE●Code identifying the receipt days exception.
RECEIVE_CLOSE_TOLERANCE●Receive close tolerance.
RECEIVING_ROUTING_ID●Identifier for the receiving routing.
RECIPE_ENABLED_FLAG●Indicator (Y/N) for the recipe enabled.
RECOVERED_PART_DISP_CODE●Code identifying the recovered part disp.
RELEASE_TIME_FENCE_CODE●Code identifying the release time fence.
RELEASE_TIME_FENCE_DAYS●Release time fence days.
REPAIR_TRANSACTION_CODE●Code identifying the repair transaction.
REPLACEMENT_TYPE●Type of replacement.
REPLENISH_TO_ORDER_FLAG●Indicator (Y/N) for the replenish to order.
REQUIRES_FULFILLMENT_LOC_FLAG●Indicator (Y/N) for the requires fulfillment loc.
REQUIRES_ITM_ASSOCIATION_FLAG●Indicator (Y/N) for the requires itm association.
RESERVABLE_TYPE●Type of reservable.
RESTRICT_LOCATORS_CODE●Code identifying the restrict locators.
RESTRICT_SUBINVENTORIES_CODE●Code identifying the restrict subinventories.
RETEST_INTERVAL●Retest interval.
RETURNABLE_FLAG●Indicator (Y/N) for the returnable.
RETURN_INSPECTION_REQUIREMENT●Return inspection requirement.
REVISION_QTY_CONTROL_CODE●Code identifying the revision quantity control.
ROUNDING_CONTROL_TYPE●Type of rounding control.
ROUNDING_FACTOR●Rounding factor.
SAFETY_STOCK_PLANNING_METHOD●Safety stock planning method.
SALES_ACCOUNT●Sales account.
SALES_PRODUCT_TYPE●Type of sales product.
SECONDARY_DEFAULT_IND●Secondary default ind.
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.
SERVICEABLE_PRODUCT_FLAG●Indicator (Y/N) for the serviceable product.
SERVICE_DURATION●Service duration.
SERVICE_DURATION_PERIOD_CODE●Code identifying the service duration period.
SERVICE_DURATION_TYPE_CODE●Code identifying the service duration type.
SERVICE_START_DELAY●Service start delay.
SERVICE_START_TYPE_CODE●Code identifying the service start type.
SERV_BILLING_ENABLED_FLAG●Indicator (Y/N) for the serv billing enabled.
SERV_REQ_ENABLED_CODE●Code identifying the serv req 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.
SHRINKAGE_RATE●Shrinkage rate.
SOURCE_ORGANIZATION_ID●Identifier for the source organization.
SOURCE_SUBINVENTORY●Source subinventory.
SOURCE_TYPE●Type of source.
SO_AUTHORIZATION_FLAG●Indicator (Y/N) for the so authorization.
SO_TRANSACTIONS_FLAG●Indicator (Y/N) for the so transactions.
START_AUTO_LOT_NUMBER●Start auto lot number.
START_AUTO_SERIAL_NUMBER●Start auto serial number.
STD_LOT_SIZE●Std lot size.
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.
SUBCONTRACTING_COMPONENT●Subcontracting component.
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.
UNDER_COMPL_TOLERANCE_TYPE●Type of under compl tolerance.
UNDER_COMPL_TOLERANCE_VALUE●Under compl tolerance value.
UNDER_RETURN_TOLERANCE●Under return tolerance.
UNDER_SHIPMENT_TOLERANCE●Under shipment tolerance.
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.
VARIABLE_LEAD_TIME●Variable lead time.
VEHICLE_ITEM_FLAG●Indicator (Y/N) for the vehicle item.
VMI_FIXED_ORDER_QUANTITY●Vmi fixed order quantity.
VMI_FORECAST_TYPE●Type of vmi forecast.
VMI_MAXIMUM_DAYS●Vmi maximum days.
VMI_MAXIMUM_UNITS●Vmi maximum units.
VMI_MINIMUM_DAYS●Vmi minimum days.
VMI_MINIMUM_UNITS●Vmi minimum units.
VOLUME_UOM_CODE●Code identifying the volume unit of measure.
WEB_STATUS●Status of the web.
WEIGHT_UOM_CODE●Code identifying the weight unit of measure.
WIP_SUPPLY_SUBINVENTORY●Work in process supply subinventory.
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.

Need the extract + dbt staging for EGP_SYSTEM_ITEMS_B_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us