DBA Data[Home] [Help] [Dependency Information]

TABLE: MSC.MSC_ITEM_ATTRIBUTES

Object Details
Object Name: MSC_ITEM_ATTRIBUTES
Object Type: TABLE
Owner: MSC
Subobject Name:
Status: VALID


This table contains all the item attributes that can be updated againist a Item simulation set.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_ITEM_ATTRIBUTES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnINVENTORY_ITEM_ID
ColumnSIMULATION_SET_ID
ColumnSR_INSTANCE_ID
ColumnREGION_ID
ColumnCUSTOMER_ID
ColumnCUSTOMER_SITE_ID
MSC_ITEM_ATTRIBUTES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnSIMULATION_SET_ID
ColumnSR_INSTANCE_ID
MSC_ITEM_ATTRIBUTES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSIMULATION_SET_ID
ColumnINVENTORY_ITEM_ID
MSC_ITEM_ATTRIBUTES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSR_INSTANCE_ID
ColumnORGANIZATION_ID
ColumnINVENTORY_ITEM_ID
Columns
Name Datatype Length Mandatory Comments
SIMULATION_SET_ID NUMBER
Yes Simulation Set Id
PLAN_ID NUMBER
Yes Plan Id
ORGANIZATION_ID NUMBER
Yes Organization Id
INVENTORY_ITEM_ID NUMBER
Yes Inventory Item Id
SR_INSTANCE_ID NUMBER
Yes Sr Instance Id
CRITICAL_COMPONENT_FLAG NUMBER

Critical Component Flag
PREPROCESSING_LEAD_TIME NUMBER

Preprocessing Lead Time
POSTPROCESSING_LEAD_TIME NUMBER

Postprocessing Lead Time
FIXED_LEAD_TIME NUMBER

Fixed Lead Time
VARIABLE_LEAD_TIME NUMBER

Variable Lead Time
FIXED_ORDER_QUANTITY NUMBER

Fixed Order Quantity
FIXED_DAYS_SUPPLY NUMBER

Fixed Days Supply
SHRINKAGE_RATE NUMBER

Shrinkage Rate
FIXED_LOT_MULTIPLIER NUMBER

Fixed Lot Multiplier
MINIMUM_ORDER_QUANTITY NUMBER

Minimum Order Quantity
MAXIMUM_ORDER_QUANTITY NUMBER

Maximum Order Quantity
SERVICE_LEVEL NUMBER

Service Level
CARRYING_COST NUMBER

Carrying Cost
DEMAND_TIME_FENCE_DAYS NUMBER

Demand Time Fence Days
ATO_FORECAST_CONTROL NUMBER

ATO Forecast Control
PLANNING_TIME_FENCE_DAYS NUMBER

Planning Time Fence Days
STANDARD_COST NUMBER

Standard Cost
PIP_FLAG NUMBER

Pip Flag
LIST_PRICE NUMBER

List Price
SUBSTITUTION_WINDOW NUMBER

Substitution Window
SAFETY_STOCK_BUCKET_DAYS NUMBER

Safety Stock Bucket Days
UNIT_WEIGHT NUMBER

Unit weight
UNIT_VOLUME NUMBER

Unit Volume
SAFETY_STOCK_PERCENT NUMBER

Safety Stock Percent
ABC_CLASS NUMBER

ABC Class
MRP_PLANNING_CODE NUMBER

MRP Planning Code
DRP_PLANNED NUMBER

DRP Planned
DAYS_MAX_INV_SUPPLY NUMBER

Days Max Inv Supply
DAYS_MAX_INV_WINDOW NUMBER

Days Max Inv Window
DAYS_TGT_INV_SUPPLY NUMBER

Days Target Inv Supply
DAYS_TGT_INV_WINDOW NUMBER

Days Target Inv Window
CONTINOUS_TRANSFER NUMBER

Continous Transfer
CONVERGENCE NUMBER

Convergence
CREATE_SUPPLY_FLAG NUMBER

Create Supply Flag
DIVERGENCE NUMBER

Divergence
PLANNING_EXCEPTION_SET VARCHAR2 (10)
Planning Exception Set
INVENTORY_USE_UP_DATE DATE

Inventory Use Up Date
PLANNING_MAKE_BUY_CODE NUMBER

Planning Make Buy Code
WEIGHT_UOM VARCHAR2 (3)
Weight Uom
VOLUME_UOM VARCHAR2 (3)
Volume Uom
ROUNDING_CONTROL_TYPE NUMBER

Rounding Control Type
ATP_FLAG VARCHAR2 (1)
ATP Flag
ATP_COMPONENTS_FLAG VARCHAR2 (1)
ATP Components Flag
DEMAND_FULFILLMENT_LT NUMBER

Demand Fulfillment Lead Time
UPDATED_COLUMNS_COUNT NUMBER

Column to identify how many attributes are updated.
FULL_LEAD_TIME NUMBER

Full Lead Time
SAFETY_STOCK_CODE NUMBER

Safety Stock Code
ABC_CLASS_NAME VARCHAR2 (40)
ABC Class Name
VMI_MAXIMUM_UNITS NUMBER

VMI Maximum Units
VMI_MINIMUM_UNITS NUMBER

VMI Minimum Units
VMI_MINIMUM_DAYS NUMBER

VMI Minimum Days
VMI_MAXIMUM_DAYS NUMBER

VMI Maximum Days
VMI_FIXED_ORDER_QUANTITY NUMBER

VMI Fixed Order Quantity
CONSIGNED_FLAG NUMBER

Consigned Flag
LOTS_EXPIRATION NUMBER

Lots Expiration
LEADTIME_VARIABILITY NUMBER

Leadtime Variability
PLANNER_CODE VARCHAR2 (240)
Planner Code
EO_FLAG NUMBER

