Skip to content

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 Mandatory Comments
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:

SchemaMSC
TableMSC_ST_ITEM_ATTRIBUTES
MSC.MSC_ST_ITEM_ATTRIBUTES# is referenced by following:

SchemaAPPS
SynonymMSC_ST_ITEM_ATTRIBUTES