VIEW: MRP.MRP_SYSTEM_ITEMS#

Source

View Text - Preformatted

select INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, COMPILE_DESIGNATOR COMPILE_DESIGNATOR, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, IN_SOURCE_PLAN IN_SOURCE_PLAN, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, INVENTORY_TYPE INVENTORY_TYPE, MRP_PLANNING_CODE MRP_PLANNING_CODE, INVENTORY_PLANNING_CODE INVENTORY_PLANNING_CODE, LOW_LEVEL_CODE LOW_LEVEL_CODE, PREPROCESSING_LEAD_TIME PREPROCESSING_LEAD_TIME, POSTPROCESSING_LEAD_TIME POSTPROCESSING_LEAD_TIME, FULL_LEAD_TIME FULL_LEAD_TIME, CUMULATIVE_TOTAL_LEAD_TIME CUMULATIVE_TOTAL_LEAD_TIME, CUM_MANUFACTURING_LEAD_TIME CUM_MANUFACTURING_LEAD_TIME, FIXED_LEAD_TIME FIXED_LEAD_TIME, VARIABLE_LEAD_TIME VARIABLE_LEAD_TIME, UOM_CODE UOM_CODE, BUILD_IN_WIP_FLAG BUILD_IN_WIP_FLAG, PURCHASING_ENABLED_FLAG PURCHASING_ENABLED_FLAG, PLANNING_MAKE_BUY_CODE PLANNING_MAKE_BUY_CODE, REPETITIVE_TYPE REPETITIVE_TYPE, STANDARD_COST STANDARD_COST, LOT_CONTROL_CODE LOT_CONTROL_CODE, ROUNDING_CONTROL_TYPE ROUNDING_CONTROL_TYPE, CALCULATE_ATP CALCULATE_ATP, END_ASSEMBLY_PEGGING END_ASSEMBLY_PEGGING, NETTABLE_INVENTORY_QUANTITY NETTABLE_INVENTORY_QUANTITY, NONNETTABLE_INVENTORY_QUANTITY NONNETTABLE_INVENTORY_QUANTITY, ENGINEERING_ITEM_FLAG ENGINEERING_ITEM_FLAG, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE, OVERRUN_PERCENTAGE OVERRUN_PERCENTAGE, ACCEPTABLE_RATE_INCREASE ACCEPTABLE_RATE_INCREASE, ACCEPTABLE_RATE_DECREASE ACCEPTABLE_RATE_DECREASE, SAFETY_STOCK_CODE SAFETY_STOCK_CODE, SAFETY_STOCK_PERCENT SAFETY_STOCK_PERCENT, SAFETY_STOCK_BUCKET_DAYS SAFETY_STOCK_BUCKET_DAYS, SAFETY_STOCK_QUANTITY SAFETY_STOCK_QUANTITY, PLAN_LAST_REVISION_DATE PLAN_LAST_REVISION_DATE, DESCRIPTION DESCRIPTION, CATEGORY_ID CATEGORY_ID, BUYER_ID BUYER_ID, BUYER_NAME BUYER_NAME, PLANNER_CODE PLANNER_CODE, ABC_CLASS ABC_CLASS, REVISION REVISION, FIXED_DAYS_SUPPLY FIXED_DAYS_SUPPLY, FIXED_ORDER_QUANTITY FIXED_ORDER_QUANTITY, FIXED_LOT_MULTIPLIER FIXED_LOT_MULTIPLIER, MINIMUM_ORDER_QUANTITY MINIMUM_ORDER_QUANTITY, MAXIMUM_ORDER_QUANTITY MAXIMUM_ORDER_QUANTITY, PLANNING_TIME_FENCE_DAYS PLANNING_TIME_FENCE_DAYS, PLANNING_TIME_FENCE_DATE PLANNING_TIME_FENCE_DATE, DEMAND_TIME_FENCE_DAYS DEMAND_TIME_FENCE_DAYS, INVENTORY_USE_UP_DATE INVENTORY_USE_UP_DATE, ACCEPTABLE_EARLY_DELIVERY ACCEPTABLE_EARLY_DELIVERY, PLANNER_BATCH_NUMBER PLANNER_BATCH_NUMBER, PLANNER_STATUS_CODE PLANNER_STATUS_CODE, PLAN_START_DATE PLAN_START_DATE, PLAN_COMPLETION_DATE PLAN_COMPLETION_DATE, SHRINKAGE_RATE SHRINKAGE_RATE, PLANNING_EXCEPTION_SET PLANNING_EXCEPTION_SET, EXCESS_QUANTITY EXCESS_QUANTITY, REPETITIVE_VARIANCE REPETITIVE_VARIANCE, EXCEPTION_SHORTAGE_DAYS EXCEPTION_SHORTAGE_DAYS, EXCEPTION_EXCESS_DAYS EXCEPTION_EXCESS_DAYS, EXCEPTION_REP_VARIANCE_DAYS EXCEPTION_REP_VARIANCE_DAYS, EXCEPTION_OVERPROMISED_DAYS EXCEPTION_OVERPROMISED_DAYS, BASE_ITEM_ID BASE_ITEM_ID, BOM_ITEM_TYPE BOM_ITEM_TYPE, ATO_FORECAST_CONTROL ATO_FORECAST_CONTROL, EXCEPTION_CODE EXCEPTION_CODE, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PRIMARY_VENDOR_ID PRIMARY_VENDOR_ID, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, DEMAND_TIME_FENCE_DATE DEMAND_TIME_FENCE_DATE, FULL_PEGGING FULL_PEGGING, ORGANIZATION_CODE ORGANIZATION_CODE, EFFECTIVITY_CONTROL EFFECTIVITY_CONTROL from "MRP"."MRP_SYSTEM_ITEMS"

