CRP — Capacity
11 documented tables · 12 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
CRP_BILLS_OF_RESOURCES |
Bill of resource sets | hub-leaning |
CRP_BILL_OF_RESOURCE_ITEMS |
Items in a bill of resource set | satellite-leaning |
CRP_CAL_SHIFT_DELTA |
Deltas between the primary calendar and shift calendars | link |
CRP_RESOURCE_PLAN |
Capacity resource plan | satellite-leaning |
CRP_RESOURCE_HOURS |
Results of the rollup for rough cut capacity | link |
CRP_FORM_QUERY |
Generic query table for inquiry forms | standalone |
CRP_PLANNED_RESOURCES |
List of resources planned in the CRP run | link |
CRP_SIMULATION_SETS |
Simulation set names | standalone |
CRP_DISPLAY_OPTIONS |
User interface setup information for CRP forms | standalone |
CRP_CAPACITY_PLANS |
Bucketed resource availability and requirement information | standalone |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.