CSD — Depot Repair
105 documented tables · 85 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
CSD_REPAIRS |
This table holds all the repair orders. | hub |
CSD_REPAIR_TYPES_B |
This table stores all the repair types. | hub |
CSD_REPAIR_ORDER_GROUPS |
Stores Repair Order groups. Each group translates into one or more repair order lines. | satellite-leaning |
CSD_BULLETINS_B |
Base table for service bulletins | hub-leaning |
CSD_RULES_B |
Base table for Defaulting Rules | hub-leaning |
CSD_SERVICE_CODES_B |
This table stores all service codes. | hub-leaning |
CSD_REPAIR_ACTUALS |
Stores Repair Actuals header information. | satellite-leaning |
CSD_REPAIR_ESTIMATE |
Header for estimate lines of a repair order. | satellite-leaning |
CSD_RECALL_PARAMETERS |
Recall parameters setup table | standalone |
CSD_TASKS |
Transaction table for Task-QA integration. | standalone |
CSD_MTL_DISPOSITION_REASONS |
Material Transaction Disposition Reasons | standalone |
CSD_MRO_SERIAL_NUMBERS |
Stores serial numbers for the items in a repair order group. | link |
CSD_RECALL_STATUSES_B |
The setup table for holding all the different recall flow statuses. | standalone |
CSD_MASS_RO_SN_ERRORS |
Obsoleted table. | standalone |
CSD_REGION_GEOGRAPHIES |
Region Geographies table | standalone |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
CSD_REPAIRS_PUB |
PUB | 4 | 19 packages |
CSD_REFURBISH_IRO_GRP |
GRP | 2 | 2 packages |
CSD_REPAIRS_GRP |
GRP | 6 | 2 packages |
CSD_REPAIR_ESTIMATE_PUB |
PUB | 4 | 2 packages |
CSD_LOGISTICS_PUB |
PUB | 3 | 2 packages |