FND Design Data [Home] [Help]

Table: AHL_UNIT_THRESHOLDS

Product: AHL - Complex Maintenance Repair and Overhaul
Description: This will store the item instance's threshold values, i.e Due at counter values, provided by Production or in cases where previous accomplishment data not available on the component and initial setup values are defined through Initializati
Implementation/DBA Data: TableAHL.AHL_UNIT_THRESHOLDS
Primary Key: AHL_UNIT_THRESHOLDS_PK
  1. ColumnUNIT_THRESHOLD_ID
Primary Key: AHL_UNIT_THRESHOLDS_UK1
  1. ColumnUNIT_EFFECTIVITY_ID
  2. ColumnCOUNTER_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AHL_UNIT_THRESHOLDS FK Joins to TableAHL_UNIT_DEFERRALS_B AHL_UNIT_THRESHOLDS.UNIT_DEFERRAL_ID
AHL_UNIT_THRESHOLDS FK Joins to TableCS_COUNTERS AHL_UNIT_THRESHOLDS.COUNTER_ID