/*==============================================================*/
/* DBMS name:      ORACLE Version 9i                            */
/* Created on:     29/01/2008 04:29:44 p.m.                     */
/*==============================================================*/


DROP VIEW V_INVMOV;

DROP VIEW INV_VISTRASLADO;

DROP VIEW INV_EXIST_BODEGA;

DROP TABLE ARTICULOSVTMP CASCADE CONSTRAINTS;

DROP TABLE INVETIQCAMPO CASCADE CONSTRAINTS;

DROP TABLE INVETIQUETA CASCADE CONSTRAINTS;

DROP TABLE INVLOGX CASCADE CONSTRAINTS;

DROP TABLE INV_ARTABC_TMP CASCADE CONSTRAINTS;

DROP TABLE INV_CONTEO CASCADE CONSTRAINTS;

DROP TABLE INV_MENSUALTMP CASCADE CONSTRAINTS;

DROP TABLE INV_PENMOVIMIENTO CASCADE CONSTRAINTS;

DROP TABLE INV_TABLADESC CASCADE CONSTRAINTS;

DROP TABLE INV_DETALLES CASCADE CONSTRAINTS;

DROP TABLE INV_DETTABLACOMSN CASCADE CONSTRAINTS;

DROP TABLE INV_ACUM_PERIODO CASCADE CONSTRAINTS;

DROP TABLE INV_ARTIC_CODBAR CASCADE CONSTRAINTS;

DROP TABLE INV_ARTIC_LOCBOD CASCADE CONSTRAINTS;

DROP TABLE INV_ARTIC_MEDIDA CASCADE CONSTRAINTS;

DROP TABLE INV_ARTIC_PROV CASCADE CONSTRAINTS;

DROP TABLE INV_ARTICULO CASCADE CONSTRAINTS;

DROP TABLE INV_ARTICULO_CON_LOTE CASCADE CONSTRAINTS;

DROP TABLE INV_ARTICULOBOD CASCADE CONSTRAINTS;

DROP TABLE INV_ATRIBUTOS CASCADE CONSTRAINTS;

DROP TABLE INV_BODEGA CASCADE CONSTRAINTS;

DROP TABLE INV_CLASE CASCADE CONSTRAINTS;

DROP TABLE INV_COMB_LCM CASCADE CONSTRAINTS;

DROP TABLE INV_CONCEPMOVTO CASCADE CONSTRAINTS;

DROP TABLE INV_CONSEC_MOVTOS CASCADE CONSTRAINTS;

DROP TABLE INV_DEPTOS CASCADE CONSTRAINTS;

DROP TABLE INV_DETMOVDESP CASCADE CONSTRAINTS;

DROP TABLE INV_DETMOVIMIENTO CASCADE CONSTRAINTS;

DROP TABLE INV_DETSOLTRASLADO CASCADE CONSTRAINTS;

DROP TABLE INV_DETTOMAFIS CASCADE CONSTRAINTS;

DROP TABLE INV_DIFTOMAFIS CASCADE CONSTRAINTS;

DROP TABLE INV_DINTOMAFIS CASCADE CONSTRAINTS;

DROP TABLE INV_ENCABMOVIMIENTO CASCADE CONSTRAINTS;

DROP TABLE INV_ENCABTABLACOMSN CASCADE CONSTRAINTS;

DROP TABLE INV_ENCABTRASLADO CASCADE CONSTRAINTS;

DROP TABLE INV_ENCMOVDESP CASCADE CONSTRAINTS;

DROP TABLE INV_ENCSOLTRASLADO CASCADE CONSTRAINTS;

DROP TABLE INV_GRUPO CASCADE CONSTRAINTS;

DROP TABLE INV_GRUPODET CASCADE CONSTRAINTS;

DROP TABLE INV_HIST_DET_MOVTO CASCADE CONSTRAINTS;

DROP TABLE INV_HIST_ENC_MOVTO CASCADE CONSTRAINTS;

DROP TABLE INV_HIST_LOTE CASCADE CONSTRAINTS;

DROP TABLE INV_LINEA CASCADE CONSTRAINTS;

DROP TABLE INV_LOC CASCADE CONSTRAINTS;

DROP TABLE INV_LOTE CASCADE CONSTRAINTS;

DROP TABLE INV_LOTE_ARTIC_BODEGA CASCADE CONSTRAINTS;

DROP TABLE INV_MARCA CASCADE CONSTRAINTS;

DROP TABLE INV_MEDIDA CASCADE CONSTRAINTS;

DROP TABLE INV_MOVGRUPO CASCADE CONSTRAINTS;

DROP TABLE INV_MOVGRUPODET CASCADE CONSTRAINTS;

DROP TABLE INV_NIVLOC CASCADE CONSTRAINTS;

DROP TABLE INV_NOMLOC CASCADE CONSTRAINTS;

DROP TABLE INV_PARAMETRO CASCADE CONSTRAINTS;

DROP TABLE INV_SUSTITUTO CASCADE CONSTRAINTS;

DROP TABLE INV_TABLABONIFIC CASCADE CONSTRAINTS;

DROP TABLE INV_TIPINV CASCADE CONSTRAINTS;

DROP TABLE INV_TMP_CRITERIOS CASCADE CONSTRAINTS;

DROP TABLE INV_TOMAFIS CASCADE CONSTRAINTS;

DROP SEQUENCE SEQ_TOMAFIS;

