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]

VIEW: MSC.MSC_ST_ITEM_ATTRIBUTES#

Object Details

Object Name:	MSC_ST_ITEM_ATTRIBUTES#
Object Type:	VIEW
Owner:	MSC
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
SIMULATION_SET_NAME	VARCHAR2	(240)
ITEM_NAME	VARCHAR2	(250)
ORGANIZATION_CODE	VARCHAR2	(7)
SR_INSTANCE_CODE	VARCHAR2	(3)
ZONE	VARCHAR2	(60)
CUSTOMER_NAME	VARCHAR2	(255)
CUSTOMER_SITE_NAME	VARCHAR2	(30)
CATEGORY	VARCHAR2	(250)
CRITICAL_COMPONENT_FLAG	VARCHAR2	(80)
FULL_LEAD_TIME	NUMBER
PREPROCESSING_LEAD_TIME	NUMBER
POSTPROCESSING_LEAD_TIME	NUMBER
FIXED_LEAD_TIME	NUMBER
VARIABLE_LEAD_TIME	NUMBER
FIXED_ORDER_QUANTITY	NUMBER
FIXED_DAYS_SUPPLY	NUMBER
SHRINKAGE_RATE	NUMBER
FIXED_LOT_MULTIPLIER	NUMBER
MINIMUM_ORDER_QUANTITY	NUMBER
MAXIMUM_ORDER_QUANTITY	NUMBER
SERVICE_LEVEL	VARCHAR2	(40)
CARRYING_COST	NUMBER
DEMAND_TIME_FENCE_DAYS	NUMBER
ATO_FORECAST_CONTROL	VARCHAR2	(80)
PLANNING_TIME_FENCE_DAYS	NUMBER
STANDARD_COST	NUMBER
PIP_FLAG	VARCHAR2	(80)
LIST_PRICE	NUMBER
SUBSTITUTION_WINDOW	NUMBER
SAFETY_STOCK_BUCKET_DAYS	NUMBER
UNIT_WEIGHT	NUMBER
UNIT_VOLUME	NUMBER
SAFETY_STOCK_CODE	VARCHAR2	(80)
SAFETY_STOCK_PERCENT	NUMBER
ABC_CLASS_NAME	VARCHAR2	(40)
MRP_PLANNING_CODE	VARCHAR2	(80)
DRP_PLANNED	VARCHAR2	(80)
DAYS_MAX_INV_SUPPLY	NUMBER
DAYS_MAX_INV_WINDOW	NUMBER
DAYS_TGT_INV_SUPPLY	NUMBER
DAYS_TGT_INV_WINDOW	NUMBER
CONTINOUS_TRANSFER	VARCHAR2	(80)
CONVERGENCE	VARCHAR2	(80)
CREATE_SUPPLY_FLAG	VARCHAR2	(80)
DIVERGENCE	VARCHAR2	(80)
PLANNING_EXCEPTION_SET	VARCHAR2	(10)
INVENTORY_USE_UP_DATE	DATE
PLANNING_MAKE_BUY_CODE	VARCHAR2	(80)
WEIGHT_UOM	VARCHAR2	(3)
VOLUME_UOM	VARCHAR2	(3)
ROUNDING_CONTROL_TYPE	VARCHAR2	(80)
ATP_FLAG	VARCHAR2	(80)
ATP_COMPONENTS_FLAG	VARCHAR2	(80)
DEMAND_FULFILLMENT_LT	VARCHAR2	(40)
LOTS_EXPIRATION	NUMBER
VMI_MINIMUM_UNITS	NUMBER
VMI_MINIMUM_DAYS	NUMBER
VMI_MAXIMUM_UNITS	NUMBER
VMI_MAXIMUM_DAYS	NUMBER
VMI_FIXED_ORDER_QUANTITY	NUMBER
CONSIGNED_FLAG	VARCHAR2	(80)
LEADTIME_VARIABILITY	VARCHAR2	(40)
PLANNER_CODE	VARCHAR2	(240)
EO_FLAG	VARCHAR2	(80)
EXCESS_HORIZON	VARCHAR2	(40)
OBSOLESCENCE_DATE	DATE
MIN_SHELF_LIFE_DAYS	NUMBER
REPAIR_LEAD_TIME	VARCHAR2	(40)
REPAIR_YIELD	VARCHAR2	(40)
REPAIR_COST	VARCHAR2	(40)
RELIABILITY	VARCHAR2	(240)
FAILURE_IMPACT	VARCHAR2	(240)
STANDARD_DEVIATION	VARCHAR2	(40)
COEFFICIENT_OF_VARIATION	VARCHAR2	(40)
BASIS_AVG_DAILY_DEMAND	VARCHAR2	(40)
FORECAST_RULE_FOR_DEMANDS	VARCHAR2	(30)
FORECAST_RULE_FOR_RETURNS	VARCHAR2	(30)
LIFE_TIME_BUY_DATE	DATE
END_OF_LIFE_DATE	DATE
AVG_DEMAND_BEYOND_PH	NUMBER
AVG_RETURNS_BEYOND_PH	NUMBER
RETURN_FORECAST_TIME_FENCE	NUMBER
AVERAGE_DAILY_DEMAND	NUMBER
DEFECTIVE_ITEM_COST	NUMBER
STD_DEVIATION_FOR_DEMAND	NUMBER
MEAN_INTER_ARRIVAL	NUMBER
STD_DEVIATION_INTER_ARRIVAL	NUMBER
INTERARRIVAL_DIST_METHOD	VARCHAR2	(240)
INTERMITTENT_DEMAND	VARCHAR2	(80)
MAX_USAGE_FACTOR	NUMBER
MIN_REM_SHELF_LIFE_DAYS	NUMBER
UNSATISFIED_DEMAND_FACTOR	NUMBER
DMD_SATISFIED_PERCENT	NUMBER
MIN_SUP_DEM_PERCENT	NUMBER
REQUEST_ID	NUMBER
ROP_SAFETY_STOCK	NUMBER
COMPUTE_SS	VARCHAR2	(240)
COMPUTE_EOQ	VARCHAR2	(240)
ORDER_COST	NUMBER
CREATION_DATE	DATE
LAST_UPDATED_BY	NUMBER
LAST_UPDATE_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER
CREATED_BY	NUMBER

