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

TABLE: MSC.MSC_SAFETY_STOCKS

Object Details
Object Name: MSC_SAFETY_STOCKS
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_SAFETY_STOCKS
Subobject Name:
Status: VALID


MSC_SAFETY_STOCKS stores the time-phased safety stock levels for an
item. Each row represents the start date for a safety stock level.
This table is populated by the Snapshot and used by the Planner.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_SAFETY_STOCKS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnSR_INSTANCE_ID
ColumnORGANIZATION_ID
ColumnINVENTORY_ITEM_ID
ColumnPERIOD_START_DATE
ColumnPROJECT_ID
ColumnTASK_ID
ColumnPLANNING_GROUP
ColumnUNIT_NUMBER
ColumnNEW_PLAN_ID
MSC_SAFETY_STOCKS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnINVENTORY_ITEM_ID
ColumnSR_INSTANCE_ID
Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes Plan identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
SR_INSTANCE_ID NUMBER
Yes Source application instance identifier
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
PERIOD_START_DATE DATE
Yes Period start date
SAFETY_STOCK_QUANTITY NUMBER
Yes Safety stock quantity
UPDATED NUMBER

Updated flag
STATUS NUMBER

Status flag
REFRESH_NUMBER NUMBER

Refresh number
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
REQUEST_ID NUMBER

Concurrent Who column
PROGRAM_ID NUMBER

Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
TARGET_SAFETY_STOCK NUMBER

Target safety stock
PROJECT_ID NUMBER

project id
TASK_ID NUMBER

task id
PLANNING_GROUP VARCHAR2 (30)
planning group
USER_DEFINED_SAFETY_STOCKS NUMBER

User defined safety stock quantity
USER_DEFINED_DOS NUMBER

User defined days of supply
TARGET_DAYS_OF_SUPPLY NUMBER

Target days of supply
ACHIEVED_DAYS_OF_SUPPLY NUMBER

Achieved days of supply.
UNIT_NUMBER VARCHAR2 (30)
unit number
DEMAND_VAR_SS_PERCENT NUMBER

Percentage of total Safety Stock held for demand variability
MFG_LTVAR_SS_PERCENT NUMBER

Percentage of total Safety Stock held for Mfg. Leadtime variability
TRANSIT_LTVAR_SS_PERCENT NUMBER

Percentage of total Safety Stock held for Transit Leadtime variability
SUP_LTVAR_SS_PERCENT NUMBER

Percentage of total Safety Stock held for Supplier Leadtime variability
TOTAL_UNPOOLED_SAFETY_STOCK NUMBER

Unpooled Sum of Safety Stocks for all Uncertainity forms
ITEM_TYPE_ID NUMBER

Item type id
ITEM_TYPE_VALUE NUMBER

Item type Value
NEW_PLAN_ID NUMBER

SIMULATION_SET_ID NUMBER

NEW_PLAN_LIST VARCHAR2 (240)
APPLIED NUMBER

Query Text

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


SELECT PLAN_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      INVENTORY_ITEM_ID
,      PERIOD_START_DATE
,      SAFETY_STOCK_QUANTITY
,      UPDATED
,      STATUS
,      REFRESH_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      TARGET_SAFETY_STOCK
,      PROJECT_ID
,      TASK_ID
,      PLANNING_GROUP
,      USER_DEFINED_SAFETY_STOCKS
,      USER_DEFINED_DOS
,      TARGET_DAYS_OF_SUPPLY
,      ACHIEVED_DAYS_OF_SUPPLY
,      UNIT_NUMBER
,      DEMAND_VAR_SS_PERCENT
,      MFG_LTVAR_SS_PERCENT
,      TRANSIT_LTVAR_SS_PERCENT
,      SUP_LTVAR_SS_PERCENT
,      TOTAL_UNPOOLED_SAFETY_STOCK
,      ITEM_TYPE_ID
,      ITEM_TYPE_VALUE
,      NEW_PLAN_ID
,      SIMULATION_SET_ID
,      NEW_PLAN_LIST
,      APPLIED
FROM MSC.MSC_SAFETY_STOCKS;

Dependencies

[top of page]

MSC.MSC_SAFETY_STOCKS does not reference any database object

MSC.MSC_SAFETY_STOCKS is referenced by following:

SchemaMSC
ViewMSC_SAFETY_STOCKS#