eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.MSC_SYSTEM_ITEMS_V

Object Details

Object Name:	MSC_SYSTEM_ITEMS_V
Object Type:	VIEW
Owner:	APPS
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

Name	Datatype	Length
PLAN_ID	NUMBER
PDS_PLAN_ID	NUMBER
ITEM_SIMULATION_SET_ID	NUMBER
ORGANIZATION_ID	NUMBER
INVENTORY_ITEM_ID	NUMBER
SR_INSTANCE_ID	NUMBER
SR_INVENTORY_ITEM_ID	NUMBER
ITEM_NAME	VARCHAR2	(250)
LOTS_EXPIRATION	NUMBER
LOT_CONTROL_CODE	NUMBER
SHRINKAGE_RATE	NUMBER
FIXED_DAYS_SUPPLY	NUMBER
FIXED_ORDER_QUANTITY	NUMBER
FIXED_LOT_MULTIPLIER	NUMBER
MINIMUM_ORDER_QUANTITY	NUMBER
MAXIMUM_ORDER_QUANTITY	NUMBER
ROUNDING_CONTROL_TYPE	NUMBER
PLANNING_TIME_FENCE_DAYS	NUMBER
PLANNING_TIME_FENCE_DATE	DATE
DEMAND_TIME_FENCE_DAYS	NUMBER
DEMAND_TIME_FENCE_DATE	DATE
DESCRIPTION	VARCHAR2	(240)
RELEASE_TIME_FENCE_CODE	NUMBER
RELEASE_TIME_FENCE_DAYS	NUMBER
IN_SOURCE_PLAN	NUMBER
REVISION	VARCHAR2	(3)
SR_CATEGORY_ID	NUMBER
ABC_CLASS	NUMBER
CATEGORY_NAME	VARCHAR2	(200)
MRP_PLANNING_CODE	NUMBER
FIXED_LEAD_TIME	NUMBER
VARIABLE_LEAD_TIME	NUMBER
PREPROCESSING_LEAD_TIME	NUMBER
POSTPROCESSING_LEAD_TIME	NUMBER
FULL_LEAD_TIME	NUMBER
CUMULATIVE_TOTAL_LEAD_TIME	NUMBER
CUM_MANUFACTURING_LEAD_TIME	NUMBER
UOM_CODE	VARCHAR2	(3)
UNIT_WEIGHT	NUMBER
UNIT_VOLUME	NUMBER
WEIGHT_UOM	VARCHAR2	(3)
VOLUME_UOM	VARCHAR2	(3)
PRODUCT_FAMILY_ID	NUMBER
ATP_RULE_ID	NUMBER
ATP_COMPONENTS_FLAG	VARCHAR2	(1)
BUILD_IN_WIP_FLAG	NUMBER
PURCHASING_ENABLED_FLAG	NUMBER
PLANNING_MAKE_BUY_CODE	NUMBER
REPETITIVE_TYPE	NUMBER
REPETITIVE_VARIANCE	NUMBER
STANDARD_COST	NUMBER
CARRYING_COST	NUMBER
ORDER_COST	NUMBER
MATERIAL_COST	NUMBER
DMD_LATENESS_COST	NUMBER
RESOURCE_COST	NUMBER
SS_PENALTY_COST	NUMBER
SUPPLIER_CAP_OVERUTIL_COST	NUMBER
LIST_PRICE	NUMBER
AVERAGE_DISCOUNT	NUMBER
ENGINEERING_ITEM_FLAG	NUMBER
WIP_SUPPLY_TYPE	NUMBER
SAFETY_STOCK_CODE	NUMBER
SAFETY_STOCK_PERCENT	NUMBER
SAFETY_STOCK_BUCKET_DAYS	NUMBER
INVENTORY_USE_UP_DATE	DATE
BUYER_NAME	VARCHAR2	(240)
PLANNER_CODE	VARCHAR2	(240)
PLANNING_EXCEPTION_SET	VARCHAR2	(10)
EXCESS_QUANTITY	NUMBER
EXCEPTION_SHORTAGE_DAYS	NUMBER
EXCEPTION_EXCESS_DAYS	NUMBER
EXCEPTION_OVERPROMISED_DAYS	NUMBER
EXCEPTION_CODE	VARCHAR2	(5)
BOM_ITEM_TYPE	NUMBER
ATO_FORECAST_CONTROL	NUMBER
EFFECTIVITY_CONTROL	NUMBER
ORGANIZATION_CODE	VARCHAR2	(7)
ACCEPTABLE_RATE_INCREASE	NUMBER
ACCEPTABLE_RATE_DECREASE	NUMBER
EXCEPTION_REP_VARIANCE_DAYS	NUMBER
OVERRUN_PERCENTAGE	NUMBER
INVENTORY_PLANNING_CODE	NUMBER
ACCEPTABLE_EARLY_DELIVERY	NUMBER
CALCULATE_ATP	NUMBER
END_ASSEMBLY_PEGGING_FLAG	VARCHAR2	(1)
END_ASSEMBLY_PEGGING	NUMBER
FULL_PEGGING	NUMBER
INVENTORY_ITEM_FLAG	NUMBER
SOURCE_ORG_ID	NUMBER
BASE_ITEM_ID	NUMBER
ABC_CLASS_NAME	VARCHAR2	(40)
FIXED_SAFETY_STOCK_QTY	NUMBER
PRIMARY_SUPPLIER_ID	NUMBER
ATP_FLAG	VARCHAR2	(1)
LOW_LEVEL_CODE	NUMBER
PLANNER_STATUS_CODE	NUMBER
NETTABLE_INVENTORY_QUANTITY	NUMBER
NONNETTABLE_INVENTORY_QUANTITY	NUMBER
REFRESH_NUMBER	NUMBER
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER
CREATION_DATE	DATE
CREATED_BY	NUMBER
LAST_UPDATE_LOGIN	NUMBER
REQUEST_ID	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_UPDATE_DATE	DATE
ATTRIBUTE_CATEGORY	VARCHAR2	(30)
ATTRIBUTE1	VARCHAR2	(150)
ATTRIBUTE2	VARCHAR2	(150)
ATTRIBUTE3	VARCHAR2	(150)
ATTRIBUTE4	VARCHAR2	(150)
ATTRIBUTE5	VARCHAR2	(150)
ATTRIBUTE6	VARCHAR2	(150)
ATTRIBUTE7	VARCHAR2	(150)
ATTRIBUTE8	VARCHAR2	(150)
ATTRIBUTE9	VARCHAR2	(150)
ATTRIBUTE10	VARCHAR2	(150)
ATTRIBUTE11	VARCHAR2	(150)
ATTRIBUTE12	VARCHAR2	(150)
ATTRIBUTE13	VARCHAR2	(150)
ATTRIBUTE14	VARCHAR2	(150)
ATTRIBUTE15	VARCHAR2	(150)
REVISION_QTY_CONTROL_CODE	NUMBER
EXPENSE_ACCOUNT	NUMBER
INVENTORY_ASSET_FLAG	VARCHAR2	(1)
BUYER_ID	NUMBER	(9)
REPETITIVE_PLANNING_FLAG	VARCHAR2	(1)
PICK_COMPONENTS_FLAG	VARCHAR2	(1)
SERVICE_LEVEL	NUMBER
REPLENISH_TO_ORDER_FLAG	VARCHAR2	(1)
PIP_FLAG	NUMBER
YIELD_CONV_FACTOR	NUMBER
MIN_MINMAX_QUANTITY	NUMBER
MAX_MINMAX_QUANTITY	NUMBER
NEW_ATP_FLAG	VARCHAR2	(1)
SOURCE_TYPE	NUMBER
SUBSTITUTION_WINDOW	NUMBER
CREATE_SUPPLY_FLAG	NUMBER
REORDER_POINT	NUMBER
AVERAGE_ANNUAL_DEMAND	NUMBER
ECONOMIC_ORDER_QUANTITY	NUMBER
SERIAL_NUMBER_CONTROL_CODE	NUMBER
CONVERGENCE	NUMBER
DIVERGENCE	NUMBER
CONTINOUS_TRANSFER	NUMBER
CRITICAL_COMPONENT_FLAG	NUMBER
REDUCE_MPS	NUMBER
CONSIGNED_FLAG	NUMBER
VMI_MINIMUM_UNITS	NUMBER
VMI_MINIMUM_DAYS	NUMBER
VMI_MAXIMUM_UNITS	NUMBER
VMI_MAXIMUM_DAYS	NUMBER
AVERAGE_DAILY_DEMAND	NUMBER
VMI_FIXED_ORDER_QUANTITY	NUMBER
SO_AUTHORIZATION_FLAG	NUMBER
VMI_FORECAST_TYPE	NUMBER
FORECAST_HORIZON	NUMBER
ASN_AUTOEXPIRE_FLAG	NUMBER
VMI_REFRESH_FLAG	NUMBER
BUDGET_CONSTRAINED	NUMBER
MAX_QUANTITY	NUMBER
MAX_QUANTITY_DOS	NUMBER
DAYS_TGT_INV_WINDOW	NUMBER
DAYS_MAX_INV_WINDOW	NUMBER
DAYS_TGT_INV_SUPPLY	NUMBER
DAYS_MAX_INV_SUPPLY	NUMBER
DRP_PLANNED	NUMBER
AGGREGATE_TIME_FENCE_DATE	DATE
INFERRED_CRITICAL_FLAG	NUMBER
SS_WINDOW_SIZE	NUMBER
LOWEST_LEVEL_SRC	NUMBER
EAM_ITEM_TYPE	NUMBER
LOTS_EXIST	NUMBER
LEADTIME_VARIABILITY	NUMBER
MIN_SHELF_LIFE_DAYS	NUMBER
GROUP_ID	NUMBER
REPAIR_YIELD	NUMBER
REPAIR_PROGRAM	NUMBER
REPAIR_LEAD_TIME	NUMBER
PRE_POSITION_INVENTORY	NUMBER
PREPOSITION_POINT	VARCHAR2	(1)
DEMAND_FULFILLMENT_LT	NUMBER
FORECAST_RULE_FOR_DEMANDS	NUMBER
FORECAST_RULE_FOR_RETURNS	NUMBER
DEMAND_DISTRIBUTION	VARCHAR2	(20)
INTERARRIVAL_TIME	NUMBER
REPAIR_COST	NUMBER
LIFE_TIME_BUY_DATE	DATE
END_OF_LIFE_DATE	DATE
STD_DMD_OVER_HORIZON	NUMBER
COEFFICIENT_OF_VARIATION	NUMBER
AVG_DEMAND_BEYOND_PH	NUMBER
AVG_RETURNS_BEYOND_PH	NUMBER
RETURN_FORECAST_TIME_FENCE	NUMBER
DEFECTIVE_ITEM_COST	NUMBER
BASIS_AVG_DAILY_DEMAND	NUMBER
STD_DEVIATION_FOR_DEMAND	NUMBER
MEAN_INTER_ARRIVAL	NUMBER
STD_DEVIATION_INTER_ARRIVAL	NUMBER
STANDARD_DEVIATION	NUMBER
INTERARRIVAL_DIST_METHOD	VARCHAR2	(240)
SAFETY_LEAD_TIME	NUMBER
UNSATISFIED_DEMAND_FACTOR	NUMBER
PLANNING_TIME_FENCE_CODE	NUMBER
MAX_USAGE_FACTOR	NUMBER
MIN_SUP_DEM_PERCENT	NUMBER
DMD_SATISFIED_PERCENT	NUMBER
MIN_REM_SHELF_LIFE_DAYS	NUMBER
NEW_PLANNED_ORDER	NUMBER
PEGGING_DEMAND_WINDOW_DAYS	NUMBER
PEGGING_SUPPLY_WINDOW_DAYS	NUMBER
SCRAP_RATE	NUMBER
REPAIR_MODULE	NUMBER
REBUILD_ACTIVITY	NUMBER
ORDER_PERIOD	NUMBER
INV_DAYS_INCREMENT	NUMBER

