[Home] [Help] [Dependency Information]
Object Name: | MTL_ITEM_SUB_INVS_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | INV |
FND Design Data: | INV.MTL_ITEM_SUB_INVS_INTERFACE |
Subobject Name: | |
Status: | VALID |
MTL_ITEM_SUB_INVS_INTERFACE temporarily stores a listing of
subinventories assigned to an inventory or engineering item before
loading this information into Oracle Inventory. This table contains a
flag (PRIMARY_SUBINVENTORY_FLAG) which indicates whether or not the
subinventory is the primary subinventory to the item. Only one primary
subinventory per item is allowed.
.
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, if you enter the
ITEM_NUMBER Oracle Inventory will fill in the corresponding
INVENTORY_ITEM_ID for you.
.
Also, you can enter five locators for each item subinventory. Oracle
Inventory will insert these records into the table,
MTL_SECONDARY_LOCATORS after validating the data.
This table is currently not used.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | Inventory item identifier | ||
ORGANIZATION_ID | NUMBER | Organization identifier | ||
SECONDARY_INVENTORY | VARCHAR2 | (10) | Subinventory name | |
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 | ||
PRIMARY_SUBINVENTORY_FLAG | NUMBER | Primary / secondary type code | ||
PICKING_ORDER | NUMBER | Picking order | ||
MIN_MINMAX_QUANTITY | NUMBER | Subinventory-level minmax planning minimum quantity | ||
MAX_MINMAX_QUANTITY | NUMBER | Subinventory-level minmax planning maximum quantity | ||
INVENTORY_PLANNING_CODE | NUMBER | Item planning method | ||
FIXED_LOT_MULTIPLE | NUMBER | Subinventory-level fixed lot multiple | ||
MINIMUM_ORDER_QUANTITY | NUMBER | Subinventory-level minimum order quantity | ||
MAXIMUM_ORDER_QUANTITY | NUMBER | Subinventory-level maximum order quantity | ||
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 | |
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 | ||
ENCUMBRANCE_ACCOUNT | NUMBER | Encumbrance account | ||
TRANSACTION_ID | NUMBER | Row identifier | ||
PROCESS_FLAG | NUMBER | Row status | ||
ORGANIZATION_CODE | VARCHAR2 | (3) | Abbreviation of organization name | |
ITEM_NUMBER | VARCHAR2 | (81) | Concatenated item segments | |
SOURCE_ORG_CODE | VARCHAR2 | (3) | Abbreviation of source organization name | |
LOCATOR_ID1 | NUMBER | First locator identifier | ||
LOCATOR_ID2 | NUMBER | Second locator identifier | ||
LOCATOR_ID3 | NUMBER | Third locator identifier | ||
LOCATOR_ID4 | NUMBER | Fourth locator identifier | ||
LOCATOR_ID5 | NUMBER | Fifth locator identifier | ||
LOCATOR_NAME1 | VARCHAR2 | (81) | First locator name | |
LOCATOR_NAME2 | VARCHAR2 | (81) | Second locator name | |
LOCATOR_NAME3 | VARCHAR2 | (81) | Third locator name | |
LOCATOR_NAME4 | VARCHAR2 | (81) | Fourth locator name | |
LOCATOR_NAME5 | VARCHAR2 | (81) | Fifth locator name | |
TRANSACTION_TYPE | VARCHAR2 | (10) | Specifies the mode in which item open interface is working (eg: CREATE) |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, ORGANIZATION_ID
, SECONDARY_INVENTORY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, PRIMARY_SUBINVENTORY_FLAG
, PICKING_ORDER
, MIN_MINMAX_QUANTITY
, MAX_MINMAX_QUANTITY
, INVENTORY_PLANNING_CODE
, FIXED_LOT_MULTIPLE
, MINIMUM_ORDER_QUANTITY
, MAXIMUM_ORDER_QUANTITY
, SOURCE_TYPE
, SOURCE_ORGANIZATION_ID
, SOURCE_SUBINVENTORY
, 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
, ENCUMBRANCE_ACCOUNT
, TRANSACTION_ID
, PROCESS_FLAG
, ORGANIZATION_CODE
, ITEM_NUMBER
, SOURCE_ORG_CODE
, LOCATOR_ID1
, LOCATOR_ID2
, LOCATOR_ID3
, LOCATOR_ID4
, LOCATOR_ID5
, LOCATOR_NAME1
, LOCATOR_NAME2
, LOCATOR_NAME3
, LOCATOR_NAME4
, LOCATOR_NAME5
, TRANSACTION_TYPE
FROM INV.MTL_ITEM_SUB_INVS_INTERFACE;
INV.MTL_ITEM_SUB_INVS_INTERFACE does not reference any database object
INV.MTL_ITEM_SUB_INVS_INTERFACE is referenced by following:
|
|
|