APPS.WIP_DEFAULT_SHOPFLOORMOVE dependencies on WIP_OPERATIONS

Line 133: from WIP_SHOP_FLOOR_STATUSES wsfs, WIP_OPERATIONS wo,

129: BEGIN
130:
131:
132: select count(*) into x_valid_ez_complete
133: from WIP_SHOP_FLOOR_STATUSES wsfs, WIP_OPERATIONS wo,
134: WIP_SHOP_FLOOR_STATUS_CODES wsfsc
135: where wsfs.wip_entity_id = p_wip_entity_id
136: and wsfs.organization_id = p_org_id
137: and nvl (wsfs.line_id, -1) = nvl (p_line_id, -1)

Line 430: from wip_operations

426: quantity_in_queue,
427: quantity_waiting_to_move,
428: quantity_completed,
429: repetitive_schedule_id
430: from wip_operations
431: where wip_entity_id= l_wip_entity_id
432: and nvl (repetitive_schedule_id, -1) = nvl (l_rep_sch_id, -1)
433: and organization_id= l_organization_id
434: and operation_seq_num > l_osp_op_seq

Line 439: wip_operations wop

435: and count_point_type = 1
436: and ROWNUM=1
437: ORDER BY operation_seq_num) nwop,
438: /*Bug 6146597 End*/
439: wip_operations wop
440: WHERE wop.organization_id = l_organization_id
441: and wop.wip_entity_id = l_wip_entity_id
442: and wop.operation_seq_num = l_osp_op_seq
443: and nvl (wop.repetitive_schedule_id, -1) =

Line 682: FROM wip_operations

678: AND g_ShopFloorMove_rec.organization_id IS NOT NULL THEN
679:
680: SELECT department_id
681: INTO g_ShopFloorMove_rec.fm_department_id
682: FROM wip_operations
683: WHERE wip_entity_id = g_ShopFloorMove_rec.wip_entity_id
684: AND organization_id = g_ShopFloorMove_rec.organization_id
685: AND operation_seq_num = g_ShopFloorMove_rec.fm_operation_seq_num
686: AND (repetitive_schedule_id IS NULL

Line 1222: from wip_operations wo

1218: quantity_completed
1219: into l_quantity_in_queue,
1220: l_quantity_running,
1221: l_quantity_completed
1222: from wip_operations wo
1223: where wo.wip_entity_id = g_ShopFloorMove_rec.wip_entity_id
1224: and nvl(wo.repetitive_schedule_id, -1) = nvl(g_ShopFloorMove_rec.repetitive_schedule_id, -1)
1225: and wo.organization_id = g_ShopFloorMove_rec.organization_id
1226: and wo.operation_seq_num = g_ShopFloorMove_rec.fm_operation_seq_num;

Line 1242: from wip_operations wo,

1238: sum(wo.quantity_completed)
1239: into l_quantity_in_queue,
1240: l_quantity_running,
1241: l_quantity_completed
1242: from wip_operations wo,
1243: wip_repetitive_schedules wrs
1244: where wo.wip_entity_id = g_ShopFloorMove_rec.wip_entity_id
1245: and wrs.wip_entity_id = wo.wip_entity_id
1246: and wo.organization_id = wrs.organization_id

Line 1725: FROM wip_operations

1721: AND g_ShopFloorMove_rec.organization_id IS NOT NULL THEN
1722:
1723: SELECT department_id
1724: INTO g_ShopFloorMove_rec.to_department_id
1725: FROM wip_operations
1726: WHERE wip_entity_id = g_ShopFloorMove_rec.wip_entity_id
1727: AND operation_seq_num = g_ShopFloorMove_rec.to_operation_seq_num
1728: AND organization_id = g_ShopFloorMove_rec.organization_id
1729: AND (repetitive_schedule_id IS NULL