Query Text

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


SELECT PLAN_ID
,      PDS_PLAN_ID
,      ITEM_SIMULATION_SET_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      SR_INSTANCE_ID
,      SR_INVENTORY_ITEM_ID
,      ITEM_NAME
,      LOTS_EXPIRATION
,      LOT_CONTROL_CODE
,      SHRINKAGE_RATE
,      FIXED_DAYS_SUPPLY
,      FIXED_ORDER_QUANTITY
,      FIXED_LOT_MULTIPLIER
,      MINIMUM_ORDER_QUANTITY
,      MAXIMUM_ORDER_QUANTITY
,      ROUNDING_CONTROL_TYPE
,      PLANNING_TIME_FENCE_DAYS
,      PLANNING_TIME_FENCE_DATE
,      DEMAND_TIME_FENCE_DAYS
,      DEMAND_TIME_FENCE_DATE
,      DESCRIPTION
,      RELEASE_TIME_FENCE_CODE
,      RELEASE_TIME_FENCE_DAYS
,      IN_SOURCE_PLAN
,      REVISION
,      SR_CATEGORY_ID
,      ABC_CLASS
,      CATEGORY_NAME
,      MRP_PLANNING_CODE
,      FIXED_LEAD_TIME
,      VARIABLE_LEAD_TIME
,      PREPROCESSING_LEAD_TIME
,      POSTPROCESSING_LEAD_TIME
,      FULL_LEAD_TIME
,      CUMULATIVE_TOTAL_LEAD_TIME
,      CUM_MANUFACTURING_LEAD_TIME
,      UOM_CODE
,      UNIT_WEIGHT
,      UNIT_VOLUME
,      WEIGHT_UOM
,      VOLUME_UOM
,      PRODUCT_FAMILY_ID
,      ATP_RULE_ID
,      ATP_COMPONENTS_FLAG
,      BUILD_IN_WIP_FLAG
,      PURCHASING_ENABLED_FLAG
,      PLANNING_MAKE_BUY_CODE
,      REPETITIVE_TYPE
,      REPETITIVE_VARIANCE
,      STANDARD_COST
,      CARRYING_COST
,      ORDER_COST
,      MATERIAL_COST
,      DMD_LATENESS_COST
,      RESOURCE_COST
,      SS_PENALTY_COST
,      SUPPLIER_CAP_OVERUTIL_COST
,      LIST_PRICE
,      AVERAGE_DISCOUNT
,      ENGINEERING_ITEM_FLAG
,      WIP_SUPPLY_TYPE
,      SAFETY_STOCK_CODE
,      SAFETY_STOCK_PERCENT
,      SAFETY_STOCK_BUCKET_DAYS
,      INVENTORY_USE_UP_DATE
,      BUYER_NAME
,      PLANNER_CODE
,      PLANNING_EXCEPTION_SET
,      EXCESS_QUANTITY
,      EXCEPTION_SHORTAGE_DAYS
,      EXCEPTION_EXCESS_DAYS
,      EXCEPTION_OVERPROMISED_DAYS
,      EXCEPTION_CODE
,      BOM_ITEM_TYPE
,      ATO_FORECAST_CONTROL
,      EFFECTIVITY_CONTROL
,      ORGANIZATION_CODE
,      ACCEPTABLE_RATE_INCREASE
,      ACCEPTABLE_RATE_DECREASE
,      EXCEPTION_REP_VARIANCE_DAYS
,      OVERRUN_PERCENTAGE
,      INVENTORY_PLANNING_CODE
,      ACCEPTABLE_EARLY_DELIVERY
,      CALCULATE_ATP
,      END_ASSEMBLY_PEGGING_FLAG
,      END_ASSEMBLY_PEGGING
,      FULL_PEGGING
,      INVENTORY_ITEM_FLAG
,      SOURCE_ORG_ID
,      BASE_ITEM_ID
,      ABC_CLASS_NAME
,      FIXED_SAFETY_STOCK_QTY
,      PRIMARY_SUPPLIER_ID
,      ATP_FLAG
,      LOW_LEVEL_CODE
,      PLANNER_STATUS_CODE
,      NETTABLE_INVENTORY_QUANTITY
,      NONNETTABLE_INVENTORY_QUANTITY
,      REFRESH_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REVISION_QTY_CONTROL_CODE
,      EXPENSE_ACCOUNT
,      INVENTORY_ASSET_FLAG
,      BUYER_ID
,      REPETITIVE_PLANNING_FLAG
,      PICK_COMPONENTS_FLAG
,      SERVICE_LEVEL
,      REPLENISH_TO_ORDER_FLAG
,      PIP_FLAG
,      YIELD_CONV_FACTOR
,      MIN_MINMAX_QUANTITY
,      MAX_MINMAX_QUANTITY
,      NEW_ATP_FLAG
,      SOURCE_TYPE
,      SUBSTITUTION_WINDOW
,      CREATE_SUPPLY_FLAG
,      REORDER_POINT
,      AVERAGE_ANNUAL_DEMAND
,      ECONOMIC_ORDER_QUANTITY
,      SERIAL_NUMBER_CONTROL_CODE
,      CONVERGENCE
,      DIVERGENCE
,      CONTINOUS_TRANSFER
,      CRITICAL_COMPONENT_FLAG
,      REDUCE_MPS
,      CONSIGNED_FLAG
,      VMI_MINIMUM_UNITS
,      VMI_MINIMUM_DAYS
,      VMI_MAXIMUM_UNITS
,      VMI_MAXIMUM_DAYS
,      AVERAGE_DAILY_DEMAND
,      VMI_FIXED_ORDER_QUANTITY
,      SO_AUTHORIZATION_FLAG
,      VMI_FORECAST_TYPE
,      FORECAST_HORIZON
,      ASN_AUTOEXPIRE_FLAG
,      VMI_REFRESH_FLAG
,      BUDGET_CONSTRAINED
,      MAX_QUANTITY
,      MAX_QUANTITY_DOS
,      DAYS_TGT_INV_WINDOW
,      DAYS_MAX_INV_WINDOW
,      DAYS_TGT_INV_SUPPLY
,      DAYS_MAX_INV_SUPPLY
,      DRP_PLANNED
,      AGGREGATE_TIME_FENCE_DATE
,      INFERRED_CRITICAL_FLAG
,      SS_WINDOW_SIZE
,      LOWEST_LEVEL_SRC
,      EAM_ITEM_TYPE
,      LOTS_EXIST
,      LEADTIME_VARIABILITY
,      MIN_SHELF_LIFE_DAYS
,      GROUP_ID
,      REPAIR_YIELD
,      REPAIR_PROGRAM
,      REPAIR_LEAD_TIME
,      PRE_POSITION_INVENTORY
,      PREPOSITION_POINT
,      DEMAND_FULFILLMENT_LT
,      FORECAST_RULE_FOR_DEMANDS
,      FORECAST_RULE_FOR_RETURNS
,      DEMAND_DISTRIBUTION
,      INTERARRIVAL_TIME
,      REPAIR_COST
,      LIFE_TIME_BUY_DATE
,      END_OF_LIFE_DATE
,      STD_DMD_OVER_HORIZON
,      COEFFICIENT_OF_VARIATION
,      AVG_DEMAND_BEYOND_PH
,      AVG_RETURNS_BEYOND_PH
,      RETURN_FORECAST_TIME_FENCE
,      DEFECTIVE_ITEM_COST
,      BASIS_AVG_DAILY_DEMAND
,      STD_DEVIATION_FOR_DEMAND
,      MEAN_INTER_ARRIVAL
,      STD_DEVIATION_INTER_ARRIVAL
,      STANDARD_DEVIATION
,      INTERARRIVAL_DIST_METHOD
,      SAFETY_LEAD_TIME
,      UNSATISFIED_DEMAND_FACTOR
,      PLANNING_TIME_FENCE_CODE
,      MAX_USAGE_FACTOR
,      MIN_SUP_DEM_PERCENT
,      DMD_SATISFIED_PERCENT
,      MIN_REM_SHELF_LIFE_DAYS
,      NEW_PLANNED_ORDER
,      PEGGING_DEMAND_WINDOW_DAYS
,      PEGGING_SUPPLY_WINDOW_DAYS
,      SCRAP_RATE
,      REPAIR_MODULE
,      REBUILD_ACTIVITY
,      ORDER_PERIOD
,      INV_DAYS_INCREMENT
FROM APPS.MSC_SYSTEM_ITEMS_V;

Dependencies

[top of page]

APPS.MSC_SYSTEM_ITEMS_V references the following:

APPS: MSC_ITEM_ATTRIBUTES; MSC_PLANS; MSC_SYSTEM_ITEMS

APPS.MSC_SYSTEM_ITEMS_V is referenced by following:

APPS: MSC_SNAPSHOT_PK - show dependent code