Table: AHL_RT_OPER_MATERIALS

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This table stores the material and tool requirements for a Route or an Operation.
Implementation/DBA Data:	AHL.AHL_RT_OPER_MATERIALS

Primary Key: AHL_RT_OPER_MATERIALS_PK

1. RT_OPER_MATERIAL_ID

Primary Key: AHL_RT_OPER_MATERIALS_UK1

1. OBJECT_ID
2. INVENTORY_ITEM_ID
3. INVENTORY_ORG_ID
4. POSITION_PATH_ID
5. ASSOCIATION_TYPE_CODE

Foreign Keys

Table		Foreign Table	Foreign Key Column
AHL_RT_OPER_MATERIALS		MTL_SYSTEM_ITEMS_B	AHL_RT_OPER_MATERIALS.INVENTORY_ITEM_ID AHL_RT_OPER_MATERIALS.INVENTORY_ORG_ID
AHL_RT_OPER_MATERIALS		AHL_ROUTES_B	AHL_RT_OPER_MATERIALS.OBJECT_ID
AHL_RT_OPER_MATERIALS		AHL_OPERATIONS_B	AHL_RT_OPER_MATERIALS.OBJECT_ID
AHL_RT_OPER_MATERIALS		AHL_ITEM_GROUPS_B	AHL_RT_OPER_MATERIALS.ITEM_GROUP_ID
AHL_RT_OPER_MATERIALS		AHL_MC_PATH_POSITIONS	AHL_RT_OPER_MATERIALS.POSITION_PATH_ID
AHL_RT_OPER_MATERIALS		AHL_ITEM_COMPOSITIONS	AHL_RT_OPER_MATERIALS.ITEM_COMP_DETAIL_ID
AHL_RT_OPER_MATERIALS_H		AHL_RT_OPER_MATERIALS	AHL_RT_OPER_MATERIALS_H.RT_OPER_MATERIAL_ID