DBA Data[Home] [Help]

APPS.BOM_COPY_ROUTING dependencies on BOM_OPERATION_SEQUENCES_S

Line 422: SELECT bom_operation_sequences_s.NEXTVAL,

418: show_lot_attrib,
419: track_multiple_res_usage_dates,
420: check_skill --added for bug 7597474
421: )
422: SELECT bom_operation_sequences_s.NEXTVAL,
423: to_sequence_id,
424: a.operation_seq_num,
425: l_curr_date,
426: a.operation_sequence_id,

Line 1040: from bom_operation_skills SKL, bom_operation_sequences SEQ1, bom_operation_sequences SEQ2

1036: user_id,
1037: user_id,
1038: sysdate
1039:
1040: from bom_operation_skills SKL, bom_operation_sequences SEQ1, bom_operation_sequences SEQ2
1041: where SEQ1.routing_sequence_id = from_sequence_id
1042: and SEQ2.routing_sequence_id = to_sequence_id
1043: and SKL.operation_sequence_id = SEQ1.operation_sequence_id
1044: and SEQ1.operation_seq_num = SEQ2.operation_seq_num

Line 2536: SELECT bom_operation_sequences_s.NEXTVAL,

2532: show_lot_attrib,
2533: track_multiple_res_usage_dates,
2534: check_skill --added for bug 7597474
2535: )
2536: SELECT bom_operation_sequences_s.NEXTVAL,
2537: to_sequence_id,
2538: a.operation_seq_num,
2539: l_curr_date,
2540: a.operation_sequence_id,

Line 2980: from bom_operation_skills SKL, bom_operation_sequences SEQ1, bom_operation_sequences SEQ2

2976: user_id,
2977: user_id,
2978: sysdate
2979:
2980: from bom_operation_skills SKL, bom_operation_sequences SEQ1, bom_operation_sequences SEQ2
2981: where SEQ1.routing_sequence_id = from_sequence_id
2982: and SEQ2.routing_sequence_id = to_sequence_id
2983: and SKL.operation_sequence_id = SEQ1.operation_sequence_id
2984: and SEQ1.operation_seq_num = SEQ2.operation_seq_num