CSP Tables (44)

CSP - Spares Management — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

TableColumnsDescription
CSP_AVAILABLE_PARTS_TEMP 17
CSP_CARRIER_DELIVERY_TIMES 36 This table stores the deliver time related information
CSP_CURR_SUP_DEM_SUMS 45 Summarized supply and demand information.
CSP_EXCESS_LISTS 35 Excess Spare Parts
CSP_EXCESS_LIST_SERIAL_LOTS 13 Excess list serial and lot numbers
CSP_EXCESS_RULES_B 31 To Store Excess Rules
CSP_EXCESS_RULES_TL 10 Translated Excess rules definitions
CSP_FAILURE_RATES 12 Stores component's failure rates for a product.
CSP_FORECAST_RULES_B 44 Stores forecast rules
CSP_FORECAST_RULES_TL 10 Translated forecast rules definitions
CSP_INV_LOC_ASSIGNMENTS 31 Inventory location assignments to resources
CSP_LOOP_CALC_RULES_B 39 Stores calculation rules
CSP_LOOP_CALC_RULES_TL 10 Translated calculation rules definitions
CSP_MOVEORDER_HEADERS 28 Holds extra information for moveorder headers
CSP_MOVEORDER_LINES 29 Holds extra information for moveorder lines
CSP_MSTRSTCK_LISTS_ITMS 32 Master stocklist
CSP_NOTIFICATIONS 38 Holds parts loop notifications
CSP_NOTIFICATION_DETAILS 32 Details on how to handle a warehouse notification.
CSP_PACKLIST_BOXES 27 Packlist Boxes
CSP_PACKLIST_HEADERS 37 Packlist headers
CSP_PACKLIST_LINES 35 Packlist lines
CSP_PACKLIST_SERIAL_LOTS 13 Packlist serial and lot numbers
CSP_PARTS_LOOPS_B 28 Parts Loop definition
CSP_PARTS_LOOPS_TL 10 Translated Parts Loop definition
CSP_PICKLIST_HEADERS 28 Picklist headers
CSP_PICKLIST_LINES 31 Picklist lines
CSP_PICKLIST_SERIAL_LOTS 13 Picklist serial and lotnumbers
CSP_PLANNING_PARAMETERS 108 Planning Parameters Definition
CSP_PRODUCT_POPULATIONS 11 Stores the population of a product.
CSP_PRODUCT_TASKS 28 Product Tasks
CSP_REP_HIERARCHIES 28 Reporting hierarchies
CSP_REQUIRED_PARTS_TEMP 5
CSP_REQUIREMENT_HEADERS 38 Stores information regarding parts requirements.
CSP_REQUIREMENT_LINES 41 Parts requirement details.
CSP_REQ_LINE_DETAILS 9
CSP_RS_CUST_RELATIONS 31 Resource with ship to address and subinventory assigned
CSP_SAFETY_FACTORS 11 Safety Factors Lookup
CSP_SEC_INVENTORIES 37 Holds extra subinventory information
CSP_STOCK_LISTS 11 Stores information about how the stock list item was created.
CSP_SUPERSEDE_ITEMS 26 This table stores Item planned for warehouses and item supplied for subinventories
CSP_SUPPLY_CHAIN 16 Supply Chain details
CSP_TASK_PARTS 36 Task Parts
CSP_USAGE_HEADERS 23 Planning recommendations summary
CSP_USAGE_HISTORIES 38 Summarized usage history information