se me duplican unos valores en una consulta con union
Publicado por Luis Rodriguez (1 intervención) el 07/10/2019 20:44:36
por favor su ayuda con esto
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
SELECT * FROM (
SELECT
'Pesos' AS MonedaImp,
A.[PONUMBER] AS OCNum,
CASE A.[POSTATUS]
WHEN 1 THEN 'Nuevo' WHEN 2 THEN 'Publicado' WHEN 3 THEN 'Cambiar Orden' WHEN 4 THEN 'Recibido' WHEN 5 THEN 'Cerrado' WHEN 6 THEN 'Cancelado' END AS EstatusOC ,POA40003.POA_PO_Approval_Status AS EstadoAprob,
CASE A.[POTYPE]
WHEN 1 THEN 'Estandar' WHEN 2 THEN 'Dropshipping' WHEN 3 THEN 'BLANKET' WHEN 4 THEN 'BLANKET DROP-SHIP ' END AS TipoOC ,A.[DOCDATE] AS FechaOC,
A.[VENDORID] AS IdProveedor,
A.[VENDNAME] AS NombreProveedor,
A.PYMTRMID AS TermPago,
A.[CURNCYID] AS IdMoneda,
A.XCHGRATE AS TasaCambio,
A.REQDATE AS FechaRequerida,
A.CMPNYNAM AS Ent_NombComp,
A.CONTACT AS Ent_Contacto,
A.ADDRESS1 AS Ent_DireccLin1,
A.ADDRESS2 AS Ent_DireccLin2,
A.ADDRESS3 AS Ent_DireccLin3,
A.CITY AS Ent_Ciudad,
A.STATE AS Ent_Departamento,
A.COUNTRY AS Ent_Pais,
SUBSTRING(A.PHONE1, 4, 7) AS Ent_Telefono1,
A.PHONE2 AS Ent_Telefono2,
A.PHONE3 AS Ent_Telefono3,
A.PURCHCMPNYNAM AS Prov_Nombre,
A.PURCHCONTACT AS Prov_Contacto,
A.PURCHADDRESS1 AS Prov_DireccLin1,
A.PURCHADDRESS2 AS Prov_DireccLin2,
A.PURCHADDRESS3 AS Prov_DireccLin3,
A.PURCHCITY AS Prov_Ciudad,
A.PURCHSTATE AS Prov_Departamento,
A.PURCHCOUNTRY AS Prov_Pais,
SUBSTRING(A.PURCHPHONE1, 4, 7) AS Prov_Telefono1,
SUBSTRING(A.PURCHPHONE2, 4, 7) AS Prov_Telefono2,
SUBSTRING(A.PURCHPHONE3, 4, 7) AS Prov_Telefono3,
B.LineNumber AS LineaNum,
B.VNDITNUM AS IdArticuloProvd,
B.VNDITDSC AS NombArticuloProv,
B.UOFM AS UdeM,
B.QTYORDER AS Cantidad,
B.UNITCOST AS CostoUnit,
B.EXTDCOST AS CostoTot,
POP10150.CMMTTEXT AS Coment_OC,
A.COMMNTID AS ComentLinea,
A.SUBTOTAL AS SubTotal,
A.TRDISAMT AS Descuento,
A.TAXAMNT AS Impuestos,
A.FRTAMNT AS Flete,
A.MSCCHAMT AS Micelaneos,
POP00101.DSCRIPTN AS DesComprador,
POA40003.POA_Created_By AS ID_Creador_OC,
POA40003.POA_Approved_By AS ID_Aprobado_OC,
IV40700.LOCNCODE AS ID_Bodega,
IV40700.LOCNDSCR AS Desc_Bodega,
B.PRMSHPDTE AS fecent,
B.ITEMDESC AS Desc_LineaPO FROM dbo.POP10100 AS AINNER JOIN dbo.POP10110 AS B ON A.[PONUMBER] = B.[PONUMBER]
LEFT OUTER JOIN dbo.POP10500 AS C ON B.[PONUMBER] = C.[PONUMBER] AND B.[ORD] = C.[POLNENUM]
LEFT OUTER JOIN dbo.POP30310 AS D ON C.[PONUMBER] = D.[PONUMBER] AND C.[RCPTLNNM] = D.[RCPTLNNM] AND C.POPRCTNM = D.POPRCTNM
LEFT OUTER JOIN dbo.POP30300 AS E ON D.[POPRCTNM] = E.[POPRCTNM]
LEFT OUTER JOIN dbo.POA40003 ON B.PONUMBER = POA40003.PONUMBER
LEFT OUTER JOIN POP10150 ON B.PONUMBER = POP10150.POPNUMBE
INNER JOIN POP00101 ON A.BUYERID = POP00101.BUYERID
INNER JOIN IV40700 ON B.LOCNCODE = IV40700.LOCNCODE
) PESOWHERE PESO.OCNum IN (@OCompra) AND PESO.EstadoAprob='2' AND MonedaImp='Pesos'
Valora esta pregunta
0