DBA Data[Home] [Help] [Dependency Information]


TABLE: INV.MTL_SYSTEM_ITEMS_B

Object Details
Object Name: MTL_SYSTEM_ITEMS_B
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.MTL_SYSTEM_ITEMS_B
Subobject Name:
Status: VALID


MTL_SYSTEM_ITEMS_B is the definition table for items. This table holds
the definitions for inventory items, engineering items, and purchasing
items. You can specify item-related information in fields such as:
Bill of Material, Costing, Purchasing, Receiving, Inventory, Physical attributes, General Planning, MPS/MRP Planning, Lead times, Work in Process, Order Management, and Invoicing.
.
You can set up the item with multiple segments, since it is
implemented as a flexfield. Use the standard 'System Items' flexfield
that is shipped with the product to configure your item flexfield.
The flexfield code is MSTK.
.
The primary key for an item is the INVENTORY_ITEM_ID and ORGANIZATION_ID. Therefore, the same item can be defined in more than one organization.
.
Each item is initially defined in an item master organization. The
user then assigns the item to other organizations that need to
recognize this item. A row is inserted for each new organization
the item is assigned to. Many columns such as MTL_TRANSACTIONS_ENABLED_FLAG and
BOM_ENABLED_FLAG correspond to item attributes defined in the
MTL_ITEM_ATTRIBUTES table. The attributes that are available to the
user depend on which Oracle applications are installed. The table
MTL_ATTR_APPL_DEPENDENCIES maintains the relationships between item
attributes and Oracle applications.
.
Two unit of measure columns are stored in MTL_SYSTEM_ITEMS_B table. PRIMARY_UOM_CODE is the 3-character unit that is used throughout Oracle Manufacturing. PRIMARY_UNIT_OF_MEASURE is the 25-character Unit of Measure that is used throughout Oracle Purchasing. Unlike the PRIMARY_UOM_CODE, the Unit of Measure is language-dependent attribute, however, PRIMARY_UNIT_OF_MEASURE column stores value in the installation base language only.
.
Items now support multilingual description. MLS is implemented with a pair of tables: MTL_SYSTEM_ITEMS_B and MTL_SYSTEM_ITEMS_TL. Translations table (MTL_SYSTEM_ITEMS_TL) holds item Description and Long Description in multiple languages. DESCRIPTION column in the base table (MTL_SYSTEM_ITEMS_B) is for backward compatibility and is maintained in the installation base language only.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_SYSTEM_ITEMS_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVENTORY_ITEM_ID
ColumnORGANIZATION_ID
MTL_SYSTEM_ITEMS_B_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnSEGMENT1
MTL_SYSTEM_ITEMS_B_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnPLANNER_CODE
MTL_SYSTEM_ITEMS_B_N11 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnWEB_STATUS
ColumnORGANIZATION_ID
MTL_SYSTEM_ITEMS_B_N12 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnCUSTOMER_ORDER_ENABLED_FLAG
ColumnSERVICE_ITEM_FLAG
ColumnVENDOR_WARRANTY_FLAG
ColumnUSAGE_ITEM_FLAG
MTL_SYSTEM_ITEMS_B_N13 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnWIP_SUPPLY_LOCATOR_ID
MTL_SYSTEM_ITEMS_B_N14 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBASE_ITEM_ID
ColumnORGANIZATION_ID
MTL_SYSTEM_ITEMS_B_N15 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTYLE_ITEM_ID
ColumnORGANIZATION_ID
MTL_SYSTEM_ITEMS_B_N16 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnEAM_ITEM_TYPE
MTL_SYSTEM_ITEMS_B_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnDESCRIPTION
MTL_SYSTEM_ITEMS_B_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVENTORY_ITEM_STATUS_CODE
MTL_SYSTEM_ITEMS_B_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnAUTO_CREATED_CONFIG_FLAG
MTL_SYSTEM_ITEMS_B_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnWH_UPDATE_DATE
MTL_SYSTEM_ITEMS_B_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnITEM_CATALOG_GROUP_ID
ColumnCATALOG_STATUS_FLAG
MTL_SYSTEM_ITEMS_B_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRODUCT_FAMILY_ITEM_ID
ColumnORGANIZATION_ID
MTL_SYSTEM_ITEMS_B_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOMMS_NL_TRACKABLE_FLAG
ColumnORGANIZATION_ID
MTL_SYSTEM_ITEMS_B_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnBUYER_ID
Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
SUMMARY_FLAG VARCHAR2 (1) Yes Flexfield summary flag
ENABLED_FLAG VARCHAR2 (1) Yes Flexfield segment enabled flag
START_DATE_ACTIVE DATE

Flexfield segment start date
END_DATE_ACTIVE DATE

Flexfield segment end date
DESCRIPTION VARCHAR2 (240)
Item description is maintained in the installation base language only. Translations table (MTL_SYSTEM_ITEMS_TL) holds item descriptions in multiple languages
BUYER_ID NUMBER (9)
Buyer identifier
ACCOUNTING_RULE_ID NUMBER

Accounting rule identifier
INVOICING_RULE_ID NUMBER

Invoicing rule identifier
SEGMENT1 VARCHAR2 (40)
Key flexfield segment
SEGMENT2 VARCHAR2 (40)
Key flexfield segment
SEGMENT3 VARCHAR2 (40)
Key flexfield segment
SEGMENT4 VARCHAR2 (40)
Key flexfield segment
SEGMENT5 VARCHAR2 (40)
Key flexfield segment
SEGMENT6 VARCHAR2 (40)
Key flexfield segment
SEGMENT7 VARCHAR2 (40)
Key flexfield segment
SEGMENT8 VARCHAR2 (40)
Key flexfield segment
SEGMENT9 VARCHAR2 (40)
Key flexfield segment
SEGMENT10 VARCHAR2 (40)
Key flexfield segment
SEGMENT11 VARCHAR2 (40)
Key flexfield segment
SEGMENT12 VARCHAR2 (40)
Key flexfield segment
SEGMENT13 VARCHAR2 (40)
Key flexfield segment
SEGMENT14 VARCHAR2 (40)
Key flexfield segment
SEGMENT15 VARCHAR2 (40)
Key flexfield segment
SEGMENT16 VARCHAR2 (40)
Key flexfield segment
SEGMENT17 VARCHAR2 (40)
Key flexfield segment
SEGMENT18 VARCHAR2 (40)
Key flexfield segment
SEGMENT19 VARCHAR2 (40)
Key flexfield segment
SEGMENT20 VARCHAR2 (40)
Key flexfield segment
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
PURCHASING_ITEM_FLAG VARCHAR2 (1) Yes Flag indicating purchasing item
SHIPPABLE_ITEM_FLAG VARCHAR2 (1) Yes Flag indicating shippable item
CUSTOMER_ORDER_FLAG VARCHAR2 (1) Yes Flag indicating customer orderable item
INTERNAL_ORDER_FLAG VARCHAR2 (1) Yes Flag indicating internally orderable item
SERVICE_ITEM_FLAG VARCHAR2 (1) Yes Flag indicating service item
INVENTORY_ITEM_FLAG VARCHAR2 (1) Yes Flag indicating inventory item
ENG_ITEM_FLAG VARCHAR2 (1) Yes Flag indicating engineering item
INVENTORY_ASSET_FLAG VARCHAR2 (1) Yes Flag indicating item is an inventory asset
PURCHASING_ENABLED_FLAG VARCHAR2 (1) Yes Flag indicating item is purchasable
CUSTOMER_ORDER_ENABLED_FLAG VARCHAR2 (1) Yes Flag indicating item is customer orderable
INTERNAL_ORDER_ENABLED_FLAG VARCHAR2 (1) Yes Flag indicating item is internally orderable
SO_TRANSACTIONS_FLAG VARCHAR2 (1) Yes Sales order transactions flag
MTL_TRANSACTIONS_ENABLED_FLAG VARCHAR2 (1) Yes Flag indicating item is transactable
STOCK_ENABLED_FLAG VARCHAR2 (1) Yes Flag indicating item is stockable
BOM_ENABLED_FLAG VARCHAR2 (1) Yes Flag indicating item may appear on a BOM
BUILD_IN_WIP_FLAG VARCHAR2 (1) Yes Flag indicating item may be built in WIP
REVISION_QTY_CONTROL_CODE NUMBER

