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


VIEW: APPS.MTL_SYSTEM_ITEMS_ER1_V

Object Details
Object Name: MTL_SYSTEM_ITEMS_ER1_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.MTL_SYSTEM_ITEMS_ER1_V
Subobject Name:
Status: VALID

View Type

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.

[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.MTL_SYSTEM_ITEMS_ER1_V references the following:

SchemaAPPS
ViewFA_CATEGORIES_B_KFV
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_SECURITY - show dependent code
PL/SQL PackageINV_MEANING_SEL - show dependent code
SynonymMTL_ITEM_CATALOG_GROUPS_KFV
ViewMTL_ITEM_LOCATIONS_KFV
SynonymMTL_ITEM_SUB_DEFAULTS
SynonymMTL_PARAMETERS
ViewMTL_SYSTEM_ITEMS_B_KFV
SynonymMTL_SYSTEM_ITEMS_TL
ViewOKS_COVERAGE_TEMPLTS_V
ViewRCV_ROUTING_HEADERS

APPS.MTL_SYSTEM_ITEMS_ER1_V is not referenced by any database object