APPS.WSM_SERIAL_SUPPORT_PVT dependencies on WIP_OPERATIONS

Line 932: FROM wip_operations

928: l_stmt_num := 40;
929:
930: SELECT max(operation_seq_num)
931: INTO l_op_seq_num
932: FROM wip_operations
933: WHERE wip_entity_id = p_wip_entity_id
934: AND ((quantity_in_queue <> 0
935: OR quantity_running <> 0
936: OR quantity_waiting_to_move <> 0)

Line 951: FROM wip_operations

947: quantity_waiting_to_move
948: INTO l_qty_queue,
949: l_qty_run,
950: l_qty_tomove
951: FROM wip_operations
952: WHERE wip_entity_id = p_wip_entity_id
953: AND operation_seq_num = l_op_seq_num;
954:
955: l_stmt_num := 60;

Line 5211: -- FROM wip_operations

5207: and we.organization_id = p_organization_id;
5208:
5209: -- SELECT max(operation_seq_num)
5210: -- INTO l_op_seq_num
5211: -- FROM wip_operations
5212: -- WHERE wip_entity_id = p_wip_entity_id
5213: -- AND (quantity_in_queue <> 0
5214: -- OR quantity_waiting_to_move <> 0
5215: -- );

Line 5255: -- FROM wip_operations

5251: l_stmt_num := 35;
5252:
5253: -- SELECT max(operation_seq_num)
5254: -- INTO l_op_seq_num
5255: -- FROM wip_operations
5256: -- WHERE wip_entity_id = p_wip_entity_id
5257: -- AND (quantity_in_queue <> 0
5258: -- OR quantity_waiting_to_move <> 0
5259: -- );