AHL Tables (212)

AHL - Complex Maintenance Repair and Overhaul — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

TableColumnsDescription
AHL_ALTERNATE_RESOURCES 27 This table stores the alternate ASO resources for the resource requirements.
AHL_APPLICABLE_INSTANCES 2
AHL_APPLICABLE_MRS 17
AHL_APPLICABLE_MRS1 26
AHL_APPROVAL_API 15 This table stores information about apis for approval rules
AHL_APPROVAL_RULES_B 34 This table stores information about approval rules
AHL_APPROVAL_RULES_TL 12 This table stores information about translated columns for approval rules
AHL_APPROVERS 29 This table stores information about approvers
AHL_AUTOVISIT_HIERARCHY 31
AHL_AUTOVST_SNPSHT_HDR 31
AHL_BUE_WORKER_DATA 11 Table contains data that needs to be processed by BUE worker programs. Data is populated into this table by BUE concurrent program. This tab
AHL_BUILD_GOALS 27
AHL_CONFIG_COMPONENTS 3
AHL_CONFIG_COMPONENTS1 4
AHL_CTR_UPDATE_RULES 28 This table will store rules to update counters for a position with respect to its parent position.
AHL_DEPARTMENT_SHIFTS 32 This table stores information about department shifts
AHL_DEPT_RESOURCE_CAPACITY 16
AHL_DOCUMENTS_B 32 This table stores information about documents.
AHL_DOCUMENTS_TL 10 This table stores the translated column information for document.
AHL_DOCUMENT_SUB_TYPES 26 This table stores association information between document types and document sub types.
AHL_DOC_FILE_ASSOC_B 28 This table stores files association with document. As a part of 11.5.10 Enhancements
AHL_DOC_FILE_ASSOC_TL 10 This table stores the translated values for AHL_DOC_FILE_ASSOC_B
AHL_DOC_REVISIONS_B 42 This table stores revision information of a document.
AHL_DOC_REVISIONS_TL 10 This table stores the translated column information of a document revision.
AHL_DOC_REVISION_COPIES 29 Table is Obsolete.This table stores persons who received copies of document revision.
AHL_DOC_TITLE_ASSOS_B 31 This table stores association between document or document revision and ASO object (ASO object could be a route, master configuration, unit
AHL_DOC_TITLE_ASSOS_TL 15 This table stores the translated columns information for the association between document or document revision and ASO object.
AHL_ENIGMA_JCG_DETAILS 16 JCG details
AHL_ENIGMA_OP_INTERFACE 17
AHL_ENIGMA_PROCESS_LOG 13
AHL_ENIGMA_RT_INTERFACE 12
AHL_EVENT_ASSOCIATIONS 26 This table is an intersection table to store the association between events and positions.
AHL_FLEET_DOWNTIMES 12
AHL_FLEET_HEADERS_B 30
AHL_FLEET_HEADERS_TL 10
AHL_FLEET_RECONFIG_MRS 12
AHL_FLEET_UNIT_ASSOCS 14
AHL_FLEET_UTILIZATION 36
AHL_FLEET_UTLZN_FORECAST 29
AHL_INV_SERVICE_ITEM_RELS 30 This table stores the relationships between physical inventory items and service items.
AHL_ITEM_ASSOCIATIONS_B 34 This table is an intersection table to store the association between item group and the inventory item.
AHL_ITEM_ASSOCIATIONS_B_H 38 This table is Histrory of the Item Group Assoications
AHL_ITEM_ASSOCIATIONS_TL 10 This table is an intersection table to store the association between item group and the inventory item.
AHL_ITEM_ASSOCIATIONS_TL_H 10 History table for the Association Table
AHL_ITEM_COMPOSITIONS 31 This table stores information about item compositions header .
AHL_ITEM_COMP_DETAILS 32 This table stores the details of Non-Tracked Items/ Item Groups associated with a Item Composition in the header table.
AHL_ITEM_GROUPS_B 29 This table stores information about item groups. Items are grouped so that each group could be used in positions multiple times.
AHL_ITEM_GROUPS_B_H 32 This table stores History about item groups.
AHL_ITEM_GROUPS_TL 10 This table stores translated information about item groups.
AHL_ITEM_GROUPS_TL_H 10 This table stores translated information about item group History.
AHL_ITEM_VENDOR_RELS 30 This table stores the relationships between the relationships of physical inventory items and service items and certified vendors.
AHL_MC_CONFIG_RELATIONS 29 This table maps sub configuration with Parent Master Configurations
AHL_MC_HEADERS_B 31 Stores Master Configuration Header details
AHL_MC_HEADERS_TL 10 This table stores translatable Master Configuration header information
AHL_MC_PATH_POSITIONS 28 Stores multi-level MC Positions
AHL_MC_PATH_POSITION_NODES 29 Stores Path Positions nodes
AHL_MC_RELATIONSHIPS 37 This table stores MC Node information .It is result of denormalization of AHL_RELATIONSHIP_B and TL.
AHL_MC_RULES_B 29 Stores MC Rules
AHL_MC_RULES_TL 10 Translation table for MC Rules
AHL_MC_RULE_STATEMENTS 37 Stores Rule Statements
AHL_MEL_CDL_ATA_SEQUENCES 29 This table stores information about ATA codes (System Sequnces) associated to the MEL/CDL.
AHL_MEL_CDL_HEADERS 31 This table stores MEL / CDL header information associated with Product Classification node.
AHL_MEL_CDL_MO_PROCEDURES 26 This table stores association of M&O procedures (Maintenance Requirements of program_type MO_PROC) with ATA sequences.
AHL_MEL_CDL_RELATIONSHIPS 26 This table stores relationships between a pair of ATA sequences across the same MEL/CDL
AHL_MM_TXN_INTERFACE 9
AHL_MR_ACTIONS_B 27 This table stores the actions associated with each maintenance requirement.
AHL_MR_ACTIONS_TL 10 Translation table for maintenance requirement and action association.
AHL_MR_EFFECTIVITIES 35 This table stores the effectivity of maintenance requirement.
AHL_MR_EFFECTIVITY_DTLS 32 This table stores the item instance level details of the maintenance requirement.
AHL_MR_EFFECTIVITY_EXT_DTLS 31 Table to store extended effectivity details
AHL_MR_HEADERS_B 55 This table stores the maintenance requirement header information.
AHL_MR_HEADERS_TL 11 Translation table for maintenance requirement header.
AHL_MR_INTERVALS 36 This table stores the details of the frequency at whcih the maintenance requirement would be performed.
AHL_MR_ORGANIZATIONS 28
AHL_MR_RELATIONSHIPS 27 This table stores the parent/child relationships of maintenance requirements.
AHL_MR_ROUTES 28 This table stores the associations of maintenance requirements to routes.
AHL_MR_ROUTE_SEQUENCES 27 This table stores the sequencing of routes attached to a maintenance requirement.
AHL_MR_VISIT_TYPES 26 Ahl mr visit types Table
AHL_NR_PROFILE_DETAILS 20
AHL_NR_PROFILE_HEADERS 28
AHL_OPERATIONS_B 70 This Table stores the Standard and Non Standard Operations.
AHL_OPERATIONS_H_B 53 History table for AHL_OPERATIONS_B.
AHL_OPERATIONS_H_TL 12 This table stores the translated Operation history attributes.
AHL_OPERATIONS_TL 14 This table stores the translated Operation attributes.
AHL_OPERATION_PHASES 27 This table stores the significant phases in an Operation.
AHL_OPERATION_PHASES_H 28 History table for AHL_OPERATION_PHASES.
AHL_OPERATION_RESOURCES 32 This table stores information about job operation resources
AHL_OPER_VST_AUTOCREATE 34
AHL_OSP_ORDERS_B 44 This table stores the osp order header information.
AHL_OSP_ORDERS_TL 10 Translatable Table for AHL_OSP_ORDERS_B
AHL_OSP_ORDER_LINES 48 Table to store order lines
AHL_OSP_ORDER_LOGS 32 This table stores the log for OSP order transactions
AHL_PART_CHANGES 41 Table to store part change transaction details.
AHL_PC_ASSOCIATIONS 32 This table stores information about Product Classification Node Association with Unit or Part.
AHL_PC_HEADERS_B 31 This table stores information about Product Classification header.
AHL_PC_HEADERS_TL 10 Translation table for AHL_PC_HEADERS_B.
AHL_PC_NODES_B 31 Product Classification Node Table
AHL_PC_NODES_TL 10 Translation table for AHL_PC_NODES_B.
AHL_PLANNING_FACTORS 35
AHL_PRD_DISPOSITIONS_B 44 Store information about workorders's disposiiton
AHL_PRD_DISPOSITIONS_B_H 45 Store disposition history
AHL_PRD_DISPOSITIONS_TL 10 Stores disposition translatable columns
AHL_PRD_DISPOSITIONS_TL_H 11 Stores disposition history's translatable columns
AHL_PRD_DISP_MTL_TXNS 28 This table stores the relationship between dispositions and material transactions.
AHL_PRD_MB_UC_DETAILS 26
AHL_PRODTYPE_ZONES 29 This table stores the association between product type, zone and sub zone.
AHL_PROG_TYPE_SUBTYPES 26 This table stores the association between program type sand subtypes.
AHL_RA_CTR_ASSOCIATIONS 27 This Table stores information about counter association.
AHL_RA_DEFINITION_DTLS 27 This Setup Table stores Reliability definition details.
AHL_RA_DEFINITION_HDR 29 This Setup Table stores Reliability definition Header info.
AHL_RA_FCT_ASSOCIATIONS 29 This Table stores Reliability Forecast association (Forecast designator of MRP/IO) for setup (MTBF) data and Historical data.
AHL_RA_SETUPS 27 This Table stores Reliability Setup info.
AHL_RECIPIENT_DOCUMENTS 26 This table stores information about recipients who received the document.
AHL_RELATIONSHIPS_B 39 This table is obsoleted tabled from 11.5.10 .. This table stores the position hierarchy of the master configuration.
AHL_RELATIONSHIPS_TL 10 This table is obsoleted tabled from 11.5.10 .. This table stores the translated position hierarchy information of the master configuration.
AHL_REPAIR_CATEGORIES 26 This table stores repair categories from CS_INCIDENT_URGENCIES_B with their repair time limits (in hours).
AHL_REQ_SUPPLY_SCHEDULE 30
AHL_RESOURCES 28 This table stores the ASO resource, which can be related to HR's skill type, skill lvevl and certifiaction.
AHL_RESOURCE_MAPPINGS 28 This table stores the mapping between ASO resource and BOM resource.
AHL_RESOURCE_SKILLS 28 This table stores the relationship between the ASO resource and HR's skill type, skill lvevl and certifiaction. It should be obsolete for ne
AHL_ROUTES_B 82 This table stores the Route attributes.
AHL_ROUTES_H_B 44 History table for AHL_ROUTES_B.
AHL_ROUTES_H_TL 11 This table stores the translated Route history attributes.
AHL_ROUTES_TL 13 This table stores the translated Route attributes.
AHL_ROUTE_EFFECTIVITIES 29 This table stores the Route Effectivity Attributes.
AHL_ROUTE_OPERATIONS 31 This table stores the association between Routes and Operations.
AHL_ROUTE_OPERATIONS_H 32 History table for AHL_ROUTE_OPERATIONS.
AHL_RT_OPER_ACCESS_PANELS 27 This table stores the access panels associated with a Route or an Operation.
AHL_RT_OPER_DEPENDENCIES 29
AHL_RT_OPER_INTERFACE 13
AHL_RT_OPER_LABOR 35 This table stores the labor requirements for a Route or an Operation.
AHL_RT_OPER_LABOR_H 36 History table for AHL_RT_OPER_LABOR.
AHL_RT_OPER_MATERIALS 43 This table stores the material and tool requirements for a Route or an Operation.
AHL_RT_OPER_MATERIALS_H 35 History table for AHL_RT_OPER_MATERIALS.
AHL_RT_OPER_RESOURCES 38 This table stores the resource requirements for a Route or an Operation.
AHL_SB_POSITION_RULES 31
AHL_SB_RULE_ITEMS 28
AHL_SCHEDULE_MATERIALS 58 This table stores information about materials scheduled in MRP
AHL_SIMULATION_PLANS_B 29 This table stores information about simulation plans
AHL_SIMULATION_PLANS_TL 12 This table stores information about translated columns for simulation plans
AHL_SNAPSHOTS 32 This table stores information about SnapShots.
AHL_SPACES_B 28 This table stores information about spaces
AHL_SPACES_TL 10 This table stores information about translated columns for spaces
AHL_SPACE_ASSIGNMENTS 28 This table stores information about space assignments
AHL_SPACE_CAPABILITIES 28 This table stores information about space capabilities
AHL_SPACE_UNAVAILABLE_B 27 This table stores information about space restrictions
AHL_SPACE_UNAVAILABLE_TL 10 This table stores information about space restrictions(Translation Table)
AHL_STAGE_LINKS 27
AHL_STATUS_ORDER_RULES 12 This table stores status order rules for any aso object
AHL_SUBSCRIPTIONS_B 35 This table stores information about subscriptions for documents.
AHL_SUBSCRIPTIONS_TL 10 This table stores the translated columns of subscription information for a document.
AHL_SUPPLIER_DOCUMENTS 27 This table stores supplier information for documents.
AHL_TASK_LINKS 31 This table stores information about task links between different ahl tasks
AHL_TEMP_UNIT_EFFECTIVITIES1 34
AHL_UC_DETAILS_FOR_HGRID 72
AHL_UC_HEADERS_H 33 History table of ahl_unit_config_headers. To keep the changes of each unit configuration.
AHL_UE_RELATIONSHIPS 28 This table stores information about the relationships between unit effectivities.
AHL_UE_SIMULATIONS 33
AHL_UF_DETAILS 29 This table stores information about unit forcast details
AHL_UF_HEADERS 30 This table stores information about utilization forecast header.
AHL_UMP_MAINT_REQMNTS 32
AHL_UMP_MATERIAL_REQMNTS 29
AHL_UMP_RESOURCE_REQMNTS 31
AHL_UNIT_ACCOMPLISHMNTS 27 This table will contain all instances counter values at the time of accomplishment.
AHL_UNIT_CONFIG_HEADERS 32 Unit Configuration represents a complex equipment. A unit configuration is constructed from a master configuration template. This table stor
AHL_UNIT_DEFERRALS_B 35 This table holds the deferral and MR initialization information for a unit effectivity.
AHL_UNIT_DEFERRALS_TL 11 Translation table for AHL_UNIT_DEFFRALS_B
AHL_UNIT_EFFECTIVITIES_B 68 This table stores the applicable maintenance requirements for all units and their components.
AHL_UNIT_EFFECTIVITIES_TL 10 Translate table that for unit effectivities
AHL_UNIT_SCHEDULES 41 Event describing usage of a configured unit for a specific time period, such as an airplane flight.
AHL_UNIT_THRESHOLDS 29 This will store the item instance's threshold values, i.e Due at counter values, provided by Production or in cases where previous accompli
AHL_USER_STATUSES_B 31 This table stores user status information
AHL_USER_STATUSES_TL 10 This table stores translated information for user statuses
AHL_VENDOR_CERTIFICATIONS 29 This table stores the vendors that can perform services during outside processing.
AHL_VENDOR_CUSTOMER_RELS 26 This table stores the association between vendor, vendor location and customer, customer location for use during outside processing.
AHL_VISITS_B 63 This table stores information about visits
AHL_VISITS_TL 11 This table stores information about translated columns for a visit
AHL_VISIT_INST_ROUTINGS 27
AHL_VISIT_IR_UC_DETAILS 44
AHL_VISIT_STAGE_TYP_ASOC 25
AHL_VISIT_TASKS_B 61 This table stores information about visit tasks
AHL_VISIT_TASKS_TL 11 This table stores information about translated columns for visit tasks
AHL_VISIT_TYPES_B 32
AHL_VISIT_TYPES_TL 10
AHL_VISIT_TYPE_STAGES_B 27
AHL_VISIT_TYPE_STAGES_TL 10
AHL_VST_TYP_STAGE_LINKS 27
AHL_VST_TYP_STG_TYP_ASOC 25
AHL_VWP_STAGES_B 32 This table stores information about stages
AHL_VWP_STAGES_TL 10 This table stores information about translated columns for stages
AHL_WARRANTY_CLAIMS_B 54 This table stores information of a Supplier Warranty Claim
AHL_WARRANTY_CLAIMS_TL 11 This table stores the translated column information of a document revision.
AHL_WARRANTY_CONTRACTS_B 40 Table to store Contract records
AHL_WARRANTY_CONTRACTS_TL 14
AHL_WARRANTY_CONT_CTR_B 29
AHL_WARRANTY_CONT_CTR_TL 13
AHL_WARRANTY_ENTITLEMENTS 36
AHL_WARRANTY_TEMPLATES_B 36 Table contains Warranty Template definitions
AHL_WARRANTY_TEMPLATES_TL 14 Table to hold warranty template translated attibutes
AHL_WARRANTY_TMPL_CTR_B 27 Table holds warranty template counter definitions
AHL_WARRANTY_TMPL_CTR_TL 13 Table to store translated information for the warranty template counter.
AHL_WARRANTY_TMPL_ITEMS 30 Table to store items association to warranty template.
AHL_WBS_RULES 34
AHL_WF_MAPPING 13 This table stores information about workflow process mapping for differnet AHL objects
AHL_WORKORDERS 43 Ahl Production Workorder Information stored in this table
AHL_WORKORDER_MTL_TXNS 44 This table stores the material transactions that were issued against a job.
AHL_WORKORDER_OPERATIONS 33 Stores AHL Workorder Operation Information
AHL_WORKORDER_TXNS 43 Ahl Production Workorder Transaction Information stored in this table
AHL_WORK_ASSIGNMENTS 32 This table stores the workorder assigments
AHL_WORK_LOGIN_TIMES 32 This table stores employee login/logout times into a operation-resource.
AHL_WO_OPERATIONS_RELN 33
AHL_WO_OPERATIONS_TXNS 53 Ahl Production Workorder Operations Information stored in this table