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

TABLE: MSC.MSC_ST_SYSTEM_ITEMS

Object Details
Object Name: MSC_ST_SYSTEM_ITEMS
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_ST_SYSTEM_ITEMS
Subobject Name:
Status: VALID

The staging table used by the collection program to valid and process data for table MSC_SYSTEM_ITEMS.

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Organization identifer
SR_ORGANIZATION_ID NUMBER

Source organization identifer
INVENTORY_ITEM_ID NUMBER

Inventory item identifier
SR_INVENTORY_ITEM_ID NUMBER

Source inventory item identifier
ITEM_NAME VARCHAR2 (250)
Item name
LOTS_EXPIRATION NUMBER

Lots expiration
LOT_CONTROL_CODE NUMBER

Flag indicating if lots_expiration is used or not
SHRINKAGE_RATE NUMBER

Percentage of shinkage for this item
FIXED_DAYS_SUPPLY NUMBER

Period of the supply days
FIXED_ORDER_QUANTITY NUMBER

Fixed order quantity
FIXED_LOT_MULTIPLIER NUMBER

Fixed lot multiplier
MINIMUM_ORDER_QUANTITY NUMBER

Minimum size of an order
MAXIMUM_ORDER_QUANTITY NUMBER

Maximum size of an order
ROUNDING_CONTROL_TYPE NUMBER

Flag indicating if rounding of the quantity is allowed
PLANNING_TIME_FENCE_DAYS NUMBER

Planning time fences days of the item
DEMAND_TIME_FENCE_DAYS NUMBER

Demand time fence days
RELEASE_TIME_FENCE_CODE NUMBER

Release time fence code
RELEASE_TIME_FENCE_DAYS NUMBER

Release time fence days
DESCRIPTION VARCHAR2 (960)
Item description
IN_SOURCE_PLAN NUMBER

Flag indicating whether the item is in the plan
REVISION VARCHAR2 (3)
Item revision code
SR_CATEGORY_ID NUMBER

Source category identifier
CATEGORY_NAME VARCHAR2 (200)
Category name
ABC_CLASS_ID NUMBER

ABC class identifier
ABC_CLASS_NAME VARCHAR2 (40)
ABC class name
MRP_PLANNING_CODE NUMBER

MRP planning code
FIXED_LEAD_TIME NUMBER

Fixed lead time
VARIABLE_LEAD_TIME NUMBER

Variable lead time
PREPROCESSING_LEAD_TIME NUMBER

Preprocessing lead time
POSTPROCESSING_LEAD_TIME NUMBER

Postprocessing lead time
FULL_LEAD_TIME NUMBER

Full lead time
CUMULATIVE_TOTAL_LEAD_TIME NUMBER

Cumulative total lead time
CUM_MANUFACTURING_LEAD_TIME NUMBER

Cumulative manufacturing lead time
UOM_CODE VARCHAR2 (3)
Unit of measure code
UNIT_WEIGHT NUMBER

Weight of the item
UNIT_VOLUME NUMBER

Volum of the item
WEIGHT_UOM VARCHAR2 (3)
Unit of measure for the weight
VOLUME_UOM VARCHAR2 (3)
Unit of measure for the volume
PRODUCT_FAMILY_ID NUMBER

Product family identifier
ATP_RULE_ID NUMBER

ATP rule identifier
MRP_CALCULATE_ATP_FLAG NUMBER

Flag indication whether to caculate ATP in MRP
ATP_COMPONENTS_FLAG VARCHAR2 (1)
Flag indicating whether to calculate components ATP
BUILT_IN_WIP_FLAG NUMBER

Flag to indicate if the item can be built in WIP
PURCHASING_ENABLED_FLAG NUMBER

Flag to indicate if the item can be purchased
PLANNING_MAKE_BUY_CODE NUMBER

Plan this item as either a make item or buy item
REPETITIVE_TYPE NUMBER

Flag indicates if this item build repetitively
STANDARD_COST NUMBER

Standard cost
CARRYING_COST NUMBER

Actual carrying cost
ORDER_COST NUMBER

Order cost
DMD_LATENESS_COST NUMBER

DMD lateness cost
SS_PENALTY_COST NUMBER

SS penalty cost
SUPPLIER_CAP_OVERUTIL_COST NUMBER

Supplier capacity over-utilization cost
LIST_PRICE NUMBER

Item list price
AVERAGE_DISCOUNT NUMBER

Item average discount
END_ASSEMBLY_PEGGING_FLAG VARCHAR2 (1)
Peg to the end assembly on reports
END_ASSEMBLY_PEGGING NUMBER

Peg to the end assembly on reports (value is populated by the plan)
FULL_PEGGING NUMBER

Full pegging flag
ENGINEERING_ITEM_FLAG NUMBER

Engineering item flag
WIP_SUPPLY_TYPE NUMBER

WIP supply type
MRP_SAFETY_STOCK_CODE NUMBER

