CSP — Spares Management
44 documented tables · 93 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
CSP_REP_HIERARCHIES |
Reporting hierarchies | hub |
CSP_FORECAST_RULES_B |
Stores forecast rules | hub-leaning |
CSP_PARTS_LOOPS_B |
Parts Loop definition | hub |
CSP_LOOP_CALC_RULES_B |
Stores calculation rules | hub-leaning |
CSP_EXCESS_RULES_B |
To Store Excess Rules | satellite-leaning |
CSP_PLANNING_PARAMETERS |
Planning Parameters Definition | satellite-leaning |
CSP_PACKLIST_HEADERS |
Packlist headers | satellite-leaning |
CSP_EXCESS_LISTS |
Excess Spare Parts | satellite-leaning |
CSP_PRODUCT_TASKS |
Product Tasks | satellite-leaning |
CSP_MOVEORDER_LINES |
Holds extra information for moveorder lines | satellite-leaning |
CSP_PICKLIST_LINES |
Picklist lines | satellite-leaning |
CSP_MOVEORDER_HEADERS |
Holds extra information for moveorder headers | satellite-leaning |
CSP_PICKLIST_HEADERS |
Picklist headers | hub-leaning |
CSP_NOTIFICATIONS |
Holds parts loop notifications | satellite-leaning |
CSP_SUPPLY_CHAIN |
Supply Chain details | satellite-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
CSP_TRANSACTIONS_PUB |
PUB | 15 | 12 packages |
CSP_VALIDATE_PUB |
PUB | 6 | 4 packages |
CSP_REPAIR_PO_GRP |
GRP | 5 | 4 packages |
CSP_REQUIREMENT_LINES_PUB |
PUB | 3 | 2 packages |
CSP_ORDERLINES_PUB |
PUB | 4 | 1 packages |
CSP_PICK_SERIAL_LOTS_PUB |
PUB | 4 | 1 packages |
CSP_TASK_PART_PUB |
PUB | 4 | 1 packages |
CSP_PACKLIST_LINES_PUB |
PUB | 4 | 1 packages |
CSP_PACKLIST_HEADERS_PUB |
PUB | 4 | 1 packages |
CSP_RS_CUST_RELATION_PUB |
PUB | 4 | 1 packages |