SELECT CFGV.ID as ID, ART.DESCRIPCION as DESCRIPCION, ART.FAMILIA as FAMILIA, ART.SUBFAMILIA as SUBFAMILIA, DET.CANTIDAD as CANTIDAD, CFGV.NOMBREVENDEDOR as VENDEDOR, CFGV.ID as IDVENDEDOR, (DET.IMPORTELINEA+DET.IMPIVA) AS TOTAL, DET.PRECIO + (DET.PRECIO * (DET.PORCIVA/100)) as PRECIO, PRE.PVP3 as PVP3, 'DOCTOS.' AS FORMLISTA, EXTRACT(DAY FROM CFGD.FECHA) as DIA, EXTRACT(MONTH FROM CFGD.FECHA) as MES, EXTRACT(YEAR FROM CFGD.FECHA) as ANIO From ref_pedidospresup CFGD inner join cfg_vendedores CFGV on CFGV.id=CFGD.fk1mcfg_vendedores inner join REF_DETPEDIDOSPRESUP DET on CFGD.ID=DET.FKPADREF_PEDIDOSPRESUP inner join CFG_ARTICULOS ART on DET.CODIGO=ART.CODIGOARTICULO inner join CFG_PRECIOSXALMACENES PRE on PRE.FK1MCFG_ARTICULOS=ART.ID and PRE.FK1MCFG_ALMACENES=10754 Where EXTRACT(YEAR FROM CFGD.FECHA)=2022 AND EXTRACT(MONTH FROM CFGD.FECHA)=8 AND NOT CFGD.ESPEDLIQAPARTADO='AA' AND CFGD.SERDOCTO<>'CREDITO' AND ART.FAMILIA NOT IN ('OXIFUEL','CONTRAPESO','CONTRAPESO') AND CFGD.DOCTOESPECIAL='' AND CFGD.STATUS IN ('PEDIDO EMITIDO','PEDIDO FACTURADO') Order by CFGV.NOMBREVENDEDOR,TOTAL DESC