FND Design Data [Home] [Help]

Table: AHL_RT_OPER_LABOR

Product: AHL - Complex Maintenance Repair and Overhaul
Description: This table stores the labor requirements for a Route or an Operation.
Implementation/DBA Data: TableAHL.AHL_RT_OPER_LABOR
Primary Key: AHL_RT_OPER_LABOR_PK
  1. ColumnRT_OPER_LABOR_ID
Primary Key: AHL_RT_OPER_LABOR_UK1
  1. ColumnOBJECT_ID
  2. ColumnSKILL_COMPETENCE_ID
  3. ColumnSKILL_RATING_LEVEL_ID
  4. ColumnASSOCIATION_TYPE_CODE
Foreign Keys
Table
Foreign Table Foreign Key Column
AHL_RT_OPER_LABOR FK Joins to TableAHL_ROUTES_B AHL_RT_OPER_LABOR.OBJECT_ID
AHL_RT_OPER_LABOR FK Joins to TableAHL_OPERATIONS_B AHL_RT_OPER_LABOR.OBJECT_ID
TableAHL_RT_OPER_LABOR_H FK Joins to AHL_RT_OPER_LABOR AHL_RT_OPER_LABOR_H.RT_OPER_LABOR_ID