[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MTL_SYSTEM_ITEMS_B |
|---|---|
| Object Type: | TABLE |
| Owner: | INV |
| FND Design Data: |  INV.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.
.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MTL_SYSTEM_ITEMS_B_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 INVENTORY_ITEM_ID
ORGANIZATION_ID
|
| MTL_SYSTEM_ITEMS_B_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORGANIZATION_ID
SEGMENT1
|
| MTL_SYSTEM_ITEMS_B_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORGANIZATION_ID
PLANNER_CODE
|
| MTL_SYSTEM_ITEMS_B_N11 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
WEB_STATUS
ORGANIZATION_ID
|
| MTL_SYSTEM_ITEMS_B_N12 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORGANIZATION_ID
CUSTOMER_ORDER_ENABLED_FLAG
SERVICE_ITEM_FLAG
VENDOR_WARRANTY_FLAG
USAGE_ITEM_FLAG
|
| MTL_SYSTEM_ITEMS_B_N13 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORGANIZATION_ID
WIP_SUPPLY_LOCATOR_ID
|
| MTL_SYSTEM_ITEMS_B_N14 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BASE_ITEM_ID
ORGANIZATION_ID
|
| MTL_SYSTEM_ITEMS_B_N15 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
STYLE_ITEM_ID
ORGANIZATION_ID
|
| MTL_SYSTEM_ITEMS_B_N16 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORGANIZATION_ID
EAM_ITEM_TYPE
SERIAL_NUMBER_CONTROL_CODE
|
| MTL_SYSTEM_ITEMS_B_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORGANIZATION_ID
DESCRIPTION
|
| MTL_SYSTEM_ITEMS_B_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INVENTORY_ITEM_STATUS_CODE
|
| MTL_SYSTEM_ITEMS_B_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORGANIZATION_ID
AUTO_CREATED_CONFIG_FLAG
|
| MTL_SYSTEM_ITEMS_B_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
WH_UPDATE_DATE
|
| MTL_SYSTEM_ITEMS_B_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ITEM_CATALOG_GROUP_ID
CATALOG_STATUS_FLAG
|
| MTL_SYSTEM_ITEMS_B_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PRODUCT_FAMILY_ITEM_ID
ORGANIZATION_ID
|
| MTL_SYSTEM_ITEMS_B_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
COMMS_NL_TRACKABLE_FLAG
ORGANIZATION_ID
|
| MTL_SYSTEM_ITEMS_B_N9 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORGANIZATION_ID
BUYER_ID
|
| 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 | |
| SERIAL_TAGGING_FLAG | VARCHAR2 | (1) | Flag indicates if Serial Tagging Assignments exist for an Item |
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
, SERIAL_TAGGING_FLAG
FROM INV.MTL_SYSTEM_ITEMS_B;
INV.MTL_SYSTEM_ITEMS_B does not reference any database object
INV.MTL_SYSTEM_ITEMS_B is referenced by following:
APPS
OE_ITEMS_MV
INV
MTL_SYSTEM_ITEMS_B#
|
|
|
|