EO Flag
EXCESS_HORIZON NUMBER

Excess Horizon
OBSOLESCENCE_DATE DATE

Obsolescence Date
MIN_SHELF_LIFE_DAYS NUMBER

Minimum Shelf Life Days
LAST_UPDATE_DATE DATE
Yes standard WHO Column
LAST_UPDATED_BY NUMBER
Yes standard WHO Column
CREATION_DATE DATE
Yes standard WHO Column
CREATED_BY NUMBER
Yes standard WHO Column
LAST_UPDATE_LOGIN NUMBER

standard WHO Column
REPAIR_LEAD_TIME NUMBER

Repair Lead Time
REPAIR_YIELD NUMBER

Repair Yield
REPAIR_COST NUMBER

Repair Cost
CRITICALITY_CATEGORY NUMBER

Criticality Category
RELIABILITY VARCHAR2 (240)
Reliability
FAILURE_IMPACT VARCHAR2 (240)
Failure Impact
STANDARD_DEVIATION NUMBER

Standard Deviation
COEFFICIENT_OF_VARIATION NUMBER

Coefficient Of Variation
USER_ATTRIBUTE1 VARCHAR2 (30)
User Attribute1
USER_ATTRIBUTE2 VARCHAR2 (30)
User Attribute2
USER_ATTRIBUTE3 VARCHAR2 (30)
User Attribute3
USER_ATTRIBUTE4 VARCHAR2 (30)
User Attribute4
USER_ATTRIBUTE5 VARCHAR2 (30)
User Attribute5
USER_ATTRIBUTE6 VARCHAR2 (30)
User Attribute6
USER_ATTRIBUTE7 VARCHAR2 (30)
User Attribute7
USER_ATTRIBUTE8 VARCHAR2 (30)
User Attribute8
USER_ATTRIBUTE9 VARCHAR2 (30)
User Attribute9
USER_ATTRIBUTE10 VARCHAR2 (30)
User Attribute10
USER_ATTRIBUTE11 VARCHAR2 (30)
User Attribute11
USER_ATTRIBUTE12 VARCHAR2 (30)
User Attribute12
USER_ATTRIBUTE13 VARCHAR2 (30)
User Attribute13
USER_ATTRIBUTE14 VARCHAR2 (30)
User Attribute14
USER_ATTRIBUTE15 VARCHAR2 (30)
User Attribute15
BASIS_AVG_DAILY_DEMAND NUMBER

Avg Daily Demand Basis
REGION_ID NUMBER

Region Identifier
FORECAST_RULE_FOR_DEMANDS NUMBER

Forecast Rule for Demands
FORECAST_RULE_FOR_RETURNS NUMBER

Forecast Rule fo Returns
LIFE_TIME_BUY_DATE DATE

Life time Buy Date
END_OF_LIFE_DATE DATE

End of Life Date
AVG_DEMAND_BEYOND_PH NUMBER

Avg Demand Beyond Ph
AVG_RETURNS_BEYOND_PH NUMBER

Avg Returns Beyond Ph
RETURN_FORECAST_TIME_FENCE NUMBER

Return Forecast Time Fence
AVERAGE_DAILY_DEMAND NUMBER

Average Daily Demand
DEFECTIVE_ITEM_COST NUMBER

Defective Item Cost
STD_DEVIATION_FOR_DEMAND NUMBER

Std Deviation For Demand
MEAN_INTER_ARRIVAL NUMBER

Mean Inter Arrival
STD_DEVIATION_INTER_ARRIVAL NUMBER

Std Deviation Inter Arrival
INTERARRIVAL_DIST_METHOD VARCHAR2 (240)
Interarrival Dist Method
REGION VARCHAR2 (240)
Region Identifier
REGION_INSTANCE_ID VARCHAR2 (240)
Region Instance Id
SAFETY_LEAD_TIME NUMBER

Safety Lead Time
UNSATISFIED_DEMAND_FACTOR NUMBER

Unsatisfied Demand Factor
INTERMITTENT_DEMAND NUMBER

Intermittent Demand
CUSTOMER_ID NUMBER

Custmoer Identifier
CUSTOMER_SITE_ID NUMBER

Custmoer Site Identifier
CUSTOMER_INSTANCE_ID NUMBER

Custmoer Instance Identifier
MIN_REM_SHELF_LIFE_DAYS NUMBER

Min. Remaining Shelf LIfe Days
MAX_USAGE_FACTOR NUMBER

Max. Usage Factor
DMD_SATISFIED_PERCENT NUMBER

Demand Satisfied Percent
MIN_SUP_DEM_PERCENT NUMBER

Min. Supply Demand Percent
PICK_PACK_LT NUMBER

REPAIR_PROGRAM NUMBER

PRE_POSITION_POINT NUMBER

Pre Position Point
NEW_PLANNED_ORDER NUMBER

New Planned Order
ROP_SAFETY_STOCK NUMBER

ROP Safety Stock
ORDER_COST NUMBER

Order Cost
COMPUTE_SS NUMBER

Compute Safety Stock
COMPUTE_EOQ NUMBER

Compute EOQ
ANNUAL_USAGE NUMBER

Annual Usage in Units
ANNUAL_CARRYING_COST NUMBER

Annual Carrying Cost Per Unit
BUYER_NAME VARCHAR2 (240)
Buyer Name
INTERMITTENCY_THRESHOLD NUMBER

Intermittency Threshold
REPAIR_MODULE NUMBER

Repair Module
SCRAP_RATE NUMBER

Scrap Rate
REBUILD_ACTIVITY NUMBER

Rebuild Activity
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 does not reference any database object

MSC.MSC_ITEM_ATTRIBUTES is referenced by following:

SchemaMSC
ViewMSC_ITEM_ATTRIBUTES#