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_ITEM_ATTRIBUTES#

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
SIMULATION_SET_ID	NUMBER		Yes
PLAN_ID	NUMBER		Yes
ORGANIZATION_ID	NUMBER		Yes
INVENTORY_ITEM_ID	NUMBER		Yes
SR_INSTANCE_ID	NUMBER		Yes
CRITICAL_COMPONENT_FLAG	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	NUMBER
CARRYING_COST	NUMBER
DEMAND_TIME_FENCE_DAYS	NUMBER
ATO_FORECAST_CONTROL	NUMBER
PLANNING_TIME_FENCE_DAYS	NUMBER
STANDARD_COST	NUMBER
PIP_FLAG	NUMBER
LIST_PRICE	NUMBER
SUBSTITUTION_WINDOW	NUMBER
SAFETY_STOCK_BUCKET_DAYS	NUMBER
UNIT_WEIGHT	NUMBER
UNIT_VOLUME	NUMBER
SAFETY_STOCK_PERCENT	NUMBER
ABC_CLASS	NUMBER
MRP_PLANNING_CODE	NUMBER
DRP_PLANNED	NUMBER
DAYS_MAX_INV_SUPPLY	NUMBER
DAYS_MAX_INV_WINDOW	NUMBER
DAYS_TGT_INV_SUPPLY	NUMBER
DAYS_TGT_INV_WINDOW	NUMBER
CONTINOUS_TRANSFER	NUMBER
CONVERGENCE	NUMBER
CREATE_SUPPLY_FLAG	NUMBER
DIVERGENCE	NUMBER
PLANNING_EXCEPTION_SET	VARCHAR2	(10)
INVENTORY_USE_UP_DATE	DATE
PLANNING_MAKE_BUY_CODE	NUMBER
WEIGHT_UOM	VARCHAR2	(3)
VOLUME_UOM	VARCHAR2	(3)
ROUNDING_CONTROL_TYPE	NUMBER
ATP_FLAG	VARCHAR2	(1)
ATP_COMPONENTS_FLAG	VARCHAR2	(1)
DEMAND_FULFILLMENT_LT	NUMBER
UPDATED_COLUMNS_COUNT	NUMBER
FULL_LEAD_TIME	NUMBER
SAFETY_STOCK_CODE	NUMBER
ABC_CLASS_NAME	VARCHAR2	(40)
VMI_MAXIMUM_UNITS	NUMBER
VMI_MINIMUM_UNITS	NUMBER
VMI_MINIMUM_DAYS	NUMBER
VMI_MAXIMUM_DAYS	NUMBER
VMI_FIXED_ORDER_QUANTITY	NUMBER
CONSIGNED_FLAG	NUMBER
LOTS_EXPIRATION	NUMBER
LEADTIME_VARIABILITY	NUMBER
PLANNER_CODE	VARCHAR2	(240)
EO_FLAG	NUMBER
EXCESS_HORIZON	NUMBER
OBSOLESCENCE_DATE	DATE
MIN_SHELF_LIFE_DAYS	NUMBER
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER
REPAIR_LEAD_TIME	NUMBER
REPAIR_YIELD	NUMBER
REPAIR_COST	NUMBER
CRITICALITY_CATEGORY	NUMBER
RELIABILITY	VARCHAR2	(240)
FAILURE_IMPACT	VARCHAR2	(240)
STANDARD_DEVIATION	NUMBER
COEFFICIENT_OF_VARIATION	NUMBER
USER_ATTRIBUTE1	VARCHAR2	(30)
USER_ATTRIBUTE2	VARCHAR2	(30)
USER_ATTRIBUTE3	VARCHAR2	(30)
USER_ATTRIBUTE4	VARCHAR2	(30)
USER_ATTRIBUTE5	VARCHAR2	(30)
USER_ATTRIBUTE6	VARCHAR2	(30)
USER_ATTRIBUTE7	VARCHAR2	(30)
USER_ATTRIBUTE8	VARCHAR2	(30)
USER_ATTRIBUTE9	VARCHAR2	(30)
USER_ATTRIBUTE10	VARCHAR2	(30)
USER_ATTRIBUTE11	VARCHAR2	(30)
USER_ATTRIBUTE12	VARCHAR2	(30)
USER_ATTRIBUTE13	VARCHAR2	(30)
USER_ATTRIBUTE14	VARCHAR2	(30)
USER_ATTRIBUTE15	VARCHAR2	(30)
BASIS_AVG_DAILY_DEMAND	NUMBER
REGION_ID	NUMBER
FORECAST_RULE_FOR_DEMANDS	NUMBER
FORECAST_RULE_FOR_RETURNS	NUMBER
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)
REGION	VARCHAR2	(240)
REGION_INSTANCE_ID	VARCHAR2	(240)
SAFETY_LEAD_TIME	NUMBER
UNSATISFIED_DEMAND_FACTOR	NUMBER
INTERMITTENT_DEMAND	NUMBER
CUSTOMER_ID	NUMBER
CUSTOMER_SITE_ID	NUMBER
CUSTOMER_INSTANCE_ID	NUMBER
MIN_REM_SHELF_LIFE_DAYS	NUMBER
MAX_USAGE_FACTOR	NUMBER
DMD_SATISFIED_PERCENT	NUMBER
MIN_SUP_DEM_PERCENT	NUMBER
PICK_PACK_LT	NUMBER
REPAIR_PROGRAM	NUMBER
PRE_POSITION_POINT	NUMBER
NEW_PLANNED_ORDER	NUMBER
ROP_SAFETY_STOCK	NUMBER
ORDER_COST	NUMBER
COMPUTE_SS	NUMBER
COMPUTE_EOQ	NUMBER
ANNUAL_USAGE	NUMBER
ANNUAL_CARRYING_COST	NUMBER
BUYER_NAME	VARCHAR2	(240)
INTERMITTENCY_THRESHOLD	NUMBER
REPAIR_MODULE	NUMBER
SCRAP_RATE	NUMBER
REBUILD_ACTIVITY	NUMBER
ORDER_PERIOD	NUMBER
INV_DAYS_INCREMENT	NUMBER

