Table: AHL_MR_EFFECTIVITIES

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This table stores the effectivity of maintenance requirement.
Implementation/DBA Data:	AHL.AHL_MR_EFFECTIVITIES

Primary Key: AHL_MR_EFFECTIVITIES_PK

1. MR_EFFECTIVITY_ID

Primary Key: AHL_MR_EFFECTIVITIES_UK1

1. NAME
2. MR_HEADER_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
AHL_MR_EFFECTIVITIES		AHL_MR_HEADERS_B	AHL_MR_EFFECTIVITIES.MR_HEADER_ID
AHL_MR_EFFECTIVITIES		AHL_MC_PATH_POSITIONS	AHL_MR_EFFECTIVITIES.RELATIONSHIP_ID
AHL_MR_EFFECTIVITIES		MTL_SYSTEM_ITEMS_B	AHL_MR_EFFECTIVITIES.INVENTORY_ITEM_ID AHL_MR_EFFECTIVITIES.INVENTORY_ORG_ID
AHL_MR_EFFECTIVITIES		AHL_PC_NODES_B	AHL_MR_EFFECTIVITIES.PC_NODE_ID
AHL_MR_EFFECTIVITY_DTLS		AHL_MR_EFFECTIVITIES	AHL_MR_EFFECTIVITY_DTLS.MR_EFFECTIVITY_ID
AHL_MR_EFFECTIVITY_EXT_DTLS		AHL_MR_EFFECTIVITIES	AHL_MR_EFFECTIVITY_EXT_DTLS.MR_EFFECTIVITY_ID
AHL_MR_INTERVALS		AHL_MR_EFFECTIVITIES	AHL_MR_INTERVALS.MR_EFFECTIVITY_ID
AHL_UNIT_EFFECTIVITIES_B		AHL_MR_EFFECTIVITIES	AHL_UNIT_EFFECTIVITIES_B.MR_EFFECTIVITY_ID