APPS.WIP_INFINITE_SCHEDULER_PVT dependencies on WIP_OPERATIONS

Line 296: from wip_operations

292: select min(operation_seq_num),
293: max(operation_seq_num)
294: into x_minOpSeqNum,
295: x_maxOpSeqNum
296: from wip_operations
297: where wip_entity_id = p_wipEntityID
298: and organization_id = p_orgID;
299:
300: elsif(p_schedMethod = wip_constants.midpoint_forwards) then

Line 323: from wip_operations

319: end if;
320:
321: select max(operation_seq_num)
322: into x_maxOpSeqNum
323: from wip_operations
324: where wip_entity_id = p_wipEntityID
325: and organization_id = p_orgID;
326:
327: select max(nvl(schedule_seq_num, resource_seq_num))

Line 356: from wip_operations

352: end if;
353:
354: select min(operation_seq_num)
355: into x_minOpSeqNum
356: from wip_operations
357: where wip_entity_id = p_wipEntityID
358: and organization_id = p_orgID;
359:
360: select min(nvl(schedule_seq_num, resource_seq_num))

Line 469: from wip_operations

465: for update nowait;
466:
467: cursor c_ops is
468: select 1
469: from wip_operations
470: where wip_entity_id = p_wipEntityID
471: and organization_id = p_orgID
472: and operation_seq_num between p_minOpSeqNum and p_maxOpSeqNum
473: for update nowait;

Line 637: wip_operations wo,

633: x_resTbls.avail24Flag,
634: x_resTbls.totalDaysUsg,
635: x_assignedUnits
636: from wip_discrete_jobs wdj,
637: wip_operations wo,
638: wip_operation_resources wor,
639: mtl_uom_conversions muc,
640: bom_department_resources bdr,
641: wip_parameters wp

Line 974: from wip_operations wo,

970: bulk collect into
971: l_opTbls.opSeqNum,
972: l_opTbls.startDate,
973: l_opTbls.endDate
974: from wip_operations wo,
975: wip_operation_resources wor
976: where wo.wip_entity_id = p_wipEntityID
977: and wo.organization_id = p_orgID
978: and wo.wip_entity_id = wor.wip_entity_id (+)

Line 990: from wip_operations wo,

986: bulk collect into
987: l_opSchYesTbls.opSeqNum,
988: l_opSchYesTbls.startDate,
989: l_opSchYesTbls.endDate
990: from wip_operations wo,
991: wip_operation_resources wor
992: where wo.wip_entity_id = p_wipEntityID
993: and wo.organization_id = p_orgID
994: and wo.wip_entity_id = wor.wip_entity_id (+)

Line 1067: update wip_operations

1063: end if;
1064:
1065: if(l_startOpIdx is not null) then
1066: forall i in l_startOpIdx..l_endOpIdx
1067: update wip_operations
1068: set first_unit_start_date = l_opTbls.startDate(i),
1069: last_unit_start_date = l_opTbls.startDate(i),
1070: first_unit_completion_date = l_opTbls.endDate(i),
1071: last_unit_completion_date = l_opTbls.endDate(i),