[Home] [Help] [Dependency Information]

VIEW: APPS.MSC_SIM_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
,      ORI_PLANNER_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
,      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
,      UPDATED_COLUMNS_COUNT
,      UPDATED
FROM APPS.MSC_SIM_ITEM_ATTRIBUTES_V;

Dependencies

[top of page]

APPS

MFG_LOOKUPS

MSC_ITEM_ATTRIBUTES

MSC_ITEM_CATEGORIES

MSC_SYSTEM_ITEMS

MSC_TRADING_PARTNERS

APPS.MSC_SIM_ITEM_ATTRIBUTES_V is not referenced by any database object