-
Notifications
You must be signed in to change notification settings - Fork 5
/
CLBD_PRC
142 lines (141 loc) · 3.83 KB
/
CLBD_PRC
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
--#CKFK 20211108 Agregué el delete de las trans_manufactura_picking
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[CLBD_PRC]
AS
BEGIN
DELETE FROM transacciones_log
DELETE FROM trans_ubic_tarima
DELETE FROM trans_ubic_hh_se
DELETE FROM trans_ubic_hh_op
DELETE FROM trans_ubic_hh_enc
DELETE FROM trans_ubic_hh_det
DELETE FROM trans_ubic_hh_stock
DELETE FROM trans_tras_op
DELETE FROM trans_tras_enc
DELETE FROM trans_tras_det
DELETE FROM trans_re_op
DELETE FROM trans_re_oc
DELETE FROM trans_re_img
DELETE FROM trans_re_fact
DELETE FROM producto_pallet
DELETE FROM trans_re_enc
DELETE FROM trans_re_det_parametros
DELETE FROM trans_re_det_infraccion
DELETE FROM trans_re_det
DELETE FROM trans_picking_ubic
DELETE FROM trans_picking_op
DELETE FROM trans_picking_enc
DELETE FROM trans_picking_det_parametros
DELETE FROM trans_picking_det
DELETE FROM trans_manufactura_picking
DELETE FROM trans_manufactura_det
DELETE FROM trans_manufactura_enc
DELETE FROM trans_pe_det
DELETE FROM trans_pe_enc
DELETE FROM trans_oc_pol
DELETE FROM trans_oc_imagen
DELETE FROM trans_oc_det_lote
DELETE FROM trans_oc_det
DELETE FROM trans_oc_enc
DELETE FROM trans_movimientos
DELETE FROM trans_inventario_enc
DELETE FROM trans_inventario_det
DELETE FROM trans_despacho_enc
DELETE FROM trans_despacho_det
DELETE FROM tarea_hh
DELETE FROM stock_se_rec
DELETE FROM stock_se
DELETE FROM stock_res_se
DELETE FROM stock_res
DELETE FROM stock_rec
DELETE FROM stock_parametro
DELETE FROM stock_hist
DELETE FROM stock
DELETE FROM trans_inv_detalle
DELETE FROM trans_inv_resumen
DELETE FROM trans_inv_reconteo
DELETE FROM trans_inv_ciclico
DELETE FROM trans_inv_ciclico_ubic
DELETE FROM trans_inv_tramo
DELETE FROM trans_inv_operador
DELETE FROM trans_inv_stock
DELETE FROM trans_inv_stock_prod
DELETE FROM trans_inv_enc
DELETE FROM Appointments
DELETE FROM i_nav_ejecucion_det_error
DELETE FROM i_nav_ejecucion_res
DELETE FROM i_nav_ejecucion_enc
DELETE FROM I_nav_transacciones_out
END
--#CKFK 20211108 Agregué el delete de stock_jornada
ALTER PROCEDURE [dbo].[CLBD_PRC]
AS
BEGIN
DELETE FROM stock_jornada
DELETE FROM transacciones_log
DELETE FROM trans_ubic_tarima
DELETE FROM trans_ubic_hh_se
DELETE FROM trans_ubic_hh_op
DELETE FROM trans_ubic_hh_enc
DELETE FROM trans_ubic_hh_det
DELETE FROM trans_ubic_hh_stock
DELETE FROM trans_tras_op
DELETE FROM trans_tras_enc
DELETE FROM trans_tras_det
DELETE FROM trans_re_op
DELETE FROM trans_re_oc
DELETE FROM trans_re_img
DELETE FROM trans_re_fact
DELETE FROM producto_pallet
DELETE FROM trans_re_enc
DELETE FROM trans_re_det_parametros
DELETE FROM trans_re_det_infraccion
DELETE FROM trans_re_det
DELETE FROM trans_picking_ubic
DELETE FROM trans_picking_op
DELETE FROM trans_picking_enc
DELETE FROM trans_picking_det_parametros
DELETE FROM trans_picking_det
DELETE FROM trans_pe_det
DELETE FROM trans_pe_enc
DELETE FROM trans_oc_pol
DELETE FROM trans_oc_imagen
DELETE FROM trans_oc_det_lote
DELETE FROM trans_oc_det
DELETE FROM trans_oc_enc
DELETE FROM trans_movimientos
DELETE FROM trans_inventario_enc
DELETE FROM trans_inventario_det
DELETE FROM trans_despacho_enc
DELETE FROM trans_despacho_det
DELETE FROM tarea_hh
DELETE FROM stock_se_rec
DELETE FROM stock_se
DELETE FROM stock_res_se
DELETE FROM stock_res
DELETE FROM stock_rec
DELETE FROM stock_parametro
DELETE FROM stock_hist
DELETE FROM stock
DELETE FROM trans_inv_detalle
DELETE FROM trans_inv_resumen
DELETE FROM trans_inv_reconteo
DELETE FROM trans_inv_ciclico
DELETE FROM trans_inv_ciclico_ubic
DELETE FROM trans_inv_tramo
DELETE FROM trans_inv_operador
DELETE FROM trans_inv_stock
DELETE FROM trans_inv_stock_prod
DELETE FROM trans_inv_enc
DELETE FROM Appointments
DELETE FROM i_nav_ejecucion_det_error
DELETE FROM i_nav_ejecucion_res
DELETE FROM i_nav_ejecucion_enc
DELETE FROM I_nav_transacciones_out
DELETE FROM trans_movimiento_pallet
DELETE FROM dbo.trans_servicio_det
DELETE FROM dbo.trans_servicio_enc
END