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: MSC.MSC_ANALYSIS_AGGREGATE

Object Details

Object Name:	MSC_ANALYSIS_AGGREGATE
Object Type:	TABLE
Owner:	MSC
Subobject Name:
Status:	VALID

This table holds data for row types in the Analysis Workbench. The Analysis Workbench is a set of reports within Inventory Optimization.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_ANALYSIS_AGGREGATE_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PLAN_ID SR_INSTANCE_ID ORGANIZATION_ID SR_CAT_INSTANCE_ID SR_CATEGORY_ID CATEGORY_NAME INVENTORY_ITEM_ID RECORD_TYPE PERIOD_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
PLAN_ID	NUMBER		Yes	Plan Id
RECORD_TYPE	NUMBER		Yes	Record Type
SAFETY_STOCK_QTY	NUMBER			Safety Stock Quantity
SAFETY_STOCK_DOLLARS	NUMBER			Safety Stock Dollars
SAFETY_STOCK_DOS	NUMBER			Safety Stock Days of Supply
TARGET_SAFETY_STOCK_QTY	NUMBER			Target Safety Stock Quantity
TARGET_SAFETY_STOCK_DOLLARS	NUMBER			Target Safety Stock Dollars
TARGET_SAFETY_STOCK_DOS	NUMBER			Target Safety Stock Days of Supply
USERDEF_SAFETY_STOCK_QTY	NUMBER			User Defined Safety Stock Quantity
USERDEF_SAFETY_STOCK_DOLLARS	NUMBER			User Defined Safety Stock Dollars
USERDEF_SAFETY_STOCK_DOS	NUMBER			User Defined Safety Stock Days of Supply
ACHIEVED_SERVICE_LEVEL	NUMBER			Achieved Service Level
ACHIEVED_SERVICE_LEVEL_QTY1	NUMBER			Achieved Service Level Quantity1
ACHIEVED_SERVICE_LEVEL_QTY2	NUMBER			Achieved Service Level Quantity2
TARGET_SERVICE_LEVEL	NUMBER			Target Service Level
INVENTORY_VALUE_DOLLARS	NUMBER			Inventory Value Dollars
PERIOD_TYPE	NUMBER		Yes	Period Type
WEEK_START_DATE	DATE			Week Start Date
PERIOD_START_DATE	DATE			Period Start Date
SR_INSTANCE_ID	NUMBER			Instance id
ORGANIZATION_ID	NUMBER			Organization Id
SR_CAT_INSTANCE_ID	NUMBER			Category Instance Id
SR_CATEGORY_ID	NUMBER			Category Id
CATEGORY_NAME	VARCHAR2	(250)		Category Name
INVENTORY_ITEM_ID	NUMBER			Inventory item Id
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
TOTAL_UNPOOLED_SAFETY_STOCK	NUMBER			Total Unpooled Safety Stock
DEMAND_VAR_SS_PERCENT	NUMBER			Demand Variability Safety Stock Percent
MFG_LTVAR_SS_PERCENT	NUMBER			Manufacturing Leadtime Variability Safety Stock Percent
TRANSIT_LTVAR_SS_PERCENT	NUMBER			Transit Leadtime Variability Safety Stock Percent
SUP_LTVAR_SS_PERCENT	NUMBER			Supplier Leadtime Variability Safety Stock Percent
DEMAND_CLASS	VARCHAR2	(80)		Demand Class
CATEGORY_SET_ID	NUMBER			Category Set Id

Query Text

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


SELECT PLAN_ID
,      RECORD_TYPE
,      SAFETY_STOCK_QTY
,      SAFETY_STOCK_DOLLARS
,      SAFETY_STOCK_DOS
,      TARGET_SAFETY_STOCK_QTY
,      TARGET_SAFETY_STOCK_DOLLARS
,      TARGET_SAFETY_STOCK_DOS
,      USERDEF_SAFETY_STOCK_QTY
,      USERDEF_SAFETY_STOCK_DOLLARS
,      USERDEF_SAFETY_STOCK_DOS
,      ACHIEVED_SERVICE_LEVEL
,      ACHIEVED_SERVICE_LEVEL_QTY1
,      ACHIEVED_SERVICE_LEVEL_QTY2
,      TARGET_SERVICE_LEVEL
,      INVENTORY_VALUE_DOLLARS
,      PERIOD_TYPE
,      WEEK_START_DATE
,      PERIOD_START_DATE
,      SR_INSTANCE_ID
,      ORGANIZATION_ID
,      SR_CAT_INSTANCE_ID
,      SR_CATEGORY_ID
,      CATEGORY_NAME
,      INVENTORY_ITEM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      TOTAL_UNPOOLED_SAFETY_STOCK
,      DEMAND_VAR_SS_PERCENT
,      MFG_LTVAR_SS_PERCENT
,      TRANSIT_LTVAR_SS_PERCENT
,      SUP_LTVAR_SS_PERCENT
,      DEMAND_CLASS
,      CATEGORY_SET_ID
FROM MSC.MSC_ANALYSIS_AGGREGATE;

Dependencies

[top of page]

MSC.MSC_ANALYSIS_AGGREGATE does not reference any database object

MSC.MSC_ANALYSIS_AGGREGATE is referenced by following:

APPS: MSC_ANALYSIS_AGGREGATE