[Home] [Help] [Dependency Information]

VIEW: APPS.MSC_SYSTEM_ITEMS_SC_V

Object Details

Object Name:	MSC_SYSTEM_ITEMS_SC_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MSC.MSC_SYSTEM_ITEMS_SC_V
Subobject Name:
Status:	VALID

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 ROW_ID
,      INVENTORY_ITEM_ID
,      ITEM_SEGMENTS
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      PLAN_ORGANIZATION_ID
,      COMPILE_DESIGNATOR
,      MRP_PLANNING_CODE_TEXT
,      PREPROCESSING_LEAD_TIME
,      POSTPROCESSING_LEAD_TIME
,      FULL_LEAD_TIME
,      FIXED_LEAD_TIME
,      VARIABLE_LEAD_TIME
,      PLANNING_MAKE_BUY_CODE_TEXT
,      REPETITIVE_TYPE
,      STANDARD_COST
,      CARRYING_COST
,      SELLING_PRICE
,      MARGIN
,      ROUNDING_CONTROL_TYPE
,      WIP_SUPPLY_TYPE_TEXT
,      DESCRIPTION
,      CATEGORY_ID
,      BUYER_NAME
,      PLANNER_CODE
,      ABC_CLASS
,      ABC_CLASS_NAME
,      FIXED_DAYS_SUPPLY
,      FIXED_ORDER_QUANTITY
,      FIXED_LOT_MULTIPLIER
,      MINIMUM_ORDER_QUANTITY
,      MAXIMUM_ORDER_QUANTITY
,      SHRINKAGE_RATE
,      PLANNING_EXCEPTION_SET
,      BASE_ITEM_ID
,      BOM_ITEM_TYPE_TEXT
,      ATO_FORECAST_CONTROL
,      ATO_FORECAST_CONTROL_TEXT
,      PRIMARY_VENDOR_ID
,      IN_SOURCE_PLAN
,      PLANNING_MAKE_BUY_CODE
,      EFFECTIVITY_CONTROL
,      EFFECTIVITY_CONTROL_TYPE
,      PLANNING_TIME_FENCE_DATE
,      PLANNING_TIME_FENCE_DAYS
,      UOM_CODE
,      CATEGORY_SET_ID
,      CATEGORY
,      CATEGORY_DESC
,      INVENTORY_USE_UP_DATE
,      END_ASSEMBLY_PEGGING
,      END_ASSEMBLY_PEGGING_TEXT
,      FULL_PEGGING
,      FULL_PEGGING_TEXT
,      SAFETY_STOCK_DAYS
,      SAFETY_STOCK_PERCENT
,      SAFETY_STOCK_QTY
,      PRODUCT_FAMILY_ITEM_ID
,      PRODUCT_FAMILY_ITEM
,      PRODUCT_FAMILY_ITEM_DESC
,      PLAN_ID
,      SR_INSTANCE_ID
,      NETTABLE_INVENTORY_QUANTITY
,      NONNETTABLE_INVENTORY_QUANTITY
,      SERVICE_LEVEL
,      ATP_FLAG
,      ATP_COMPONENTS_FLAG
,      DEMAND_TIME_FENCE_DAYS
,      DEMAND_TIME_FENCE_DATE
,      SAFETY_STOCK_CODE
,      WEIGHT_UOM
,      UNIT_WEIGHT
,      VOLUME_UOM
,      UNIT_VOLUME
,      PIP_FLAG
,      CREATE_SUPPLY_FLAG
,      SUBSTITUTION_WINDOW
,      AVERAGE_DISCOUNT
,      NET_SELLING_PRICE
,      CONVERGENCE_TEXT
,      DIVERGENCE_TEXT
,      CONTINOUS_TRANSFER_TEXT
,      CRITICAL_COMPONENT_FLAG
,      BASE_MODEL
,      DRP_PLANNED
,      EXCLUDE_FROM_BUDGET
,      DAYS_TGT_INV_WINDOW
,      DAYS_MAX_INV_WINDOW
,      DAYS_TGT_INV_SUPPLY
,      DAYS_MAX_INV_SUPPLY
,      ACCEPTABLE_EARLY_DELIVERY
,      LEADTIME_VARIABILITY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SHELF_LIFE_DAYS
,      RELEASE_TIME_FENCE_DAYS
,      MIN_SHELF_LIFE_DAYS
,      DEMAND_FULFILLMENT_LT
,      END_OF_LIFE_DATE
,      FCST_RULE_FOR_DEMANDS_TEXT
,      FCST_RULE_FOR_RETURNS_TEXT
,      INTERARRIVAL_TIME
,      LIFE_TIME_BUY_DATE
,      PREPOSITION_POINT
,      PRE_POSITION_INVENTORY
,      REPAIR_COST
,      REPAIR_LEAD_TIME
,      REPAIR_PROGRAM_TEXT
,      REPAIR_YIELD
,      STD_DMD_OVER_HORIZON
,      MEAN_INTER_ARRIVAL
,      REPETITIVE_PLANNING_FLAG_TEXT
,      FORECAST_RULE_FOR_DEMANDS
,      FORECAST_RULE_FOR_RETURNS
,      CRITICALITY_CATEGORY
,      MAX_USAGE_FACTOR
,      MIN_SUP_DEM_PERCENT
,      DMD_SATISFIED_PERCENT
FROM APPS.MSC_SYSTEM_ITEMS_SC_V;

Dependencies

[top of page]

APPS

MSC_GET_NAME - show dependent code

MSC_ITEMS

MSC_ITEM_CATEGORIES

MSC_PLANS

MSC_SYSTEM_ITEMS

APPS

MSC_SDA_UTILS - show dependent code