APPS.WIP_VALIDATEMLHEADER_PVT dependencies on WIP_OPERATIONS

Line 2968: from wip_operations

2964: from wip_discrete_jobs wdj
2965: where wdj.organization_id = wjsi.organization_id
2966: and wdj.wip_entity_id = wjsi.wip_entity_id) */ wjsi.routing_reference_id is null and
2967: (select count(*)
2968: from wip_operations
2969: where organization_id = wjsi.organization_id
2970: and wip_entity_id = wjsi.wip_entity_id) = 0 and
2971: ((wjsi.first_unit_start_date is not null or wjsi.last_unit_completion_date is not null)
2972: /* Bug fix : 8407567 If scheduling method is manual, then both the dates are needed */

Line 3409: from wip_operations

3405: /* Modified for Bug 9286094. Modified logic to default scheduling method. */
3406: if ( nvl(wjsi_row.allow_explosion, 'Y') in ('n', 'N') ) then
3407: select count(*)
3408: into l_rtgCount
3409: from wip_operations
3410: where wip_entity_id = wjsi_row.wip_entity_id;
3411: else
3412: select count(*)
3413: into l_rtgCount

Line 3904: from wip_operations

3900: -- Fix for 5999220 Added if condition by mraman
3901: if ( wdj_row.status_type <> wip_constants.unreleased ) then
3902: select nvl(min(operation_seq_num), fnd_api.g_miss_num)
3903: into l_minOp
3904: from wip_operations
3905: where organization_id = wjsi_row.organization_id
3906: and wip_entity_id = wjsi_row.wip_entity_id
3907: and nvl(repetitive_schedule_id, -1) = nvl(wjsi_row.repetitive_schedule_id, -1);
3908:

Line 3914: from wip_operations

3910: select quantity_in_queue,
3911: scheduled_quantity
3912: into l_queueQty,
3913: l_scheduledQty
3914: from wip_operations
3915: where organization_id = wjsi_row.organization_id
3916: and wip_entity_id = wjsi_row.wip_entity_id
3917: and nvl(repetitive_schedule_id, -1) = nvl(wjsi_row.repetitive_schedule_id, -1)
3918: and operation_seq_num = l_minOp;

Line 4533: from wip_operations

4529:
4530: elsif ( l_default = wip_constants.yes ) then
4531: update wip_discrete_jobs
4532: set serialization_start_op = (select nvl(min(operation_seq_num), 1)
4533: from wip_operations
4534: where wip_entity_id = l_wipID)
4535: where wip_entity_id = l_wipID
4536: and exists (select 1
4537: from mtl_system_items

Line 4564: from wip_operations

4560: l_dummy number;
4561:
4562: cursor c_ops(p_wipEntityId number) is
4563: select operation_seq_num
4564: from wip_operations
4565: where wip_entity_id = p_wipEntityId;
4566: begin
4567: x_returnStatus := fnd_api.g_ret_sts_success;
4568:

Line 4585: from wip_operations wo

4581: set serialization_start_op = null
4582: where wip_entity_id = l_wipEntityID
4583: and serialization_start_op <> 1
4584: and not exists(select 1
4585: from wip_operations wo
4586: where wo.wip_entity_id = wdj.wip_entity_id
4587: and wo.operation_seq_num = wdj.serialization_start_op);
4588: end if;
4589:

Line 4793: from wip_operations wo

4789: from wip_discrete_jobs wdj
4790: where wdj.wip_entity_id = wjsi_row.wip_entity_id
4791: and wdj.organization_id = wjsi_row.organization_id
4792: and exists ( select operation_seq_num
4793: from wip_operations wo
4794: where wo.wip_entity_id = wdj.wip_entity_id and
4795: wo.organization_id = wdj.organization_id
4796: minus
4797: select operation_seq_num