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_WORKORDER_MTL_TXNS

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This table stores the material transactions that were issued against a job.
Implementation/DBA Data:	AHL.AHL_WORKORDER_MTL_TXNS

Primary Key: AHL_WORKORDER_MTL_TXNS_PK

WORKORDER_MTL_TXN_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
AHL_WORKORDER_MTL_TXNS	AHL_WORKORDER_OPERATIONS	AHL_WORKORDER_MTL_TXNS.WORKORDER_OPERATION_ID
AHL_WORKORDER_MTL_TXNS	MTL_ITEM_LOCATIONS	AHL_WORKORDER_MTL_TXNS.LOCATOR_ID AHL_WORKORDER_MTL_TXNS.ORGANIZATION_ID
AHL_WORKORDER_MTL_TXNS	AHL_WORKORDERS	AHL_WORKORDER_MTL_TXNS.NON_ROUTINE_WORKORDER_ID
AHL_WORKORDER_MTL_TXNS	MTL_MATERIAL_TRANSACTIONS	AHL_WORKORDER_MTL_TXNS.MATERIAL_TRANSACTION_ID
AHL_WORKORDER_MTL_TXNS	MTL_SYSTEM_ITEMS_B	AHL_WORKORDER_MTL_TXNS.INVENTORY_ITEM_ID AHL_WORKORDER_MTL_TXNS.ORGANIZATION_ID
AHL_WORKORDER_MTL_TXNS	MTL_SECONDARY_INVENTORIES	AHL_WORKORDER_MTL_TXNS.SUBINVENTORY_CODE AHL_WORKORDER_MTL_TXNS.ORGANIZATION_ID
AHL_WORKORDER_MTL_TXNS	MTL_TRANSACTION_TYPES	AHL_WORKORDER_MTL_TXNS.TRANSACTION_TYPE_ID
AHL_WORKORDER_MTL_TXNS	MTL_LOT_NUMBERS	AHL_WORKORDER_MTL_TXNS.INVENTORY_ITEM_ID AHL_WORKORDER_MTL_TXNS.ORGANIZATION_ID AHL_WORKORDER_MTL_TXNS.LOT_NUMBER
AHL_WORKORDER_MTL_TXNS	MTL_SERIAL_NUMBERS	AHL_WORKORDER_MTL_TXNS.SERIAL_NUMBER AHL_WORKORDER_MTL_TXNS.INVENTORY_ITEM_ID AHL_WORKORDER_MTL_TXNS.ORGANIZATION_ID
AHL_PART_CHANGES	AHL_WORKORDER_MTL_TXNS	AHL_PART_CHANGES.WORKORDER_MTL_TXN_ID