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

VIEW: MSC.MSC_ST_SYSTEM_ITEMS#

Object Details
Object Name: MSC_ST_SYSTEM_ITEMS#
Object Type: VIEW
Owner: MSC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

SR_ORGANIZATION_ID NUMBER

INVENTORY_ITEM_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

DEMAND_TIME_FENCE_DAYS NUMBER

RELEASE_TIME_FENCE_CODE NUMBER

RELEASE_TIME_FENCE_DAYS NUMBER

DESCRIPTION VARCHAR2 (960)
IN_SOURCE_PLAN NUMBER

REVISION VARCHAR2 (3)
SR_CATEGORY_ID NUMBER

CATEGORY_NAME VARCHAR2 (200)
ABC_CLASS_ID NUMBER

ABC_CLASS_NAME VARCHAR2 (40)
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

MRP_CALCULATE_ATP_FLAG NUMBER

ATP_COMPONENTS_FLAG VARCHAR2 (1)
BUILT_IN_WIP_FLAG NUMBER

PURCHASING_ENABLED_FLAG NUMBER

PLANNING_MAKE_BUY_CODE NUMBER

REPETITIVE_TYPE NUMBER

STANDARD_COST NUMBER

CARRYING_COST NUMBER

ORDER_COST NUMBER

DMD_LATENESS_COST NUMBER

SS_PENALTY_COST NUMBER

SUPPLIER_CAP_OVERUTIL_COST NUMBER

LIST_PRICE NUMBER

AVERAGE_DISCOUNT NUMBER

END_ASSEMBLY_PEGGING_FLAG VARCHAR2 (1)
END_ASSEMBLY_PEGGING NUMBER

FULL_PEGGING NUMBER

ENGINEERING_ITEM_FLAG NUMBER

WIP_SUPPLY_TYPE NUMBER

MRP_SAFETY_STOCK_CODE NUMBER

MRP_SAFETY_STOCK_PERCENT NUMBER

SAFETY_STOCK_BUCKET_DAYS NUMBER

INVENTORY_USE_UP_DATE DATE

BUYER_NAME VARCHAR2 (255)
PLANNER_CODE VARCHAR2 (10)
PLANNING_EXCEPTION_SET VARCHAR2 (10)
EXCESS_QUANTITY NUMBER

EXCEPTION_SHORTAGE_DAYS NUMBER

EXCEPTION_EXCESS_DAYS NUMBER

EXCEPTION_OVERPROMISED_DAYS NUMBER

REPETITIVE_VARIANCE_DAYS NUMBER

BASE_ITEM_ID NUMBER

BOM_ITEM_TYPE NUMBER

ATO_FORECAST_CONTROL NUMBER

ORGANIZATION_CODE VARCHAR2 (7)
EFFECTIVITY_CONTROL NUMBER

ACCEPTABLE_EARLY_DELIVERY NUMBER

INVENTORY_PLANNING_CODE NUMBER

INVENTORY_TYPE NUMBER

ACCEPTABLE_RATE_INCREASE NUMBER

ACCEPTABLE_RATE_DECREASE NUMBER

PRIMARY_SUPPLIER_ID NUMBER

DELETED_FLAG 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

SR_INSTANCE_ID NUMBER

REFRESH_ID NUMBER

ATP_FLAG VARCHAR2 (1)
INVENTORY_ITEM_FLAG NUMBER

REVISION_QTY_CONTROL_CODE NUMBER

EXPENSE_ACCOUNT NUMBER

INVENTORY_ASSET_FLAG VARCHAR2 (1)
BUYER_ID NUMBER (9)
MATERIAL_COST NUMBER

RESOURCE_COST NUMBER

SOURCE_ORG_ID NUMBER

PICK_COMPONENTS_FLAG VARCHAR2 (1)
ALLOWED_UNITS_LOOKUP_CODE NUMBER

SERVICE_LEVEL NUMBER

REPLENISH_TO_ORDER_FLAG VARCHAR2 (1)
PIP_FLAG NUMBER

COMPANY_ID NUMBER

COMPANY_NAME VARCHAR2 (255)
SR_INSTANCE_CODE VARCHAR2 (3)
ATP_RULE_CODE VARCHAR2 (80)
BASE_ITEM_NAME VARCHAR2 (250)
PRIMARY_SUPPLIER_NAME VARCHAR2 (255)
SOURCE_ORG_CODE VARCHAR2 (7)
MESSAGE_ID NUMBER

