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 645: wip_operations wo,

641: x_resTbls.avail24Flag,
642: x_resTbls.totalDaysUsg,
643: x_assignedUnits
644: from wip_discrete_jobs wdj,
645: wip_operations wo,
646: wip_operation_resources wor,
647: mtl_uom_conversions muc,
648: bom_department_resources bdr,
649: wip_parameters wp

Line 994: from wip_operations wo,

990: bulk collect into
991: l_opTbls.opSeqNum,
992: l_opTbls.startDate,
993: l_opTbls.endDate
994: from wip_operations wo,
995: wip_operation_resources wor
996: where wo.wip_entity_id = p_wipEntityID
997: and wo.organization_id = p_orgID
998: and wo.wip_entity_id = wor.wip_entity_id (+)

Line 1010: from wip_operations wo,

1006: bulk collect into
1007: l_opSchYesTbls.opSeqNum,
1008: l_opSchYesTbls.startDate,
1009: l_opSchYesTbls.endDate
1010: from wip_operations wo,
1011: wip_operation_resources wor
1012: where wo.wip_entity_id = p_wipEntityID
1013: and wo.organization_id = p_orgID
1014: and wo.wip_entity_id = wor.wip_entity_id (+)

Line 1090: update wip_operations

1086: end if;
1087:
1088: if(l_startOpIdx is not null) then
1089: forall i in l_startOpIdx..l_endOpIdx
1090: update wip_operations
1091: set first_unit_start_date = l_opTbls.startDate(i),
1092: last_unit_start_date = l_opTbls.startDate(i),
1093: first_unit_completion_date = l_opTbls.endDate(i),
1094: last_unit_completion_date = l_opTbls.endDate(i),