Table: AHL_OPERATIONS_B

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This Table stores the Standard and Non Standard Operations.
Implementation/DBA Data:	AHL.AHL_OPERATIONS_B

Primary Key: AHL_OPERATIONS_B_PK

1. OPERATION_ID

Primary Key: AHL_OPERATIONS_B_UK1

1. SEGMENT1
2. SEGMENT2
3. SEGMENT3
4. SEGMENT4
5. SEGMENT5
6. SEGMENT6
7. SEGMENT7

Foreign Keys

Table		Foreign Table	Foreign Key Column
AHL_OPERATIONS_B		QA_PLANS	AHL_OPERATIONS_B.QA_PLAN_ID
AHL_DOC_TITLE_ASSOS_B		AHL_OPERATIONS_B	AHL_DOC_TITLE_ASSOS_B.ASO_OBJECT_ID
AHL_OPERATIONS_H_B		AHL_OPERATIONS_B	AHL_OPERATIONS_H_B.OPERATION_ID
AHL_OPERATIONS_TL		AHL_OPERATIONS_B	AHL_OPERATIONS_TL.OPERATION_ID
AHL_OPERATION_PHASES		AHL_OPERATIONS_B	AHL_OPERATION_PHASES.OPERATION_ID
AHL_OPERATION_PHASES_H		AHL_OPERATIONS_B	AHL_OPERATION_PHASES_H.OPERATION_ID
AHL_ROUTE_OPERATIONS		AHL_OPERATIONS_B	AHL_ROUTE_OPERATIONS.OPERATION_ID
AHL_ROUTE_OPERATIONS_H		AHL_OPERATIONS_B	AHL_ROUTE_OPERATIONS_H.OPERATION_ID
AHL_RT_OPER_ACCESS_PANELS		AHL_OPERATIONS_B	AHL_RT_OPER_ACCESS_PANELS.OBJECT_ID
AHL_RT_OPER_LABOR		AHL_OPERATIONS_B	AHL_RT_OPER_LABOR.OBJECT_ID
AHL_RT_OPER_LABOR_H		AHL_OPERATIONS_B	AHL_RT_OPER_LABOR_H.OBJECT_ID
AHL_RT_OPER_MATERIALS		AHL_OPERATIONS_B	AHL_RT_OPER_MATERIALS.OBJECT_ID
AHL_RT_OPER_MATERIALS_H		AHL_OPERATIONS_B	AHL_RT_OPER_MATERIALS_H.OBJECT_ID
AHL_RT_OPER_RESOURCES		AHL_OPERATIONS_B	AHL_RT_OPER_RESOURCES.OBJECT_ID
AHL_WORKORDER_OPERATIONS		AHL_OPERATIONS_B	AHL_WORKORDER_OPERATIONS.OPERATION_ID