FND Design Data [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: TableAHL.AHL_UNIT_EFFECTIVITIES_B
Primary Key: AHL_UNIT_EFFECTIVITIES_B_UK1
  1. ColumnLOG_SERIES_NUMBER
Primary Key: UNIT_EFFECTIVITY_ID
  1. ColumnUNIT_EFFECTIVITY_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AHL_UNIT_EFFECTIVITIES_B FK Joins to TableCSI_ITEM_INSTANCES AHL_UNIT_EFFECTIVITIES_B.CSI_ITEM_INSTANCE_ID
AHL_UNIT_EFFECTIVITIES_B FK Joins to TableAHL_UNIT_EFFECTIVITIES_B AHL_UNIT_EFFECTIVITIES_B.DEFER_FROM_UE_ID
AHL_UNIT_EFFECTIVITIES_B FK Joins to TableAHL_UNIT_EFFECTIVITIES_B AHL_UNIT_EFFECTIVITIES_B.ORIG_DEFERRAL_UE_ID
AHL_UNIT_EFFECTIVITIES_B FK Joins to TableAHL_UNIT_EFFECTIVITIES_B AHL_UNIT_EFFECTIVITIES_B.PRECEDING_UE_ID
AHL_UNIT_EFFECTIVITIES_B FK Joins to TableAHL_MC_PATH_POSITIONS AHL_UNIT_EFFECTIVITIES_B.POSITION_PATH_ID
AHL_UNIT_EFFECTIVITIES_B FK Joins to TableHR_ALL_ORGANIZATION_UNITS AHL_UNIT_EFFECTIVITIES_B.CLEAR_STATION_ORG_ID
AHL_UNIT_EFFECTIVITIES_B FK Joins to TableBOM_DEPARTMENTS AHL_UNIT_EFFECTIVITIES_B.CLEAR_STATION_DEPT_ID
AHL_UNIT_EFFECTIVITIES_B FK Joins to TableAHL_UNIT_CONFIG_HEADERS AHL_UNIT_EFFECTIVITIES_B.UNIT_CONFIG_HEADER_ID
AHL_UNIT_EFFECTIVITIES_B FK Joins to TableAHL_MR_HEADERS_B AHL_UNIT_EFFECTIVITIES_B.MR_HEADER_ID
AHL_UNIT_EFFECTIVITIES_B FK Joins to TableAHL_MR_INTERVALS AHL_UNIT_EFFECTIVITIES_B.MR_INTERVAL_ID
AHL_UNIT_EFFECTIVITIES_B FK Joins to TableAHL_MR_HEADERS_B AHL_UNIT_EFFECTIVITIES_B.PROGRAM_MR_HEADER_ID
AHL_UNIT_EFFECTIVITIES_B FK Joins to TableOKC_K_LINES_B AHL_UNIT_EFFECTIVITIES_B.SERVICE_LINE_ID
AHL_UNIT_EFFECTIVITIES_B FK Joins to TableAHL_MR_EFFECTIVITIES AHL_UNIT_EFFECTIVITIES_B.MR_EFFECTIVITY_ID
AHL_UNIT_EFFECTIVITIES_B FK Joins to TableCS_INCIDENTS_ALL_B AHL_UNIT_EFFECTIVITIES_B.CS_INCIDENT_ID
AHL_UNIT_EFFECTIVITIES_B FK Joins to TableAHL_MR_HEADERS_B AHL_UNIT_EFFECTIVITIES_B.PROGRAM_MR_HEADER_ID
AHL_UNIT_EFFECTIVITIES_B FK Joins to TableCS_COUNTERS AHL_UNIT_EFFECTIVITIES_B.COUNTER_ID
TableAHL_SCHEDULE_MATERIALS FK Joins to AHL_UNIT_EFFECTIVITIES_B AHL_SCHEDULE_MATERIALS.UNIT_EFFECTIVITY_ID
TableAHL_UE_RELATIONSHIPS FK Joins to AHL_UNIT_EFFECTIVITIES_B AHL_UE_RELATIONSHIPS.UE_ID
TableAHL_UE_RELATIONSHIPS FK Joins to AHL_UNIT_EFFECTIVITIES_B AHL_UE_RELATIONSHIPS.RELATED_UE_ID
TableAHL_UNIT_ACCOMPLISHMNTS FK Joins to AHL_UNIT_EFFECTIVITIES_B AHL_UNIT_ACCOMPLISHMNTS.UNIT_EFFECTIVITY_ID
TableAHL_UNIT_DEFERRALS_B FK Joins to AHL_UNIT_EFFECTIVITIES_B AHL_UNIT_DEFERRALS_B.UNIT_EFFECTIVITY_ID
TableAHL_UNIT_EFFECTIVITIES_B FK Joins to AHL_UNIT_EFFECTIVITIES_B AHL_UNIT_EFFECTIVITIES_B.DEFER_FROM_UE_ID
TableAHL_UNIT_EFFECTIVITIES_B FK Joins to AHL_UNIT_EFFECTIVITIES_B AHL_UNIT_EFFECTIVITIES_B.ORIG_DEFERRAL_UE_ID
TableAHL_UNIT_EFFECTIVITIES_B FK Joins to AHL_UNIT_EFFECTIVITIES_B AHL_UNIT_EFFECTIVITIES_B.PRECEDING_UE_ID
TableAHL_UNIT_EFFECTIVITIES_TL FK Joins to AHL_UNIT_EFFECTIVITIES_B AHL_UNIT_EFFECTIVITIES_TL.UNIT_EFFECTIVITY_ID
TableAHL_VISIT_TASKS_B FK Joins to AHL_UNIT_EFFECTIVITIES_B AHL_VISIT_TASKS_B.UNIT_EFFECTIVITY_ID