229: and (p_assembly_name_to is NULL or p_assembly_name_to >= msi_kfv.concatenated_segments)
230: and (p_tpct_from is NULL or bor.total_product_cycle_time >= p_tpct_from)
231: and (p_tpct_to is NULL or bor.total_product_cycle_time <= p_tpct_to)
232: and (p_lineop_code is NULL or exists (
233: select 1 from bom_operation_sequences_v bosv
234: where bosv.routing_sequence_id = bor.common_routing_sequence_id
235: and p_lineop_code = bosv.standard_operation_code
236: and bosv.operation_type = 3)
237: )
235: and p_lineop_code = bosv.standard_operation_code
236: and bosv.operation_type = 3)
237: )
238: and (p_process_code is NULL or exists (
239: select 1 from bom_operation_sequences_v bosv
240: where bosv.routing_sequence_id = bor.common_routing_sequence_id
241: and p_process_code = bosv.standard_operation_code
242: and bosv.operation_type = 2)
243: )
269: and (p_tpct_from is NULL or bor.total_product_cycle_time >= p_tpct_from)
270: and (p_tpct_to is NULL or bor.total_product_cycle_time <= p_tpct_to)
271: and (p_lineop_code is NULL or exists (
272: select 1
273: from bom_operation_sequences bos1, bom_standard_operations bso1
274: where bos1.routing_sequence_id = bor.common_routing_sequence_id
275: and p_lineop_code = bso1.operation_code
276: and bos1.standard_operation_id = bso1.standard_operation_id
277: and bso1.organization_id = p_organization_id
279: and bos1.operation_type = 3)
280: )
281: and (p_process_code is NULL or exists (
282: select 1
283: from bom_operation_sequences bos1, bom_standard_operations bso1
284: where bos1.routing_sequence_id = bor.common_routing_sequence_id
285: and p_process_code = bso1.operation_code
286: and bos1.standard_operation_id = bso1.standard_operation_id
287: and bso1.organization_id = p_organization_id
436: ,NULL Return_Status
437: ,NULL Delete_Group_Name
438: ,NULL DG_Description
439: From
440: bom_operation_sequences_v bosv
441: Where
442: bosv.routing_sequence_id = p_routing_sequence_id
443: and ((bosv.effectivity_date <= l_today and nvl(bosv.disable_date,l_today+1) > l_today)
444: or (bosv.effectivity_date > l_today and nvl(bosv.disable_date, bosv.effectivity_date+1) > bosv.effectivity_date))
488: ,'CREATE' Transaction_Type
489: ,NULL Return_Status
490: From
491: bom_operation_networks_v bonv,
492: bom_operation_sequences bos1,
493: bom_operation_sequences bos2
494: Where
495: bonv.routing_sequence_id = p_routing_sequence_id
496: and bonv.from_op_seq_id = bos1.operation_sequence_id
489: ,NULL Return_Status
490: From
491: bom_operation_networks_v bonv,
492: bom_operation_sequences bos1,
493: bom_operation_sequences bos2
494: Where
495: bonv.routing_sequence_id = p_routing_sequence_id
496: and bonv.from_op_seq_id = bos1.operation_sequence_id
497: and ((bos1.effectivity_date <= l_today and nvl(bos1.disable_date,l_today+1) > l_today)
508: standard_operation_id
509: ,standard_operation_code
510: ,operation_type
511: From
512: bom_operation_sequences_v bosv
513: Where
514: routing_sequence_id = p_routing_sequence_id
515: and ((effectivity_date <= l_today and nvl(disable_date,l_today+1) > l_today)
516: or (effectivity_date > l_today and nvl(disable_date, effectivity_date+1) > effectivity_date))
552: Cursor c_op_seq_id(p_rtg_seq_id number, p_op_type number, p_op_seq_num number) Is
553: Select
554: operation_sequence_id
555: From
556: bom_operation_sequences
557: Where
558: routing_sequence_id = p_rtg_seq_id
559: and nvl(operation_type,0) = nvl(p_op_type,0)
560: and operation_seq_num = p_op_seq_num
1260: END LOOP;
1261: end if;
1262: end if;
1263: if l_2_seq_ids.COUNT > 0 then
1264: copy_attach('BOM_OPERATION_SEQUENCES','BOM_OPERATION_SEQUENCES',l_2_seq_ids);
1265: end if;
1266: success := success + 1;
1267: end if;
1268: