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 |
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 |
|
|
|