Table: AHL_ROUTES_B

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This table stores the Route attributes.
Implementation/DBA Data:	AHL.AHL_ROUTES_B

Primary Key: AHL_ROUTES_B_PK

1. ROUTE_ID

Primary Key: AHL_ROUTES_B_UK1

1. ROUTE_NO

Foreign Keys

Table		Foreign Table	Foreign Key Column
AHL_ROUTES_B		HZ_PARTIES	AHL_ROUTES_B.OPERATOR_PARTY_ID
AHL_ROUTES_B		QA_PLANS	AHL_ROUTES_B.QA_PLAN_ID
AHL_ROUTES_B		MTL_SYSTEM_ITEMS_B	AHL_ROUTES_B.SERVICE_ITEM_ID AHL_ROUTES_B.SERVICE_ITEM_ORG_ID
AHL_ROUTES_B		JTF_TASK_TEMP_GROUPS_B	AHL_ROUTES_B.TASK_TEMPLATE_GROUP_ID
AHL_ROUTES_B		WIP_ACCOUNTING_CLASSES	AHL_ROUTES_B.ACCOUNTING_CLASS_CODE AHL_ROUTES_B.ACCOUNTING_CLASS_ORG_ID
AHL_DOC_TITLE_ASSOS_B		AHL_ROUTES_B	AHL_DOC_TITLE_ASSOS_B.ASO_OBJECT_ID
AHL_MR_ROUTES		AHL_ROUTES_B	AHL_MR_ROUTES.ROUTE_ID
AHL_ROUTES_H_B		AHL_ROUTES_B	AHL_ROUTES_H_B.ROUTE_ID
AHL_ROUTES_TL		AHL_ROUTES_B	AHL_ROUTES_TL.ROUTE_ID
AHL_ROUTE_EFFECTIVITIES		AHL_ROUTES_B	AHL_ROUTE_EFFECTIVITIES.ROUTE_ID
AHL_ROUTE_OPERATIONS		AHL_ROUTES_B	AHL_ROUTE_OPERATIONS.ROUTE_ID
AHL_ROUTE_OPERATIONS_H		AHL_ROUTES_B	AHL_ROUTE_OPERATIONS_H.ROUTE_ID
AHL_RT_OPER_LABOR		AHL_ROUTES_B	AHL_RT_OPER_LABOR.OBJECT_ID
AHL_RT_OPER_LABOR_H		AHL_ROUTES_B	AHL_RT_OPER_LABOR_H.OBJECT_ID
AHL_RT_OPER_MATERIALS		AHL_ROUTES_B	AHL_RT_OPER_MATERIALS.OBJECT_ID
AHL_RT_OPER_MATERIALS_H		AHL_ROUTES_B	AHL_RT_OPER_MATERIALS_H.OBJECT_ID
AHL_RT_OPER_RESOURCES		AHL_ROUTES_B	AHL_RT_OPER_RESOURCES.OBJECT_ID
AHL_WORKORDERS		AHL_ROUTES_B	AHL_WORKORDERS.ROUTE_ID