You are browsing the archive for CRP.

Oracle Material Requirements Planning Tables

Oracle MRP module – List of database tables

  • MRP_AD_BOMS
  • MRP_AD_CTO_ORDER_DEMAND
  • MRP_AD_DEMAND
  • MRP_AD_DEPT_RESS
  • MRP_AD_DSCR_JOBS
  • MRP_AD_FLOW_SCHDS
  • MRP_AD_FORECAST_DATES
  • MRP_AD_FORECAST_DSGN
  • MRP_AD_INV_COMPS
  • MRP_AD_MTRX_TMP
  • MRP_AD_OH_QTYS
  • MRP_AD_OPERATION_COMPONENTS
  • MRP_AD_OPR_NETWORKS
  • MRP_AD_OPR_RESS
  • MRP_AD_OPR_RTNS
  • MRP_AD_OPR_SEQS
  • MRP_AD_ORDER_LINES_ALL
  • MRP_AD_PROCESS_EFFECTIVITY
  • MRP_AD_REPT_ITEM_DEMANDS
  • MRP_AD_REPT_ITEM_SUPPLIES
  • MRP_AD_REPT_SCHDS
  • MRP_AD_RESOURCE_REQUIREMENTS
  • MRP_AD_RES_CHNGS
  • MRP_AD_SCHD_DATES
  • MRP_AD_SI_CAPA
  • MRP_AD_SUB_OPR_RESS
  • MRP_AD_SUPPLY
  • MRP_AD_U_DEMAND
  • MRP_AD_U_SUPPLY
  • MRP_AD_WIP_COMP_DEMANDS
  • MRP_AD_WIP_COMP_SUPPLIES
  • MRP_AD_WLINES
  • MRP_AD_WOPRS
  • MRP_AD_WOPR_RESS
  • MRP_AD_WREQ_OPRS
  • MRP_AGGREGATE_RATES
  • MRP_AMONG_VALUES
  • MRP_AP_APPS_INSTANCES
  • MRP_ASSEMBLY_OPERATIONS
  • MRP_ASSIGNMENT_SETS
  • MRP_ATP_DETAILS_TEMP
  • MRP_ATP_SCHEDULE_TEMP
  • MRP_ATP_SUPPLY_DEMAND
  • MRP_AUDIT_SQL_STATEMENTS
  • MRP_AVAILABLE_TO_PROMISE
  • MRP_BIS_FORECAST_WB
  • MRP_BIS_INV_DETAIL
  • MRP_BIS_PLAN_PROFIT
  • MRP_BIS_RES_SUMMARY
  • MRP_BOM_COMPONENTS
  • MRP_CACHE_SEQ
  • MRP_COMPONENT_SUBSTITUTES
  • MRP_CRITERIA
  • MRP_DERIVED_SO_DEMANDS
  • MRP_DESIGNATORS
  • MRP_END_ASSEMBLIES
  • MRP_EXCELS
  • MRP_EXCEL_COLUMNS
  • MRP_EXCEL_COMPONENTS
  • MRP_EXCEPTION_DETAILS
  • MRP_FILES
  • MRP_FLOW_DEMANDS
  • MRP_FORECAST_DATES
  • MRP_FORECAST_DESIGNATORS
  • MRP_FORECAST_INTERFACE
  • MRP_FORECAST_ITEMS
  • MRP_FORECAST_UPDATES
  • MRP_FORM_QUERY
  • MRP_FULL_PEGGING
  • MRP_GROSS_REQUIREMENTS
  • MRP_I2_ACTIONS
  • MRP_I2_ACTION_SETS
  • MRP_I2_AGGREGATE_RESOURCE
  • MRP_I2_BC_RESULTS
  • MRP_I2_BOM
  • MRP_I2_BOM_NET
  • MRP_I2_BOM_TEMP
  • MRP_I2_DEBUG_MSG
  • MRP_I2_FORECASTS
  • MRP_I2_MFG_ORDER_OUTPUT
  • MRP_I2_ONHAND_INVENTORY
  • MRP_I2_OP_RESOURCE
  • MRP_I2_PARAMETERS
  • MRP_I2_PART_MASTER
  • MRP_I2_PART_MASTER_NET
  • MRP_I2_PART_SUPPLIER
  • MRP_I2_PENDING_BACKFLUSH
  • MRP_I2_PO_EDC
  • MRP_I2_PROCUREMENT
  • MRP_I2_PROC_BY_PART
  • MRP_I2_PROD_SCHEDULE
  • MRP_I2_RESOURCE
  • MRP_I2_RESOURCE_CALENDAR
  • MRP_I2_ROUTING
  • MRP_I2_ROUTING_NET
  • MRP_I2_SAFETY_STOCK
  • MRP_I2_SALES_ORDER
  • MRP_I2_UNAVAIL_RESOURCE
  • MRP_I2_WIP
  • MRP_I2_WORK_ORDERS
  • MRP_I2_WO_DELTAS
  • MRP_I2_WO_OP_OUTPUT
  • MRP_INVENTORY_LOTS
  • MRP_ITEM_EXCEPTIONS
  • MRP_ITEM_PURCHASE_ORDERS
  • MRP_ITEM_SOURCING
  • MRP_ITEM_SUPPLIERS
  • MRP_ITEM_WIP_ENTITIES
  • MRP_KANBAN_DEMAND
  • MRP_KANBAN_PLANS
  • MRP_LOAD_PARAMETERS
  • MRP_LOAD_SELECTIONS
  • MRP_LOW_LEVEL_CODES
  • MRP_MATERIAL_PLANS
  • MRP_MESSAGES_TMP
  • MRP_NET_RESOURCE_AVAIL
  • MRP_ONHAND_QUANTITIES
  • MRP_PARAMETERS
  • MRP_PENDING_ENG_CHANGES
  • MRP_PLANNED_RESOURCE_REQS
  • MRP_PLANNER_TASKS
  • MRP_PLANNING_EXCEPTION_SETS
  • MRP_PLANS
  • MRP_PLAN_ORGANIZATIONS
  • MRP_PLAN_SCHEDULES
  • MRP_RECOMMENDATIONS
  • MRP_RELIEF_INTERFACE
  • MRP_REPETITIVE_PERIODS
  • MRP_REPETITIVE_SCHEDULES
  • MRP_RESERVATIONS
  • MRP_RHX_USEUP_INFO
  • MRP_SAFETY_STOCK
  • MRP_SALES_ORDER_UPDATES
  • MRP_SCHEDULER_MESSAGES
  • MRP_SCHEDULE_CONSUMPTIONS
  • MRP_SCHEDULE_DATES
  • MRP_SCHEDULE_DESIGNATORS
  • MRP_SCHEDULE_INTERFACE
  • MRP_SCHEDULE_ITEMS
  • MRP_SCHEDULING_RULES
  • MRP_SELECTION_CRITERIA
  • MRP_SNAPSHOT_TASKS
  • MRP_SOURCING_HISTORY
  • MRP_SOURCING_RULES
  • MRP_SO_LINES_TEMP
  • MRP_SQLLOAD_PARAMETERS
  • MRP_SR_ASSIGNMENTS
  • MRP_SR_RECEIPT_ORG
  • MRP_SR_SOURCE_ORG
  • MRP_SUB_INVENTORIES
  • MRP_SUGG_REP_SCHEDULES
  • MRP_SUPPLIER_CAPACITIES
  • MRP_SUPPLIER_FLEX_FENCES
  • MRP_SYSTEM_ITEMS
  • MRP_WIP_COMPONENTS
  • MRP_WIP_RESOURCES
  • MRP_WORKBENCH_BUCKET_DATES
  • MRP_WORKBENCH_CRITERIA
  • MRP_WORKBENCH_DISPLAY_OPTIONS
  • MRP_WORKBENCH_QUERY

