eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: AHL_MC_RELATIONSHIPS

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This table stores MC Node information .It is result of denormalization of AHL_RELATIONSHIP_B and TL.
Implementation/DBA Data:	AHL.AHL_MC_RELATIONSHIPS

Primary Key: AHL_MC_RELATIONSHIPS_PK

RELATIONSHIP_ID

Primary Key: AHL_MC_RELATIONSHIPS_UK1

MC_HEADER_ID
POSITION_KEY

Foreign Keys

Table	Foreign Table	Foreign Key Column
AHL_MC_RELATIONSHIPS	AHL_MC_HEADERS_B	AHL_MC_RELATIONSHIPS.MC_HEADER_ID
AHL_MC_RELATIONSHIPS	AHL_ITEM_GROUPS_B	AHL_MC_RELATIONSHIPS.ITEM_GROUP_ID
AHL_MC_RELATIONSHIPS	AHL_MC_RELATIONSHIPS	AHL_MC_RELATIONSHIPS.PARENT_RELATIONSHIP_ID
AHL_CTR_UPDATE_RULES	AHL_MC_RELATIONSHIPS	AHL_CTR_UPDATE_RULES.RELATIONSHIP_ID
AHL_DOC_TITLE_ASSOS_B	AHL_MC_RELATIONSHIPS	AHL_DOC_TITLE_ASSOS_B.ASO_OBJECT_ID
AHL_MC_CONFIG_RELATIONS	AHL_MC_RELATIONSHIPS	AHL_MC_CONFIG_RELATIONS.RELATIONSHIP_ID
AHL_MC_RELATIONSHIPS	AHL_MC_RELATIONSHIPS	AHL_MC_RELATIONSHIPS.PARENT_RELATIONSHIP_ID