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]

TABLE: INV.MTL_SECONDARY_INVENTORIES

Object Details

Object Name:	MTL_SECONDARY_INVENTORIES
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.MTL_SECONDARY_INVENTORIES
Subobject Name:
Status:	VALID

MTL_SECONDARY_INVENTORIES is the definition table for the
subinventory. A subinventory is a section of inventory, i.e., raw
material, finished goods, etc. Subinventories are assigned to items
(in a many to one relationship), indicating a list of valid places
where this item will physically exist in inventory.
.
Other attributes include general ledger accounts, demand picking
order, locator type, availability type, and reservable type.
.
You can also specify whether this subinventory is an expense or asset
subinventory (ASSET_INVENTORY), or whether quantities are tracked
(QUANTITY_TRACKED).
.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_SECONDARY_INVENTORIES_U1	NORMAL	UNIQUE	APPS_TS_SEED	ORGANIZATION_ID SECONDARY_INVENTORY_NAME
MTL_SECONDARY_INVENTORIES_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	SUBINVENTORY_TYPE ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SECONDARY_INVENTORY_NAME	VARCHAR2	(10)	Yes	Subinventory name
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
DESCRIPTION	VARCHAR2	(50)		Subinventory description
DISABLE_DATE	DATE			Disable date
INVENTORY_ATP_CODE	NUMBER		Yes	Inventory available to promise code
AVAILABILITY_TYPE	NUMBER		Yes	Subinventory availability code
RESERVABLE_TYPE	NUMBER		Yes	Hard reservation eligibility
LOCATOR_TYPE	NUMBER			Subinventory-level stock locator control type
PICKING_ORDER	NUMBER			Picking order
MATERIAL_ACCOUNT	NUMBER			Subinventory material account
MATERIAL_OVERHEAD_ACCOUNT	NUMBER			Material overhead account
RESOURCE_ACCOUNT	NUMBER			Resource labor account
OVERHEAD_ACCOUNT	NUMBER			Resource overhead account
OUTSIDE_PROCESSING_ACCOUNT	NUMBER			Outside processing account
QUANTITY_TRACKED	NUMBER		Yes	Flag indicating onhand item quantity is recorded
ASSET_INVENTORY	NUMBER		Yes	Items contained within the subinventory regarded as assets
SOURCE_TYPE	NUMBER			Inventory or Supplier sourcing type
SOURCE_SUBINVENTORY	VARCHAR2	(10)		Subinventory to source items from
SOURCE_ORGANIZATION_ID	NUMBER			Organization to source items from
REQUISITION_APPROVAL_TYPE	NUMBER			Approval status of replenishment requisitions generated
EXPENSE_ACCOUNT	NUMBER			Account to expense items issued to subinventory
ENCUMBRANCE_ACCOUNT	NUMBER			Account to encumber items requested by subinventory
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
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
PREPROCESSING_LEAD_TIME	NUMBER			Pre-processing lead time
PROCESSING_LEAD_TIME	NUMBER			Processing lead time
POSTPROCESSING_LEAD_TIME	NUMBER			Post-processing lead time
DEMAND_CLASS	VARCHAR2	(30)		Demand class for the subinventory
PROJECT_ID	NUMBER	(15)		Project identifier
TASK_ID	NUMBER	(15)		Task identifier
SUBINVENTORY_USAGE	NUMBER			Specifies whether costs should be collected for this subinventory in project manufacturing environment
NOTIFY_LIST_ID	NUMBER			ID of Notify List
PICK_UOM_CODE	VARCHAR2	(3)		Unit of measure in which items are stored/picked in this subinventory
DEPRECIABLE_FLAG	NUMBER			Flag indicating if the sub inventory is depreciable
LOCATION_ID	NUMBER	(15)		Location identifier
DEFAULT_COST_GROUP_ID	NUMBER			Default cost group id - Used by WMS only
STATUS_ID	NUMBER			Status Identifier - Used by WMS only
DEFAULT_LOC_STATUS_ID	NUMBER			Default status ID for locators - Used by WMS only
LPN_CONTROLLED_FLAG	NUMBER			Subinventory is LPN Controlled
PICK_METHODOLOGY	NUMBER			Pick Methodology
CARTONIZATION_FLAG	NUMBER	(30)		Cartonization flag
DROPPING_ORDER	NUMBER			Dropping order used to sequence a drop operation
SUBINVENTORY_TYPE	NUMBER			Type of subinventory. A value 1 means storage and 2 means receiving.
PLANNING_LEVEL	NUMBER	(22)		Enable PAR level Planning.
DEFAULT_COUNT_TYPE_CODE	NUMBER	(22)		Default Replenishment Count Type.
ENABLE_BULK_PICK	VARCHAR2	(1)		Enable Bulk Pick
ENABLE_LOCATOR_ALIAS	VARCHAR2	(1)		Indicates whether Locator Aliases are enabled for this Subinventory
ENFORCE_ALIAS_UNIQUENESS	VARCHAR2	(1)		Flag to Enforce Locator Alias Uniqueness in the Subinventory

Query Text

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


SELECT SECONDARY_INVENTORY_NAME
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DESCRIPTION
,      DISABLE_DATE
,      INVENTORY_ATP_CODE
,      AVAILABILITY_TYPE
,      RESERVABLE_TYPE
,      LOCATOR_TYPE
,      PICKING_ORDER
,      MATERIAL_ACCOUNT
,      MATERIAL_OVERHEAD_ACCOUNT
,      RESOURCE_ACCOUNT
,      OVERHEAD_ACCOUNT
,      OUTSIDE_PROCESSING_ACCOUNT
,      QUANTITY_TRACKED
,      ASSET_INVENTORY
,      SOURCE_TYPE
,      SOURCE_SUBINVENTORY
,      SOURCE_ORGANIZATION_ID
,      REQUISITION_APPROVAL_TYPE
,      EXPENSE_ACCOUNT
,      ENCUMBRANCE_ACCOUNT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PREPROCESSING_LEAD_TIME
,      PROCESSING_LEAD_TIME
,      POSTPROCESSING_LEAD_TIME
,      DEMAND_CLASS
,      PROJECT_ID
,      TASK_ID
,      SUBINVENTORY_USAGE
,      NOTIFY_LIST_ID
,      PICK_UOM_CODE
,      DEPRECIABLE_FLAG
,      LOCATION_ID
,      DEFAULT_COST_GROUP_ID
,      STATUS_ID
,      DEFAULT_LOC_STATUS_ID
,      LPN_CONTROLLED_FLAG
,      PICK_METHODOLOGY
,      CARTONIZATION_FLAG
,      DROPPING_ORDER
,      SUBINVENTORY_TYPE
,      PLANNING_LEVEL
,      DEFAULT_COUNT_TYPE_CODE
,      ENABLE_BULK_PICK
,      ENABLE_LOCATOR_ALIAS
,      ENFORCE_ALIAS_UNIQUENESS
FROM INV.MTL_SECONDARY_INVENTORIES;

Dependencies

[top of page]

INV.MTL_SECONDARY_INVENTORIES does not reference any database object

INV.MTL_SECONDARY_INVENTORIES is referenced by following:

APPS: MTL_SECONDARY_INVENTORIES; MTL_SECONDARY_INVENTORIES_T