Revision quantity control code
ITEM_CATALOG_GROUP_ID NUMBER

Item catalog group identifier
CATALOG_STATUS_FLAG VARCHAR2 (1)
Flag indicating item catalog complete
RETURNABLE_FLAG VARCHAR2 (1)
Flag indicating whether item is returnable
DEFAULT_SHIPPING_ORG NUMBER

Default shipping organization
COLLATERAL_FLAG VARCHAR2 (1)
Flag indicating item is collateral item
TAXABLE_FLAG VARCHAR2 (1)
Flag indicating whether item is taxable
QTY_RCV_EXCEPTION_CODE VARCHAR2 (25)
Over tolerance receipts processing method code
ALLOW_ITEM_DESC_UPDATE_FLAG VARCHAR2 (1)
Allow item description updates on PO lines
INSPECTION_REQUIRED_FLAG VARCHAR2 (1)
Flag indicating whether inspection is required upon receipt
RECEIPT_REQUIRED_FLAG VARCHAR2 (1)
Flag indicating supplier receipt is required before payment
MARKET_PRICE NUMBER

Purchasing market price
HAZARD_CLASS_ID NUMBER

Purchasing hazard identifier
RFQ_REQUIRED_FLAG VARCHAR2 (1)
Flag indicating whether an RFQ (request for quotation) is required
QTY_RCV_TOLERANCE NUMBER

Maximum acceptable over-receipt percentage
LIST_PRICE_PER_UNIT NUMBER

Unit list price - purchasing
UN_NUMBER_ID NUMBER

Purchasing UN (United Nations) number
PRICE_TOLERANCE_PERCENT NUMBER

Purchase price tolerance percentage
ASSET_CATEGORY_ID NUMBER

Fixed asset category identifier (foreign key FA asset category flexfield)
ROUNDING_FACTOR NUMBER

Rounding factor used to determine order quantity
UNIT_OF_ISSUE VARCHAR2 (25)
Unit of issue
ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2 (25)
Require receipt location to match ship-to location
ALLOW_SUBSTITUTE_RECEIPTS_FLAG VARCHAR2 (1)
Flag indicating substitute receipts allowed
ALLOW_UNORDERED_RECEIPTS_FLAG VARCHAR2 (1)
Flag indicating unordered receipts allowed
ALLOW_EXPRESS_DELIVERY_FLAG VARCHAR2 (1)
Flag indicating express delivery allowed
DAYS_EARLY_RECEIPT_ALLOWED NUMBER

Days before planned receipt that item may be received
DAYS_LATE_RECEIPT_ALLOWED NUMBER

Days after the planned receipt that item may be received
RECEIPT_DAYS_EXCEPTION_CODE VARCHAR2 (25)
Exception processing for early/late receipts
RECEIVING_ROUTING_ID NUMBER

Default receipt routing
INVOICE_CLOSE_TOLERANCE NUMBER

Invoice close tolerance
RECEIVE_CLOSE_TOLERANCE NUMBER

Receipt close tolerance
AUTO_LOT_ALPHA_PREFIX VARCHAR2 (30)
Item-level prefix for lot numbers
START_AUTO_LOT_NUMBER VARCHAR2 (30)
Next auto assigned lot number
LOT_CONTROL_CODE NUMBER

Lot control code
SHELF_LIFE_CODE NUMBER

Shelf life code
SHELF_LIFE_DAYS NUMBER

Length of shelf life days
SERIAL_NUMBER_CONTROL_CODE NUMBER

Serial number control code
START_AUTO_SERIAL_NUMBER VARCHAR2 (30)
Next auto assigned serial number
AUTO_SERIAL_ALPHA_PREFIX VARCHAR2 (30)
Item-level alpha prefix for serial numbers
SOURCE_TYPE NUMBER

Inventory or supplier source type
SOURCE_ORGANIZATION_ID NUMBER

Organization to source items from
SOURCE_SUBINVENTORY VARCHAR2 (10)
Subinventory to source items from
EXPENSE_ACCOUNT NUMBER

Expense account
ENCUMBRANCE_ACCOUNT NUMBER

Encumbrance account
RESTRICT_SUBINVENTORIES_CODE NUMBER

Subinventory restrictions type
UNIT_WEIGHT NUMBER

Conversion between weight unit of measure and base unit of measure
WEIGHT_UOM_CODE VARCHAR2 (3)
Weight unit of measure code
VOLUME_UOM_CODE VARCHAR2 (3)
Volume unit of measure code
UNIT_VOLUME NUMBER

Conversion between volume unit of measure and base unit of measure
RESTRICT_LOCATORS_CODE NUMBER

Locators restrictions type
LOCATION_CONTROL_CODE NUMBER

Stock locator control code
SHRINKAGE_RATE NUMBER

Planned shrinkage rate
ACCEPTABLE_EARLY_DAYS NUMBER

Days an order may be early before rescheduling is recommended
PLANNING_TIME_FENCE_CODE NUMBER

Planning time fence code
DEMAND_TIME_FENCE_CODE NUMBER

Demand time fence code
LEAD_TIME_LOT_SIZE NUMBER

Lead time lot size
STD_LOT_SIZE NUMBER

Standard lot size
CUM_MANUFACTURING_LEAD_TIME NUMBER