PROCESS_FLAG NUMBER

ERROR_TEXT VARCHAR2 (2000)
DATA_SOURCE_TYPE VARCHAR2 (15)
ST_TRANSACTION_ID NUMBER

BATCH_ID NUMBER

MIN_MINMAX_QUANTITY NUMBER

MAX_MINMAX_QUANTITY NUMBER

YIELD_CONV_FACTOR NUMBER

SOURCE_TYPE NUMBER

SUBSTITUTION_WINDOW NUMBER

CREATE_SUPPLY_FLAG NUMBER

SERIAL_NUMBER_CONTROL_CODE NUMBER

CRITICAL_COMPONENT_FLAG NUMBER

REDUCE_MPS NUMBER

SOURCE_SR_INVENTORY_ITEM_ID NUMBER

SOURCE_SOURCE_ORG_ID NUMBER

SOURCE_PRIMARY_SUPPLIER_ID NUMBER

SOURCE_BASE_ITEM_ID NUMBER

SOURCE_ABC_CLASS_ID NUMBER

VMI_MINIMUM_UNITS NUMBER

VMI_MINIMUM_DAYS NUMBER

VMI_MAXIMUM_UNITS NUMBER

VMI_MAXIMUM_DAYS NUMBER

VMI_FIXED_ORDER_QUANTITY NUMBER

SO_AUTHORIZATION_FLAG NUMBER

CONSIGNED_FLAG NUMBER

ASN_AUTOEXPIRE_FLAG NUMBER

VMI_FORECAST_TYPE NUMBER

FORECAST_HORIZON NUMBER

BUDGET_CONSTRAINED NUMBER

DAYS_TGT_INV_SUPPLY NUMBER

DAYS_TGT_INV_WINDOW NUMBER

DAYS_MAX_INV_SUPPLY NUMBER

DAYS_MAX_INV_WINDOW NUMBER

DRP_PLANNED NUMBER

CONTINOUS_TRANSFER NUMBER

CONVERGENCE NUMBER

DIVERGENCE NUMBER

PRODUCT_FAMILY_ITEM_NAME VARCHAR2 (250)
EAM_ITEM_TYPE NUMBER

REPAIR_LEAD_TIME NUMBER

PRE_POSITION_INVENTORY NUMBER

REPAIR_YIELD NUMBER

REPAIR_PROGRAM NUMBER

PREPOSITION_POINT VARCHAR2 (1)
REPAIR_LEADTIME NUMBER

ITEM_CREATION_DATE DATE

SHORTAGE_TYPE NUMBER

EXCESS_TYPE NUMBER

PLANNING_TIME_FENCE_CODE NUMBER

PEGGING_DEMAND_WINDOW_DAYS NUMBER

PEGGING_SUPPLY_WINDOW_DAYS NUMBER

UNSATISFIED_DEMAND_FACTOR NUMBER

MIN_SUP_DEM_PERCENT NUMBER

DMD_SATISFIED_PERCENT NUMBER

Query Text

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


