teste

-- EXCLUIR RDM 0905/2011
DELETE FROM estoque WHERE IRD_ID = 14563;
DELETE FROM itensrdm WHERE RDM_ID = 12663;
-- EXCLUIR MOVIMENTO DO ESTOQUE
UPDATE estoque SET est_qtdatual = (est_qtdatual + 1000) , EST_VALORRESIDUAL = 0,
                    est_valorestoquemedio  = 3.18
   WHERE ID IN (12021,12093,12094,12095,12169,12289);
DELETE FROM programacaordm WHERE rdm_id = 12663;
DELETE FROM historicoetapas WHERE rdm_id = 12663;
DELETE FROM RDM WHERE id = 12663;
 
--EXCLUIR MOVIMENTO DO ESTOQUE
DELETE FROM estoque WHERE PND_ID = 2721;
-- EXCLUIR NDE 0078/2011
DELETE FROM produtonde WHERE nde_id = 1661;
DELETE FROM notadeentrada WHERE ID = 1661;
COMMIT;
 
SELECT * FROM estoque e WHERE pro_id = 2261 ORDER BY id;
 
SELECT e.*, r.rdm_idsequencia, r.id idrdm FROM estoque e
INNER JOIN itensrdm i ON (e.ird_id = i.id)
INNER JOIN rdm r ON (r.id = i.rdm_id)
WHERE e.pro_id = 2261 AND e.id >=11881 
ORDER BY id;
 
SELECT * FROM itensrdm WHERE pro_id = 2261;
 
SELECT e.*, n.nde_numero, p.nde_id idnde FROM estoque e
INNER JOIN produtonde p ON (e.pnd_id = p.id)
INNER JOIN notadeentrada n ON (n.id = p.nde_id)
WHERE e.pro_id = 2261 AND e.id >=11881 
ORDER BY id;