[Home] [Help] [Dependency Information]
Object Name: | MSC_INVENTORY_LEVELS |
---|---|
Object Type: | TABLE |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
This table contains inventory level values
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_INVENTORY_LEVELS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
INVENTORY_ITEM_ID
ORGANIZATION_ID SR_INSTANCE_ID PLAN_ID INVENTORY_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory Item Identifier | |
ORGANIZATION_ID | NUMBER | Yes | Organization Identifier | |
SR_INSTANCE_ID | NUMBER | Yes | Source Instance Identifier | |
INVENTORY_DATE | DATE | Yes | Inventory Date | |
MIN_QUANTITY | NUMBER | Minimum Inventory Quantity | ||
MIN_QUANTITY_DOS | NUMBER | Minimum inventory (days of supply) | ||
MAX_QUANTITY | NUMBER | Maximum inventory quantity | ||
MAX_QUANTITY_DOS | NUMBER | Maximum Quantity (Days of supply) | ||
TARGET_QUANTITY | NUMBER | Target Inventory level | ||
TARGET_QUANTITY_DOS | NUMBER | Target Inventory - Days of supply | ||
LAST_UPDATE_DATE | DATE | Yes | Last update date | |
CREATION_DATE | DATE | Yes | Creation date | |
LAST_UPDATED_BY | NUMBER | Yes | Last update by user id | |
CREATED_BY | NUMBER | Yes | Created by user ID | |
LAST_UPDATE_LOGIN | NUMBER | Last update login | ||
PLAN_ID | NUMBER | Yes | Plan Id |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, ORGANIZATION_ID
, SR_INSTANCE_ID
, INVENTORY_DATE
, MIN_QUANTITY
, MIN_QUANTITY_DOS
, MAX_QUANTITY
, MAX_QUANTITY_DOS
, TARGET_QUANTITY
, TARGET_QUANTITY_DOS
, LAST_UPDATE_DATE
, CREATION_DATE
, LAST_UPDATED_BY
, CREATED_BY
, LAST_UPDATE_LOGIN
, PLAN_ID
FROM MSC.MSC_INVENTORY_LEVELS;
MSC.MSC_INVENTORY_LEVELS does not reference any database object
MSC.MSC_INVENTORY_LEVELS is referenced by following:
|
|
|