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_VISITS_B

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This table stores information about visits
Implementation/DBA Data:	AHL.AHL_VISITS_B

Primary Key: AHL_VISITS_B_PK

VISIT_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
AHL_VISITS_B	AHL_SIMULATION_PLANS_B	AHL_VISITS_B.SIMULATION_PLAN_ID
AHL_VISITS_B	PA_PROJECTS_ALL	AHL_VISITS_B.PROJECT_ID
AHL_VISITS_B	CS_INCIDENTS_ALL_B	AHL_VISITS_B.SERVICE_REQUEST_ID
AHL_VISITS_B	CSI_ITEM_INSTANCES	AHL_VISITS_B.ITEM_INSTANCE_ID
AHL_VISITS_B	BOM_DEPARTMENTS	AHL_VISITS_B.DEPARTMENT_ID
AHL_VISITS_B	MTL_SYSTEM_ITEMS_B	AHL_VISITS_B.INVENTORY_ITEM_ID AHL_VISITS_B.ITEM_ORGANIZATION_ID
AHL_SNAPSHOTS	AHL_VISITS_B	AHL_SNAPSHOTS.VISIT_ID
AHL_SPACE_ASSIGNMENTS	AHL_VISITS_B	AHL_SPACE_ASSIGNMENTS.VISIT_ID
AHL_VISITS_TL	AHL_VISITS_B	AHL_VISITS_TL.VISIT_ID
AHL_VISIT_TASKS_B	AHL_VISITS_B	AHL_VISIT_TASKS_B.VISIT_ID
AHL_WORKORDERS	AHL_VISITS_B	AHL_WORKORDERS.VISIT_ID