FND Design Data [Home] [Help]

Table: AHL_MC_PATH_POSITIONS

Product: AHL - Complex Maintenance Repair and Overhaul
Description: Stores multi-level MC Positions
Implementation/DBA Data: TableAHL.AHL_MC_PATH_POSITIONS
Primary Key: AHL_MC_PATH_POSITIONS_PK
  1. ColumnPATH_POSITION_ID
Primary Key: AHL_MC_PATH_POSITIONS_UK1
  1. ColumnENCODED_PATH_POSITION
Foreign Keys
Table
Foreign Table Foreign Key Column
TableAHL_MC_PATH_POSITION_NODES FK Joins to AHL_MC_PATH_POSITIONS AHL_MC_PATH_POSITION_NODES.PATH_POSITION_ID
TableAHL_MC_RULE_STATEMENTS FK Joins to AHL_MC_PATH_POSITIONS AHL_MC_RULE_STATEMENTS.SUBJECT_ID
TableAHL_MC_RULE_STATEMENTS FK Joins to AHL_MC_PATH_POSITIONS AHL_MC_RULE_STATEMENTS.OBJECT_ID
TableAHL_MR_EFFECTIVITIES FK Joins to AHL_MC_PATH_POSITIONS AHL_MR_EFFECTIVITIES.RELATIONSHIP_ID
TableAHL_PRD_DISPOSITIONS_B FK Joins to AHL_MC_PATH_POSITIONS AHL_PRD_DISPOSITIONS_B.PATH_POSITION_ID
TableAHL_PRD_DISPOSITIONS_B_H FK Joins to AHL_MC_PATH_POSITIONS AHL_PRD_DISPOSITIONS_B_H.PATH_POSITION_ID
TableAHL_RT_OPER_MATERIALS FK Joins to AHL_MC_PATH_POSITIONS AHL_RT_OPER_MATERIALS.POSITION_PATH_ID
TableAHL_UNIT_EFFECTIVITIES_B FK Joins to AHL_MC_PATH_POSITIONS AHL_UNIT_EFFECTIVITIES_B.POSITION_PATH_ID