You are browsing the archive for Service.

Contract Billing Program

 

NAME: Contract Billing Program
SHORT CODE: CSCRBAT
MODULE: Oracle Service

Description: Contract Billing Program
Navigation: Oracle Service Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • Default Date : Default date
  • Window : Window
  • Contract Number : Contract Number

 

Auto-Renew Eligible Contracts

 

NAME: Auto-Renew Eligible Contracts
SHORT CODE: CSAUBAT
MODULE: Oracle Service

Description: Auto-Renew Eligible Contracts
Navigation: Oracle Service Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • Default Date : Default Date

 

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