FND Design Data [Home] [Help]

Table: AHL_MEL_CDL_HEADERS

Product: AHL - Complex Maintenance Repair and Overhaul
Description: This table stores MEL / CDL header information associated with Product Classification node.
Implementation/DBA Data: TableAHL.AHL_MEL_CDL_HEADERS
Primary Key: AHL_MEL_CDL_HEADERS_PK
  1. ColumnMEL_CDL_HEADER_ID
Primary Key: AHL_MEL_CDL_HEADERS_UK1
  1. ColumnPC_NODE_ID
  2. ColumnMEL_CDL_TYPE_CODE
  3. ColumnVERSION_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
AHL_MEL_CDL_HEADERS FK Joins to TableAHL_PC_NODES_B AHL_MEL_CDL_HEADERS.PC_NODE_ID
TableAHL_MEL_CDL_ATA_SEQUENCES FK Joins to AHL_MEL_CDL_HEADERS AHL_MEL_CDL_ATA_SEQUENCES.MEL_CDL_HEADER_ID