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.
Joins (inferred from key columns): INVENTORY_ITEM_ID → INV_LICENSE_PLATE_NUMBERS · ORGANIZATION_ID → INV_ORGANIZATION_DEFINITIONS_V

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
Problems that run through this table
Inventory as of any date · What the extract does not carry · The export ceiling