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

Product:	INV - Inventory
Description:	Table for Asset Activity Association
Implementation/DBA Data:	INV.MTL_EAM_ASSET_ACTIVITIES

Primary Key: MTL_EAM_ASSET_ACTIVITIES_PK

ACTIVITY_ASSOCIATION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
MTL_EAM_ASSET_ACTIVITIES	MTL_PARAMETERS	MTL_EAM_ASSET_ACTIVITIES.ORGANIZATION_ID
MTL_EAM_ASSET_ACTIVITIES	MTL_SYSTEM_ITEMS_B	MTL_EAM_ASSET_ACTIVITIES.ASSET_ACTIVITY_ID MTL_EAM_ASSET_ACTIVITIES.ORGANIZATION_ID
MTL_EAM_ASSET_ACTIVITIES	MTL_SERIAL_NUMBERS	MTL_EAM_ASSET_ACTIVITIES.SERIAL_NUMBER MTL_EAM_ASSET_ACTIVITIES.INVENTORY_ITEM_ID MTL_EAM_ASSET_ACTIVITIES.ORGANIZATION_ID
MTL_EAM_ASSET_ACTIVITIES	MTL_SYSTEM_ITEMS_B	MTL_EAM_ASSET_ACTIVITIES.INVENTORY_ITEM_ID MTL_EAM_ASSET_ACTIVITIES.ORGANIZATION_ID
EAM_FORECASTED_WORK_ORDERS	MTL_EAM_ASSET_ACTIVITIES	EAM_FORECASTED_WORK_ORDERS.ACTIVITY_ASSOCIATION_ID
EAM_PM_ACTIVITIES	MTL_EAM_ASSET_ACTIVITIES	EAM_PM_ACTIVITIES.ACTIVITY_ASSOCIATION_ID
EAM_PM_LAST_SERVICE	MTL_EAM_ASSET_ACTIVITIES	EAM_PM_LAST_SERVICE.ACTIVITY_ASSOCIATION_ID
EAM_PM_SCHEDULINGS	MTL_EAM_ASSET_ACTIVITIES	EAM_PM_SCHEDULINGS.ACTIVITY_ASSOCIATION_ID
EAM_SUPPRESSION_RELATIONS	MTL_EAM_ASSET_ACTIVITIES	EAM_SUPPRESSION_RELATIONS.CHILD_ASSOCIATION_ID
EAM_SUPPRESSION_RELATIONS	MTL_EAM_ASSET_ACTIVITIES	EAM_SUPPRESSION_RELATIONS.PARENT_ASSOCIATION_ID