[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MTL_SYSTEM_ITEMS_ER1_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  INV.MTL_SYSTEM_ITEMS_ER1_V
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INVENTORY_ITEM_ID | NUMBER | Yes | ||
| ORGANIZATION_ID | NUMBER | Yes | ||
| ORGANIZATION_CODE | VARCHAR2 | (3) | ||
| ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | |
| ITEM_CATALOG_GROUP | VARCHAR2 | (40) | ||
| ITEM | VARCHAR2 | (40) | ||
| ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
| INVENTORY_ITEM_STATUS_CODE | VARCHAR2 | (10) | Yes | |
| ITEM_TYPE | VARCHAR2 | (4000) | ||
| PRIMARY_UNIT_OF_MEASURE | VARCHAR2 | (4000) | ||
| TRACKING_QUANTITY | VARCHAR2 | (4000) | ||
| ONT_PRICING_QTY_SOURCE | VARCHAR2 | (4000) | ||
| SECONDARY_UOM | VARCHAR2 | (4000) | ||
| SECONDARY_DEFAULT_IND | VARCHAR2 | (4000) | ||
| DUAL_UOM_DEVIATION_HIGH | NUMBER | |||
| DUAL_UOM_DEVIATION_LOW | NUMBER | |||
| ALLOWED_UNITS | VARCHAR2 | (4000) | ||
| LONG_DESCRIPTION | VARCHAR2 | (4000) | ||
| INVENTORY_ITEM_FLAG | VARCHAR2 | (1) | Yes | |
| STOCK_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| MTL_TRANSACTIONS_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| REVISION_QTY_CONTROL | VARCHAR2 | (4000) | ||
| RESERVABLE_TYPE | VARCHAR2 | (4000) | ||
| CHECK_SHORTAGES_FLAG | VARCHAR2 | (1) | ||
| LOCATION_CONTROL | VARCHAR2 | (4000) | ||
| RESTRICT_SUBINVENTORIES | VARCHAR2 | (4000) | ||
| RESTRICT_LOCATORS | VARCHAR2 | (4000) | ||
| LOT_SPLIT_ENABLED | VARCHAR2 | (1) | ||
| LOT_MERGE_ENABLED | VARCHAR2 | (1) | ||
| LOT_TRANSLATE_ENABLED | VARCHAR2 | (1) | ||
| LOT_SUBSTITUTION_ENABLED | VARCHAR2 | (1) | Lot Substitution Enabled for 11.5.9 | |
| BULK_PICKED_FLAG | VARCHAR2 | (1) | ||
| MOVE_ORDER_RECEIPTS_SUBINV | VARCHAR2 | (10) | ||
| SHELF_LIFE | VARCHAR2 | (4000) | ||
| SHELF_LIFE_DAYS | NUMBER | |||
| LOT_CONTROL | VARCHAR2 | (4000) | ||
| START_AUTO_LOT_NUMBER | VARCHAR2 | (30) | ||
| AUTO_LOT_ALPHA_PREFIX | VARCHAR2 | (30) | ||
| SERIAL_NUMBER_CONTROL | VARCHAR2 | (4000) | ||
| START_AUTO_SERIAL_NUMBER | VARCHAR2 | (30) | ||
| AUTO_SERIAL_ALPHA_PREFIX | VARCHAR2 | (30) | ||
| LOT_STATUS_ENABLED | VARCHAR2 | (1) | ||
| DEFAULT_LOT_STATUS | VARCHAR2 | (4000) | ||
| SERIAL_STATUS_ENABLED | VARCHAR2 | (1) | ||
| DEFAULT_SERIAL_STATUS | VARCHAR2 | (4000) | ||
| BOM_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| BOM_ITEM_TYPE | VARCHAR2 | (4000) | ||
| BASE_ITEM | VARCHAR2 | (40) | ||
| BASE_ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
| CONFIG_MODEL_TYPE | VARCHAR2 | (4000) | ||
| EFFECTIVITY_CONTROL | VARCHAR2 | (4000) | ||
| ENG_ITEM_FLAG | VARCHAR2 | (1) | Yes | |
| EAM_ITEM_TYPE | NUMBER | |||
| EAM_ACTIVITY_TYPE | VARCHAR2 | (4000) | ||
| EAM_ACTIVITY_CAUSE | VARCHAR2 | (4000) | ||
| ASSET_ACTIVITY_SOURCE | VARCHAR2 | (4000) | ||
| EAM_ACT_SHUTDOWN_STATUS | VARCHAR2 | (4000) | ||
| EAM_ACT_NOTIFICATION_FLAG | VARCHAR2 | (1) | ||
| PURCHASING_ITEM_FLAG | VARCHAR2 | (1) | Yes | |
| ALLOW_ITEM_DESC_UPDATE_FLAG | VARCHAR2 | (1) | ||
| PURCHASING_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| MUST_USE_APPROVED_VENDOR_FLAG | VARCHAR2 | (1) | Yes | |
| UNIT_OF_ISSUE | VARCHAR2 | (25) | ||
| HAZARD_CLASS | VARCHAR2 | (4000) | ||
| ROUNDING_FACTOR | NUMBER | |||
| BUYER | VARCHAR2 | (4000) | ||
| UN_NUMBER | VARCHAR2 | (4000) | ||
| ASSET_CATEGORY | VARCHAR2 | (61) | ||
| OUTSIDE_OPERATION_FLAG | VARCHAR2 | (1) | Yes | |
| OUTSIDE_OPERATION_UOM_TYPE | VARCHAR2 | (4000) | ||
| RECEIPT_REQUIRED_FLAG | VARCHAR2 | (1) | ||
| INSPECTION_REQUIRED_FLAG | VARCHAR2 | (1) | ||
| RECEIPT_ROUTING | VARCHAR2 | (80) | ||
| RECEIVING_SUBINVENTORY | VARCHAR2 | (10) | ||
| ENFORCE_SHIP_TO_LOCATION | VARCHAR2 | (4000) | ||
| ALLOW_SUBSTITUTE_RECEIPTS_FLAG | VARCHAR2 | (1) | ||
| ALLOW_EXPRESS_DELIVERY_FLAG | VARCHAR2 | (1) | ||
| ALLOW_UNORDERED_RECEIPTS_FLAG | VARCHAR2 | (1) | ||
| QTY_RCV_EXCEPTION_CODE | VARCHAR2 | (4000) | ||
| QTY_RCV_TOLERANCE | NUMBER | |||
| BUILD_IN_WIP_FLAG | VARCHAR2 | (1) | Yes | |
| WIP_SUPPLY_TYPE | VARCHAR2 | (4000) | ||
| WIP_SUPPLY_SUBINVENTORY | VARCHAR2 | (10) | ||
| WIP_SUPPLY_LOCATOR | CHAR | (1) | ||
| OVERCOMPLETION_TOLERANCE_TYPE | NUMBER | |||
| OVERCOMPLETION_TOLERANCE_VALUE | NUMBER | |||
| PLANNING_MAKE_BUY_CODE | VARCHAR2 | (4000) | ||
| CUSTOMER_ORDER_FLAG | VARCHAR2 | (1) | Yes | |
| INTERNAL_ORDER_FLAG | VARCHAR2 | (1) | Yes | |
| SHIPPABLE_ITEM_FLAG | VARCHAR2 | (1) | Yes | |
| PICK_COMPONENTS_FLAG | VARCHAR2 | (1) | Yes | |
| SHIP_MODEL_COMPLETE_FLAG | VARCHAR2 | (1) | ||
| RETURNABLE_FLAG | VARCHAR2 | (1) | ||
| CUSTOMER_ORDER_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| INTERNAL_ORDER_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| SO_TRANSACTIONS_FLAG | VARCHAR2 | (1) | Yes | |
| REPLENISH_TO_ORDER_FLAG | VARCHAR2 | (1) | Yes | |
| RETURN_INSPECTION_REQUIRED | VARCHAR2 | (4000) | ||
| DEFAULT_SHIPPING_ORG | VARCHAR2 | (240) | ||
| DEFAULT_SHIPPING_SUBINVENTORY | VARCHAR2 | (10) | ||
| OVER_SHIPMENT_TOLERANCE | NUMBER | |||
| OVER_RETURN_TOLERANCE | NUMBER | |||
| UNDER_SHIPMENT_TOLERANCE | NUMBER | |||
| UNDER_RETURN_TOLERANCE | NUMBER | |||
| CONTRACT_ITEM_TYPE_CODE | VARCHAR2 | (30) | ||
| SERVICE_DURATION_PERIOD_CODE | VARCHAR2 | (4000) | ||
| SERVICE_DURATION | NUMBER | |||
| COVERAGE_SCHEDULE | VARCHAR2 | (240) | ||
| SUBSCRIPTION_DEPEND_FLAG | VARCHAR2 | (1) | ||
| SERV_IMPORTANCE_LEVEL | NUMBER | |||
| SERVICEABLE_PRODUCT_FLAG | VARCHAR2 | (1) | Yes | |
| DEFECT_TRACKING_ON_FLAG | VARCHAR2 | (1) | ||
| RECOVERED_PART_DISP_CODE | VARCHAR2 | (4000) | ||
| COMMS_NL_TRACKABLE_FLAG | VARCHAR2 | (1) | ||
| ASSET_CREATION | VARCHAR2 | (4000) | ||
| IB_ITEM_INSTANCE_CLASS | VARCHAR2 | (4000) | ||
| SERV_REQ_ENABLED_CODE | VARCHAR2 | (30) | ||
| COMMS_ACTIVATION_REQD_FLAG | VARCHAR2 | (1) | ||
| SERVICE_STARTING_DELAY | NUMBER | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (240) | ||
| ATTRIBUTE3 | VARCHAR2 | (240) | ||
| ATTRIBUTE4 | VARCHAR2 | (240) | ||
| ATTRIBUTE5 | VARCHAR2 | (240) | ||
| ATTRIBUTE6 | VARCHAR2 | (240) | ||
| ATTRIBUTE7 | VARCHAR2 | (240) | ||
| ATTRIBUTE8 | VARCHAR2 | (240) | ||
| ATTRIBUTE9 | VARCHAR2 | (240) | ||
| ATTRIBUTE10 | VARCHAR2 | (240) | ||
| ATTRIBUTE11 | VARCHAR2 | (240) | ||
| ATTRIBUTE12 | VARCHAR2 | (240) | ||
| ATTRIBUTE13 | VARCHAR2 | (240) | ||
| ATTRIBUTE14 | VARCHAR2 | (240) | ||
| ATTRIBUTE15 | VARCHAR2 | (240) | ||
| CHILD_LOT_FLAG | VARCHAR2 | (1) | Whether a child lot can be created for items | |
| CHILD_LOT_PREFIX | VARCHAR2 | (30) | tem-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 | CHAR | (1) | ||
| PROCESS_SUPPLY_SUBINVENTORY | VARCHAR2 | (10) | Default supply subinventory for process execution transactions | |
| PROCESS_YIELD_LOCATOR | CHAR | (1) | ||
| 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 | ||
| CAS_NUMBER | VARCHAR2 | (30) | Chemical abstracts service registry number |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, ORGANIZATION_ID
, ORGANIZATION_CODE
, ORGANIZATION_NAME
, ITEM_CATALOG_GROUP
, ITEM
, ITEM_DESCRIPTION
, INVENTORY_ITEM_STATUS_CODE
, ITEM_TYPE
, PRIMARY_UNIT_OF_MEASURE
, TRACKING_QUANTITY
, ONT_PRICING_QTY_SOURCE
, SECONDARY_UOM
, SECONDARY_DEFAULT_IND
, DUAL_UOM_DEVIATION_HIGH
, DUAL_UOM_DEVIATION_LOW
, ALLOWED_UNITS
, LONG_DESCRIPTION
, INVENTORY_ITEM_FLAG
, STOCK_ENABLED_FLAG
, MTL_TRANSACTIONS_ENABLED_FLAG
, REVISION_QTY_CONTROL
, RESERVABLE_TYPE
, CHECK_SHORTAGES_FLAG
, LOCATION_CONTROL
, RESTRICT_SUBINVENTORIES
, RESTRICT_LOCATORS
, LOT_SPLIT_ENABLED
, LOT_MERGE_ENABLED
, LOT_TRANSLATE_ENABLED
, LOT_SUBSTITUTION_ENABLED
, BULK_PICKED_FLAG
, MOVE_ORDER_RECEIPTS_SUBINV
, SHELF_LIFE
, SHELF_LIFE_DAYS
, LOT_CONTROL
, START_AUTO_LOT_NUMBER
, AUTO_LOT_ALPHA_PREFIX
, SERIAL_NUMBER_CONTROL
, START_AUTO_SERIAL_NUMBER
, AUTO_SERIAL_ALPHA_PREFIX
, LOT_STATUS_ENABLED
, DEFAULT_LOT_STATUS
, SERIAL_STATUS_ENABLED
, DEFAULT_SERIAL_STATUS
, BOM_ENABLED_FLAG
, BOM_ITEM_TYPE
, BASE_ITEM
, BASE_ITEM_DESCRIPTION
, CONFIG_MODEL_TYPE
, EFFECTIVITY_CONTROL
, ENG_ITEM_FLAG
, EAM_ITEM_TYPE
, EAM_ACTIVITY_TYPE
, EAM_ACTIVITY_CAUSE
, ASSET_ACTIVITY_SOURCE
, EAM_ACT_SHUTDOWN_STATUS
, EAM_ACT_NOTIFICATION_FLAG
, PURCHASING_ITEM_FLAG
, ALLOW_ITEM_DESC_UPDATE_FLAG
, PURCHASING_ENABLED_FLAG
, MUST_USE_APPROVED_VENDOR_FLAG
, UNIT_OF_ISSUE
, HAZARD_CLASS
, ROUNDING_FACTOR
, BUYER
, UN_NUMBER
, ASSET_CATEGORY
, OUTSIDE_OPERATION_FLAG
, OUTSIDE_OPERATION_UOM_TYPE
, RECEIPT_REQUIRED_FLAG
, INSPECTION_REQUIRED_FLAG
, RECEIPT_ROUTING
, RECEIVING_SUBINVENTORY
, ENFORCE_SHIP_TO_LOCATION
, ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, ALLOW_EXPRESS_DELIVERY_FLAG
, ALLOW_UNORDERED_RECEIPTS_FLAG
, QTY_RCV_EXCEPTION_CODE
, QTY_RCV_TOLERANCE
, BUILD_IN_WIP_FLAG
, WIP_SUPPLY_TYPE
, WIP_SUPPLY_SUBINVENTORY
, WIP_SUPPLY_LOCATOR
, OVERCOMPLETION_TOLERANCE_TYPE
, OVERCOMPLETION_TOLERANCE_VALUE
, PLANNING_MAKE_BUY_CODE
, CUSTOMER_ORDER_FLAG
, INTERNAL_ORDER_FLAG
, SHIPPABLE_ITEM_FLAG
, PICK_COMPONENTS_FLAG
, SHIP_MODEL_COMPLETE_FLAG
, RETURNABLE_FLAG
, CUSTOMER_ORDER_ENABLED_FLAG
, INTERNAL_ORDER_ENABLED_FLAG
, SO_TRANSACTIONS_FLAG
, REPLENISH_TO_ORDER_FLAG
, RETURN_INSPECTION_REQUIRED
, DEFAULT_SHIPPING_ORG
, DEFAULT_SHIPPING_SUBINVENTORY
, OVER_SHIPMENT_TOLERANCE
, OVER_RETURN_TOLERANCE
, UNDER_SHIPMENT_TOLERANCE
, UNDER_RETURN_TOLERANCE
, CONTRACT_ITEM_TYPE_CODE
, SERVICE_DURATION_PERIOD_CODE
, SERVICE_DURATION
, COVERAGE_SCHEDULE
, SUBSCRIPTION_DEPEND_FLAG
, SERV_IMPORTANCE_LEVEL
, SERVICEABLE_PRODUCT_FLAG
, DEFECT_TRACKING_ON_FLAG
, RECOVERED_PART_DISP_CODE
, COMMS_NL_TRACKABLE_FLAG
, ASSET_CREATION
, IB_ITEM_INSTANCE_CLASS
, SERV_REQ_ENABLED_CODE
, COMMS_ACTIVATION_REQD_FLAG
, SERVICE_STARTING_DELAY
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, 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
, PROCESS_SUPPLY_SUBINVENTORY
, PROCESS_YIELD_LOCATOR
, PROCESS_YIELD_SUBINVENTORY
, RECIPE_ENABLED_FLAG
, RETEST_INTERVAL
, CAS_NUMBER
FROM APPS.MTL_SYSTEM_ITEMS_ER1_V;
APPS
FA_CATEGORIES_B_KFV
HR_ALL_ORGANIZATION_UNITS_TL
HR_GENERAL
- show dependent code
HR_ORGANIZATION_UNITS
HR_SECURITY
- show dependent code
INV_MEANING_SEL
- show dependent code
MTL_ITEM_CATALOG_GROUPS_KFV
MTL_ITEM_LOCATIONS_KFV
MTL_ITEM_SUB_DEFAULTS
MTL_PARAMETERS
MTL_SYSTEM_ITEMS_B_KFV
MTL_SYSTEM_ITEMS_TL
OKS_COVERAGE_TEMPLTS_V
RCV_ROUTING_HEADERS
APPS.MTL_SYSTEM_ITEMS_ER1_V is not referenced by any database object
|
|
|
|