Safety stock code
MRP_SAFETY_STOCK_PERCENT NUMBER

Safety stock percent
SAFETY_STOCK_BUCKET_DAYS NUMBER

Safety stock bucket days
INVENTORY_USE_UP_DATE DATE

Use up date
BUYER_NAME VARCHAR2 (255)
Buyer name
PLANNER_CODE VARCHAR2 (10)
Planner code
PLANNING_EXCEPTION_SET VARCHAR2 (10)
Exception control set
EXCESS_QUANTITY NUMBER

Excess quantity
EXCEPTION_SHORTAGE_DAYS NUMBER

Exception shortage days
EXCEPTION_EXCESS_DAYS NUMBER

Exception excess days
EXCEPTION_OVERPROMISED_DAYS NUMBER

Exception overpromised days
REPETITIVE_VARIANCE_DAYS NUMBER

Repetitive variance days
BASE_ITEM_ID NUMBER

Inventory base item identifier
BOM_ITEM_TYPE NUMBER

BOM item type
ATO_FORECAST_CONTROL NUMBER

ATO forecast control
ORGANIZATION_CODE VARCHAR2 (7)
Organization code
EFFECTIVITY_CONTROL NUMBER

Effectivity control code
ACCEPTABLE_EARLY_DELIVERY NUMBER

Acceptable early delivery
INVENTORY_PLANNING_CODE NUMBER

Inventory planning code
INVENTORY_TYPE NUMBER

Inventory type
ACCEPTABLE_RATE_INCREASE NUMBER

Acceptable rate increase
ACCEPTABLE_RATE_DECREASE NUMBER

Acceptable rate increase
PRIMARY_SUPPLIER_ID NUMBER

Primary supplier identifier
DELETED_FLAG NUMBER

Peg to the end assembly on reports
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
PROGRAM_ID NUMBER

Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
SR_INSTANCE_ID NUMBER

Source application instance identifier
REFRESH_ID NUMBER

Refresh identifier
ATP_FLAG VARCHAR2 (1)
ATP flag
INVENTORY_ITEM_FLAG NUMBER

Inventory item identifier
REVISION_QTY_CONTROL_CODE NUMBER

Revision quantity control control
EXPENSE_ACCOUNT NUMBER

Expense account
INVENTORY_ASSET_FLAG VARCHAR2 (1)
Inventory asset flag
BUYER_ID NUMBER (9)
Buyer identifier
MATERIAL_COST NUMBER

Material cost
RESOURCE_COST NUMBER

Resource cost
SOURCE_ORG_ID NUMBER

Source organization identifier
PICK_COMPONENTS_FLAG VARCHAR2 (1)
Flag indicating whether all shippable components should be picked
ALLOWED_UNITS_LOOKUP_CODE NUMBER

Allowed lookup code for units
SERVICE_LEVEL NUMBER

Service Level For the Item
REPLENISH_TO_ORDER_FLAG VARCHAR2 (1)
Replenish to Order Flag
PIP_FLAG NUMBER

Pip Flag
COMPANY_ID NUMBER

Company identifier
COMPANY_NAME VARCHAR2 (255)
Company name
SR_INSTANCE_CODE VARCHAR2 (3)
Source Instance Code
ATP_RULE_CODE VARCHAR2 (80)
ATP Rule
BASE_ITEM_NAME VARCHAR2 (250)
Base Item Name
PRIMARY_SUPPLIER_NAME VARCHAR2 (255)
Primary Supplier Name
SOURCE_ORG_CODE VARCHAR2 (7)
Source Organization Code
MESSAGE_ID NUMBER

This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML
PROCESS_FLAG NUMBER

- Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed
ERROR_TEXT VARCHAR2 (2000)
If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error
DATA_SOURCE_TYPE VARCHAR2 (15)
Source Type indicating the source of the records
ST_TRANSACTION_ID NUMBER

Transaction ID generated during pre-processing to uniquely identify a record in the staging table
BATCH_ID NUMBER

Batch identifier generated during pre-processing
MIN_MINMAX_QUANTITY NUMBER

Min Minmax Quantity
MAX_MINMAX_QUANTITY NUMBER

Max Minmax Quantity
YIELD_CONV_FACTOR NUMBER

Yield Conversion Factor
SOURCE_TYPE NUMBER

Source Type
SUBSTITUTION_WINDOW NUMBER

Substitution Window for the Item
CREATE_SUPPLY_FLAG NUMBER

create supply flag (1=Yes, 2=No)
SERIAL_NUMBER_CONTROL_CODE NUMBER

serial number control code
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

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
FROM MSC.MSC_ST_SYSTEM_ITEMS;

Dependencies

[top of page]

MSC.MSC_ST_SYSTEM_ITEMS does not reference any database object

MSC.MSC_ST_SYSTEM_ITEMS is referenced by following:

SchemaAPPS
SynonymMSC_ST_SYSTEM_ITEMS