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_VISIT_TASKS_B

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

Primary Key: AHL_VISIT_TASKS_B_PK

VISIT_TASK_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
AHL_VISIT_TASKS_B	AHL_VISITS_B	AHL_VISIT_TASKS_B.VISIT_ID
AHL_VISIT_TASKS_B	AHL_VISIT_TASKS_B	AHL_VISIT_TASKS_B.ORIGINATING_TASK_ID
AHL_VISIT_TASKS_B	AHL_VWP_STAGES_B	AHL_VISIT_TASKS_B.STAGE_ID
AHL_VISIT_TASKS_B	AHL_MR_HEADERS_B	AHL_VISIT_TASKS_B.MR_ID
AHL_VISIT_TASKS_B	AHL_MR_ROUTES	AHL_VISIT_TASKS_B.MR_ROUTE_ID
AHL_VISIT_TASKS_B	AHL_UNIT_EFFECTIVITIES_B	AHL_VISIT_TASKS_B.UNIT_EFFECTIVITY_ID
AHL_VISIT_TASKS_B	CSI_ITEM_INSTANCES	AHL_VISIT_TASKS_B.INSTANCE_ID
AHL_VISIT_TASKS_B	CS_INCIDENTS_ALL_B	AHL_VISIT_TASKS_B.SERVICE_REQUEST_ID
AHL_VISIT_TASKS_B	BOM_DEPARTMENTS	AHL_VISIT_TASKS_B.DEPARTMENT_ID
AHL_VISIT_TASKS_B	MTL_SYSTEM_ITEMS_B	AHL_VISIT_TASKS_B.INVENTORY_ITEM_ID AHL_VISIT_TASKS_B.ITEM_ORGANIZATION_ID
AHL_VISIT_TASKS_B	PA_TASKS	AHL_VISIT_TASKS_B.PROJECT_TASK_ID
AHL_SCHEDULE_MATERIALS	AHL_VISIT_TASKS_B	AHL_SCHEDULE_MATERIALS.VISIT_TASK_ID
AHL_SNAPSHOTS	AHL_VISIT_TASKS_B	AHL_SNAPSHOTS.VISIT_TASK_ID
AHL_TASK_LINKS	AHL_VISIT_TASKS_B	AHL_TASK_LINKS.VISIT_TASK_ID
AHL_TASK_LINKS	AHL_VISIT_TASKS_B	AHL_TASK_LINKS.PARENT_TASK_ID
AHL_VISIT_TASKS_B	AHL_VISIT_TASKS_B	AHL_VISIT_TASKS_B.ORIGINATING_TASK_ID
AHL_VISIT_TASKS_TL	AHL_VISIT_TASKS_B	AHL_VISIT_TASKS_TL.VISIT_TASK_ID
AHL_WARRANTY_ENTITLEMENTS	AHL_VISIT_TASKS_B	AHL_WARRANTY_ENTITLEMENTS.VISIT_TASK_ID
AHL_WORKORDERS	AHL_VISIT_TASKS_B	AHL_WORKORDERS.VISIT_TASK_ID