eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: AHL_UNIT_EFFECTIVITIES_B

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This table stores the applicable maintenance requirements for all units and their components.
Implementation/DBA Data:	AHL.AHL_UNIT_EFFECTIVITIES_B

Primary Key: AHL_UNIT_EFFECTIVITIES_B_UK1

LOG_SERIES_NUMBER

Primary Key: UNIT_EFFECTIVITY_ID

UNIT_EFFECTIVITY_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
AHL_UNIT_EFFECTIVITIES_B	CSI_ITEM_INSTANCES	AHL_UNIT_EFFECTIVITIES_B.CSI_ITEM_INSTANCE_ID
AHL_UNIT_EFFECTIVITIES_B	AHL_UNIT_EFFECTIVITIES_B	AHL_UNIT_EFFECTIVITIES_B.DEFER_FROM_UE_ID
AHL_UNIT_EFFECTIVITIES_B	AHL_UNIT_EFFECTIVITIES_B	AHL_UNIT_EFFECTIVITIES_B.ORIG_DEFERRAL_UE_ID
AHL_UNIT_EFFECTIVITIES_B	AHL_UNIT_EFFECTIVITIES_B	AHL_UNIT_EFFECTIVITIES_B.PRECEDING_UE_ID
AHL_UNIT_EFFECTIVITIES_B	AHL_MC_PATH_POSITIONS	AHL_UNIT_EFFECTIVITIES_B.POSITION_PATH_ID
AHL_UNIT_EFFECTIVITIES_B	HR_ALL_ORGANIZATION_UNITS	AHL_UNIT_EFFECTIVITIES_B.CLEAR_STATION_ORG_ID
AHL_UNIT_EFFECTIVITIES_B	BOM_DEPARTMENTS	AHL_UNIT_EFFECTIVITIES_B.CLEAR_STATION_DEPT_ID
AHL_UNIT_EFFECTIVITIES_B	AHL_UNIT_CONFIG_HEADERS	AHL_UNIT_EFFECTIVITIES_B.UNIT_CONFIG_HEADER_ID
AHL_UNIT_EFFECTIVITIES_B	AHL_MR_HEADERS_B	AHL_UNIT_EFFECTIVITIES_B.MR_HEADER_ID
AHL_UNIT_EFFECTIVITIES_B	AHL_MR_INTERVALS	AHL_UNIT_EFFECTIVITIES_B.MR_INTERVAL_ID
AHL_UNIT_EFFECTIVITIES_B	AHL_MR_HEADERS_B	AHL_UNIT_EFFECTIVITIES_B.PROGRAM_MR_HEADER_ID
AHL_UNIT_EFFECTIVITIES_B	OKC_K_LINES_B	AHL_UNIT_EFFECTIVITIES_B.SERVICE_LINE_ID
AHL_UNIT_EFFECTIVITIES_B	AHL_MR_EFFECTIVITIES	AHL_UNIT_EFFECTIVITIES_B.MR_EFFECTIVITY_ID
AHL_UNIT_EFFECTIVITIES_B	CS_INCIDENTS_ALL_B	AHL_UNIT_EFFECTIVITIES_B.CS_INCIDENT_ID
AHL_UNIT_EFFECTIVITIES_B	AHL_MR_HEADERS_B	AHL_UNIT_EFFECTIVITIES_B.PROGRAM_MR_HEADER_ID
AHL_UNIT_EFFECTIVITIES_B	CS_COUNTERS	AHL_UNIT_EFFECTIVITIES_B.COUNTER_ID
AHL_SCHEDULE_MATERIALS	AHL_UNIT_EFFECTIVITIES_B	AHL_SCHEDULE_MATERIALS.UNIT_EFFECTIVITY_ID
AHL_UE_RELATIONSHIPS	AHL_UNIT_EFFECTIVITIES_B	AHL_UE_RELATIONSHIPS.UE_ID
AHL_UE_RELATIONSHIPS	AHL_UNIT_EFFECTIVITIES_B	AHL_UE_RELATIONSHIPS.RELATED_UE_ID
AHL_UNIT_ACCOMPLISHMNTS	AHL_UNIT_EFFECTIVITIES_B	AHL_UNIT_ACCOMPLISHMNTS.UNIT_EFFECTIVITY_ID
AHL_UNIT_DEFERRALS_B	AHL_UNIT_EFFECTIVITIES_B	AHL_UNIT_DEFERRALS_B.UNIT_EFFECTIVITY_ID
AHL_UNIT_EFFECTIVITIES_B	AHL_UNIT_EFFECTIVITIES_B	AHL_UNIT_EFFECTIVITIES_B.DEFER_FROM_UE_ID
AHL_UNIT_EFFECTIVITIES_B	AHL_UNIT_EFFECTIVITIES_B	AHL_UNIT_EFFECTIVITIES_B.ORIG_DEFERRAL_UE_ID
AHL_UNIT_EFFECTIVITIES_B	AHL_UNIT_EFFECTIVITIES_B	AHL_UNIT_EFFECTIVITIES_B.PRECEDING_UE_ID
AHL_UNIT_EFFECTIVITIES_TL	AHL_UNIT_EFFECTIVITIES_B	AHL_UNIT_EFFECTIVITIES_TL.UNIT_EFFECTIVITY_ID
AHL_VISIT_TASKS_B	AHL_UNIT_EFFECTIVITIES_B	AHL_VISIT_TASKS_B.UNIT_EFFECTIVITY_ID