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_ITEM_COMPOSITIONS

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This table stores information about item compositions header .
Implementation/DBA Data:	AHL.AHL_ITEM_COMPOSITIONS

Primary Key: AHL_ITEM_COMPOSITIONS_PK

ITEM_COMPOSITION_ID

Primary Key: AHL_ITEM_COMPOSITIONS_UK1

INVENTORY_ITEM_ID
INVENTORY_MASTER_ORG_ID
APPROVAL_STATUS_CODE

Foreign Keys

Table		Foreign Table	Foreign Key Column
AHL_ITEM_COMP_DETAILS		AHL_ITEM_COMPOSITIONS	AHL_ITEM_COMP_DETAILS.ITEM_COMPOSITION_ID