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 281: from wip_operations

277: after the OSP operation. The code reaches this point beacuse OSP operation
278: is the last count point operation */
279: select count(*)
280: into l_ncp_after_current_op
281: from wip_operations
282: where operation_seq_num > p_current_op
283: and count_point_type = 2
284: and wip_entity_id = p_wip_entity_id ;
285:

Line 466: from wip_operations

462: quantity_in_queue,
463: quantity_waiting_to_move,
464: quantity_completed,
465: repetitive_schedule_id
466: from wip_operations
467: where wip_entity_id= l_wip_entity_id
468: and nvl (repetitive_schedule_id, -1) = nvl (l_rep_sch_id, -1)
469: and organization_id= l_organization_id
470: and operation_seq_num > l_osp_op_seq

Line 475: wip_operations wop

471: and count_point_type = 1
472: and ROWNUM=1
473: ORDER BY operation_seq_num) nwop,
474: /*Bug 6146597 End*/
475: wip_operations wop
476: WHERE wop.organization_id = l_organization_id
477: and wop.wip_entity_id = l_wip_entity_id
478: and wop.operation_seq_num = l_osp_op_seq
479: and nvl (wop.repetitive_schedule_id, -1) =

Line 718: FROM wip_operations

714: AND g_ShopFloorMove_rec.organization_id IS NOT NULL THEN
715:
716: SELECT department_id
717: INTO g_ShopFloorMove_rec.fm_department_id
718: FROM wip_operations
719: WHERE wip_entity_id = g_ShopFloorMove_rec.wip_entity_id
720: AND organization_id = g_ShopFloorMove_rec.organization_id
721: AND operation_seq_num = g_ShopFloorMove_rec.fm_operation_seq_num
722: AND (repetitive_schedule_id IS NULL

Line 1270: from wip_operations wo

1266: into l_quantity_in_queue,
1267: l_quantity_running,
1268: l_quantity_completed,
1269: l_scheduled_quantity
1270: from wip_operations wo
1271: where wo.wip_entity_id = g_ShopFloorMove_rec.wip_entity_id
1272: and nvl(wo.repetitive_schedule_id, -1) = nvl(g_ShopFloorMove_rec.repetitive_schedule_id, -1)
1273: and wo.organization_id = g_ShopFloorMove_rec.organization_id
1274: and wo.operation_seq_num = g_ShopFloorMove_rec.fm_operation_seq_num;

Line 1290: from wip_operations wo,

1286: sum(wo.quantity_completed)
1287: into l_quantity_in_queue,
1288: l_quantity_running,
1289: l_quantity_completed
1290: from wip_operations wo,
1291: wip_repetitive_schedules wrs
1292: where wo.wip_entity_id = g_ShopFloorMove_rec.wip_entity_id
1293: and wrs.wip_entity_id = wo.wip_entity_id
1294: and wo.organization_id = wrs.organization_id

Line 1784: FROM wip_operations

1780: AND g_ShopFloorMove_rec.organization_id IS NOT NULL THEN
1781:
1782: SELECT department_id
1783: INTO g_ShopFloorMove_rec.to_department_id
1784: FROM wip_operations
1785: WHERE wip_entity_id = g_ShopFloorMove_rec.wip_entity_id
1786: AND operation_seq_num = g_ShopFloorMove_rec.to_operation_seq_num
1787: AND organization_id = g_ShopFloorMove_rec.organization_id
1788: AND (repetitive_schedule_id IS NULL