Cumulative manufacturing lead time
OVERRUN_PERCENTAGE NUMBER

MRP repetitive acceptable overrun rate
MRP_CALCULATE_ATP_FLAG VARCHAR2 (1)
Calculate ATP flag (y/n) for MRP planning routine
ACCEPTABLE_RATE_INCREASE NUMBER

MRP repetitive acceptable rate increase
ACCEPTABLE_RATE_DECREASE NUMBER

MRP repetitive acceptable rate decrease
CUMULATIVE_TOTAL_LEAD_TIME NUMBER

Cumulative total lead time
PLANNING_TIME_FENCE_DAYS NUMBER

Planning time fence days
DEMAND_TIME_FENCE_DAYS NUMBER

Demand time fence days
END_ASSEMBLY_PEGGING_FLAG VARCHAR2 (1)
End assembly pegging flag for MRP
REPETITIVE_PLANNING_FLAG VARCHAR2 (1)
Flag indicating item to be planned as repetitive schedule
PLANNING_EXCEPTION_SET VARCHAR2 (10)
Exception control set
BOM_ITEM_TYPE NUMBER
Yes Type of item
PICK_COMPONENTS_FLAG VARCHAR2 (1) Yes Flag indicating whether all shippable components should be picked
REPLENISH_TO_ORDER_FLAG VARCHAR2 (1) Yes Assemble to Order flag
BASE_ITEM_ID NUMBER

Base item identifier
ATP_COMPONENTS_FLAG VARCHAR2 (1) Yes Flag indicating whether item may have components requiring ATP check
ATP_FLAG VARCHAR2 (1) Yes Flag indicating ATP must be checked when item is ordered
FIXED_LEAD_TIME NUMBER

Fixed portion of the assembly's lead time
VARIABLE_LEAD_TIME NUMBER

Variable portion of an assembly's lead time
WIP_SUPPLY_LOCATOR_ID NUMBER

Supply locator for WIP transactions
WIP_SUPPLY_TYPE NUMBER

Source of WIP material supply
WIP_SUPPLY_SUBINVENTORY VARCHAR2 (10)
Supply subinventory for WIP transactions
PRIMARY_UOM_CODE VARCHAR2 (3)
Primary unit of measure code
PRIMARY_UNIT_OF_MEASURE VARCHAR2 (25)
Primary stocking unit of measure for the item
ALLOWED_UNITS_LOOKUP_CODE NUMBER

Allowed unit of measure conversion type
COST_OF_SALES_ACCOUNT NUMBER

Cost of sales account
SALES_ACCOUNT NUMBER

Sales account
DEFAULT_INCLUDE_IN_ROLLUP_FLAG VARCHAR2 (1)
Default value for include in cost rollup
INVENTORY_ITEM_STATUS_CODE VARCHAR2 (10) Yes Material status code
INVENTORY_PLANNING_CODE NUMBER

Inventory planning code
PLANNER_CODE VARCHAR2 (10)
Planner code
PLANNING_MAKE_BUY_CODE NUMBER

Indicates whether item is planned as manufactured or purchased
FIXED_LOT_MULTIPLIER NUMBER

Fixed lot size multiplier
ROUNDING_CONTROL_TYPE NUMBER

Rounding control code
CARRYING_COST NUMBER

Annual carrying cost
POSTPROCESSING_LEAD_TIME NUMBER

Post-processing lead time
PREPROCESSING_LEAD_TIME NUMBER

Pre-processing lead time
FULL_LEAD_TIME NUMBER

Full lead time
ORDER_COST NUMBER

Order cost
MRP_SAFETY_STOCK_PERCENT NUMBER

Safety stock percentage
MRP_SAFETY_STOCK_CODE NUMBER

Safety stock code
MIN_MINMAX_QUANTITY NUMBER

Minimum minmax order quantity
MAX_MINMAX_QUANTITY NUMBER

Maximum minmax order quantity
MINIMUM_ORDER_QUANTITY NUMBER

Minimum order quantity
FIXED_ORDER_QUANTITY NUMBER

Fixed order quantity
FIXED_DAYS_SUPPLY NUMBER

Fixed days supply
MAXIMUM_ORDER_QUANTITY NUMBER

Maximum order quantity
ATP_RULE_ID NUMBER

Available to promise rule to be used for this item
PICKING_RULE_ID NUMBER

Picking rule code
RESERVABLE_TYPE NUMBER

Hard reservations allowed flag
POSITIVE_MEASUREMENT_ERROR NUMBER

Percent error above measured quantity
NEGATIVE_MEASUREMENT_ERROR NUMBER

Percent error below measured quantity
ENGINEERING_ECN_CODE VARCHAR2 (50)
Engineering ECN code
ENGINEERING_ITEM_ID NUMBER

Engineering implemented item identifier
ENGINEERING_DATE DATE

Engineering implementation date
SERVICE_STARTING_DELAY NUMBER

Days after shipment that service begins
VENDOR_WARRANTY_FLAG VARCHAR2 (1) Yes Flag indicating service for the item is provided by a supplier
SERVICEABLE_COMPONENT_FLAG VARCHAR2 (1)
Indicates whether the item is serviceable by other service-type items and whether it can be referenced as the component of another item
SERVICEABLE_PRODUCT_FLAG VARCHAR2 (1) Yes Indicates whether the item is serviceable by other service-type items and can have service requests reported against it
BASE_WARRANTY_SERVICE_ID NUMBER

Base warranty identifier
PAYMENT_TERMS_ID NUMBER

Payment terms identifier
PREVENTIVE_MAINTENANCE_FLAG VARCHAR2 (1)
Flag indicating whether item can be a preventive maintenance service item
PRIMARY_SPECIALIST_ID NUMBER

Primary service specialist
SECONDARY_SPECIALIST_ID NUMBER

Secondary service specialist
SERVICEABLE_ITEM_CLASS_ID NUMBER

Serviceable item class identifier
TIME_BILLABLE_FLAG VARCHAR2 (1)
Flag indicating service labor hours are billable
MATERIAL_BILLABLE_FLAG VARCHAR2 (30)
Flag indicating service material is billable
EXPENSE_BILLABLE_FLAG VARCHAR2 (1)
Flag indicating service expenses are billable
PRORATE_SERVICE_FLAG VARCHAR2 (1)
Flag indicating cost of service may be prorated
COVERAGE_SCHEDULE_ID NUMBER

Coverage schedule identifier
SERVICE_DURATION_PERIOD_CODE VARCHAR2 (10)
Period code for default service duration
SERVICE_DURATION NUMBER

Default service duration
WARRANTY_VENDOR_ID NUMBER

Service supplier identifier
MAX_WARRANTY_AMOUNT NUMBER

Monetary value of service costs covered by the item
RESPONSE_TIME_PERIOD_CODE VARCHAR2 (30)
Period code for service response time
RESPONSE_TIME_VALUE NUMBER

