Table: AHL_ROUTE_EFFECTIVITIES

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This table stores the Route Effectivity Attributes.
Implementation/DBA Data:	AHL.AHL_ROUTE_EFFECTIVITIES

Primary Key: AHL_ROUTE_EFFECTIVITIES_PK

1. ROUTE_EFFECTIVITY_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
AHL_ROUTE_EFFECTIVITIES		AHL_ROUTES_B	AHL_ROUTE_EFFECTIVITIES.ROUTE_ID
AHL_ROUTE_EFFECTIVITIES		MTL_SYSTEM_ITEMS_B	AHL_ROUTE_EFFECTIVITIES.INVENTORY_ITEM_ID AHL_ROUTE_EFFECTIVITIES.INVENTORY_MASTER_ORG_ID
AHL_ROUTE_EFFECTIVITIES		AHL_MC_HEADERS_B	AHL_ROUTE_EFFECTIVITIES.MC_HEADER_ID
AHL_RT_OPER_MATERIALS		AHL_ROUTE_EFFECTIVITIES	AHL_RT_OPER_MATERIALS.OBJECT_ID