DBA Data[Home] [Help]

APPS.BOM_COPY_BILL dependencies on BOM_OPERATION_SEQUENCES

Line 4964: FROM bom_operation_sequences bos

4960: SET operation_seq_num = 1
4961: WHERE bill_sequence_id = to_sequence_id
4962: AND NOT EXISTS (
4963: SELECT NULL
4964: FROM bom_operation_sequences bos
4965: WHERE routing_sequence_id = to_rtg_seq_id
4966: AND bos.operation_seq_num = bic.operation_seq_num);
4967: END IF;
4968:

Line 5961: bom_operation_sequences bos,

5957: fnd_global.conc_program_id,
5958: sysdate
5959: FROM bom_component_operations bco,
5960: bom_components_b bic,
5961: bom_operation_sequences bos,
5962: bom_copy_explosions_v bev
5963: WHERE bic.bill_sequence_id = to_sequence_id
5964: AND NVL (bic.eco_for_production, 2) = 2
5965: AND bco.component_sequence_id = bic.created_by

Line 6056: bom_operation_sequences bos

6052: fnd_global.conc_program_id,
6053: sysdate
6054: FROM bom_component_operations bco,
6055: bom_inventory_components bic,
6056: bom_operation_sequences bos
6057: WHERE bic.bill_sequence_id = to_sequence_id
6058: AND NVL (bic.eco_for_production, 2) = 2
6059: AND bco.component_sequence_id = bic.created_by
6060: AND bos.routing_sequence_id = to_rtg_seq_id

Line 10599: FROM bom_operation_sequences bos

10595: SET operation_seq_num = 1
10596: WHERE bill_sequence_id = to_sequence_id
10597: AND NOT EXISTS (
10598: SELECT NULL
10599: FROM bom_operation_sequences bos
10600: WHERE routing_sequence_id = to_rtg_seq_id
10601: AND bos.operation_seq_num = bic.operation_seq_num);
10602: END IF;
10603:

Line 11422: bom_operation_sequences bos,

11418: fnd_global.conc_program_id,
11419: sysdate
11420: FROM bom_component_operations bco,
11421: bom_components_b bic,
11422: bom_operation_sequences bos,
11423: bom_copy_explosions_v bev
11424: WHERE bic.bill_sequence_id = to_sequence_id
11425: AND NVL (bic.eco_for_production, 2) = 2
11426: AND bco.component_sequence_id = bic.created_by