Default response time
NEW_REVISION_CODE VARCHAR2 (30)
Indicates how to notify customers of new revisions of the item
INVOICEABLE_ITEM_FLAG VARCHAR2 (1) Yes Flag indicating item may appear on invoices
TAX_CODE VARCHAR2 (50)
Tax code
INVOICE_ENABLED_FLAG VARCHAR2 (1) Yes Indicates whether the item can be invoiced
MUST_USE_APPROVED_VENDOR_FLAG VARCHAR2 (1) Yes Flag indicating purchases restricted to approved supplier
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
OUTSIDE_OPERATION_FLAG VARCHAR2 (1) Yes Flag indicating item may appear on outside operation purchase order
OUTSIDE_OPERATION_UOM_TYPE VARCHAR2 (25)
Outside operation unit of measure
SAFETY_STOCK_BUCKET_DAYS NUMBER

Safety stock bucket days
AUTO_REDUCE_MPS NUMBER (22)
Automatically deletes MPS entries within a time period
COSTING_ENABLED_FLAG VARCHAR2 (1) Yes Flag indicating cost information is maintained
AUTO_CREATED_CONFIG_FLAG VARCHAR2 (1) Yes Flag indicating configuration item automatically created
CYCLE_COUNT_ENABLED_FLAG VARCHAR2 (1) Yes Flag indicating item may be cycle counted
ITEM_TYPE VARCHAR2 (30)
User-defined item type
MODEL_CONFIG_CLAUSE_NAME VARCHAR2 (10)
(not currently used)
SHIP_MODEL_COMPLETE_FLAG VARCHAR2 (1)
Flag indicating model must be complete to ship
MRP_PLANNING_CODE NUMBER

MRP Planning option
RETURN_INSPECTION_REQUIREMENT NUMBER

RMA inspection requirement
ATO_FORECAST_CONTROL NUMBER

Type of forecast control for ATO
RELEASE_TIME_FENCE_CODE NUMBER

Flag to indicate if this item is auto releasable by MRP
RELEASE_TIME_FENCE_DAYS NUMBER

Number of days within which this item should be auto released
CONTAINER_ITEM_FLAG VARCHAR2 (1)
Flag indicating if the item is a container. Used for shipping sales orders
VEHICLE_ITEM_FLAG VARCHAR2 (1)
Indicates if the item is a vehicle or not. Used for shipping sales orders
MAXIMUM_LOAD_WEIGHT NUMBER

Maximum load weight of a container or a vehicle that can be used for shipping sales orders
MINIMUM_FILL_PERCENT NUMBER

Minimum fill condition under which the container or vehicle should be used
CONTAINER_TYPE_CODE VARCHAR2 (30)
Container type code for container items. Container types are user defineable
INTERNAL_VOLUME NUMBER

Internal volume for container items. Used by Shipping to calculate container capacity restrictions
WH_UPDATE_DATE DATE

Warehouse update date for tracking changes relevant to data collected in Data Warehouse
PRODUCT_FAMILY_ITEM_ID NUMBER

If the item is product family member, stores the product family identifier. Used in Production Planning
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
Global descriptive flexfield structure defining column
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Global descriptive flexfield segment
PURCHASING_TAX_CODE VARCHAR2 (50)
Purchasing tax code
OVERCOMPLETION_TOLERANCE_TYPE NUMBER

Overcompletion tolerance type
OVERCOMPLETION_TOLERANCE_VALUE NUMBER

Overcompletion tolerance value
EFFECTIVITY_CONTROL NUMBER

Effectivity control code. Indicates if the item is under Date Effectivity or Model/Unit Number Effectivity control.
CHECK_SHORTAGES_FLAG VARCHAR2 (1)
Flag indicating material shortages should be checked for this item
OVER_SHIPMENT_TOLERANCE NUMBER

Over shipment tolerance
UNDER_SHIPMENT_TOLERANCE NUMBER

Under shipment tolerance
OVER_RETURN_TOLERANCE NUMBER

Over return tolerance
UNDER_RETURN_TOLERANCE NUMBER

Under return tolerance
EQUIPMENT_TYPE NUMBER

Flag indicating item is equipment
RECOVERED_PART_DISP_CODE VARCHAR2 (30)
Indicates return is required for recovered pars, scrap in field, which is used for spare parts
DEFECT_TRACKING_ON_FLAG VARCHAR2 (1)
Specifies whether a defect or bug can be filed against the product
USAGE_ITEM_FLAG VARCHAR2 (1)
Flag indicating an item represents usage. Usage items can be sold as a use of something
EVENT_FLAG VARCHAR2 (1)
Identifies item as an event
ELECTRONIC_FLAG VARCHAR2 (1)
Flag indicating an item exists only in electronic format and not physical
DOWNLOADABLE_FLAG VARCHAR2 (1)
Flag indicating an item is downloadable
VOL_DISCOUNT_EXEMPT_FLAG VARCHAR2 (1)
Indicates an item does not contribute to volume discount for any order
COUPON_EXEMPT_FLAG VARCHAR2 (1)
Indicates an item is excluded from coupons even if it is part of the group that any coupon applies
COMMS_NL_TRACKABLE_FLAG VARCHAR2 (1)
Identifies an item as network logistics trackable
ASSET_CREATION_CODE VARCHAR2 (30)
Used to specify when an asset should be created
COMMS_ACTIVATION_REQD_FLAG VARCHAR2 (1)
Indicates an item requires activation on a network
ORDERABLE_ON_WEB_FLAG VARCHAR2 (1)
Indicates whether an item is orderable on the web or not. iStore will only sell items with this flag to be true
BACK_ORDERABLE_FLAG VARCHAR2 (1)
If ATP failed, can item be back ordered
WEB_STATUS VARCHAR2 (30)
Specifies item web status, which can be web enabled, web published, or neither
INDIVISIBLE_FLAG VARCHAR2 (1)
Item unit is indivisible
DIMENSION_UOM_CODE VARCHAR2 (3)
Item dimensions unit of measure code
UNIT_LENGTH NUMBER

Item length
UNIT_WIDTH NUMBER

Item width
UNIT_HEIGHT NUMBER

Item height
BULK_PICKED_FLAG VARCHAR2 (1)
Material pick method
LOT_STATUS_ENABLED VARCHAR2 (1)
Lot status enabled
DEFAULT_LOT_STATUS_ID NUMBER

Default lot status
SERIAL_STATUS_ENABLED VARCHAR2 (1)
Serial status enabled
DEFAULT_SERIAL_STATUS_ID NUMBER

Default serial status
LOT_SPLIT_ENABLED VARCHAR2 (1)
Lot split enabled
LOT_MERGE_ENABLED VARCHAR2 (1)
Lot merge enabled
INVENTORY_CARRY_PENALTY NUMBER