View Text - HTML Formatted

SELECT INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, COMPILE_DESIGNATOR COMPILE_DESIGNATOR
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, IN_SOURCE_PLAN IN_SOURCE_PLAN
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, INVENTORY_TYPE INVENTORY_TYPE
, MRP_PLANNING_CODE MRP_PLANNING_CODE
, INVENTORY_PLANNING_CODE INVENTORY_PLANNING_CODE
, LOW_LEVEL_CODE LOW_LEVEL_CODE
, PREPROCESSING_LEAD_TIME PREPROCESSING_LEAD_TIME
, POSTPROCESSING_LEAD_TIME POSTPROCESSING_LEAD_TIME
, FULL_LEAD_TIME FULL_LEAD_TIME
, CUMULATIVE_TOTAL_LEAD_TIME CUMULATIVE_TOTAL_LEAD_TIME
, CUM_MANUFACTURING_LEAD_TIME CUM_MANUFACTURING_LEAD_TIME
, FIXED_LEAD_TIME FIXED_LEAD_TIME
, VARIABLE_LEAD_TIME VARIABLE_LEAD_TIME
, UOM_CODE UOM_CODE
, BUILD_IN_WIP_FLAG BUILD_IN_WIP_FLAG
, PURCHASING_ENABLED_FLAG PURCHASING_ENABLED_FLAG
, PLANNING_MAKE_BUY_CODE PLANNING_MAKE_BUY_CODE
, REPETITIVE_TYPE REPETITIVE_TYPE
, STANDARD_COST STANDARD_COST
, LOT_CONTROL_CODE LOT_CONTROL_CODE
, ROUNDING_CONTROL_TYPE ROUNDING_CONTROL_TYPE
, CALCULATE_ATP CALCULATE_ATP
, END_ASSEMBLY_PEGGING END_ASSEMBLY_PEGGING
, NETTABLE_INVENTORY_QUANTITY NETTABLE_INVENTORY_QUANTITY
, NONNETTABLE_INVENTORY_QUANTITY NONNETTABLE_INVENTORY_QUANTITY
, ENGINEERING_ITEM_FLAG ENGINEERING_ITEM_FLAG
, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
, OVERRUN_PERCENTAGE OVERRUN_PERCENTAGE
, ACCEPTABLE_RATE_INCREASE ACCEPTABLE_RATE_INCREASE
, ACCEPTABLE_RATE_DECREASE ACCEPTABLE_RATE_DECREASE
, SAFETY_STOCK_CODE SAFETY_STOCK_CODE
, SAFETY_STOCK_PERCENT SAFETY_STOCK_PERCENT
, SAFETY_STOCK_BUCKET_DAYS SAFETY_STOCK_BUCKET_DAYS
, SAFETY_STOCK_QUANTITY SAFETY_STOCK_QUANTITY
, PLAN_LAST_REVISION_DATE PLAN_LAST_REVISION_DATE
, DESCRIPTION DESCRIPTION
, CATEGORY_ID CATEGORY_ID
, BUYER_ID BUYER_ID
, BUYER_NAME BUYER_NAME
, PLANNER_CODE PLANNER_CODE
, ABC_CLASS ABC_CLASS
, REVISION REVISION
, FIXED_DAYS_SUPPLY FIXED_DAYS_SUPPLY
, FIXED_ORDER_QUANTITY FIXED_ORDER_QUANTITY
, FIXED_LOT_MULTIPLIER FIXED_LOT_MULTIPLIER
, MINIMUM_ORDER_QUANTITY MINIMUM_ORDER_QUANTITY
, MAXIMUM_ORDER_QUANTITY MAXIMUM_ORDER_QUANTITY
, PLANNING_TIME_FENCE_DAYS PLANNING_TIME_FENCE_DAYS
, PLANNING_TIME_FENCE_DATE PLANNING_TIME_FENCE_DATE
, DEMAND_TIME_FENCE_DAYS DEMAND_TIME_FENCE_DAYS
, INVENTORY_USE_UP_DATE INVENTORY_USE_UP_DATE
, ACCEPTABLE_EARLY_DELIVERY ACCEPTABLE_EARLY_DELIVERY
, PLANNER_BATCH_NUMBER PLANNER_BATCH_NUMBER
, PLANNER_STATUS_CODE PLANNER_STATUS_CODE
, PLAN_START_DATE PLAN_START_DATE
, PLAN_COMPLETION_DATE PLAN_COMPLETION_DATE
, SHRINKAGE_RATE SHRINKAGE_RATE
, PLANNING_EXCEPTION_SET PLANNING_EXCEPTION_SET
, EXCESS_QUANTITY EXCESS_QUANTITY
, REPETITIVE_VARIANCE REPETITIVE_VARIANCE
, EXCEPTION_SHORTAGE_DAYS EXCEPTION_SHORTAGE_DAYS
, EXCEPTION_EXCESS_DAYS EXCEPTION_EXCESS_DAYS
, EXCEPTION_REP_VARIANCE_DAYS EXCEPTION_REP_VARIANCE_DAYS
, EXCEPTION_OVERPROMISED_DAYS EXCEPTION_OVERPROMISED_DAYS
, BASE_ITEM_ID BASE_ITEM_ID
, BOM_ITEM_TYPE BOM_ITEM_TYPE
, ATO_FORECAST_CONTROL ATO_FORECAST_CONTROL
, EXCEPTION_CODE EXCEPTION_CODE
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PRIMARY_VENDOR_ID PRIMARY_VENDOR_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, DEMAND_TIME_FENCE_DATE DEMAND_TIME_FENCE_DATE
, FULL_PEGGING FULL_PEGGING
, ORGANIZATION_CODE ORGANIZATION_CODE
, EFFECTIVITY_CONTROL EFFECTIVITY_CONTROL
FROM "MRP"."MRP_SYSTEM_ITEMS"