eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.OE_MTL_SYSTEM_ITEMS_V

Object Details

Object Name:	OE_MTL_SYSTEM_ITEMS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ONT.OE_MTL_SYSTEM_ITEMS_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory
INVENTORY_ITEM_ID	NUMBER		Yes
ORGANIZATION_ID	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER
SUMMARY_FLAG	VARCHAR2	(1)	Yes
ENABLED_FLAG	VARCHAR2	(1)	Yes
START_DATE_ACTIVE	DATE
END_DATE_ACTIVE	DATE
DESCRIPTION	VARCHAR2	(240)
BUYER_ID	NUMBER	(9)
ACCOUNTING_RULE_ID	NUMBER
INVOICING_RULE_ID	NUMBER
SEGMENT1	VARCHAR2	(40)
SEGMENT2	VARCHAR2	(40)
SEGMENT3	VARCHAR2	(40)
SEGMENT4	VARCHAR2	(40)
SEGMENT5	VARCHAR2	(40)
SEGMENT6	VARCHAR2	(40)
SEGMENT7	VARCHAR2	(40)
SEGMENT8	VARCHAR2	(40)
SEGMENT9	VARCHAR2	(40)
SEGMENT10	VARCHAR2	(40)
SEGMENT11	VARCHAR2	(40)
SEGMENT12	VARCHAR2	(40)
SEGMENT13	VARCHAR2	(40)
SEGMENT14	VARCHAR2	(40)
SEGMENT15	VARCHAR2	(40)
SEGMENT16	VARCHAR2	(40)
SEGMENT17	VARCHAR2	(40)
SEGMENT18	VARCHAR2	(40)
SEGMENT19	VARCHAR2	(40)
SEGMENT20	VARCHAR2	(40)
ATTRIBUTE_CATEGORY	VARCHAR2	(30)
ATTRIBUTE1	VARCHAR2	(240)
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)
PURCHASING_ITEM_FLAG	VARCHAR2	(1)	Yes
SHIPPABLE_ITEM_FLAG	VARCHAR2	(1)	Yes
CUSTOMER_ORDER_FLAG	VARCHAR2	(1)	Yes
INTERNAL_ORDER_FLAG	VARCHAR2	(1)	Yes
SERVICE_ITEM_FLAG	VARCHAR2	(1)	Yes
INVENTORY_ITEM_FLAG	VARCHAR2	(1)	Yes
ENG_ITEM_FLAG	VARCHAR2	(1)	Yes
INVENTORY_ASSET_FLAG	VARCHAR2	(1)	Yes
PURCHASING_ENABLED_FLAG	VARCHAR2	(1)	Yes
CUSTOMER_ORDER_ENABLED_FLAG	VARCHAR2	(1)	Yes
INTERNAL_ORDER_ENABLED_FLAG	VARCHAR2	(1)	Yes
SO_TRANSACTIONS_FLAG	VARCHAR2	(1)	Yes
MTL_TRANSACTIONS_ENABLED_FLAG	VARCHAR2	(1)	Yes
STOCK_ENABLED_FLAG	VARCHAR2	(1)	Yes
BOM_ENABLED_FLAG	VARCHAR2	(1)	Yes
BUILD_IN_WIP_FLAG	VARCHAR2	(1)	Yes
REVISION_QTY_CONTROL_CODE	NUMBER
ITEM_CATALOG_GROUP_ID	NUMBER
CATALOG_STATUS_FLAG	VARCHAR2	(1)
RETURNABLE_FLAG	VARCHAR2	(1)
DEFAULT_SHIPPING_ORG	NUMBER
COLLATERAL_FLAG	VARCHAR2	(1)
TAXABLE_FLAG	VARCHAR2	(1)
QTY_RCV_EXCEPTION_CODE	VARCHAR2	(25)
ALLOW_ITEM_DESC_UPDATE_FLAG	VARCHAR2	(1)
INSPECTION_REQUIRED_FLAG	VARCHAR2	(1)
RECEIPT_REQUIRED_FLAG	VARCHAR2	(1)
MARKET_PRICE	NUMBER
HAZARD_CLASS_ID	NUMBER
RFQ_REQUIRED_FLAG	VARCHAR2	(1)
QTY_RCV_TOLERANCE	NUMBER
LIST_PRICE_PER_UNIT	NUMBER
UN_NUMBER_ID	NUMBER
PRICE_TOLERANCE_PERCENT	NUMBER
ASSET_CATEGORY_ID	NUMBER
ROUNDING_FACTOR	NUMBER
UNIT_OF_ISSUE	VARCHAR2	(25)
ENFORCE_SHIP_TO_LOCATION_CODE	VARCHAR2	(25)
ALLOW_SUBSTITUTE_RECEIPTS_FLAG	VARCHAR2	(1)
ALLOW_UNORDERED_RECEIPTS_FLAG	VARCHAR2	(1)
ALLOW_EXPRESS_DELIVERY_FLAG	VARCHAR2	(1)
DAYS_EARLY_RECEIPT_ALLOWED	NUMBER
DAYS_LATE_RECEIPT_ALLOWED	NUMBER
RECEIPT_DAYS_EXCEPTION_CODE	VARCHAR2	(25)
RECEIVING_ROUTING_ID	NUMBER
INVOICE_CLOSE_TOLERANCE	NUMBER
RECEIVE_CLOSE_TOLERANCE	NUMBER
AUTO_LOT_ALPHA_PREFIX	VARCHAR2	(30)
START_AUTO_LOT_NUMBER	VARCHAR2	(30)
LOT_CONTROL_CODE	NUMBER
SHELF_LIFE_CODE	NUMBER
SHELF_LIFE_DAYS	NUMBER
SERIAL_NUMBER_CONTROL_CODE	NUMBER
START_AUTO_SERIAL_NUMBER	VARCHAR2	(30)
AUTO_SERIAL_ALPHA_PREFIX	VARCHAR2	(30)
SOURCE_TYPE	NUMBER
SOURCE_ORGANIZATION_ID	NUMBER
SOURCE_SUBINVENTORY	VARCHAR2	(10)
EXPENSE_ACCOUNT	NUMBER
ENCUMBRANCE_ACCOUNT	NUMBER
RESTRICT_SUBINVENTORIES_CODE	NUMBER
UNIT_WEIGHT	NUMBER
WEIGHT_UOM_CODE	VARCHAR2	(3)
VOLUME_UOM_CODE	VARCHAR2	(3)
UNIT_VOLUME	NUMBER
RESTRICT_LOCATORS_CODE	NUMBER
LOCATION_CONTROL_CODE	NUMBER
SHRINKAGE_RATE	NUMBER
ACCEPTABLE_EARLY_DAYS	NUMBER
PLANNING_TIME_FENCE_CODE	NUMBER
DEMAND_TIME_FENCE_CODE	NUMBER
LEAD_TIME_LOT_SIZE	NUMBER
STD_LOT_SIZE	NUMBER
CUM_MANUFACTURING_LEAD_TIME	NUMBER
OVERRUN_PERCENTAGE	NUMBER
MRP_CALCULATE_ATP_FLAG	VARCHAR2	(1)
ACCEPTABLE_RATE_INCREASE	NUMBER
ACCEPTABLE_RATE_DECREASE	NUMBER
CUMULATIVE_TOTAL_LEAD_TIME	NUMBER
PLANNING_TIME_FENCE_DAYS	NUMBER
DEMAND_TIME_FENCE_DAYS	NUMBER
END_ASSEMBLY_PEGGING_FLAG	VARCHAR2	(1)
REPETITIVE_PLANNING_FLAG	VARCHAR2	(1)
PLANNING_EXCEPTION_SET	VARCHAR2	(10)
BOM_ITEM_TYPE	NUMBER		Yes
PICK_COMPONENTS_FLAG	VARCHAR2	(1)	Yes
REPLENISH_TO_ORDER_FLAG	VARCHAR2	(1)	Yes
BASE_ITEM_ID	NUMBER
ATP_COMPONENTS_FLAG	VARCHAR2	(1)	Yes
ATP_FLAG	VARCHAR2	(1)	Yes
FIXED_LEAD_TIME	NUMBER
VARIABLE_LEAD_TIME	NUMBER
WIP_SUPPLY_LOCATOR_ID	NUMBER
WIP_SUPPLY_TYPE	NUMBER
WIP_SUPPLY_SUBINVENTORY	VARCHAR2	(10)
PRIMARY_UOM_CODE	VARCHAR2	(3)
PRIMARY_UNIT_OF_MEASURE	VARCHAR2	(25)
ALLOWED_UNITS_LOOKUP_CODE	NUMBER
COST_OF_SALES_ACCOUNT	NUMBER
SALES_ACCOUNT	NUMBER
DEFAULT_INCLUDE_IN_ROLLUP_FLAG	VARCHAR2	(1)
INVENTORY_ITEM_STATUS_CODE	VARCHAR2	(10)	Yes
INVENTORY_PLANNING_CODE	NUMBER
PLANNER_CODE	VARCHAR2	(10)
PLANNING_MAKE_BUY_CODE	NUMBER
FIXED_LOT_MULTIPLIER	NUMBER
ROUNDING_CONTROL_TYPE	NUMBER
CARRYING_COST	NUMBER
POSTPROCESSING_LEAD_TIME	NUMBER
PREPROCESSING_LEAD_TIME	NUMBER
FULL_LEAD_TIME	NUMBER
ORDER_COST	NUMBER
MRP_SAFETY_STOCK_PERCENT	NUMBER
MRP_SAFETY_STOCK_CODE	NUMBER
MIN_MINMAX_QUANTITY	NUMBER
MAX_MINMAX_QUANTITY	NUMBER
MINIMUM_ORDER_QUANTITY	NUMBER
FIXED_ORDER_QUANTITY	NUMBER
FIXED_DAYS_SUPPLY	NUMBER
MAXIMUM_ORDER_QUANTITY	NUMBER
ATP_RULE_ID	NUMBER
PICKING_RULE_ID	NUMBER
RESERVABLE_TYPE	NUMBER
POSITIVE_MEASUREMENT_ERROR	NUMBER
NEGATIVE_MEASUREMENT_ERROR	NUMBER
ENGINEERING_ECN_CODE	VARCHAR2	(50)
ENGINEERING_ITEM_ID	NUMBER
ENGINEERING_DATE	DATE
SERVICE_STARTING_DELAY	NUMBER
VENDOR_WARRANTY_FLAG	VARCHAR2	(1)	Yes
SERVICEABLE_COMPONENT_FLAG	VARCHAR2	(1)
SERVICEABLE_PRODUCT_FLAG	VARCHAR2	(1)	Yes
BASE_WARRANTY_SERVICE_ID	NUMBER
PAYMENT_TERMS_ID	NUMBER
PREVENTIVE_MAINTENANCE_FLAG	VARCHAR2	(1)
PRIMARY_SPECIALIST_ID	NUMBER
SECONDARY_SPECIALIST_ID	NUMBER
SERVICEABLE_ITEM_CLASS_ID	NUMBER
TIME_BILLABLE_FLAG	VARCHAR2	(1)
MATERIAL_BILLABLE_FLAG	VARCHAR2	(30)
EXPENSE_BILLABLE_FLAG	VARCHAR2	(1)
PRORATE_SERVICE_FLAG	VARCHAR2	(1)
COVERAGE_SCHEDULE_ID	NUMBER
SERVICE_DURATION_PERIOD_CODE	VARCHAR2	(10)
SERVICE_DURATION	NUMBER
WARRANTY_VENDOR_ID	NUMBER
MAX_WARRANTY_AMOUNT	NUMBER
RESPONSE_TIME_PERIOD_CODE	VARCHAR2	(30)
RESPONSE_TIME_VALUE	NUMBER
NEW_REVISION_CODE	VARCHAR2	(30)
INVOICEABLE_ITEM_FLAG	VARCHAR2	(1)	Yes
TAX_CODE	VARCHAR2	(50)
INVOICE_ENABLED_FLAG	VARCHAR2	(1)	Yes
MUST_USE_APPROVED_VENDOR_FLAG	VARCHAR2	(1)	Yes
REQUEST_ID	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_UPDATE_DATE	DATE
OUTSIDE_OPERATION_FLAG	VARCHAR2	(1)	Yes
OUTSIDE_OPERATION_UOM_TYPE	VARCHAR2	(25)
SAFETY_STOCK_BUCKET_DAYS	NUMBER
AUTO_REDUCE_MPS	NUMBER	(22)
COSTING_ENABLED_FLAG	VARCHAR2	(1)	Yes
AUTO_CREATED_CONFIG_FLAG	VARCHAR2	(1)	Yes
CYCLE_COUNT_ENABLED_FLAG	VARCHAR2	(1)	Yes
ITEM_TYPE	VARCHAR2	(30)
MODEL_CONFIG_CLAUSE_NAME	VARCHAR2	(10)
SHIP_MODEL_COMPLETE_FLAG	VARCHAR2	(1)
MRP_PLANNING_CODE	NUMBER
RETURN_INSPECTION_REQUIREMENT	NUMBER
ATO_FORECAST_CONTROL	NUMBER
RELEASE_TIME_FENCE_CODE	NUMBER
RELEASE_TIME_FENCE_DAYS	NUMBER
CONTAINER_ITEM_FLAG	VARCHAR2	(1)
VEHICLE_ITEM_FLAG	VARCHAR2	(1)
MAXIMUM_LOAD_WEIGHT	NUMBER
MINIMUM_FILL_PERCENT	NUMBER
CONTAINER_TYPE_CODE	VARCHAR2	(30)
INTERNAL_VOLUME	NUMBER
WH_UPDATE_DATE	DATE
PRODUCT_FAMILY_ITEM_ID	NUMBER
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(150)
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)
PURCHASING_TAX_CODE	VARCHAR2	(50)

Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SUMMARY_FLAG
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      DESCRIPTION
,      BUYER_ID
,      ACCOUNTING_RULE_ID
,      INVOICING_RULE_ID
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PURCHASING_ITEM_FLAG
,      SHIPPABLE_ITEM_FLAG
,      CUSTOMER_ORDER_FLAG
,      INTERNAL_ORDER_FLAG
,      SERVICE_ITEM_FLAG
,      INVENTORY_ITEM_FLAG
,      ENG_ITEM_FLAG
,      INVENTORY_ASSET_FLAG
,      PURCHASING_ENABLED_FLAG
,      CUSTOMER_ORDER_ENABLED_FLAG
,      INTERNAL_ORDER_ENABLED_FLAG
,      SO_TRANSACTIONS_FLAG
,      MTL_TRANSACTIONS_ENABLED_FLAG
,      STOCK_ENABLED_FLAG
,      BOM_ENABLED_FLAG
,      BUILD_IN_WIP_FLAG
,      REVISION_QTY_CONTROL_CODE
,      ITEM_CATALOG_GROUP_ID
,      CATALOG_STATUS_FLAG
,      RETURNABLE_FLAG
,      DEFAULT_SHIPPING_ORG
,      COLLATERAL_FLAG
,      TAXABLE_FLAG
,      QTY_RCV_EXCEPTION_CODE
,      ALLOW_ITEM_DESC_UPDATE_FLAG
,      INSPECTION_REQUIRED_FLAG
,      RECEIPT_REQUIRED_FLAG
,      MARKET_PRICE
,      HAZARD_CLASS_ID
,      RFQ_REQUIRED_FLAG
,      QTY_RCV_TOLERANCE
,      LIST_PRICE_PER_UNIT
,      UN_NUMBER_ID
,      PRICE_TOLERANCE_PERCENT
,      ASSET_CATEGORY_ID
,      ROUNDING_FACTOR
,      UNIT_OF_ISSUE
,      ENFORCE_SHIP_TO_LOCATION_CODE
,      ALLOW_SUBSTITUTE_RECEIPTS_FLAG
,      ALLOW_UNORDERED_RECEIPTS_FLAG
,      ALLOW_EXPRESS_DELIVERY_FLAG
,      DAYS_EARLY_RECEIPT_ALLOWED
,      DAYS_LATE_RECEIPT_ALLOWED
,      RECEIPT_DAYS_EXCEPTION_CODE
,      RECEIVING_ROUTING_ID
,      INVOICE_CLOSE_TOLERANCE
,      RECEIVE_CLOSE_TOLERANCE
,      AUTO_LOT_ALPHA_PREFIX
,      START_AUTO_LOT_NUMBER
,      LOT_CONTROL_CODE
,      SHELF_LIFE_CODE
,      SHELF_LIFE_DAYS
,      SERIAL_NUMBER_CONTROL_CODE
,      START_AUTO_SERIAL_NUMBER
,      AUTO_SERIAL_ALPHA_PREFIX
,      SOURCE_TYPE
,      SOURCE_ORGANIZATION_ID
,      SOURCE_SUBINVENTORY
,      EXPENSE_ACCOUNT
,      ENCUMBRANCE_ACCOUNT
,      RESTRICT_SUBINVENTORIES_CODE
,      UNIT_WEIGHT
,      WEIGHT_UOM_CODE
,      VOLUME_UOM_CODE
,      UNIT_VOLUME
,      RESTRICT_LOCATORS_CODE
,      LOCATION_CONTROL_CODE
,      SHRINKAGE_RATE
,      ACCEPTABLE_EARLY_DAYS
,      PLANNING_TIME_FENCE_CODE
,      DEMAND_TIME_FENCE_CODE
,      LEAD_TIME_LOT_SIZE
,      STD_LOT_SIZE
,      CUM_MANUFACTURING_LEAD_TIME
,      OVERRUN_PERCENTAGE
,      MRP_CALCULATE_ATP_FLAG
,      ACCEPTABLE_RATE_INCREASE
,      ACCEPTABLE_RATE_DECREASE
,      CUMULATIVE_TOTAL_LEAD_TIME
,      PLANNING_TIME_FENCE_DAYS
,      DEMAND_TIME_FENCE_DAYS
,      END_ASSEMBLY_PEGGING_FLAG
,      REPETITIVE_PLANNING_FLAG
,      PLANNING_EXCEPTION_SET
,      BOM_ITEM_TYPE
,      PICK_COMPONENTS_FLAG
,      REPLENISH_TO_ORDER_FLAG
,      BASE_ITEM_ID
,      ATP_COMPONENTS_FLAG
,      ATP_FLAG
,      FIXED_LEAD_TIME
,      VARIABLE_LEAD_TIME
,      WIP_SUPPLY_LOCATOR_ID
,      WIP_SUPPLY_TYPE
,      WIP_SUPPLY_SUBINVENTORY
,      PRIMARY_UOM_CODE
,      PRIMARY_UNIT_OF_MEASURE
,      ALLOWED_UNITS_LOOKUP_CODE
,      COST_OF_SALES_ACCOUNT
,      SALES_ACCOUNT
,      DEFAULT_INCLUDE_IN_ROLLUP_FLAG
,      INVENTORY_ITEM_STATUS_CODE
,      INVENTORY_PLANNING_CODE
,      PLANNER_CODE
,      PLANNING_MAKE_BUY_CODE
,      FIXED_LOT_MULTIPLIER
,      ROUNDING_CONTROL_TYPE
,      CARRYING_COST
,      POSTPROCESSING_LEAD_TIME
,      PREPROCESSING_LEAD_TIME
,      FULL_LEAD_TIME
,      ORDER_COST
,      MRP_SAFETY_STOCK_PERCENT
,      MRP_SAFETY_STOCK_CODE
,      MIN_MINMAX_QUANTITY
,      MAX_MINMAX_QUANTITY
,      MINIMUM_ORDER_QUANTITY
,      FIXED_ORDER_QUANTITY
,      FIXED_DAYS_SUPPLY
,      MAXIMUM_ORDER_QUANTITY
,      ATP_RULE_ID
,      PICKING_RULE_ID
,      RESERVABLE_TYPE
,      POSITIVE_MEASUREMENT_ERROR
,      NEGATIVE_MEASUREMENT_ERROR
,      ENGINEERING_ECN_CODE
,      ENGINEERING_ITEM_ID
,      ENGINEERING_DATE
,      SERVICE_STARTING_DELAY
,      VENDOR_WARRANTY_FLAG
,      SERVICEABLE_COMPONENT_FLAG
,      SERVICEABLE_PRODUCT_FLAG
,      BASE_WARRANTY_SERVICE_ID
,      PAYMENT_TERMS_ID
,      PREVENTIVE_MAINTENANCE_FLAG
,      PRIMARY_SPECIALIST_ID
,      SECONDARY_SPECIALIST_ID
,      SERVICEABLE_ITEM_CLASS_ID
,      TIME_BILLABLE_FLAG
,      MATERIAL_BILLABLE_FLAG
,      EXPENSE_BILLABLE_FLAG
,      PRORATE_SERVICE_FLAG
,      COVERAGE_SCHEDULE_ID
,      SERVICE_DURATION_PERIOD_CODE
,      SERVICE_DURATION
,      WARRANTY_VENDOR_ID
,      MAX_WARRANTY_AMOUNT
,      RESPONSE_TIME_PERIOD_CODE
,      RESPONSE_TIME_VALUE
,      NEW_REVISION_CODE
,      INVOICEABLE_ITEM_FLAG
,      TAX_CODE
,      INVOICE_ENABLED_FLAG
,      MUST_USE_APPROVED_VENDOR_FLAG
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      OUTSIDE_OPERATION_FLAG
,      OUTSIDE_OPERATION_UOM_TYPE
,      SAFETY_STOCK_BUCKET_DAYS
,      AUTO_REDUCE_MPS
,      COSTING_ENABLED_FLAG
,      AUTO_CREATED_CONFIG_FLAG
,      CYCLE_COUNT_ENABLED_FLAG
,      ITEM_TYPE
,      MODEL_CONFIG_CLAUSE_NAME
,      SHIP_MODEL_COMPLETE_FLAG
,      MRP_PLANNING_CODE
,      RETURN_INSPECTION_REQUIREMENT
,      ATO_FORECAST_CONTROL
,      RELEASE_TIME_FENCE_CODE
,      RELEASE_TIME_FENCE_DAYS
,      CONTAINER_ITEM_FLAG
,      VEHICLE_ITEM_FLAG
,      MAXIMUM_LOAD_WEIGHT
,      MINIMUM_FILL_PERCENT
,      CONTAINER_TYPE_CODE
,      INTERNAL_VOLUME
,      WH_UPDATE_DATE
,      PRODUCT_FAMILY_ITEM_ID
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      PURCHASING_TAX_CODE
FROM APPS.OE_MTL_SYSTEM_ITEMS_V;

Dependencies

[top of page]

APPS.OE_MTL_SYSTEM_ITEMS_V references the following:

APPS: MTL_SYSTEM_ITEMS

APPS.OE_MTL_SYSTEM_ITEMS_V is not referenced by any database object