Penalty incurred for holding this item inventory
OPERATION_SLACK_PENALTY NUMBER

Penalty incurred for a time in between two operations
FINANCING_ALLOWED_FLAG VARCHAR2 (1)
Item is eligible for financing
EAM_ITEM_TYPE NUMBER

Asset item type
EAM_ACTIVITY_TYPE_CODE VARCHAR2 (30)
Asset activity type
EAM_ACTIVITY_CAUSE_CODE VARCHAR2 (30)
Asset activity cause
EAM_ACT_NOTIFICATION_FLAG VARCHAR2 (1)
Asset activity notification required
EAM_ACT_SHUTDOWN_STATUS VARCHAR2 (30)
Asset activity shutdown type
DUAL_UOM_CONTROL NUMBER

Indicates Item control of Dual Unit of Measure
SECONDARY_UOM_CODE VARCHAR2 (3)
Secondary Unit of Measure
DUAL_UOM_DEVIATION_HIGH NUMBER

Upper bound of tolerance factor by which the Dual Unit of Measure may be transacted in
DUAL_UOM_DEVIATION_LOW NUMBER

Lower bound of tolerance factor by which the Dual Unit of Measure may be transacted in
CONTRACT_ITEM_TYPE_CODE VARCHAR2 (30)
Contract Item type
SUBSCRIPTION_DEPEND_FLAG VARCHAR2 (1)
Subscription dependency enabled
SERV_REQ_ENABLED_CODE VARCHAR2 (30)
Service Request Enabled
SERV_BILLING_ENABLED_FLAG VARCHAR2 (1)
Service Billing Enabled
SERV_IMPORTANCE_LEVEL NUMBER

Service Importance Level
PLANNED_INV_POINT_FLAG VARCHAR2 (1)
Planned inventory point enabled
LOT_TRANSLATE_ENABLED VARCHAR2 (1)
Lot Translate Enabled
DEFAULT_SO_SOURCE_TYPE VARCHAR2 (30)
Default Sales Order Source Type
CREATE_SUPPLY_FLAG VARCHAR2 (1)
Create Supply Flag
SUBSTITUTION_WINDOW_CODE NUMBER

Substitution Window
SUBSTITUTION_WINDOW_DAYS NUMBER

Substitution Window Days
IB_ITEM_INSTANCE_CLASS VARCHAR2 (30)
Installed Base Item Instance Classification
CONFIG_MODEL_TYPE VARCHAR2 (30)
Configurator Model Type
LOT_SUBSTITUTION_ENABLED VARCHAR2 (1)
Lot Substitution Enabled for 11.5.9
MINIMUM_LICENSE_QUANTITY NUMBER

Minimum License Quantity for 11.5.9
EAM_ACTIVITY_SOURCE_CODE VARCHAR2 (30)
Activity Source for 11.5.9
LIFECYCLE_ID NUMBER

Lifecycle
CURRENT_PHASE_ID NUMBER

Current Lifecycle Phase
OBJECT_VERSION_NUMBER NUMBER (9)
Object version number tracks row updates
TRACKING_QUANTITY_IND VARCHAR2 (30)
Catch-weight Support for 11.5.10
ONT_PRICING_QTY_SOURCE VARCHAR2 (30)
Catch-Weight Support for 11.5.10
SECONDARY_DEFAULT_IND VARCHAR2 (30)
Catch-Weight Support for 11.5.10
OPTION_SPECIFIC_SOURCED NUMBER

CTO changes for 11.5.10
APPROVAL_STATUS VARCHAR2 (30)
11.5.10 added for PLM it will be used in Part Number Request
VMI_MINIMUM_UNITS NUMBER

Minimum quantity in units
VMI_MINIMUM_DAYS NUMBER

Minimum quantity in days
VMI_MAXIMUM_UNITS NUMBER

Maximum quantity in units
VMI_MAXIMUM_DAYS NUMBER

Maximum quantity in days
VMI_FIXED_ORDER_QUANTITY NUMBER

Fixed order quantity in units
SO_AUTHORIZATION_FLAG NUMBER

SO release authorization flag: 1 - authorization by customer required, 2 - authorization not required (default),
CONSIGNED_FLAG NUMBER

Consigned flag: 1 - consigned, 2 - unconsigned (default)
ASN_AUTOEXPIRE_FLAG NUMBER

Auto-expiring ASN flag: 1 - ASN auto-expired (default), 2 - ASN not auto-expired
VMI_FORECAST_TYPE NUMBER

Forecast type for average daily demand calculation: 1 - order forecast (default), 2 - sales forecast, 3 - historical sales
FORECAST_HORIZON NUMBER

Forecast horizon for average daily demand calculation
EXCLUDE_FROM_BUDGET_FLAG NUMBER

1- Yes2- No (Default)
DAYS_TGT_INV_SUPPLY NUMBER

Target Inventory Level Days of Supply
DAYS_TGT_INV_WINDOW NUMBER

Target Inventory Level Calculation Window
DAYS_MAX_INV_SUPPLY NUMBER

Maximum Inventory Level Days of Supply
DAYS_MAX_INV_WINDOW NUMBER

Maximum Inventory Level Calculation Window
DRP_PLANNED_FLAG NUMBER

Distribution Planned
CRITICAL_COMPONENT_FLAG NUMBER

Critical Component flag
CONTINOUS_TRANSFER NUMBER

Continuous Inter Organization transfers1. Yes2. No3. Use Global Value (default)
CONVERGENCE NUMBER

Convergent Supply Consumption Pattern1. Series2. Parallel3. Use Global Value (default)
DIVERGENCE NUMBER

Divergent Supply Feeding Pattern1. Series2. Series with MTQ3. Use Global Value (default)
CONFIG_ORGS VARCHAR2 (30)
CTO 11.5.10 Enahncement
CONFIG_MATCH VARCHAR2 (30)
CTO 11.5.10 ENH
ATTRIBUTE16 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE17 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE18 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE19 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE20 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE21 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE22 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE23 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE24 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE25 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE26 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE27 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE28 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE29 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE30 VARCHAR2 (240)
Descriptive flexfield segment
CAS_NUMBER VARCHAR2 (30)
Chemical abstracts service registry number
CHILD_LOT_FLAG VARCHAR2 (1)
Whether a child lot can be created for items
CHILD_LOT_PREFIX VARCHAR2 (30)
Item-level prefix for child lot numbers
CHILD_LOT_STARTING_NUMBER NUMBER

