APPS.WSM_INFINITE_SCHEDULER_PVT dependencies on WIP_OPERATIONS

Line 277: from wip_operations

273: --get l_curJobOpSeqNum and l_curJobOpSeqid
274: begin
275: select count(operation_seq_num)
276: into l_count
277: from wip_operations
278: where wip_entity_id = p_wipEntityID;
279:
280: if(l_count = 0) then
281: l_curJobOpSeqNum := null;

Line 311: from wip_operations

307: select operation_seq_num,
308: operation_sequence_id
309: into l_curJobOpSeqNum,
310: l_curJobOpSeqid
311: from wip_operations
312: where wip_entity_id = p_wipEntityID
313: and operation_seq_num = -p_opSeqNum;
314: else
315: l_stmt_num := 30.4;

Line 321: from wip_operations

317: select operation_seq_num,
318: operation_sequence_id
319: into l_curJobOpSeqNum,
320: l_curJobOpSeqid
321: from wip_operations
322: where wip_entity_id = p_wipEntityID
323: and (quantity_in_queue <> 0 or
324: quantity_running <> 0 or
325: quantity_waiting_to_move <> 0);

Line 366: from wip_operations

362: l_dummy varchar2(1);
363: begin
364: select '1'
365: into l_dummy
366: from wip_operations
367: where wip_entity_id = p_wipEntityID
368: and operation_seq_num = l_curJobOpSeqNum
369: and nvl(quantity_running, 0) = 0
370: and nvl(quantity_waiting_to_move, 0) = 0;

Line 604: from wip_operations

600:
601: --the following cursors simply lock the records wsmJobWriter() will later modify
602: cursor c_WO is
603: select 1
604: from wip_operations
605: where wip_entity_id = p_wipEntityID
606: and organization_id = p_orgID
607: for update nowait;
608:

Line 700: wip_operations wo,

696: * nvl(bdr.utilization, 1) * nvl(bdr.efficiency, 1) ),
697: wor.basis_type,
698: wor.assigned_units
699: from wip_discrete_jobs wdj,
700: wip_operations wo,
701: wip_operation_resources wor,
702: mtl_uom_conversions muc,
703: bom_department_resources bdr
704: where wdj.wip_entity_id = p_wipEntityID

Line 961: from wip_operations wo

957: 0, 1, 2)
958: into l_job_quantity,
959: l_cur_op_yield,
960: l_qty_posi
961: from wip_operations wo
962: where wo.wip_entity_id = p_wipEntityID
963: and wo.operation_seq_num = l_cur_job_op_seq;
964:
965: if(l_job_quantity = 0) then

Line 1355: from wip_operations

1351: select first_unit_start_date,
1352: last_unit_completion_date
1353: into l_OpStartDate(1),
1354: l_OpEndDate(1)
1355: from wip_operations
1356: where wip_entity_id = p_wipEntityID
1357: and organization_id = p_orgID
1358: and operation_seq_num = -l_curOp;
1359: else

Line 1596: update wip_operations

1592:
1593: l_stat_num := 70;
1594: --update operations WO
1595: forall i in 1..l_cnt_wo
1596: update wip_operations
1597: set first_unit_start_date = NVL(l_OpStartDate(i), first_unit_start_date),
1598: last_unit_start_date = NVL(l_OpStartDate(i), last_unit_start_date),
1599: first_unit_completion_date = NVL(l_OpEndDate(i), first_unit_completion_date),
1600: last_unit_completion_date = NVL(l_OpEndDate(i), last_unit_completion_date),