ARTICULO NOMBRE EXISTENCIA COST_PROM TOTAL

01.B.34 TUBO ROSC/BIPLAST 3/4"X6MT 0.34 4.5349 1.54

01D.T110 TEE REFORZADO 110 168 1.84 309.12
01F.C3245 CODO TERMOFUSION 32*45º (R-133) 53 0.543 28.78
01F.CIH32-12 CODO INSERTO HEM.TERMOF. 32 X1/2" 1 1.1736 1.17
01H.C11245 CODO IPS 1½*45 (R-335) 30 0 0.00
01H.NE11410 NEPLO IPS 11/4 * 10CM 1 2.28 2.28
01M.C2590 CODO MOL 250*90 3 49.11 147.33
01R.B112 BUSHING ROSCA/ROS. 1"*1/2" 1 0.2191 0.22
01R.C11490 CODO IM R/R 1¼"*90 16 0.9199 14.72
01R.C1290 CODO IM R/R 1/2"*90 1 0.2287 0.23
01R.C190 CODO IM R/R 1"*90 1 0.7294 0.73
01R.N114 NUDO IM R/R 1¼" 1 1.7985 1.80
01R.N12 NUDO IM R/R 1/2" 45 0.87 39.15
01R.T1 TEE IM R/R 1" 1 0.7521 0.75
01R.T112 TEE IM R/R 1½" 1 1.8586 1.86
01R.U114 UNION IM R/R 1¼" 1 0.7321 0.73
01T.TH34 ADAPTADOR 3/4" PLASTIGAMA 10 0.72 7.20
02.JPR12 MANG/JARD. C/ACOP 1/2" (20M-CAR) 0.94 8.5305 8.02
02A.I1 ABRAZ/IDEAL 1" 40 1.5434 61.74
02F.TS12 TEE SEN FLEX 1/2" 1 0.0827 0.08
03M.C10250 MALLA CERRAM. 50X10 10/250 2 119.6956 239.39
04C.CS1290 CODO COBRE SO-HI 1/2" * 90 1 1.6223 1.62
04C.P12 PUENTE COBRE 1/2 7 3.52 24.64
04G.B43 BUSHING 4"*3" HG 2 4.41 8.82
04G.CC1 CODO CACHIM HG 1" 62 0.5578 34.58
04G.NB4 NUDO PATEN/BRON 4" 4 20.8575 83.43
04G.P1 PUENTE HG 1" 57 0.7734 44.08
04G.R11434 REDUCC HG 1¼"*3/4" 8 0.505 4.04
04G.TH4 TAPON HEMBRA HG 4" 8 3.9638 31.71
04G.TM3 TAPON MACHO HG 3" 8 2.02 16.16
04G.TM4 TAPON MACHO HG 4" 7 3.6143 25.30
04G.TR112 TEE/REDU HG 1"*1/2" 1 0.5575 0.56
04G.TRI34 TRICODO HG 3/4" 13 0.6636 8.63
05C.TE223 INCABLE ENTORCHAD AWG 2*23 0.41 19.071 7.82
05F.F20 TUBO FLUORECT SYLVANIA 20W 1 0.8921 0.89
05T.EXTED &TOMA.EXE TELF.2"ERV. 36112 98 1.3834 135.57
05T.EXTEDF &TOMA DOBLE TLF.2"ER FOSF 36325 24 1.2342 29.62
08.16.201 JGO.LAVABO 8" MALENA 16 1 126.7589 126.76
08.16.221 LLAVE LAVABO MALENA CR (E220/16) 2 14.928 29.86
08.16L.103CO JGO.DUCHA-TINA MALEN II CR-ORO 4 99.7057 398.82
08.16L.109 JGO. DUCHA MALENA II CR 1 65.68 65.68
08.26.190CO MEZCL. S/SIFON LUMINA CR.ORO 1 24.9424 24.94
08.26.192CO MEZCL.LAVAB.LUMIN.4"CR-ORO 8 33.005 264.04
08.26.413 JGO.P´COCINA MESA LUMINA CR 1 27.02 27.02
08.27.192 JGO. LAVABO PISTON FIORI 4 35.3 141.20
08.65.107 MEZCLA/DUCHA TINA T/C 65 3 39.8918 119.68
08.71.413 JGO.8" MESA SOB/PUEST.CAPRI 2 24.7568 49.51
08.78.192 MEZC/LAV AUT VERS 78 1 51.1038 51.10
08.P.365/11 FLUXOMETRO P/URINARIO CR 1 120.705 120.71
08.RE.593/17/03 REJILLA LC 50X70X40 COMBINADO 5 3.49 17.45
08.SD.246/08 CONJUNTO DESAGUE 1-1/4" CR 2 18.005 36.01
09.S.208AO LAVABO GALA AZUL COBALTO 2 26.4476 52.90
09.S.210BO LAVABO FERRARA C/UÑETA BONE 2 13.645 27.29
09.S.218ME LAVABO SIENA C/PED.MERLOT 1 29.615 29.62
09.S.247B LAVABO VESSEL BERLIOZ - BL 4 33.9025 135.61
09.SA.101/01AM ASIENTO STD. AZUL MEDITERRANEO 1 6.5832 6.58
09.SA.P28 PERNOS TRENTO 1 1.33 1.33
09.SA.TLD/AC TAPA DEPOSITO LIDO AZUL CIELO 1 4.24 4.24
10.CI.EW60 COCINA EW/60 4G AI AL (40218050) 1 343.08 343.08
10L.BE34 POCETA BE 34.37 (10125004) 2 51.17 102.34
10L.P1P100S LAVADER.PREM/SOB.SEGUN 100X50 1 23.2925 23.29
10L.TW1CI TEKAWAY 1C1E IZQ+GRIFO (11124031) 2 73.1 146.20
10L.TW2CD TEKAWAY 2C1E DER+GRIFO (11124032) 12 103.975 1247.70
10L.TW2CI TEKAWAY 2C1E IZQ+GRIFO (11124033) 3 94.33 282.99
10L.U1C1E FREG. UNIVERSO 1C 1E REV (10120025) 3 54.74 164.22
10L.U2C1E FREG. UNIVERSO 2C 1E REV (10120028) 8 83.0069 664.06
10T.ER250 &TANQUE EUROLIT RECTAN. 250 LT S/TAPA 1 25.99 25.99
10T.TRC1000 REP/TAPA CILINDRICO 1000LT 1 7.44 7.44
13.BP.BD30 BALANZA DIGITAL Y CONTEO 30 5 45.676 228.38
13.BP.LLPLA12 LLAVE AJUST. P/LORO AISLADA 12" 9 4.9742 44.77
13.GCA3 CEPILLO DE ALAMBRE 11*3 HILERAS 1 0.9859 0.99
13K.MPT MASCARILLA PA`POLVO TRIANGULAR 16 0.516 8.26
13K.TRJT121 JGO. TERRAJA 4PZ. 1/2" A 1" P/T HG (T)13070 1 58.685 58.69
13K.TRRIN REBAJADORA 1200W INDUSTRIAL (T) 16606 1 78.91 78.91
13K.TRSCP7 SIERRA CIRCULAR 7-1/4" 1200W (T) 16434 2 58.465 116.93
15.AD.NE4 NEUTRALIZADOR 4KG 6 4.14 24.84
15.SK.110 SIKA-1 10KG 1 8.8226 8.82
15.SK.EIL25 EMPASTE INTERIORES LISTO 25KG 1 8.64 8.64
15.SK.SE4 SIKA SELLADOR 4KG 1 8.6073 8.61
17.C.IV1214 SIFON INC. T/V 11/2-11/4 FLEX R/PLA 9 2.034 18.31
20.F.LT CONO SEGURIDAD CAUCHO C/REFLECTIVA 18" 5 5.58 27.90
22.I.BPTM BONDEX PORCELANATO TM 25KG 95 8.12 771.40
22.I.PP-AL2 &PORCELANA ALMENDRA PISO 2KG 1 0.84 0.84
915.69 7468.24
select *
from(
select
t.articulo
articulo,t.no
mbre,
(pkgeneral.f
_consumo_p
romedio(t.gr
ar_compani
a,

t.grar_clase,

t.grar_codigr
up,

t.articulo,

trunc(to_dat
e('01-01-
14','dd-mm-
rrrr')),

trunc(to_dat
e('31-07-
14','dd-mm-
rrrr')),

null))
consumo,pk
general.f_art