[Home] [Help]
289: END IF;
290:
291: g_exception_tracking_msg := 'Querying BOM_OPERATION_SEQUENCES for fm_values';
292:
293: SELECT standard_operation_id,department_id,operation_Sequence_id
294: INTO x_fm_std_op_id,x_fm_dept_id,x_fm_op_seq_id
295: FROM BOM_OPERATION_SEQUENCES
296: WHERE routing_sequence_id = p_rout_seq_id
297: AND operation_seq_num = p_prev_op_seq_num;
304: ELSE
305:
306: g_exception_tracking_msg := 'Querying BOM_OPERATION_SEQUENCES for to_ values';
307:
308: SELECT standard_operation_id,department_id,operation_Sequence_id
309: INTO x_to_std_op_id,x_to_dept_id,x_to_op_seq_id
310: FROM BOM_OPERATION_SEQUENCES
311: WHERE routing_sequence_id = p_rout_seq_id
312: AND operation_seq_num = p_op_seq_num;
1233:
1234: SELECT operation_code
1235: INTO l_op_code
1236: FROM wsm_operation_details_v
1237: WHERE standard_operation_id = l_to_std_op_id
1238: AND organization_id = p_org_id;
1239:
1240: IF (g_debug_level <= 1) THEN
1241: cln_debug_pub.Add('l_op_code : '|| l_op_code, 1);