APPS.WSM_INFINITE_SCHEDULER_PVT dependencies on WIP_DISCRETE_JOBS

Line 288: from wip_discrete_jobs

284: l_stmt_num := 30.1;
285: -- get the job status
286: select status_type
287: into l_job_status
288: from wip_discrete_jobs
289: where wip_entity_id = p_wipEntityID;
290:
291: if(l_job_status = WIP_CONSTANTS.UNRELEASED) then
292: l_stmt_num := 30.2;

Line 699: from wip_discrete_jobs wdj,

695: / ( 24 * nvl(l_hrVal,1)*least(wor.assigned_units, bdr.capacity_units)
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

Line 757: from wip_discrete_jobs wdj,

753: / ( 24 * nvl(l_hrVal,1)* least(wcor.assigned_units, bdr.capacity_units)
754: * nvl(bdr.utilization, 1) * nvl(bdr.efficiency, 1) ),
755: wcor.basis_type,
756: wcor.assigned_units
757: from wip_discrete_jobs wdj,
758: wsm_copy_operations wco,
759: wsm_copy_op_resources wcor,
760: mtl_uom_conversions muc,
761: bom_department_resources bdr

Line 938: from wip_discrete_jobs wdj

934: select wdj.start_quantity,
935: wdj.quantity_scrapped
936: into l_job_start_qty,
937: l_job_scrap_qty
938: from wip_discrete_jobs wdj
939: where wdj.wip_entity_id = p_wipEntityID;
940: -- BA: BUG3195950
941: if(l_job_start_qty = 0 or
942: l_job_start_qty - l_job_scrap_qty = 0) then

Line 1143: from wip_discrete_jobs

1139: --lock the job
1140: IF p_new_job <> 1 THEN
1141: select 1
1142: into l_dummy
1143: from wip_discrete_jobs
1144: where wip_entity_id = p_wipEntityID
1145: and organization_id = p_orgID
1146: for update nowait;
1147: END IF;

Line 1335: from wip_discrete_jobs wdj

1331: select wdj.scheduled_start_date,
1332: wdj.scheduled_completion_date
1333: into l_jobStartDate,
1334: l_jobComplDate
1335: from wip_discrete_jobs wdj
1336: where wdj.wip_entity_id = p_wipEntityID;
1337:
1338:
1339: if(x_resTbls.opSeqNum.count <> 0) then

Line 1568: update wip_discrete_jobs

1564: --update job
1565: --if(l_jobStartDate IS NOT NULL or l_jobComplDate IS NOT NULL) then
1566: if(l_jobStartDate <> l_newJobStartDate or l_jobComplDate <> l_newJobComplDate) then
1567:
1568: update wip_discrete_jobs
1569: set --scheduled_start_date = NVL(l_jobStartDate, scheduled_start_date),
1570: --scheduled_completion_date = NVL(l_jobComplDate, scheduled_completion_date),
1571: scheduled_start_date = l_newJobStartDate,
1572: scheduled_completion_date = l_newJobComplDate,