Next auto assigned child lot number
CHILD_LOT_VALIDATION_FLAG VARCHAR2 (1)
Ensure that the child lot number conforms to the parameters defined for the item/organization
COPY_LOT_ATTRIBUTE_FLAG VARCHAR2 (1)
If it is set to yes, a new child lot will inherit all attributes from the parent lot. If set to no, the lot attributes for a new child lot will not inherit the parent lot attributes and will default to values similar to a new lot.
DEFAULT_GRADE VARCHAR2 (150)
Default Grade assigned to a newly created lot
EXPIRATION_ACTION_CODE VARCHAR2 (32)
Identifier code for action to take when a lot expires
EXPIRATION_ACTION_INTERVAL NUMBER

Interval between the time lot expires and the time expiration action should be taken
GRADE_CONTROL_FLAG VARCHAR2 (1)
Whether the item is grade controlled
HAZARDOUS_MATERIAL_FLAG VARCHAR2 (1)
Flag indicating item is hazardous
HOLD_DAYS NUMBER

Number of hold days
LOT_DIVISIBLE_FLAG VARCHAR2 (1)
Whether or not a lot may be transacted against for a quantity less than total onhand for lot
MATURITY_DAYS NUMBER

Days to maturity
PARENT_CHILD_GENERATION_FLAG VARCHAR2 (1)
Generation method for child lot numbers
PROCESS_COSTING_ENABLED_FLAG VARCHAR2 (1)
Flag indicating cost information may be maintained in OPM (Oracle Process Manufacturing)
PROCESS_EXECUTION_ENABLED_FLAG VARCHAR2 (1)
Flag indicating item may be used in OPM (Oracle Process Manufacturing) Process Excecution
PROCESS_QUALITY_ENABLED_FLAG VARCHAR2 (1)
Flag indicating item may be used in OPM (Oracle Process Manufacturing) Process Quality
PROCESS_SUPPLY_LOCATOR_ID NUMBER

Default supply locator for process execution transactions
PROCESS_SUPPLY_SUBINVENTORY VARCHAR2 (10)
Default supply subinventory for process execution transactions
PROCESS_YIELD_LOCATOR_ID NUMBER

Default yield locator for process execution transactions
PROCESS_YIELD_SUBINVENTORY VARCHAR2 (10)
Default yield subinventory for process execution transactions
RECIPE_ENABLED_FLAG VARCHAR2 (1)
Flag indicating item may appear on a Recipe in OPM (Oracle Process Manufacturing) Process
RETEST_INTERVAL NUMBER

Number of days specifying how often lot controlled items should be retested
CHARGE_PERIODICITY_CODE VARCHAR2 (3)
The time unit by which a persistent or recurring service or product is priced at ordering/quoting time
REPAIR_LEADTIME NUMBER

Time to repair the part at the supplier site
REPAIR_YIELD NUMBER

Yield when a defective part is repaired/upgraded to a new part
PREPOSITION_POINT VARCHAR2 (1)
The Pre-positioning Point represents the Push type of relationship with the trading partner.
REPAIR_PROGRAM NUMBER

Defines the relationship with the vendor for the repair item
SUBCONTRACTING_COMPONENT NUMBER

- Indicates whether the sub-contracting type associated to this item when it is used as a sub-contracting component in charge based SHIKYU
OUTSOURCED_ASSEMBLY NUMBER

Identifies whether an item is Outsourced Assembly item or not
EGO_MASTER_ITEMS_DFF_CTX VARCHAR2 (1)
Context field for EGO_MASTER_ITEMS DFF
GDSN_OUTBOUND_ENABLED_FLAG VARCHAR2 (1)
Flag for Outbound GDSN being enabled or not
TRADE_ITEM_DESCRIPTOR VARCHAR2 (35)
Trade Item Descriptor value for the Item
STYLE_ITEM_ID NUMBER

Contains Style item Id
STYLE_ITEM_FLAG VARCHAR2 (1)
Flag for whether item contains a style or not
LAST_SUBMITTED_NIR_ID NUMBER

Contains the last submitted New Item Request Id
DEFAULT_MATERIAL_STATUS_ID NUMBER

