drop sequence PROVEEDORES_SEQ; drop sequence USERS_SEQ; drop sequence KPIS_SEQ; drop sequence CATEGORYS_SEQ; drop sequence AREAS_SEQ; drop sequence EV_DETAIL_SEQ; drop sequence USERPROVEEDOR_SEQ; drop sequence NOTIFICATION_SEQ; drop sequence FILE_SEQ; drop sequence EVALUACION_SEQ; drop sequence EVALUACION_PROVEEDOR_SEQ; drop sequence EVALUACION_DET_COMMENTS_SEQ; drop sequence SCORECARD_PROVIDER_SEQ; drop sequence EVALUACION_DET_SEQ; drop sequence SCORECARD_PROVIDER_MONTH_SEQ; drop sequence PLAN_ACCION_SEQ; drop sequence PLAN_ACCION_SEQ_DET; drop sequence PROVEEDORES_AGENDA_SEQ; DROP TABLE AUTHORITIES CASCADE CONSTRAINTS; DROP TABLE ARCHIVOS CASCADE CONSTRAINTS; drop table AREAS CASCADE CONSTRAINTS; drop table categorias CASCADE CONSTRAINTS; drop table file_item CASCADE CONSTRAINTS; drop table kpi CASCADE CONSTRAINTS; drop table log CASCADE CONSTRAINTS; drop table notification_template CASCADE CONSTRAINTS; drop table plan_accion_commentarios CASCADE CONSTRAINTS; drop table plan_accion_det CASCADE CONSTRAINTS; drop table plan_accion CASCADE CONSTRAINTS; drop table proveedor_agenda CASCADE CONSTRAINTS; drop table scorecard_provider_month CASCADE CONSTRAINTS; drop table scorecard_provider CASCADE CONSTRAINTS; DROP TABLE SCORECARD_PROVIDER_COMMENTS CASCADE CONSTRAINTS; drop table proveedores CASCADE CONSTRAINTS; drop table roles_permisos CASCADE CONSTRAINTS; drop table users_roles CASCADE CONSTRAINTS; drop table users_proveedores CASCADE CONSTRAINTS; drop table users CASCADE CONSTRAINTS; drop table evaluacion CASCADE CONSTRAINTS; drop table evaluacion_det CASCADE CONSTRAINTS; drop table evaluacion_det_commentarios CASCADE CONSTRAINTS; drop table evaluacion_proveedor CASCADE CONSTRAINTS; --drop procedure D_EVAL_GLOBAL_MONTH; --drop procedure DASH_GLOBAL_BY_KPI; --drop procedure DASH_GLOBAL_BY_KPI_MONTH; --drop procedure DASHBOARD_GENERATESCOREYEAR; --drop procedure GET_DETAIL_GLOBAL; --drop procedure GET_DETAIL_GLOBAL_MONTH; --drop procedure GET_DETAIL_MONTH; --drop procedure GET_RESUME_LASTEST_MONTHS; --drop procedure GET_RESUME_SCORE_AREA; --drop procedure GET_SCOREPRO_CATEGORY_SCORES; --drop procedure P_GET_ACTION_PLAN_STATUS; --drop procedure P_GET_DETAIL_BY_PROVIDER; --drop procedure P_GET_GLOBAL_AVG; --drop procedure P_GET_PROGRESS_ACTION_PLAN; --drop procedure P_GET_TREND_GLOBAL_MONTH; --drop procedure PC_CREATE_UP_SCORECARD;