AHL — Complex Maintenance Repair and Overhaul
212 documented tables · 153 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
AHL_MR_HEADERS_B |
This table stores the maintenance requirement header information. | hub |
AHL_OPERATIONS_B |
This Table stores the Standard and Non Standard Operations. | hub |
AHL_ROUTES_B |
This table stores the Route attributes. | hub |
AHL_MC_HEADERS_B |
Stores Master Configuration Header details | hub |
AHL_ITEM_GROUPS_B |
This table stores information about item groups. Items are grouped so that each group could be used in posit | hub |
AHL_UNIT_CONFIG_HEADERS |
Unit Configuration represents a complex equipment. A unit configuration is constructed from a master configura | hub |
AHL_UNIT_EFFECTIVITIES_B |
This table stores the applicable maintenance requirements for all units and their components. | hub |
AHL_VISITS_B |
This table stores information about visits | hub |
AHL_PC_HEADERS_B |
This table stores information about Product Classification header. | hub-leaning |
AHL_PC_NODES_B |
Product Classification Node Table | hub |
AHL_DOCUMENTS_B |
This table stores information about documents. | hub |
AHL_WARRANTY_TEMPLATES_B |
Table contains Warranty Template definitions | hub-leaning |
AHL_SPACES_B |
This table stores information about spaces | hub-leaning |
AHL_VISIT_TASKS_B |
This table stores information about visit tasks | hub |
AHL_WORKORDERS |
Ahl Production Workorder Information stored in this table | hub |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
AHL_DEBUG_PUB |
PUB | 5 | 122 packages |
AHL_UC_VALIDATION_PUB |
PUB | 3 | 16 packages |
AHL_DI_ASSO_DOC_GEN_PUB |
PUB | 1 | 8 packages |
AHL_LTP_MATRL_AVAL_PUB |
PUB | 5 | 5 packages |
AHL_OSP_SHIPMENT_PUB |
PUB | 10 | 5 packages |
AHL_UA_FLIGHT_SCHEDULES_PUB |
PUB | 3 | 4 packages |
AHL_LTP_SPACE_ASSIGN_PUB |
PUB | 3 | 3 packages |
AHL_PRD_WO_PUB |
PUB | 10 | 3 packages |
AHL_PC_ASSOCIATION_PUB |
PUB | 2 | 3 packages |
AHL_PC_HEADER_PUB |
PUB | 1 | 3 packages |