CARMINA USA iBoutique

Consulta per saber els articles que falten a l’iBoutique de CARMINA USA relatius a una solicitud de transferencia d’estoc de SAP Business One

SELECT T0.ItemCode,T0.Quantity,T1.ItemCode,T1.ItemName,T1.CreateDate,T1.UpdateDate,T1.U_ARGNS_MOD,T1.U_ModDesc,T1.U_ARGNS_COL,T1.U_ColDesc,T1.U_ARGNS_SIZE 
FROM WTQ1 T0 
LEFT JOIN ( 
  SELECT o.ItemCode, o.ItemName, o.U_ARGNS_MOD, o.U_ARGNS_COL, a.U_ModDesc, c.U_ColDesc, 
    o.U_ARGNS_SEASON, ec.Code, o.U_ARGNS_SIZE, o.U_ARGNS_SIZEVO, o.CodeBars, o.U_ARGNS_LineCode, 
    a.U_Brand, a.U_ModGrp, a.U_Comments, a.U_CollCode, a.U_Division, o.U_ARGNS_SCL, o.SellItem, 
    a.U_Pic, o.validFor, o.validFrom, o.validTo, isnull(vat.Rate,-1) Rate, isnull(tax.Rate,-1) 
    TaxRate, o.InvntItem, o.FrgnName, o.SuppCatNum, o.ItmsGrpCod, o.CreateDate, o.UpdateDate 
  FROM OITM o 
  LEFT JOIN OITB g ON g.ItmsGrpCod=o.ItmsGrpCod and g.U_INTRX_FM_DBOUTI='S' 
  LEFT JOIN [@ARGNS_MODEL] a ON a.U_ModCode = o.U_ARGNS_MOD AND o.SellItem = 'Y' 
  LEFT JOIN [@ARGNS_MODEL_COLOR] mc ON mc.Code = a.Code and mc.U_ColCode=o.U_ARGNS_COL 
  LEFT JOIN [@ARGNS_COLOR] c ON mc.U_ColCode = c.U_ColCode 
  LEFT JOIN [@ARGNS_MODEL_SIZE] sc ON sc.Code = a.Code and sc.U_SizeCod= o.U_ARGNS_SIZE 
  LEFT JOIN [@ARGNS_SCALE] ec ON ec.U_SclCode = sc.U_SclCode 
  LEFT JOIN [@ARGNS_SIZE] az on az.Code = ec.Code and az.U_SizeCode=o.U_ARGNS_SIZE 
  LEFT JOIN OVTG vat on vat.Code=o.VatGourpSa LEFT JOIN OSTC tax on tax.Code=o.TaxCodeAR 
  WHERE o.SellItem='Y') T1 on T1.ItemCode=T0.ItemCode 
WHERE T0.DocEntry=522 
ORDER BY T0.LineNum

SELECT T0."ItemCode",T0."Quantity"
,T1."ItemCode",T1."ItemName",T1."CreateDate",T1."UpdateDate"
,T1."U_ARGNS_MOD",T1."U_ModDesc",T1."U_ARGNS_COL",T1."U_ColDesc",T1."U_ARGNS_SIZE" 
FROM WTQ1 T0 
JOIN OWTQ T2 on T2."DocEntry"=T0."DocEntry"
LEFT JOIN ( 
  SELECT o."ItemCode", o."ItemName", o."U_ARGNS_MOD", o."U_ARGNS_COL", a."U_ModDesc", c."U_ColDesc", 
    o."U_ARGNS_SEASON", ec."Code", o."U_ARGNS_SIZE", o."U_ARGNS_SIZEVO", o."CodeBars", o."U_ARGNS_LineCode", 
    a."U_Brand", a."U_ModGrp", a."U_Comments", a."U_CollCode", a."U_Division", o."U_ARGNS_SCL", o."SellItem", 
    a."U_Pic", o."validFor", o."validFrom", o."validTo", IFNULL(vat."Rate",-1) Rate, IFNULL(tax."Rate",-1) 
    TaxRate, o."InvntItem", o."FrgnName", o."SuppCatNum", o."ItmsGrpCod", o."CreateDate", o."UpdateDate" 
  FROM OITM o 
  LEFT JOIN OITB g ON g."ItmsGrpCod"=o."ItmsGrpCod" and g."U_INTRX_FM_DBOUTI"='S' 
  LEFT JOIN "@ARGNS_MODEL" a ON a."U_ModCode" = o."U_ARGNS_MOD" AND o."SellItem" = 'Y' 
  LEFT JOIN "@ARGNS_MODEL_COLOR" mc ON mc."Code" = a."Code" and mc."U_ColCode"=o."U_ARGNS_COL" 
  LEFT JOIN "@ARGNS_COLOR" c ON mc."U_ColCode" = c."U_ColCode" 
  LEFT JOIN "@ARGNS_MODEL_SIZE" sc ON sc."Code" = a."Code" and sc."U_SizeCod"= o."U_ARGNS_SIZE" 
  LEFT JOIN "@ARGNS_SCALE" ec ON ec."U_SclCode" = sc."U_SclCode" 
  LEFT JOIN "@ARGNS_SIZE" az on az."Code" = ec."Code" and az."U_SizeCode"=o."U_ARGNS_SIZE" 
  LEFT JOIN OVTG vat on vat."Code"=o."VatGourpSa" 
  LEFT JOIN OSTC tax on tax."Code"=o."TaxCodeAR" 
  WHERE o."SellItem"='Y') T1 on T1."ItemCode"=T0."ItemCode" 
WHERE T2."DocNum"=20000028 
ORDER BY T0."LineNum"

Altres consultes interessants

select * from OPDN where comments like '%1840364%' 
select * from OWTQ where comments like '%2782%'

Visites: 17