[Home] [Help] [Dependency Information]

VIEW: APPS.MSC_ITEM_ATTRIBUTES_V

Object Details

View Type

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.

[View Source]

Columns

Query Text

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

SELECT SOURCE_ROW_ID
,      PLAN_ID
,      SR_INSTANCE_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      ITEM_SEGMENTS
,      ORGANIZATION_CODE
,      SR_CATEGORY_ID
,      CATEGORY_SET_ID
,      CATEGORY
,      DESCRIPTION
,      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_OBSOLESCENCE_DATE
,      ORI_MIN_SHELF_LIFE_DAYS
,      ORI_REPAIR_LEAD_TIME
,      ORI_REPAIR_YIELD
,      ORI_REPAIR_COST
,      ORI_CRITICALITY_CATEGORY
,      ORI_RELIABILITY
,      ORI_FAILURE_IMPACT
,      ORI_STANDARD_DEVIATION
,      ORI_COEFFICIENT_OF_VARIATION
,      ORI_BASIS_AVG_DAILY_DEMAND
,      DESTINATION_ROW_ID
,      SIMULATION_SET_ID
,      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
,      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
,      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
,      CRITICALITY_CATEGORY
,      RELIABILITY
,      FAILURE_IMPACT
,      STANDARD_DEVIATION
,      COEFFICIENT_OF_VARIATION
,      BASIS_AVG_DAILY_DEMAND
,      UPDATED_COLUMNS_COUNT
,      UPDATED
,      REGION_ID
,      REGION_INSTANCE_ID
,      REGION
,      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
,      CUSTOMER_ID
,      CUSTOMER
,      CUSTOMER_INSTANCE_ID
,      CUSTOMER_SITE_ID
,      SITE
,      MAX_USAGE_FACTOR
,      MIN_REM_SHELF_LIFE_DAYS
,      UNSATISFIED_DEMAND_FACTOR
,      DMD_SATISFIED_PERCENT
,      MIN_SUP_DEM_PERCENT
,      PICK_PACK_LT
,      REPAIR_PROGRAM
,      PRE_POSITION_POINT
FROM APPS.MSC_ITEM_ATTRIBUTES_V;

Dependencies

[top of page]

APPS

MFG_LOOKUPS

MSC_FORECAST_RULES

MSC_ITEM_ATTRIBUTES

MSC_ITEM_CATEGORIES

MSC_SYSTEM_ITEMS

MSC_TRADING_PARTNERS

APPS.MSC_ITEM_ATTRIBUTES_V is not referenced by any database object