APPS.M4R_7B1_WSM_IN dependencies on WIP_OPERATIONS

Line 679: g_exception_tracking_msg := 'Querying wip_operations for l_op_seq_num';

675: cln_debug_pub.Add('-------- Entering procedure GET_INTRAOPERATION_STEP --------',2);
676: cln_debug_pub.Add('p_wip_entity_id : ' || p_wip_entity_id, 2);
677: END IF;
678:
679: g_exception_tracking_msg := 'Querying wip_operations for l_op_seq_num';
680:
681: SELECT max(operation_seq_num)
682: INTO x_op_seq_num
683: FROM wip_operations

Line 683: FROM wip_operations

679: g_exception_tracking_msg := 'Querying wip_operations for l_op_seq_num';
680:
681: SELECT max(operation_seq_num)
682: INTO x_op_seq_num
683: FROM wip_operations
684: WHERE wip_entity_id = p_wip_entity_id
685: AND ((quantity_in_queue <> 0 OR quantity_running <> 0 OR quantity_waiting_to_move <> 0 ) OR
686: ( quantity_in_queue = 0 AND quantity_running = 0 AND quantity_waiting_to_move = 0
687: AND quantity_scrapped = quantity_completed AND quantity_completed > 0 )

Line 690: g_exception_tracking_msg := 'Querying wip_operations for quantities';

686: ( quantity_in_queue = 0 AND quantity_running = 0 AND quantity_waiting_to_move = 0
687: AND quantity_scrapped = quantity_completed AND quantity_completed > 0 )
688: ); -- this picks up te max op seq, if only scraps at ops
689:
690: g_exception_tracking_msg := 'Querying wip_operations for quantities';
691:
692: SELECT quantity_in_queue,quantity_running,quantity_waiting_to_move
693: INTO l_qty_Q,l_qty_RUN,l_qty_TM
694: FROM wip_operations

Line 694: FROM wip_operations

690: g_exception_tracking_msg := 'Querying wip_operations for quantities';
691:
692: SELECT quantity_in_queue,quantity_running,quantity_waiting_to_move
693: INTO l_qty_Q,l_qty_RUN,l_qty_TM
694: FROM wip_operations
695: WHERE wip_entity_id = p_wip_entity_id
696: AND operation_seq_num = x_op_seq_num;
697:
698: IF l_qty_Q > 0 THEN