APPS.WIP_VALIDATEMLHEADER_PVT dependencies on WIP_OPERATIONS

Line 2942: from wip_operations

2938: from wip_discrete_jobs wdj
2939: where wdj.organization_id = wjsi.organization_id
2940: and wdj.wip_entity_id = wjsi.wip_entity_id) */ wjsi.routing_reference_id is null and
2941: (select count(*)
2942: from wip_operations
2943: where organization_id = wjsi.organization_id
2944: and wip_entity_id = wjsi.wip_entity_id) = 0 and
2945: (wjsi.first_unit_start_date is not null or wjsi.last_unit_completion_date is not null))
2946: or (wjsi.load_type in (wip_constants.create_job, wip_constants.create_ns_job) and

Line 3376: from wip_operations

3372: l_qty := wjsi_row.start_quantity;
3373: elsif(wjsi_row.load_type = wip_constants.resched_job) then
3374: select count(*)
3375: into l_rtgCount
3376: from wip_operations
3377: where wip_entity_id = wjsi_row.wip_entity_id;
3378: l_qty := nvl(wjsi_row.start_quantity, wdj_row.start_quantity);
3379: end if;
3380:

Line 3798: from wip_operations

3794: -- Fix for 5999220 Added if condition by mraman
3795: if ( wdj_row.status_type <> wip_constants.unreleased ) then
3796: select nvl(min(operation_seq_num), fnd_api.g_miss_num)
3797: into l_minOp
3798: from wip_operations
3799: where organization_id = wjsi_row.organization_id
3800: and wip_entity_id = wjsi_row.wip_entity_id
3801: and nvl(repetitive_schedule_id, -1) = nvl(wjsi_row.repetitive_schedule_id, -1);
3802:

Line 3808: from wip_operations

3804: select quantity_in_queue,
3805: scheduled_quantity
3806: into l_queueQty,
3807: l_scheduledQty
3808: from wip_operations
3809: where organization_id = wjsi_row.organization_id
3810: and wip_entity_id = wjsi_row.wip_entity_id
3811: and nvl(repetitive_schedule_id, -1) = nvl(wjsi_row.repetitive_schedule_id, -1)
3812: and operation_seq_num = l_minOp;

Line 4404: from wip_operations

4400:
4401: elsif ( l_default = wip_constants.yes ) then
4402: update wip_discrete_jobs
4403: set serialization_start_op = (select nvl(min(operation_seq_num), 1)
4404: from wip_operations
4405: where wip_entity_id = l_wipID)
4406: where wip_entity_id = l_wipID
4407: and exists (select 1
4408: from mtl_system_items

Line 4435: from wip_operations

4431: l_dummy number;
4432:
4433: cursor c_ops(p_wipEntityId number) is
4434: select operation_seq_num
4435: from wip_operations
4436: where wip_entity_id = p_wipEntityId;
4437: begin
4438: x_returnStatus := fnd_api.g_ret_sts_success;
4439:

Line 4456: from wip_operations wo

4452: set serialization_start_op = null
4453: where wip_entity_id = l_wipEntityID
4454: and serialization_start_op <> 1
4455: and not exists(select 1
4456: from wip_operations wo
4457: where wo.wip_entity_id = wdj.wip_entity_id
4458: and wo.operation_seq_num = wdj.serialization_start_op);
4459: end if;
4460:

Line 4664: from wip_operations wo

4660: from wip_discrete_jobs wdj
4661: where wdj.wip_entity_id = wjsi_row.wip_entity_id
4662: and wdj.organization_id = wjsi_row.organization_id
4663: and exists ( select operation_seq_num
4664: from wip_operations wo
4665: where wo.wip_entity_id = wdj.wip_entity_id and
4666: wo.organization_id = wdj.organization_id
4667: minus
4668: select operation_seq_num