APPS.WIP_INFINITE_SCHEDULER_PVT dependencies on WIP_DISCRETE_JOBS

Line 462: from wip_discrete_jobs

458:
459: --the following cursors simply lock the records writeJobSchedule() will later modify
460: cursor c_job is
461: select 1
462: from wip_discrete_jobs
463: where wip_entity_id = p_wipEntityID
464: and organization_id = p_orgID
465: for update nowait;
466:

Line 577: -- Added decode clause to derive the quantity from wip_discrete_jobs only if the parameter

573: -- between resource UOM and standard HR uom code received from BOM profile value.
574:
575:
576: -- Fixed bug 5440007
577: -- Added decode clause to derive the quantity from wip_discrete_jobs only if the parameter
578: -- p_quantity is null
579: select wor.operation_seq_num,
580: wor.resource_id,
581: nvl(bdr.share_from_dept_id, bdr.department_id),

Line 644: from wip_discrete_jobs wdj,

640: x_resTbls.schedFlag,
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,

Line 1167: update wip_discrete_jobs

1163: if l_jobdate_align = WIP_CONSTANTS.NO and p_schedMethod = WIP_CONSTANTS.BACKWARDS then
1164: l_jobCplDate := p_anchorDate;
1165: end if;
1166:
1167: update wip_discrete_jobs
1168: set scheduled_start_date = l_jobStartDate,
1169: scheduled_completion_date = l_jobCplDate,
1170: last_update_date = l_sysdate,
1171: last_updated_by = l_userID,