Default Material Status
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Global descriptive flexfield segment
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Global descriptive flexfield segment
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SUMMARY_FLAG
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      DESCRIPTION
,      BUYER_ID
,      ACCOUNTING_RULE_ID
,      INVOICING_RULE_ID
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PURCHASING_ITEM_FLAG
,      SHIPPABLE_ITEM_FLAG
,      CUSTOMER_ORDER_FLAG
,      INTERNAL_ORDER_FLAG
,      SERVICE_ITEM_FLAG
,      INVENTORY_ITEM_FLAG
,      ENG_ITEM_FLAG
,      INVENTORY_ASSET_FLAG
,      PURCHASING_ENABLED_FLAG
,      CUSTOMER_ORDER_ENABLED_FLAG
,      INTERNAL_ORDER_ENABLED_FLAG
,      SO_TRANSACTIONS_FLAG
,      MTL_TRANSACTIONS_ENABLED_FLAG
,      STOCK_ENABLED_FLAG
,      BOM_ENABLED_FLAG
,      BUILD_IN_WIP_FLAG
,      REVISION_QTY_CONTROL_CODE
,      ITEM_CATALOG_GROUP_ID
,      CATALOG_STATUS_FLAG
,      RETURNABLE_FLAG
,      DEFAULT_SHIPPING_ORG
,      COLLATERAL_FLAG
,      TAXABLE_FLAG
,      QTY_RCV_EXCEPTION_CODE
,      ALLOW_ITEM_DESC_UPDATE_FLAG
,      INSPECTION_REQUIRED_FLAG
,      RECEIPT_REQUIRED_FLAG
,      MARKET_PRICE
,      HAZARD_CLASS_ID
,      RFQ_REQUIRED_FLAG
,      QTY_RCV_TOLERANCE
,      LIST_PRICE_PER_UNIT
,      UN_NUMBER_ID
,      PRICE_TOLERANCE_PERCENT
,      ASSET_CATEGORY_ID
,      ROUNDING_FACTOR
,      UNIT_OF_ISSUE
,      ENFORCE_SHIP_TO_LOCATION_CODE
,      ALLOW_SUBSTITUTE_RECEIPTS_FLAG
,      ALLOW_UNORDERED_RECEIPTS_FLAG
,      ALLOW_EXPRESS_DELIVERY_FLAG
,      DAYS_EARLY_RECEIPT_ALLOWED
,      DAYS_LATE_RECEIPT_ALLOWED
,      RECEIPT_DAYS_EXCEPTION_CODE
,      RECEIVING_ROUTING_ID
,      INVOICE_CLOSE_TOLERANCE
,      RECEIVE_CLOSE_TOLERANCE
,      AUTO_LOT_ALPHA_PREFIX
,      START_AUTO_LOT_NUMBER
,      LOT_CONTROL_CODE
,      SHELF_LIFE_CODE
,      SHELF_LIFE_DAYS
,      SERIAL_NUMBER_CONTROL_CODE
,      START_AUTO_SERIAL_NUMBER
,      AUTO_SERIAL_ALPHA_PREFIX
,      SOURCE_TYPE
,      SOURCE_ORGANIZATION_ID
,      SOURCE_SUBINVENTORY
,      EXPENSE_ACCOUNT
,      ENCUMBRANCE_ACCOUNT
,      RESTRICT_SUBINVENTORIES_CODE
,      UNIT_WEIGHT
,      WEIGHT_UOM_CODE
,      VOLUME_UOM_CODE
,      UNIT_VOLUME
,      RESTRICT_LOCATORS_CODE
,      LOCATION_CONTROL_CODE
,      SHRINKAGE_RATE
,      ACCEPTABLE_EARLY_DAYS
,      PLANNING_TIME_FENCE_CODE
,      DEMAND_TIME_FENCE_CODE
,      LEAD_TIME_LOT_SIZE
,      STD_LOT_SIZE
,      CUM_MANUFACTURING_LEAD_TIME
,      OVERRUN_PERCENTAGE
,      MRP_CALCULATE_ATP_FLAG
,      ACCEPTABLE_RATE_INCREASE
,      ACCEPTABLE_RATE_DECREASE
,      CUMULATIVE_TOTAL_LEAD_TIME
,      PLANNING_TIME_FENCE_DAYS
,      DEMAND_TIME_FENCE_DAYS
,      END_ASSEMBLY_PEGGING_FLAG
,      REPETITIVE_PLANNING_FLAG
,      PLANNING_EXCEPTION_SET
,      BOM_ITEM_TYPE
,      PICK_COMPONENTS_FLAG
,      REPLENISH_TO_ORDER_FLAG
,      BASE_ITEM_ID
,      ATP_COMPONENTS_FLAG
,      ATP_FLAG
,      FIXED_LEAD_TIME
,      VARIABLE_LEAD_TIME
,      WIP_SUPPLY_LOCATOR_ID
,      WIP_SUPPLY_TYPE
,      WIP_SUPPLY_SUBINVENTORY
,      PRIMARY_UOM_CODE
,      PRIMARY_UNIT_OF_MEASURE
,      ALLOWED_UNITS_LOOKUP_CODE
,      COST_OF_SALES_ACCOUNT
,      SALES_ACCOUNT
,      DEFAULT_INCLUDE_IN_ROLLUP_FLAG
,      INVENTORY_ITEM_STATUS_CODE
,      INVENTORY_PLANNING_CODE
,      PLANNER_CODE
,      PLANNING_MAKE_BUY_CODE
,      FIXED_LOT_MULTIPLIER
,      ROUNDING_CONTROL_TYPE
,      CARRYING_COST
,      POSTPROCESSING_LEAD_TIME
,      PREPROCESSING_LEAD_TIME
,      FULL_LEAD_TIME
,      ORDER_COST
,      MRP_SAFETY_STOCK_PERCENT
,      MRP_SAFETY_STOCK_CODE
,      MIN_MINMAX_QUANTITY
,      MAX_MINMAX_QUANTITY
,      MINIMUM_ORDER_QUANTITY
,      FIXED_ORDER_QUANTITY
,      FIXED_DAYS_SUPPLY
,      MAXIMUM_ORDER_QUANTITY
,      ATP_RULE_ID
,      PICKING_RULE_ID
,      RESERVABLE_TYPE
,      POSITIVE_MEASUREMENT_ERROR
,      NEGATIVE_MEASUREMENT_ERROR
,      ENGINEERING_ECN_CODE
,      ENGINEERING_ITEM_ID
,      ENGINEERING_DATE
,      SERVICE_STARTING_DELAY
,      VENDOR_WARRANTY_FLAG
,      SERVICEABLE_COMPONENT_FLAG
,      SERVICEABLE_PRODUCT_FLAG
,      BASE_WARRANTY_SERVICE_ID
,      PAYMENT_TERMS_ID
,      PREVENTIVE_MAINTENANCE_FLAG
,      PRIMARY_SPECIALIST_ID
,      SECONDARY_SPECIALIST_ID
,      SERVICEABLE_ITEM_CLASS_ID
,      TIME_BILLABLE_FLAG
,      MATERIAL_BILLABLE_FLAG
,      EXPENSE_BILLABLE_FLAG
,      PRORATE_SERVICE_FLAG
,      COVERAGE_SCHEDULE_ID
,      SERVICE_DURATION_PERIOD_CODE
,      SERVICE_DURATION
,      WARRANTY_VENDOR_ID
,      MAX_WARRANTY_AMOUNT
,      RESPONSE_TIME_PERIOD_CODE
,      RESPONSE_TIME_VALUE
,      NEW_REVISION_CODE
,      INVOICEABLE_ITEM_FLAG
,      TAX_CODE
,      INVOICE_ENABLED_FLAG
,      MUST_USE_APPROVED_VENDOR_FLAG
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      OUTSIDE_OPERATION_FLAG
,      OUTSIDE_OPERATION_UOM_TYPE
,      SAFETY_STOCK_BUCKET_DAYS
,      AUTO_REDUCE_MPS
,      COSTING_ENABLED_FLAG
,      AUTO_CREATED_CONFIG_FLAG
,      CYCLE_COUNT_ENABLED_FLAG
,      ITEM_TYPE
,      MODEL_CONFIG_CLAUSE_NAME
,      SHIP_MODEL_COMPLETE_FLAG
,      MRP_PLANNING_CODE
,      RETURN_INSPECTION_REQUIREMENT
,      ATO_FORECAST_CONTROL
,      RELEASE_TIME_FENCE_CODE
,      RELEASE_TIME_FENCE_DAYS
,      CONTAINER_ITEM_FLAG
,      VEHICLE_ITEM_FLAG
,      MAXIMUM_LOAD_WEIGHT
,      MINIMUM_FILL_PERCENT
,      CONTAINER_TYPE_CODE
,      INTERNAL_VOLUME
,      WH_UPDATE_DATE
,      PRODUCT_FAMILY_ITEM_ID
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      PURCHASING_TAX_CODE
,      OVERCOMPLETION_TOLERANCE_TYPE
,      OVERCOMPLETION_TOLERANCE_VALUE
,      EFFECTIVITY_CONTROL
,      CHECK_SHORTAGES_FLAG
,      OVER_SHIPMENT_TOLERANCE
,      UNDER_SHIPMENT_TOLERANCE
,      OVER_RETURN_TOLERANCE
,      UNDER_RETURN_TOLERANCE
,      EQUIPMENT_TYPE
,      RECOVERED_PART_DISP_CODE
,      DEFECT_TRACKING_ON_FLAG
,      USAGE_ITEM_FLAG
,      EVENT_FLAG
,      ELECTRONIC_FLAG
,      DOWNLOADABLE_FLAG
,      VOL_DISCOUNT_EXEMPT_FLAG
,      COUPON_EXEMPT_FLAG
,      COMMS_NL_TRACKABLE_FLAG
,      ASSET_CREATION_CODE
,      COMMS_ACTIVATION_REQD_FLAG
,      ORDERABLE_ON_WEB_FLAG
,      BACK_ORDERABLE_FLAG
,      WEB_STATUS
,      INDIVISIBLE_FLAG
,      DIMENSION_UOM_CODE
,      UNIT_LENGTH
,      UNIT_WIDTH
,      UNIT_HEIGHT
,      BULK_PICKED_FLAG
,      LOT_STATUS_ENABLED
,      DEFAULT_LOT_STATUS_ID
,      SERIAL_STATUS_ENABLED
,      DEFAULT_SERIAL_STATUS_ID
,      LOT_SPLIT_ENABLED
,      LOT_MERGE_ENABLED
,      INVENTORY_CARRY_PENALTY
,      OPERATION_SLACK_PENALTY
,      FINANCING_ALLOWED_FLAG
,      EAM_ITEM_TYPE
,      EAM_ACTIVITY_TYPE_CODE
,      EAM_ACTIVITY_CAUSE_CODE
,      EAM_ACT_NOTIFICATION_FLAG
,      EAM_ACT_SHUTDOWN_STATUS
,      DUAL_UOM_CONTROL
,      SECONDARY_UOM_CODE
,      DUAL_UOM_DEVIATION_HIGH
,      DUAL_UOM_DEVIATION_LOW
,      CONTRACT_ITEM_TYPE_CODE
,      SUBSCRIPTION_DEPEND_FLAG
,      SERV_REQ_ENABLED_CODE
,      SERV_BILLING_ENABLED_FLAG
,      SERV_IMPORTANCE_LEVEL
,      PLANNED_INV_POINT_FLAG
,      LOT_TRANSLATE_ENABLED
,      DEFAULT_SO_SOURCE_TYPE
,      CREATE_SUPPLY_FLAG
,      SUBSTITUTION_WINDOW_CODE
,      SUBSTITUTION_WINDOW_DAYS
,      IB_ITEM_INSTANCE_CLASS
,      CONFIG_MODEL_TYPE
,      LOT_SUBSTITUTION_ENABLED
,      MINIMUM_LICENSE_QUANTITY
,      EAM_ACTIVITY_SOURCE_CODE
,      LIFECYCLE_ID
,      CURRENT_PHASE_ID
,      OBJECT_VERSION_NUMBER
,      TRACKING_QUANTITY_IND
,      ONT_PRICING_QTY_SOURCE
,      SECONDARY_DEFAULT_IND
,      OPTION_SPECIFIC_SOURCED
,      APPROVAL_STATUS
,      VMI_MINIMUM_UNITS
,      VMI_MINIMUM_DAYS
,      VMI_MAXIMUM_UNITS
,      VMI_MAXIMUM_DAYS
,      VMI_FIXED_ORDER_QUANTITY
,      SO_AUTHORIZATION_FLAG
,      CONSIGNED_FLAG
,      ASN_AUTOEXPIRE_FLAG
,      VMI_FORECAST_TYPE
,      FORECAST_HORIZON
,      EXCLUDE_FROM_BUDGET_FLAG
,      DAYS_TGT_INV_SUPPLY
,      DAYS_TGT_INV_WINDOW
,      DAYS_MAX_INV_SUPPLY
,      DAYS_MAX_INV_WINDOW
,      DRP_PLANNED_FLAG
,      CRITICAL_COMPONENT_FLAG
,      CONTINOUS_TRANSFER
,      CONVERGENCE
,      DIVERGENCE
,      CONFIG_ORGS
,      CONFIG_MATCH
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      CAS_NUMBER
,      CHILD_LOT_FLAG
,      CHILD_LOT_PREFIX
,      CHILD_LOT_STARTING_NUMBER
,      CHILD_LOT_VALIDATION_FLAG
,      COPY_LOT_ATTRIBUTE_FLAG
,      DEFAULT_GRADE
,      EXPIRATION_ACTION_CODE
,      EXPIRATION_ACTION_INTERVAL
,      GRADE_CONTROL_FLAG
,      HAZARDOUS_MATERIAL_FLAG
,      HOLD_DAYS
,      LOT_DIVISIBLE_FLAG
,      MATURITY_DAYS
,      PARENT_CHILD_GENERATION_FLAG
,      PROCESS_COSTING_ENABLED_FLAG
,      PROCESS_EXECUTION_ENABLED_FLAG
,      PROCESS_QUALITY_ENABLED_FLAG
,      PROCESS_SUPPLY_LOCATOR_ID
,      PROCESS_SUPPLY_SUBINVENTORY
,      PROCESS_YIELD_LOCATOR_ID
,      PROCESS_YIELD_SUBINVENTORY
,      RECIPE_ENABLED_FLAG
,      RETEST_INTERVAL
,      CHARGE_PERIODICITY_CODE
,      REPAIR_LEADTIME
,      REPAIR_YIELD
,      PREPOSITION_POINT
,      REPAIR_PROGRAM
,      SUBCONTRACTING_COMPONENT
,      OUTSOURCED_ASSEMBLY
,      EGO_MASTER_ITEMS_DFF_CTX
,      GDSN_OUTBOUND_ENABLED_FLAG
,      TRADE_ITEM_DESCRIPTOR
,      STYLE_ITEM_ID
,      STYLE_ITEM_FLAG
,      LAST_SUBMITTED_NIR_ID
,      DEFAULT_MATERIAL_STATUS_ID
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
FROM INV.MTL_SYSTEM_ITEMS_B;

Dependencies

[top of page]

INV.MTL_SYSTEM_ITEMS_B does not reference any database object

INV.MTL_SYSTEM_ITEMS_B is referenced by following:

SchemaAPPS
Package BodyEGO_ITEM_PVT - show dependent code
TriggerEGO_MTL_SYSTEM_ITEMS_B_TR1
SynonymMTL_SYSTEM_ITEMS_B
TriggerMTL_SYSTEM_ITEMS_B_T2_IBE
TriggerMTL_SYSTEM_ITEMS_B_T3_IBE
TriggerMTL_SYSTEM_ITEMS_T1
TriggerMTL_SYSTEM_ITEMS_T1_BOM
TriggerMTL_SYSTEM_ITEMS_T2
TriggerMTL_SYSTEM_ITEMS_T2_BOM
TriggerMTL_SYSTEM_ITEMS_T3_BOM
TriggerMTL_SYSTEM_ITEMS_T4_BOM
TriggerMTL_SYSTEM_ITEMS_T5_BOM
TriggerMTL_SYSTEM_ITEMS_T6_BOM
Materialized ViewOE_ITEMS_MV