APPS.WIP_BOMROUTINGUTIL_PVT dependencies on BOM_OPERATION_SEQUENCES

Line 37: and fad.entity_name = 'BOM_OPERATION_SEQUENCES');

33: and wo.wip_entity_id = p_wip_entity_id
34: and exists (select fad.pk1_value
35: from fnd_attached_documents fad
36: where fad.pk1_value = to_char(wo.operation_sequence_id)
37: and fad.entity_name = 'BOM_OPERATION_SEQUENCES');
38: begin
39: x_returnStatus := fnd_api.g_ret_sts_success;
40: if (l_logLevel <= wip_constants.trace_logging) then
41: l_params(1).paramName := 'p_orgID';

Line 189: from bom_operation_sequences bos

185: bos.attribute13,
186: bos.attribute14,
187: bos.attribute15,
188: nvl(bos.check_skill,2)
189: from bom_operation_sequences bos
190: where bos.routing_sequence_id = l_routingSeqID
191: and nvl(bos.operation_type, 1) = 1
192: and bos.effectivity_date <= p_routingRevDate
193: and nvl(bos.disable_date, p_routingRevDate+1) >= p_routingRevDate

Line 203: from bom_operation_sequences bos2

199: and eng.routing_sequence_id = l_routingSeqID
200: and ((eng.status_type in (4, 7) and l_excludeECO = 1) or
201: (eng.status_type in (1, 4, 7) and l_excludeECO = 2))))
202: and not exists (select 1
203: from bom_operation_sequences bos2
204: where bos2.routing_sequence_id = bos.routing_sequence_id
205: and bos2.effectivity_date <= p_routingRevDate
206: and bos2.operation_seq_num = bos.operation_seq_num
207: and exists

Line 342: from bom_operation_sequences bos,

338: bor.attribute12,
339: bor.attribute13,
340: bor.attribute14,
341: bor.attribute15
342: from bom_operation_sequences bos,
343: bom_operation_resources bor,
344: bom_resources br
345: where bos.routing_sequence_id = l_routingSeqID
346: and bos.effectivity_date <= p_routingRevDate

Line 353: from bom_operation_sequences bos2,

349: and bor.resource_id = br.resource_id
350: and nvl(bor.acd_type, 0) <> 3
351: and bos.effectivity_date =
352: (select max(effectivity_date)
353: from bom_operation_sequences bos2,
354: bom_operation_resources bor2
355: where bos2.routing_sequence_id = l_routingSeqID
356: and bos2.operation_sequence_id = bor2.operation_sequence_id
357: and bos2.operation_seq_num = bos.operation_seq_num

Line 493: x_from_entity_name => 'BOM_OPERATION_SEQUENCES',

489:
490:
491: FOR op_attach IN op_attachments(p_orgID, p_wipEntityID) LOOP
492: fnd_attached_documents2_pkg.copy_attachments(
493: x_from_entity_name => 'BOM_OPERATION_SEQUENCES',
494: x_from_pk1_value => to_char(op_attach.operation_sequence_id),
495: x_to_entity_name => 'WIP_DISCRETE_OPERATIONS',
496: x_to_pk1_value => to_char(p_wipEntityID),
497: x_to_pk2_value => to_char(op_attach.operation_seq_num),