3861: ASML.aog_flag
3862: FROM
3863: AHL_WORKORDERS AWOS,
3864: AHL_SCHEDULE_MATERIALS ASML,
3865: wip_requirement_operations wipr,
3866: MTL_SYSTEM_ITEMS_VL MSIV,
3867: AHL_VISITS_VL AVST,
3868: AHL_WORKORDER_OPERATIONS AWOP,
3869: -- added for FP bug# 6802777
4309: wip.wip_entity_id,
4310: wip.operation_seq_num operation_sequence,
4311: wip.organization_id,
4312: wip.department_id
4313: FROM wip_requirement_operations wip,
4314: ahl_schedule_materials asm,
4315: ahl_workorders wo
4316: WHERE wip.wip_entity_id = wo.wip_entity_id
4317: AND wo.visit_task_id = asm.visit_task_id