Table: AHL_MR_HEADERS_B

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This table stores the maintenance requirement header information.
Implementation/DBA Data:	AHL.AHL_MR_HEADERS_B

Primary Key: AHL_MR_HEADERS_B_PK

1. MR_HEADER_ID

Primary Key: AHL_MR_HEADERS_B_UK1

1. TITLE
2. VERSION_NUMBER
3. APPLICATION_USG_CODE

Foreign Keys

Table		Foreign Table	Foreign Key Column
AHL_MR_HEADERS_B		AHL_MR_HEADERS_B	AHL_MR_HEADERS_B.PRECEDING_MR_HEADER_ID
AHL_MR_HEADERS_B		%	AHL_MR_HEADERS_B.WARRANTY_TEMPLATE_ID
AHL_MEL_CDL_MO_PROCEDURES		AHL_MR_HEADERS_B	AHL_MEL_CDL_MO_PROCEDURES.MR_HEADER_ID
AHL_MR_ACTIONS_B		AHL_MR_HEADERS_B	AHL_MR_ACTIONS_B.MR_HEADER_ID
AHL_MR_EFFECTIVITIES		AHL_MR_HEADERS_B	AHL_MR_EFFECTIVITIES.MR_HEADER_ID
AHL_MR_HEADERS_B		AHL_MR_HEADERS_B	AHL_MR_HEADERS_B.PRECEDING_MR_HEADER_ID
AHL_MR_HEADERS_TL		AHL_MR_HEADERS_B	AHL_MR_HEADERS_TL.MR_HEADER_ID
AHL_MR_RELATIONSHIPS		AHL_MR_HEADERS_B	AHL_MR_RELATIONSHIPS.MR_HEADER_ID
AHL_MR_RELATIONSHIPS		AHL_MR_HEADERS_B	AHL_MR_RELATIONSHIPS.RELATED_MR_HEADER_ID
AHL_MR_ROUTES		AHL_MR_HEADERS_B	AHL_MR_ROUTES.MR_HEADER_ID
AHL_SNAPSHOTS		AHL_MR_HEADERS_B	AHL_SNAPSHOTS.MR_ID
AHL_UNIT_EFFECTIVITIES_B		AHL_MR_HEADERS_B	AHL_UNIT_EFFECTIVITIES_B.MR_HEADER_ID
AHL_UNIT_EFFECTIVITIES_B		AHL_MR_HEADERS_B	AHL_UNIT_EFFECTIVITIES_B.PROGRAM_MR_HEADER_ID
AHL_UNIT_EFFECTIVITIES_B		AHL_MR_HEADERS_B	AHL_UNIT_EFFECTIVITIES_B.PROGRAM_MR_HEADER_ID
AHL_VISIT_TASKS_B		AHL_MR_HEADERS_B	AHL_VISIT_TASKS_B.MR_ID