[Home] [Help] [Dependency Information]
Object Name: | MSC_ANALYSIS_AGGREGATE# |
---|---|
Object Type: | VIEW |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Yes | ||
RECORD_TYPE | NUMBER | Yes | ||
SAFETY_STOCK_QTY | NUMBER | |||
SAFETY_STOCK_DOLLARS | NUMBER | |||
SAFETY_STOCK_DOS | NUMBER | |||
TARGET_SAFETY_STOCK_QTY | NUMBER | |||
TARGET_SAFETY_STOCK_DOLLARS | NUMBER | |||
TARGET_SAFETY_STOCK_DOS | NUMBER | |||
USERDEF_SAFETY_STOCK_QTY | NUMBER | |||
USERDEF_SAFETY_STOCK_DOLLARS | NUMBER | |||
USERDEF_SAFETY_STOCK_DOS | NUMBER | |||
ACHIEVED_SERVICE_LEVEL | NUMBER | |||
ACHIEVED_SERVICE_LEVEL_QTY1 | NUMBER | |||
ACHIEVED_SERVICE_LEVEL_QTY2 | NUMBER | |||
TARGET_SERVICE_LEVEL | NUMBER | |||
INVENTORY_VALUE_DOLLARS | NUMBER | |||
PERIOD_TYPE | NUMBER | Yes | ||
WEEK_START_DATE | DATE | |||
PERIOD_START_DATE | DATE | |||
SR_INSTANCE_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
SR_CAT_INSTANCE_ID | NUMBER | |||
SR_CATEGORY_ID | NUMBER | |||
CATEGORY_NAME | VARCHAR2 | (250) | ||
INVENTORY_ITEM_ID | NUMBER | |||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
TOTAL_UNPOOLED_SAFETY_STOCK | NUMBER | |||
DEMAND_VAR_SS_PERCENT | NUMBER | |||
MFG_LTVAR_SS_PERCENT | NUMBER | |||
TRANSIT_LTVAR_SS_PERCENT | NUMBER | |||
SUP_LTVAR_SS_PERCENT | NUMBER | |||
DEMAND_CLASS | VARCHAR2 | (80) | ||
CATEGORY_SET_ID | NUMBER | |||
PLANNED_PRODUCTION_COST | NUMBER | |||
PLANNED_CARRYING_COST | NUMBER | |||
PLANNED_PURCHASING_COST | NUMBER | |||
PLANNED_TP_COST | NUMBER | |||
PLANNED_TOTAL_COST | NUMBER | |||
PLANNED_REVENUE | NUMBER | |||
PLAN_NAME | VARCHAR2 | (4000) | ||
DETAIL_LEVEL | NUMBER | |||
CATEGORY_ID | NUMBER |
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
, PLANNED_PRODUCTION_COST
, PLANNED_CARRYING_COST
, PLANNED_PURCHASING_COST
, PLANNED_TP_COST
, PLANNED_TOTAL_COST
, PLANNED_REVENUE
, PLAN_NAME
, DETAIL_LEVEL
, CATEGORY_ID
FROM MSC.MSC_ANALYSIS_AGGREGATE#;
|
|
|