You are browsing the archive for Oracle Spares Management.

Oracle Spares Management Tables

Oracle Spares Management module database table information:

  • CSP_CARRIER_DELIVERY_TIMES
  • CSP_CURR_SUP_DEM_SUMS
  • CSP_EXCESS_LISTS
  • CSP_EXCESS_LIST_SERIAL_LOTS
  • CSP_EXCESS_RULES_B
  • CSP_EXCESS_RULES_TL
  • CSP_FAILURE_RATES
  • CSP_FORECAST_RULES_B
  • CSP_FORECAST_RULES_TL
  • CSP_INV_LOC_ASSIGNMENTS
  • CSP_LOOP_CALC_RULES_B
  • CSP_LOOP_CALC_RULES_TL
  • CSP_MOVEORDER_HEADERS
  • CSP_MOVEORDER_LINES
  • CSP_MSTRSTCK_LISTS_ITMS
  • CSP_NOTIFICATIONS
  • CSP_NOTIFICATION_DETAILS
  • CSP_PACKLIST_BOXES
  • CSP_PACKLIST_HEADERS
  • CSP_PACKLIST_LINES
  • CSP_PACKLIST_SERIAL_LOTS
  • CSP_PARTS_LOOPS_B
  • CSP_PARTS_LOOPS_TL
  • CSP_PICKLIST_HEADERS
  • CSP_PICKLIST_LINES
  • CSP_PICKLIST_SERIAL_LOTS
  • CSP_PLANNING_PARAMETERS
  • CSP_PRODUCT_POPULATIONS
  • CSP_PRODUCT_TASKS
  • CSP_REP_HIERARCHIES
  • CSP_REQUIREMENT_HEADERS
  • CSP_REQUIREMENT_LINES
  • CSP_REQ_LINE_DETAILS
  • CSP_RS_CUST_RELATIONS
  • CSP_SAFETY_FACTORS
  • CSP_SEC_INVENTORIES
  • CSP_STOCK_LISTS
  • CSP_SUPERSEDE_ITEMS
  • CSP_SUPPLY_CHAIN
  • CSP_TASK_PARTS
  • CSP_USAGE_HEADERS
  • CSP_USAGE_HISTORIES

Oracle Spares Management Forms

Oracle Spares Management Forms:

FORM SHORT CODE ORACLE FORM NAME
CSPTRDCT CSP:Delivery Time
CSPTRESS CSP:Resource Addresses and Subinventories
CSPTRVMO CSP:Move Order Status
CSPPLPLN CSP:Planner’s Desktop
CSPTRCMO CSP:Parts Order Entry
CSPTRTMO Move Order
CSPTRPCM CSP:Confirm Pick
CSPTRPAC CSP:Packlist
CSPTRREC CSP:Receive Parts
CSPPLFRU CSP:Forecasting Rules
CSPPLCAL CSP:Calculation Rules
CSPTRREQ CSP:Parts Requirements
CSPTREXC CSP:Excess Return
CSPTRBUR CSP:Excess Rules
CSPPTAPA CSP:Task Parts
CSPPPAPR CSP:Part Priorities
CSPPLBRU CSP:Business Rules
CSPPLSUP CSP:Define Supersesions

Spares Management Profile Options

Oracle Spares Management Profile Options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
CSP_REPAIR_SUP_ORG_USABLE_SUBINV CSP: Repair Supplier Organization’s Usable Subinventory
CSP_REPAIR_SUP_ORG_DEFECT_SUBINV CSP: Repair Supplier Organization’s Defective Subinventory
CSP_INCL_CAR_STOCK CSP: Include Car Stock
CSP_INCL_ALTERNATES CSP: Include Alternates
CSP_CANCEL_REASON CSP : Cancel Reason
CSP_CHECK_ATP CSP: Use ATP For Parts
CSP_PO_LINE_TYPE CSP: Purchasing Line Type
CSP_USAGE_RUN_DATE CSP: Usage Run Date
CSP_INTRANSIT_SUBINVENTORY CSP: Move Order Intransit Subinventory
CSP_EXCESS_PARTS_ORDER_TYPE CSP: Excess Parts Order Type
CSP_PROD_TASK_HIST_RULE CSP: Product Task History Threshold
CSP_ORDER_TYPE CSP: Order Type
CSP_SHIP_COMPLETE CSP: Ship Complete
CSP_INTRANSIT_LOCATION_USED CSP: Transit Times between Location usage