Oracle Capacity Tables

Oracle Capacity Module Tables:

  • CRP_AVAILABLE_RESOURCES
  • CRP_BILLS_OF_RESOURCES
  • CRP_BILL_OF_RESOURCE_ITEMS
  • CRP_CAL_SHIFT_DELTA
  • CRP_CAPACITY_PLANS
  • CRP_DISPLAY_OPTIONS
  • CRP_FORM_QUERY
  • CRP_PLANNED_RESOURCES
  • CRP_RESOURCE_HOURS
  • CRP_RESOURCE_PLAN
  • CRP_SIMULATION_SETS

Capacity Concurrent Programs

Oracle Capacity Module Concurrent Programs

CONCURRENT PROGRAM SHORT CODE CONCURRENT PROGRAM NAME
CYCROL Bill of Resources Load
CYCCRP CRP Routing-Based Report
CYCPLN CRP Planner
CYCPLW CRP Planner Worker
CRPPSPRS CRP Purge Bill of Resources
CRPRRBOR Bill of Resources Report
CYCCRP2 CRP Rate-Based Report
CYRRCP RCCP Routing-Based Report
CYRRCP2 RCCP Rate-Based Report
CRPPSPSS Purge Simulation Sets
CYCQCP Capacity Manager
CYCCRPSCP CRP Routing-Based Report (Supply Chain Planning)
CYCCRP2SCP CRP Rate-Based Report (Supply Chain Planning)
CYRRCPSCP RCCP Routing-Based Report (Supply Chain Planning)
CYRRCP2SCP RCCP Rate-Based Report (Supply Chain Planning)
CRPRRBOR_XML Bill of Resources Report (XML)