[Home] [Help] [Dependency Information]
Object Name: | MSC_CUST_ITEM_ATTRIBUTES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DESTINATION_ROW_ID | ROWID | (10) | Destination Row Id | |
SIMULATION_SET_ID | NUMBER | Yes | Simulation Set Id | |
PLAN_ID | NUMBER | Yes | Plan Id | |
SR_INSTANCE_ID | NUMBER | Yes | Sr Instance Id | |
ORGANIZATION_ID | NUMBER | Yes | Organization Id | |
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory Item Id | |
ITEM_SEGMENTS | VARCHAR2 | (250) | Item Name | |
CUSTOMER_ID | NUMBER | Customer Id | ||
CUSTOMER | VARCHAR2 | (255) | Yes | Customer Name |
CUSTOMER_INSTANCE_ID | NUMBER | Customer Instance Id | ||
CUSTOMER_SITE_ID | NUMBER | Customer Site Id | ||
SITE | VARCHAR2 | (60) | Site | |
REGION_ID | NUMBER | Region Id | ||
REGION_INSTANCE_ID | VARCHAR2 | (240) | Region Instance Id | |
REGION | VARCHAR2 | (240) | Region | |
SR_CATEGORY_ID | NUMBER | Yes | Category Id | |
CATEGORY_SET_ID | NUMBER | Yes | Category Set Id | |
CATEGORY | VARCHAR2 | (250) | Yes | Category |
BUYER_NAME | VARCHAR2 | (240) | ||
DESCRIPTION | VARCHAR2 | (240) | Item Description | |
MIN_REM_SHELF_LIFE_DAYS | NUMBER | Minimum Remaining Shelf Life Days | ||
MAX_USAGE_FACTOR | NUMBER | Max Usage Factor | ||
FORECAST_RULE_FOR_DEMANDS | VARCHAR2 | (0) | Forecast Rule For Demands | |
FORECAST_RULE_FOR_RETURNS | VARCHAR2 | (0) | Forecast Rule For Returns | |
LIFE_TIME_BUY_DATE | VARCHAR2 | (0) | Life Time Buy Date | |
END_OF_LIFE_DATE | VARCHAR2 | (0) | End Of Life Date | |
AVG_DEMAND_BEYOND_PH | VARCHAR2 | (0) | Avg Demand Beyond Ph | |
AVG_RETURNS_BEYOND_PH | VARCHAR2 | (0) | Avg Returns Beyond Ph | |
RETURN_FORECAST_TIME_FENCE | VARCHAR2 | (0) | Return Forecast Time Fence | |
AVERAGE_DAILY_DEMAND | VARCHAR2 | (0) | Average Daily Demand | |
DEFECTIVE_ITEM_COST | VARCHAR2 | (0) | Defective Item Cost | |
BASIS_AVG_DAILY_DEMAND | VARCHAR2 | (0) | Basis Avg Daily Demand | |
STD_DEVIATION_FOR_DEMAND | VARCHAR2 | (0) | Std Deviation For Demand | |
MEAN_INTER_ARRIVAL | VARCHAR2 | (0) | Mean Inter Arrival | |
STD_DEVIATION_INTER_ARRIVAL | VARCHAR2 | (0) | Std Deviation Inter Arrival | |
INTERARRIVAL_DIST_METHOD | VARCHAR2 | (0) | Interarrival Dist Method | |
UPDATED_COLUMNS_COUNT | NUMBER | Updated Columns Count | ||
UPDATED | CHAR | (3) | Updated | |
ORGANIZATION_CODE | VARCHAR2 | (0) | Organization Code | |
ORI_CRITICAL_COMPONENT_FLAG | VARCHAR2 | (0) | Original Critical Component Flag | |
ORI_FULL_LEAD_TIME | NUMBER | Original Full Lead Time | ||
ORI_PREPROCESSING_LEAD_TIME | NUMBER | Original Preprocessing Lead Time | ||
ORI_POSTPROCESSING_LEAD_TIME | NUMBER | Original Postprocessing Lead Time | ||
ORI_FIXED_LEAD_TIME | NUMBER | Original Fixed Lead Time | ||
ORI_VARIABLE_LEAD_TIME | NUMBER | Original Variable Lead Time | ||
ORI_FIXED_ORDER_QUANTITY | NUMBER | Original Fixed Order Quantity | ||
ORI_FIXED_DAYS_SUPPLY | NUMBER | Original Fixed Days Supply | ||
ORI_SHRINKAGE_RATE | NUMBER | Original Shrinkage Rate | ||
ORI_FIXED_LOT_MULTIPLIER | NUMBER | Original Fixed Lot Multiplier | ||
ORI_MINIMUM_ORDER_QUANTITY | NUMBER | Original Minimum Order Quantity | ||
ORI_MAXIMUM_ORDER_QUANTITY | NUMBER | Original Maximum Order Quantity | ||
ORI_SERVICE_LEVEL | VARCHAR2 | (0) | Original Service Level | |
ORI_CARRYING_COST | NUMBER | Original Carrying Cost | ||
ORI_DEMAND_TIME_FENCE_DAYS | NUMBER | Original Demand Time Fence Days | ||
ORI_ATO_FORECAST_CONTROL | VARCHAR2 | (0) | Original Ato Forecast Control | |
ORI_PLANNING_TIME_FENCE_DAYS | NUMBER | Original Planning Time Fence Days | ||
ORI_STANDARD_COST | NUMBER | Original Standard Cost | ||
ORI_NET_SELLING_PRICE | NUMBER | Original Net Selling Price | ||
ORI_PIP_FLAG | VARCHAR2 | (0) | Original Pip Flag | |
ORI_LIST_PRICE | NUMBER | Original List Price | ||
ORI_SUBSTITUTION_WINDOW | NUMBER | Original Substitution Window | ||
ORI_SAFETY_STOCK_BUCKET_DAYS | NUMBER | Original Safety Stock Bucket Days | ||
ORI_UNIT_WEIGHT | NUMBER | Original Unit Weight | ||
ORI_UNIT_VOLUME | NUMBER | Original Unit Volume | ||
ORI_SAFETY_STOCK_CODE | VARCHAR2 | (0) | Original Safety Stock Code | |
ORI_SAFETY_STOCK_PERCENT | NUMBER | Original Safety Stock Percent | ||
ORI_ABC_CLASS_NAME | VARCHAR2 | (0) | Original Abc Class Name | |
ORI_MRP_PLANNING_CODE | VARCHAR2 | (0) | Original Mrp Planning Code | |
ORI_DRP_PLANNED | VARCHAR2 | (0) | Original Drp Planned | |
ORI_DAYS_MAX_INV_SUPPLY | NUMBER | Original Days Max Inv Supply | ||
ORI_DAYS_MAX_INV_WINDOW | NUMBER | Original Days Max Inv Window | ||
ORI_DAYS_TGT_INV_SUPPLY | NUMBER | Original Days Tgt Inv Supply | ||
ORI_DAYS_TGT_INV_WINDOW | NUMBER | Original Days Tgt Inv Window | ||
ORI_CONTINOUS_TRANSFER | VARCHAR2 | (0) | Original Continous Transfer | |
ORI_CONVERGENCE | VARCHAR2 | (0) | Original Convergence | |
ORI_CREATE_SUPPLY_FLAG | VARCHAR2 | (0) | Original Create Supply Flag | |
ORI_DIVERGENCE | VARCHAR2 | (0) | Original Divergence | |
ORI_PLANNING_EXCEPTION_SET | VARCHAR2 | (0) | Original Planning Exception Set | |
ORI_INVENTORY_USE_UP_DATE | VARCHAR2 | (0) | Original Inventory Use Up Date | |
ORI_PLANNING_MAKE_BUY_CODE | VARCHAR2 | (0) | Original Planning Make Buy Code | |
ORI_MARGIN | NUMBER | Original Margin | ||
ORI_WEIGHT_UOM | VARCHAR2 | (0) | Original Weight Uom | |
ORI_VOLUME_UOM | VARCHAR2 | (0) | Original Volume Uom | |
ORI_ROUNDING_CONTROL_TYPE | VARCHAR2 | (0) | Original Rounding Control Type | |
ORI_ATP_FLAG | VARCHAR2 | (0) | Original Atp Flag | |
ORI_ATP_COMPONENTS_FLAG | VARCHAR2 | (0) | Original Atp Components Flag | |
ORI_DEMAND_FULFILLMENT_LT | VARCHAR2 | (0) | Original Demand Fulfillment Lt | |
ORI_LOTS_EXPIRATION | NUMBER | Original Lots Expiration | ||
ORI_VMI_MINIMUM_UNITS | NUMBER | Original Vmi Minimum Units | ||
ORI_VMI_MINIMUM_DAYS | NUMBER | Original Vmi Minimum Days | ||
ORI_VMI_MAXIMUM_UNITS | NUMBER | Original Vmi Maximum Units | ||
ORI_VMI_MAXIMUM_DAYS | NUMBER | Original Vmi Maximum Days | ||
ORI_VMI_FIXED_ORDER_QUANTITY | NUMBER | Original Vmi Fixed Order Quantity | ||
ORI_CONSIGNED_FLAG | VARCHAR2 | (0) | Original Consigned Flag | |
ORI_LEADTIME_VARIABILITY | VARCHAR2 | (0) | Original Leadtime Variability | |
ORI_PLANNER_CODE | VARCHAR2 | (0) | Original Planner Code | |
ORI_EO_FLAG | VARCHAR2 | (0) | Original Eo Flag | |
ORI_EXCESS_HORIZON | VARCHAR2 | (0) | Original Excess Horizon | |
ORI_STANDARD_DEVIATION | VARCHAR2 | (0) | Original Standard Deviation | |
ORI_OBSOLESCENCE_DATE | NUMBER | Original Obsolescence Date | ||
ORI_COEFFICIENT_OF_VARIATION | NUMBER | Original Coefficient Of Variation | ||
ORI_MIN_SHELF_LIFE_DAYS | NUMBER | Original Min Shelf Life Days | ||
ORI_BASIS_AVG_DAILY_DEMAND | NUMBER | Original Basis Avg Daily Demand | ||
ORI_REPAIR_LEAD_TIME | VARCHAR2 | (0) | Original Repair Lead Time | |
CRITICAL_COMPONENT_FLAG | VARCHAR2 | (0) | Critical Component Flag | |
ORI_REPAIR_YIELD | VARCHAR2 | (0) | Original Repair Yield | |
FULL_LEAD_TIME | NUMBER | Full Lead Time | ||
ORI_REPAIR_COST | NUMBER | Original Repair Cost | ||
PREPROCESSING_LEAD_TIME | NUMBER | Preprocessing Lead Time | ||
ORI_CRITICALITY_CATEGORY | VARCHAR2 | (0) | Original Criticality Category | |
POSTPROCESSING_LEAD_TIME | NUMBER | Postprocessing Lead Time | ||
ORI_RELIABILITY | NUMBER | Original Reliability | ||
FIXED_LEAD_TIME | NUMBER | Fixed Lead Time | ||
ORI_FAILURE_IMPACT | NUMBER | Original Failure Impact | ||
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 | VARCHAR2 | (0) | Ato Forecast Control | |
PLANNING_TIME_FENCE_DAYS | NUMBER | Planning Time Fence Days | ||
STANDARD_COST | NUMBER | Standard Cost | ||
NET_SELLING_PRICE | VARCHAR2 | (0) | Net Selling Price | |
PIP_FLAG | VARCHAR2 | (0) | 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_CODE | VARCHAR2 | (0) | Safety Stock Code | |
SAFETY_STOCK_PERCENT | NUMBER | Safety Stock Percent | ||
ABC_CLASS_NAME | VARCHAR2 | (0) | ABC Class Name | |
MRP_PLANNING_CODE | VARCHAR2 | (0) | MRP Planning Code | |
DRP_PLANNED | VARCHAR2 | (0) | 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 Tgt Inv Supply | ||
DAYS_TGT_INV_WINDOW | NUMBER | Days Tgt Inv Window | ||
CONTINOUS_TRANSFER | VARCHAR2 | (0) | Continous Transfer | |
CONVERGENCE | VARCHAR2 | (0) | Convergence | |
CREATE_SUPPLY_FLAG | VARCHAR2 | (0) | Create Supply Flag | |
DIVERGENCE | VARCHAR2 | (0) | Divergence | |
PLANNING_EXCEPTION_SET | VARCHAR2 | (0) | Planning Exception Set | |
INVENTORY_USE_UP_DATE | VARCHAR2 | (0) | Inventory Use Up Date | |
PLANNING_MAKE_BUY_CODE | VARCHAR2 | (0) | Planning Make Buy Code | |
MARGIN | VARCHAR2 | (0) | Margin | |
WEIGHT_UOM | VARCHAR2 | (0) | Weight Uom | |
VOLUME_UOM | VARCHAR2 | (0) | Volume Uom | |
ATP_FLAG | VARCHAR2 | (0) | Atp Flag | |
ATP_COMPONENTS_FLAG | VARCHAR2 | (0) | Atp Components Flag | |
DEMAND_FULFILLMENT_LT | NUMBER | Demand Fulfillment Lead Time | ||
LOTS_EXPIRATION | NUMBER | Lots Expiration | ||
VMI_MINIMUM_UNITS | NUMBER | Vmi Minimum Units | ||
VMI_MINIMUM_DAYS | NUMBER | Vmi Minimum Days | ||
VMI_MAXIMUM_UNITS | NUMBER | Vmi Maximum Units | ||
VMI_MAXIMUM_DAYS | NUMBER | Vmi Maximum Days | ||
VMI_FIXED_ORDER_QUANTITY | NUMBER | Vmi Fixed Order Quantity | ||
CONSIGNED_FLAG | VARCHAR2 | (0) | Consigned Flag | |
LEADTIME_VARIABILITY | NUMBER | Leadtime Variability | ||
PLANNER_CODE | VARCHAR2 | (0) | Planner Code | |
EO_FLAG | VARCHAR2 | (0) | Eo Flag | |
EXCESS_HORIZON | NUMBER | Excess Horizon | ||
OBSOLESCENCE_DATE | VARCHAR2 | (0) | Obsolescence Date | |
MIN_SHELF_LIFE_DAYS | VARCHAR2 | (0) | Min Shelf Life Days | |
REPAIR_LEAD_TIME | NUMBER | Repair Lead Time | ||
REPAIR_YIELD | NUMBER | Repair Yield | ||
REPAIR_COST | NUMBER | Repair Cost | ||
CRITICALITY_CATEGORY | VARCHAR2 | (0) | Criticality Category | |
RELIABILITY | VARCHAR2 | (0) | Reliability | |
FAILURE_IMPACT | VARCHAR2 | (0) | Failure Impact | |
STANDARD_DEVIATION | NUMBER | Standard Deviation | ||
COEFFICIENT_OF_VARIATION | NUMBER | Coefficient Of Variation | ||
INTERMITTENT_DEMAND | VARCHAR2 | (0) | Intermittent Demand | |
ROUNDING_CONTROL_TYPE | VARCHAR2 | (0) | Rounding Control Type | |
UNSATISFIED_DEMAND_FACTOR | NUMBER | Unsatisfied Demand Factor | ||
DMD_SATISFIED_PERCENT | NUMBER | Demand Satisfied Percent | ||
MIN_SUP_DEM_PERCENT | NUMBER | Supply Tolerance Percent | ||
ORI_COMPUTE_SS | VARCHAR2 | (0) | ||
ORI_COMPUTE_EOQ | VARCHAR2 | (0) | ||
ORI_ORDER_COST | NUMBER | |||
ORI_ANNUAL_USAGE | NUMBER | |||
ORI_ANNUAL_CARRYING_COST | NUMBER | |||
COMPUTE_SS | VARCHAR2 | (0) | ||
COMPUTE_EOQ | VARCHAR2 | (0) | ||
ORDER_COST | NUMBER | |||
ANNUAL_USAGE | NUMBER | |||
ANNUAL_CARRYING_COST | NUMBER | |||
NEW_PLANNED_ORDER | VARCHAR2 | (0) | ||
ORI_NEW_PLANNED_ORDER | VARCHAR2 | (0) | ||
ROP_SAFETY_STOCK | NUMBER | |||
ORI_ROP_SAFETY_STOCK | NUMBER | |||
INTERMITTENCY_THRESHOLD | NUMBER | |||
ORI_INTERMITTENCY_THRESHOLD | NUMBER | |||
REPAIR_MODULE | NUMBER | |||
ORI_REPAIR_MODULE | NUMBER | |||
SCRAP_RATE | NUMBER | |||
ORI_SCRAP_RATE | NUMBER | |||
REBUILD_ACTIVITY | NUMBER | |||
ORI_REBUILD_ACTIVITY | NUMBER | |||
ORI_ORDER_PERIOD | NUMBER | |||
ORDER_PERIOD | NUMBER | |||
ORI_INV_DAYS_INCREMENT | NUMBER | |||
INV_DAYS_INCREMENT | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT DESTINATION_ROW_ID
, SIMULATION_SET_ID
, PLAN_ID
, SR_INSTANCE_ID
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, ITEM_SEGMENTS
, CUSTOMER_ID
, CUSTOMER
, CUSTOMER_INSTANCE_ID
, CUSTOMER_SITE_ID
, SITE
, REGION_ID
, REGION_INSTANCE_ID
, REGION
, SR_CATEGORY_ID
, CATEGORY_SET_ID
, CATEGORY
, BUYER_NAME
, DESCRIPTION
, MIN_REM_SHELF_LIFE_DAYS
, MAX_USAGE_FACTOR
, 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
, BASIS_AVG_DAILY_DEMAND
, STD_DEVIATION_FOR_DEMAND
, MEAN_INTER_ARRIVAL
, STD_DEVIATION_INTER_ARRIVAL
, INTERARRIVAL_DIST_METHOD
, UPDATED_COLUMNS_COUNT
, UPDATED
, ORGANIZATION_CODE
, ORI_CRITICAL_COMPONENT_FLAG
, ORI_FULL_LEAD_TIME
, ORI_PREPROCESSING_LEAD_TIME
, ORI_POSTPROCESSING_LEAD_TIME
, ORI_FIXED_LEAD_TIME
, ORI_VARIABLE_LEAD_TIME
, ORI_FIXED_ORDER_QUANTITY
, ORI_FIXED_DAYS_SUPPLY
, ORI_SHRINKAGE_RATE
, ORI_FIXED_LOT_MULTIPLIER
, ORI_MINIMUM_ORDER_QUANTITY
, ORI_MAXIMUM_ORDER_QUANTITY
, ORI_SERVICE_LEVEL
, ORI_CARRYING_COST
, ORI_DEMAND_TIME_FENCE_DAYS
, ORI_ATO_FORECAST_CONTROL
, ORI_PLANNING_TIME_FENCE_DAYS
, ORI_STANDARD_COST
, ORI_NET_SELLING_PRICE
, ORI_PIP_FLAG
, ORI_LIST_PRICE
, ORI_SUBSTITUTION_WINDOW
, ORI_SAFETY_STOCK_BUCKET_DAYS
, ORI_UNIT_WEIGHT
, ORI_UNIT_VOLUME
, ORI_SAFETY_STOCK_CODE
, ORI_SAFETY_STOCK_PERCENT
, ORI_ABC_CLASS_NAME
, ORI_MRP_PLANNING_CODE
, ORI_DRP_PLANNED
, ORI_DAYS_MAX_INV_SUPPLY
, ORI_DAYS_MAX_INV_WINDOW
, ORI_DAYS_TGT_INV_SUPPLY
, ORI_DAYS_TGT_INV_WINDOW
, ORI_CONTINOUS_TRANSFER
, ORI_CONVERGENCE
, ORI_CREATE_SUPPLY_FLAG
, ORI_DIVERGENCE
, ORI_PLANNING_EXCEPTION_SET
, ORI_INVENTORY_USE_UP_DATE
, ORI_PLANNING_MAKE_BUY_CODE
, ORI_MARGIN
, ORI_WEIGHT_UOM
, ORI_VOLUME_UOM
, ORI_ROUNDING_CONTROL_TYPE
, ORI_ATP_FLAG
, ORI_ATP_COMPONENTS_FLAG
, ORI_DEMAND_FULFILLMENT_LT
, ORI_LOTS_EXPIRATION
, ORI_VMI_MINIMUM_UNITS
, ORI_VMI_MINIMUM_DAYS
, ORI_VMI_MAXIMUM_UNITS
, ORI_VMI_MAXIMUM_DAYS
, ORI_VMI_FIXED_ORDER_QUANTITY
, ORI_CONSIGNED_FLAG
, ORI_LEADTIME_VARIABILITY
, ORI_PLANNER_CODE
, ORI_EO_FLAG
, ORI_EXCESS_HORIZON
, ORI_STANDARD_DEVIATION
, ORI_OBSOLESCENCE_DATE
, ORI_COEFFICIENT_OF_VARIATION
, ORI_MIN_SHELF_LIFE_DAYS
, ORI_BASIS_AVG_DAILY_DEMAND
, ORI_REPAIR_LEAD_TIME
, CRITICAL_COMPONENT_FLAG
, ORI_REPAIR_YIELD
, FULL_LEAD_TIME
, ORI_REPAIR_COST
, PREPROCESSING_LEAD_TIME
, ORI_CRITICALITY_CATEGORY
, POSTPROCESSING_LEAD_TIME
, ORI_RELIABILITY
, FIXED_LEAD_TIME
, ORI_FAILURE_IMPACT
, 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
, NET_SELLING_PRICE
, 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
, MARGIN
, WEIGHT_UOM
, VOLUME_UOM
, 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
, CRITICALITY_CATEGORY
, RELIABILITY
, FAILURE_IMPACT
, STANDARD_DEVIATION
, COEFFICIENT_OF_VARIATION
, INTERMITTENT_DEMAND
, ROUNDING_CONTROL_TYPE
, UNSATISFIED_DEMAND_FACTOR
, DMD_SATISFIED_PERCENT
, MIN_SUP_DEM_PERCENT
, ORI_COMPUTE_SS
, ORI_COMPUTE_EOQ
, ORI_ORDER_COST
, ORI_ANNUAL_USAGE
, ORI_ANNUAL_CARRYING_COST
, COMPUTE_SS
, COMPUTE_EOQ
, ORDER_COST
, ANNUAL_USAGE
, ANNUAL_CARRYING_COST
, NEW_PLANNED_ORDER
, ORI_NEW_PLANNED_ORDER
, ROP_SAFETY_STOCK
, ORI_ROP_SAFETY_STOCK
, INTERMITTENCY_THRESHOLD
, ORI_INTERMITTENCY_THRESHOLD
, REPAIR_MODULE
, ORI_REPAIR_MODULE
, SCRAP_RATE
, ORI_SCRAP_RATE
, REBUILD_ACTIVITY
, ORI_REBUILD_ACTIVITY
, ORI_ORDER_PERIOD
, ORDER_PERIOD
, ORI_INV_DAYS_INCREMENT
, INV_DAYS_INCREMENT
FROM APPS.MSC_CUST_ITEM_ATTRIBUTES_V;
APPS.MSC_CUST_ITEM_ATTRIBUTES_V is not referenced by any database object
|
|
|