[Home] [Help] [Dependency Information]
Object Name: | MSC_ITEM_ATTRIBUTES# |
---|---|
Object Type: | VIEW |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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#;
|
|
|