SELECT ORGANIZATION_ID
,      SR_ORGANIZATION_ID
,      INVENTORY_ITEM_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
,      DEMAND_TIME_FENCE_DAYS
,      RELEASE_TIME_FENCE_CODE
,      RELEASE_TIME_FENCE_DAYS
,      DESCRIPTION
,      IN_SOURCE_PLAN
,      REVISION
,      SR_CATEGORY_ID
,      CATEGORY_NAME
,      ABC_CLASS_ID
,      ABC_CLASS_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
,      MRP_CALCULATE_ATP_FLAG
,      ATP_COMPONENTS_FLAG
,      BUILT_IN_WIP_FLAG
,      PURCHASING_ENABLED_FLAG
,      PLANNING_MAKE_BUY_CODE
,      REPETITIVE_TYPE
,      STANDARD_COST
,      CARRYING_COST
,      ORDER_COST
,      DMD_LATENESS_COST
,      SS_PENALTY_COST
,      SUPPLIER_CAP_OVERUTIL_COST
,      LIST_PRICE
,      AVERAGE_DISCOUNT
,      END_ASSEMBLY_PEGGING_FLAG
,      END_ASSEMBLY_PEGGING
,      FULL_PEGGING
,      ENGINEERING_ITEM_FLAG
,      WIP_SUPPLY_TYPE
,      MRP_SAFETY_STOCK_CODE
,      MRP_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
,      REPETITIVE_VARIANCE_DAYS
,      BASE_ITEM_ID
,      BOM_ITEM_TYPE
,      ATO_FORECAST_CONTROL
,      ORGANIZATION_CODE
,      EFFECTIVITY_CONTROL
,      ACCEPTABLE_EARLY_DELIVERY
,      INVENTORY_PLANNING_CODE
,      INVENTORY_TYPE
,      ACCEPTABLE_RATE_INCREASE
,      ACCEPTABLE_RATE_DECREASE
,      PRIMARY_SUPPLIER_ID
,      DELETED_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SR_INSTANCE_ID
,      REFRESH_ID
,      ATP_FLAG
,      INVENTORY_ITEM_FLAG
,      REVISION_QTY_CONTROL_CODE
,      EXPENSE_ACCOUNT
,      INVENTORY_ASSET_FLAG
,      BUYER_ID
,      MATERIAL_COST
,      RESOURCE_COST
,      SOURCE_ORG_ID
,      PICK_COMPONENTS_FLAG
,      ALLOWED_UNITS_LOOKUP_CODE
,      SERVICE_LEVEL
,      REPLENISH_TO_ORDER_FLAG
,      PIP_FLAG
,      COMPANY_ID
,      COMPANY_NAME
,      SR_INSTANCE_CODE
,      ATP_RULE_CODE
,      BASE_ITEM_NAME
,      PRIMARY_SUPPLIER_NAME
,      SOURCE_ORG_CODE
,      MESSAGE_ID
,      PROCESS_FLAG
,      ERROR_TEXT
,      DATA_SOURCE_TYPE
,      ST_TRANSACTION_ID
,      BATCH_ID
,      MIN_MINMAX_QUANTITY
,      MAX_MINMAX_QUANTITY
,      YIELD_CONV_FACTOR
,      SOURCE_TYPE
,      SUBSTITUTION_WINDOW
,      CREATE_SUPPLY_FLAG
,      SERIAL_NUMBER_CONTROL_CODE
,      CRITICAL_COMPONENT_FLAG
,      REDUCE_MPS
,      SOURCE_SR_INVENTORY_ITEM_ID
,      SOURCE_SOURCE_ORG_ID
,      SOURCE_PRIMARY_SUPPLIER_ID
,      SOURCE_BASE_ITEM_ID
,      SOURCE_ABC_CLASS_ID
,      VMI_MINIMUM_UNITS
,      VMI_MINIMUM_DAYS
,      VMI_MAXIMUM_UNITS
,      VMI_MAXIMUM_DAYS
,      VMI_FIXED_ORDER_QUANTITY
,      SO_AUTHORIZATION_FLAG
,      CONSIGNED_FLAG
,      ASN_AUTOEXPIRE_FLAG
,      VMI_FORECAST_TYPE
,      FORECAST_HORIZON
,      BUDGET_CONSTRAINED
,      DAYS_TGT_INV_SUPPLY
,      DAYS_TGT_INV_WINDOW
,      DAYS_MAX_INV_SUPPLY
,      DAYS_MAX_INV_WINDOW
,      DRP_PLANNED
,      CONTINOUS_TRANSFER
,      CONVERGENCE
,      DIVERGENCE
,      PRODUCT_FAMILY_ITEM_NAME
,      EAM_ITEM_TYPE
,      REPAIR_LEAD_TIME
,      PRE_POSITION_INVENTORY
,      REPAIR_YIELD
,      REPAIR_PROGRAM
,      PREPOSITION_POINT
,      REPAIR_LEADTIME
,      ITEM_CREATION_DATE
,      SHORTAGE_TYPE
,      EXCESS_TYPE
,      PLANNING_TIME_FENCE_CODE
,      PEGGING_DEMAND_WINDOW_DAYS
,      PEGGING_SUPPLY_WINDOW_DAYS
,      UNSATISFIED_DEMAND_FACTOR
,      MIN_SUP_DEM_PERCENT
,      DMD_SATISFIED_PERCENT
FROM MSC.MSC_ST_SYSTEM_ITEMS#;

Dependencies

[top of page]

MSC.MSC_ST_SYSTEM_ITEMS# references the following:

SchemaMSC
TableMSC_ST_SYSTEM_ITEMS
MSC.MSC_ST_SYSTEM_ITEMS# is referenced by following:

SchemaAPPS
SynonymMSC_ST_SYSTEM_ITEMS