Query Text

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


SELECT SIMULATION_SET_NAME
,      ITEM_NAME
,      ORGANIZATION_CODE
,      SR_INSTANCE_CODE
,      ZONE
,      CUSTOMER_NAME
,      CUSTOMER_SITE_NAME
,      CATEGORY
,      CRITICAL_COMPONENT_FLAG
,      FULL_LEAD_TIME
,      PREPROCESSING_LEAD_TIME
,      POSTPROCESSING_LEAD_TIME
,      FIXED_LEAD_TIME
,      VARIABLE_LEAD_TIME
,      FIXED_ORDER_QUANTITY
,      FIXED_DAYS_SUPPLY
,      SHRINKAGE_RATE
,      FIXED_LOT_MULTIPLIER
,      MINIMUM_ORDER_QUANTITY
,      MAXIMUM_ORDER_QUANTITY
,      SERVICE_LEVEL
,      CARRYING_COST
,      DEMAND_TIME_FENCE_DAYS
,      ATO_FORECAST_CONTROL
,      PLANNING_TIME_FENCE_DAYS
,      STANDARD_COST
,      PIP_FLAG
,      LIST_PRICE
,      SUBSTITUTION_WINDOW
,      SAFETY_STOCK_BUCKET_DAYS
,      UNIT_WEIGHT
,      UNIT_VOLUME
,      SAFETY_STOCK_CODE
,      SAFETY_STOCK_PERCENT
,      ABC_CLASS_NAME
,      MRP_PLANNING_CODE
,      DRP_PLANNED
,      DAYS_MAX_INV_SUPPLY
,      DAYS_MAX_INV_WINDOW
,      DAYS_TGT_INV_SUPPLY
,      DAYS_TGT_INV_WINDOW
,      CONTINOUS_TRANSFER
,      CONVERGENCE
,      CREATE_SUPPLY_FLAG
,      DIVERGENCE
,      PLANNING_EXCEPTION_SET
,      INVENTORY_USE_UP_DATE
,      PLANNING_MAKE_BUY_CODE
,      WEIGHT_UOM
,      VOLUME_UOM
,      ROUNDING_CONTROL_TYPE
,      ATP_FLAG
,      ATP_COMPONENTS_FLAG
,      DEMAND_FULFILLMENT_LT
,      LOTS_EXPIRATION
,      VMI_MINIMUM_UNITS
,      VMI_MINIMUM_DAYS
,      VMI_MAXIMUM_UNITS
,      VMI_MAXIMUM_DAYS
,      VMI_FIXED_ORDER_QUANTITY
,      CONSIGNED_FLAG
,      LEADTIME_VARIABILITY
,      PLANNER_CODE
,      EO_FLAG
,      EXCESS_HORIZON
,      OBSOLESCENCE_DATE
,      MIN_SHELF_LIFE_DAYS
,      REPAIR_LEAD_TIME
,      REPAIR_YIELD
,      REPAIR_COST
,      RELIABILITY
,      FAILURE_IMPACT
,      STANDARD_DEVIATION
,      COEFFICIENT_OF_VARIATION
,      BASIS_AVG_DAILY_DEMAND
,      FORECAST_RULE_FOR_DEMANDS
,      FORECAST_RULE_FOR_RETURNS
,      LIFE_TIME_BUY_DATE
,      END_OF_LIFE_DATE
,      AVG_DEMAND_BEYOND_PH
,      AVG_RETURNS_BEYOND_PH
,      RETURN_FORECAST_TIME_FENCE
,      AVERAGE_DAILY_DEMAND
,      DEFECTIVE_ITEM_COST
,      STD_DEVIATION_FOR_DEMAND
,      MEAN_INTER_ARRIVAL
,      STD_DEVIATION_INTER_ARRIVAL
,      INTERARRIVAL_DIST_METHOD
,      INTERMITTENT_DEMAND
,      MAX_USAGE_FACTOR
,      MIN_REM_SHELF_LIFE_DAYS
,      UNSATISFIED_DEMAND_FACTOR
,      DMD_SATISFIED_PERCENT
,      MIN_SUP_DEM_PERCENT
,      REQUEST_ID
,      ROP_SAFETY_STOCK
,      COMPUTE_SS
,      COMPUTE_EOQ
,      ORDER_COST
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
FROM MSC.MSC_ST_ITEM_ATTRIBUTES#;

Dependencies

[top of page]

MSC.MSC_ST_ITEM_ATTRIBUTES# references the following:

MSC: MSC_ST_ITEM_ATTRIBUTES

MSC.MSC_ST_ITEM_ATTRIBUTES# is referenced by following:

APPS: MSC_ST_ITEM_ATTRIBUTES