FND Design Data [Home] [Help]

Table: AHL_ITEM_COMP_DETAILS

Product: AHL - Complex Maintenance Repair and Overhaul
Description: This table stores the details of Non-Tracked Items/ Item Groups associated with a Item Composition in the header table.
Implementation/DBA Data: TableAHL.AHL_ITEM_COMP_DETAILS
Primary Key: AHL_ITEM_COMP_DETAILS_PK
  1. ColumnITEM_COMP_DETAIL_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AHL_ITEM_COMP_DETAILS FK Joins to TableAHL_ITEM_COMPOSITIONS AHL_ITEM_COMP_DETAILS.ITEM_COMPOSITION_ID
AHL_ITEM_COMP_DETAILS FK Joins to TableAHL_ITEM_GROUPS_B AHL_ITEM_COMP_DETAILS.ITEM_GROUP_ID
TableAHL_RT_OPER_MATERIALS FK Joins to AHL_ITEM_COMP_DETAILS AHL_RT_OPER_MATERIALS.ITEM_COMP_DETAIL_ID