Query Text

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


SELECT SIMULATION_SET_ID
,      PLAN_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      SR_INSTANCE_ID
,      CRITICAL_COMPONENT_FLAG
,      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_PERCENT
,      ABC_CLASS
,      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
,      UPDATED_COLUMNS_COUNT
,      FULL_LEAD_TIME
,      SAFETY_STOCK_CODE
,      ABC_CLASS_NAME
,      VMI_MAXIMUM_UNITS
,      VMI_MINIMUM_UNITS
,      VMI_MINIMUM_DAYS
,      VMI_MAXIMUM_DAYS
,      VMI_FIXED_ORDER_QUANTITY
,      CONSIGNED_FLAG
,      LOTS_EXPIRATION
,      LEADTIME_VARIABILITY
,      PLANNER_CODE
,      EO_FLAG
,      EXCESS_HORIZON
,      OBSOLESCENCE_DATE
,      MIN_SHELF_LIFE_DAYS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REPAIR_LEAD_TIME
,      REPAIR_YIELD
,      REPAIR_COST
,      CRITICALITY_CATEGORY
,      RELIABILITY
,      FAILURE_IMPACT
,      STANDARD_DEVIATION
,      COEFFICIENT_OF_VARIATION
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE15
,      BASIS_AVG_DAILY_DEMAND
,      REGION_ID
,      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
,      REGION
,      REGION_INSTANCE_ID
,      SAFETY_LEAD_TIME
,      UNSATISFIED_DEMAND_FACTOR
,      INTERMITTENT_DEMAND
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      CUSTOMER_INSTANCE_ID
,      MIN_REM_SHELF_LIFE_DAYS
,      MAX_USAGE_FACTOR
,      DMD_SATISFIED_PERCENT
,      MIN_SUP_DEM_PERCENT
,      PICK_PACK_LT
,      REPAIR_PROGRAM
,      PRE_POSITION_POINT
,      NEW_PLANNED_ORDER
,      ROP_SAFETY_STOCK
,      ORDER_COST
,      COMPUTE_SS
,      COMPUTE_EOQ
,      ANNUAL_USAGE
,      ANNUAL_CARRYING_COST
,      BUYER_NAME
,      INTERMITTENCY_THRESHOLD
,      REPAIR_MODULE
,      SCRAP_RATE
,      REBUILD_ACTIVITY
,      ORDER_PERIOD
,      INV_DAYS_INCREMENT
FROM MSC.MSC_ITEM_ATTRIBUTES#;

Dependencies

[top of page]

MSC.MSC_ITEM_ATTRIBUTES# references the following:

MSC: MSC_ITEM_ATTRIBUTES

MSC.MSC_ITEM_ATTRIBUTES# is referenced by following:

APPS: MSC_ITEM_ATTRIBUTES