FND Design Data [Home] [Help]

Table: AHL_VISITS_B

Product: AHL - Complex Maintenance Repair and Overhaul
Description: This table stores information about visits
Implementation/DBA Data: TableAHL.AHL_VISITS_B
Primary Key: AHL_VISITS_B_PK
  1. ColumnVISIT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AHL_VISITS_B FK Joins to TableAHL_SIMULATION_PLANS_B AHL_VISITS_B.SIMULATION_PLAN_ID
AHL_VISITS_B FK Joins to TablePA_PROJECTS_ALL AHL_VISITS_B.PROJECT_ID
AHL_VISITS_B FK Joins to TableCS_INCIDENTS_ALL_B AHL_VISITS_B.SERVICE_REQUEST_ID
AHL_VISITS_B FK Joins to TableCSI_ITEM_INSTANCES AHL_VISITS_B.ITEM_INSTANCE_ID
AHL_VISITS_B FK Joins to TableBOM_DEPARTMENTS AHL_VISITS_B.DEPARTMENT_ID
AHL_VISITS_B FK Joins to TableMTL_SYSTEM_ITEMS_B AHL_VISITS_B.INVENTORY_ITEM_ID
AHL_VISITS_B.ITEM_ORGANIZATION_ID
AHL_VISITS_B FK Joins to TableAHL_UNIT_SCHEDULES AHL_VISITS_B.UNIT_SCHEDULE_ID
TableAHL_SNAPSHOTS FK Joins to AHL_VISITS_B AHL_SNAPSHOTS.VISIT_ID
TableAHL_SPACE_ASSIGNMENTS FK Joins to AHL_VISITS_B AHL_SPACE_ASSIGNMENTS.VISIT_ID
TableAHL_VISITS_TL FK Joins to AHL_VISITS_B AHL_VISITS_TL.VISIT_ID
TableAHL_VISIT_TASKS_B FK Joins to AHL_VISITS_B AHL_VISIT_TASKS_B.VISIT_ID
TableAHL_VWP_STAGES_B FK Joins to AHL_VISITS_B AHL_VWP_STAGES_B.VISIT_ID
TableAHL_WORKORDERS FK Joins to AHL_VISITS_B AHL_WORKORDERS.VISIT_ID