[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MTL_SYSTEM_ITEMS_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | INV |
| FND Design Data: |  INV.MTL_SYSTEM_ITEMS_INTERFACE
|
| Subobject Name: | |
| Status: | VALID |
MTL_SYSTEM_ITEMS_INTERFACE temporarily stores the definitions for
inventory items, engineering items and purchasing items before loading
this information into Oracle Inventory.
.
This table contains user friendly columns which allow you to easily
enter your data as well as their corresponding foreign keys. Oracle
Inventory will default column values you do not enter, after
performing the proper validation. For example, you enter the
ORGANIZATION_CODE, and Oracle Inventory will fill in the corresponding
ORGANIZATION_ID for you. It is strongly recommended that users enter
the segment information for the item instead of the item number.
.
You can also specifiy a TEMPLATE_ID to copy item attributes from.
.
Also, if you enter REVISION, Oracle Inventory will insert a record
into MTL_ITEM_REVISIONS for your item.
.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MTL_SYSTEM_ITEMS_INTERFACE_U2 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 INTERFACE_TABLE_UNIQUE_ID
|
| MTL_SYSTEM_ITEMS_INTERFACE_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
INVENTORY_ITEM_ID
ORGANIZATION_ID
|
| MTL_SYSTEM_ITEMS_INTERFACE_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
ITEM_NUMBER
|
| MTL_SYSTEM_ITEMS_INTERFACE_N3 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
SET_PROCESS_ID
PROCESS_FLAG
ORGANIZATION_ID
SOURCE_SYSTEM_ID
SOURCE_SYSTEM_REFERENCE
|
| MTL_SYSTEM_ITEMS_INTERFACE_N4 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
ORGANIZATION_ID
SEGMENT1
|
| MTL_SYSTEM_ITEMS_INTERFACE_N5 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
SET_PROCESS_ID
CONFIRM_STATUS
PROCESS_FLAG
ORGANIZATION_ID
SOURCE_SYSTEM_ID
SOURCE_SYSTEM_REFERENCE
|
| MTL_SYSTEM_ITEMS_INTERFACE_N6 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
TRANSACTION_ID
|
| MTL_SYSTEM_ITEMS_INTERFACE_N7 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
BUNDLE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INVENTORY_ITEM_ID | NUMBER | Inventory item identifier | ||
| ORGANIZATION_ID | NUMBER | Organization identifier | ||
| LAST_UPDATE_DATE | DATE | Standard Who column | ||
| LAST_UPDATED_BY | NUMBER | Standard Who column | ||
| CREATION_DATE | DATE | Standard Who column | ||
| CREATED_BY | NUMBER | Standard Who column | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| SUMMARY_FLAG | VARCHAR2 | (1) | Flexfield summary flag | |
| ENABLED_FLAG | VARCHAR2 | (1) | 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 | |
| BUYER_ID | NUMBER | 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) | Flag indicating purchasing item | |
| SHIPPABLE_ITEM_FLAG | VARCHAR2 | (1) | Flag indicating shippable item | |
| CUSTOMER_ORDER_FLAG | VARCHAR2 | (1) | Flag indicating customer orderable item | |
| INTERNAL_ORDER_FLAG | VARCHAR2 | (1) | Flag indicating internally orderable item | |
| SERVICE_ITEM_FLAG | VARCHAR2 | (1) | Flag indicating service item | |
| INVENTORY_ITEM_FLAG | VARCHAR2 | (1) | Flag indicating inventory item | |
| ENG_ITEM_FLAG | VARCHAR2 | (1) | Flag indicating engineering item | |
| INVENTORY_ASSET_FLAG | VARCHAR2 | (1) | Flag indicating item is an inventory asset | |
| PURCHASING_ENABLED_FLAG | VARCHAR2 | (1) | Flag indicating item is purchasable | |
| CUSTOMER_ORDER_ENABLED_FLAG | VARCHAR2 | (1) | Flag indicating item is customer orderable | |
| INTERNAL_ORDER_ENABLED_FLAG | VARCHAR2 | (1) | Flag indicating item is internally orderable | |
| SO_TRANSACTIONS_FLAG | VARCHAR2 | (1) | Sales order transactions flag | |
| MTL_TRANSACTIONS_ENABLED_FLAG | VARCHAR2 | (1) | Flag indicating item is transactable | |
| STOCK_ENABLED_FLAG | VARCHAR2 | (1) | Flag indicating item is stockable | |
| BOM_ENABLED_FLAG | VARCHAR2 | (1) | Flag indicating item may appear on a BOM | |
| BUILD_IN_WIP_FLAG | VARCHAR2 | (1) | 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 | |
| CHECK_SHORTAGES_FLAG | VARCHAR2 | (1) | Flag indicating material shortages should be checked for this item | |
| 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 | |
| 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 | Purchace 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 (y/n) for MRP | |
| REPETITIVE_PLANNING_FLAG | VARCHAR2 | (1) | Flag indicating item to be planned as repetitive schedule | |
| PLANNING_EXCEPTION_SET | VARCHAR2 | (10) | Exeption control set | |
| BOM_ITEM_TYPE | NUMBER | Type of item | ||
| PICK_COMPONENTS_FLAG | VARCHAR2 | (1) | Flag indicating whether all shippable components should be picked | |
| REPLENISH_TO_ORDER_FLAG | VARCHAR2 | (1) | Assemble to Order flag | |
| BASE_ITEM_ID | NUMBER | Base item identifier | ||
| ATP_COMPONENTS_FLAG | VARCHAR2 | (1) | Flag indicating whether item may have components requiring ATP check | |
| ATP_FLAG | VARCHAR2 | (1) | 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 (Y or N) | |
| INVENTORY_ITEM_STATUS_CODE | VARCHAR2 | (10) | 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) | 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) | 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) | Indicates whether the 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) | Flag indicating item may appear on invoices | |
| TAX_CODE | VARCHAR2 | (50) | Tax code | |
| INVOICE_ENABLED_FLAG | VARCHAR2 | (1) | Indicates whether the item can be invoiced | |
| MUST_USE_APPROVED_VENDOR_FLAG | VARCHAR2 | (1) | Flag indicating purchases restricted to approved supllier | |
| REQUEST_ID | NUMBER | Concurrent Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who column | ||
| PROGRAM_ID | NUMBER | Concurrent Who column | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Who column | ||
| OUTSIDE_OPERATION_FLAG | VARCHAR2 | (1) | 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) | Flag indicating cost information is maintained | |
| CYCLE_COUNT_ENABLED_FLAG | VARCHAR2 | (1) | Flag indicating item may be cycle counted | |
| DEMAND_SOURCE_LINE | VARCHAR2 | (30) | Demand source line - used for ATO | |
| COPY_ITEM_ID | NUMBER | Inventory item identifier to copy attributes from | ||
| SET_ID | VARCHAR2 | (10) | Set identifier - used for ATO | |
| REVISION | VARCHAR2 | (3) | Item revision | |
| AUTO_CREATED_CONFIG_FLAG | VARCHAR2 | (1) | Flag indicating configuration item automatically created | |
| ITEM_TYPE | VARCHAR2 | (30) | User-defined item type | |
| MODEL_CONFIG_CLAUSE_NAME | VARCHAR2 | (10) | (not used for open interface) | |
| 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 | ||
| DEMAND_SOURCE_TYPE | NUMBER | Demand source type - used for ATO | ||
| DEMAND_SOURCE_HEADER_ID | NUMBER | Demand source header identifier - used for ATO | ||
| TRANSACTION_ID | NUMBER | Row identifier | ||
| PROCESS_FLAG | NUMBER | Row status | ||
| ORGANIZATION_CODE | VARCHAR2 | (3) | Abbreviation of organization name | |
| ITEM_NUMBER | VARCHAR2 | (700) | Concatenated item segments | |
| COPY_ITEM_NUMBER | VARCHAR2 | (81) | Concatenated item segments of copied item | |
| TEMPLATE_ID | NUMBER | Template identifier | ||
| TEMPLATE_NAME | VARCHAR2 | (30) | Template name | |
| COPY_ORGANIZATION_ID | NUMBER | Organization identifier of copied item | ||
| COPY_ORGANIZATION_CODE | VARCHAR2 | (3) | Abbreviation of organization name of copied item | |
| ATO_FORECAST_CONTROL | NUMBER | Type of forecast control for ATO | ||
| TRANSACTION_TYPE | VARCHAR2 | (10) | Transaction type | |
| MATERIAL_COST | NUMBER | Material cost | ||
| MATERIAL_SUB_ELEM | VARCHAR2 | (10) | Material sub-element | |
| MATERIAL_OH_RATE | NUMBER | Material overhead rate | ||
| MATERIAL_OH_SUB_ELEM | VARCHAR2 | (10) | Material overhead sub-element | |
| MATERIAL_SUB_ELEM_ID | NUMBER | Material sub-element identifier | ||
| MATERIAL_OH_SUB_ELEM_ID | NUMBER | Material overhead sub-element identifier | ||
| RELEASE_TIME_FENCE_CODE | NUMBER | Release time fence code | ||
| RELEASE_TIME_FENCE_DAYS | NUMBER | Release time fence days | ||
| CONTAINER_ITEM_FLAG | VARCHAR2 | (1) | Flag indicating whether item is a container. Used for shipping sales orders | |
| VEHICLE_ITEM_FLAG | VARCHAR2 | (1) | Flag indicating whether item is a vehicle. 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 a container or vehicle should be used | ||
| CONTAINER_TYPE_CODE | VARCHAR2 | (30) | Container type code for container items. Container types are user definable | |
| INTERNAL_VOLUME | NUMBER | Internal volume of container items. Used by Shipping to calculate container capacity restrictions | ||
| SET_PROCESS_ID | NUMBER | Yes | Used when multiple Item Open Interface processes are run in parallel | |
| WH_UPDATE_DATE | DATE | Standard Who column | ||
| PRODUCT_FAMILY_ITEM_ID | NUMBER | (not used in open interface) | ||
| PURCHASING_TAX_CODE | VARCHAR2 | (50) | Purchasing tax code | |
| OVERCOMPLETION_TOLERANCE_TYPE | NUMBER | Overcompletion tolerance type | ||
| OVERCOMPLETION_TOLERANCE_VALUE | NUMBER | Overcompletion tolerance type | ||
| EFFECTIVITY_CONTROL | NUMBER | Effectivity control code. Indicates if the item is under Date Effectivity or Model/Unit Number Effectivity control. | ||
| 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 | |
| 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) | 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) | 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 | |
| LONG_DESCRIPTION | VARCHAR2 | (4000) | Item Long Description | |
| 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 time in between two operations | ||
| FINANCING_ALLOWED_FLAG | VARCHAR2 | (1) | Item is eligible for financing | |
| EAM_ITEM_TYPE | NUMBER | Oracle Internal use only - reserved for future use | ||
| EAM_ACTIVITY_TYPE_CODE | VARCHAR2 | (30) | Oracle Internal use only - reserved for future use | |
| EAM_ACTIVITY_CAUSE_CODE | VARCHAR2 | (30) | Oracle Internal use only - reserved for future use | |
| EAM_ACT_NOTIFICATION_FLAG | VARCHAR2 | (1) | Oracle Internal use only - reserved for future use | |
| EAM_ACT_SHUTDOWN_STATUS | VARCHAR2 | (30) | Oracle Internal use only - reserved for future use | |
| 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 SubstitutionEnabled 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 | ||
| 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 | |
| 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 | 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 | ||
| SOURCE_SYSTEM_ID | NUMBER | Source System Identifier | ||
| SOURCE_SYSTEM_REFERENCE | VARCHAR2 | (255) | Source System Referenc | |
| SOURCE_SYSTEM_REFERENCE_DESC | VARCHAR2 | (240) | Source System Reference Identifier | |
| GLOBAL_TRADE_ITEM_NUMBER | VARCHAR2 | (14) | UCCNET : Global Trade Item Number | |
| CONFIRM_STATUS | VARCHAR2 | (3) | PDH : Matching Confirmation | |
| CHANGE_ID | NUMBER | Change Identifier | ||
| CHANGE_LINE_ID | NUMBER | Change Line Identifier | ||
| ITEM_CATALOG_GROUP_NAME | VARCHAR2 | (820) | Item Catalog Group Name | |
| REVISION_IMPORT_POLICY | VARCHAR2 | (30) | PDH : Revision Import Policy | |
| GTIN_DESCRIPTION | VARCHAR2 | (240) | UCCNET: GTIN Description | |
| INTERFACE_TABLE_UNIQUE_ID | NUMBER | Unique Row Identifier | ||
| 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 | |
| STYLE_ITEM_NUMBER | VARCHAR2 | (700) | Contains Style Item Number | |
| COPY_REVISION_ID | NUMBER | Contains Revision Id | ||
| BUNDLE_ID | NUMBER | Bundle Identification Id, generated using the sequence MTL_SYSTEM_ITEMS_INTERFACE_S | ||
| MESSAGE_TIMESTAMP | DATE | Time of message receipt | ||
| MESSAGE_ID | NUMBER | Unique identification for incoming message | ||
| OPERATION | VARCHAR2 | (80) | Operation type of the incoming message | |
| TOP_ITEM_FLAG | VARCHAR2 | (1) | Identifier for topmost items in pack | |
| GPC_CODE | VARCHAR2 | (8) | Global Product Classification Code | |
| 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 |
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
, CHECK_SHORTAGES_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
, CYCLE_COUNT_ENABLED_FLAG
, DEMAND_SOURCE_LINE
, COPY_ITEM_ID
, SET_ID
, REVISION
, AUTO_CREATED_CONFIG_FLAG
, ITEM_TYPE
, MODEL_CONFIG_CLAUSE_NAME
, SHIP_MODEL_COMPLETE_FLAG
, MRP_PLANNING_CODE
, RETURN_INSPECTION_REQUIREMENT
, DEMAND_SOURCE_TYPE
, DEMAND_SOURCE_HEADER_ID
, TRANSACTION_ID
, PROCESS_FLAG
, ORGANIZATION_CODE
, ITEM_NUMBER
, COPY_ITEM_NUMBER
, TEMPLATE_ID
, TEMPLATE_NAME
, COPY_ORGANIZATION_ID
, COPY_ORGANIZATION_CODE
, ATO_FORECAST_CONTROL
, TRANSACTION_TYPE
, MATERIAL_COST
, MATERIAL_SUB_ELEM
, MATERIAL_OH_RATE
, MATERIAL_OH_SUB_ELEM
, MATERIAL_SUB_ELEM_ID
, MATERIAL_OH_SUB_ELEM_ID
, 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
, SET_PROCESS_ID
, WH_UPDATE_DATE
, PRODUCT_FAMILY_ITEM_ID
, PURCHASING_TAX_CODE
, OVERCOMPLETION_TOLERANCE_TYPE
, OVERCOMPLETION_TOLERANCE_VALUE
, EFFECTIVITY_CONTROL
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, 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
, LONG_DESCRIPTION
, 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
, TRACKING_QUANTITY_IND
, ONT_PRICING_QTY_SOURCE
, SECONDARY_DEFAULT_IND
, 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
, SOURCE_SYSTEM_ID
, SOURCE_SYSTEM_REFERENCE
, SOURCE_SYSTEM_REFERENCE_DESC
, GLOBAL_TRADE_ITEM_NUMBER
, CONFIRM_STATUS
, CHANGE_ID
, CHANGE_LINE_ID
, ITEM_CATALOG_GROUP_NAME
, REVISION_IMPORT_POLICY
, GTIN_DESCRIPTION
, INTERFACE_TABLE_UNIQUE_ID
, GDSN_OUTBOUND_ENABLED_FLAG
, TRADE_ITEM_DESCRIPTOR
, STYLE_ITEM_ID
, STYLE_ITEM_FLAG
, STYLE_ITEM_NUMBER
, COPY_REVISION_ID
, BUNDLE_ID
, MESSAGE_TIMESTAMP
, MESSAGE_ID
, OPERATION
, TOP_ITEM_FLAG
, GPC_CODE
, 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_INTERFACE;
INV.MTL_SYSTEM_ITEMS_INTERFACE does not reference any database object
INV.MTL_SYSTEM_ITEMS_INTERFACE is referenced by following:
APPS
EGO_MSII_UNIQUE_ID_T
MTL_SYSTEM_ITEMS_INTERFACE
|
|
|
|