Skip to content

Instantly share code, notes, and snippets.

@lucassch

lucassch/consulta apontamento hipper

Created January 27, 2015 12:59
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save lucassch/e05f48718932282ae902 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save lucassch/e05f48718932282ae902 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. lucassch created this gist Jan 27, 2015.
    43 changes: 43 additions & 0 deletions consulta apontamento hipper
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,43 @@
    SELECT H6_PRODUTO, SUM(H6_QTDPROD) QTD_PROD , 0 AS QTD_PERDA,
    (CASE
    WHEN H6_PRODUTO LIKE 'PIM%' THEN 'MACHARIA'
    WHEN H6_PRODUTO LIKE 'PIC%' THEN 'MOLDAGEM'
    WHEN H6_PRODUTO LIKE 'PIU%' THEN 'USINAGEM'
    WHEN H6_PRODUTO LIKE 'PIH%' THEN 'FUNDICAO' END) DEPTO,
    H6_DATAINI DT_PROD,
    H6_OPERADO USUARIO,
    H6_RECURSO RECURSO,
    H1_DESCRI,
    H6_HTURNO
    FROM SH6010, SH1010
    WHERE
    H6_FILIAL='11' AND
    H6_DATAINI='20150123' AND
    SH6010.D_E_L_E_T_<>'*' AND
    H6_HTURNO BETWEEN '001' AND '002' AND
    H1_FILIAL=' ' AND
    H1_CODIGO=H6_RECURSO AND
    SH1010.D_E_L_E_T_<>'*'
    GROUP BY H6_PRODUTO, H6_DATAINI, H6_OPERADO, H6_RECURSO, H1_DESCRI, H6_HTURNO
    UNION ALL
    SELECT BC_PRODUTO, 0 QTD_PROD , SUM(BC_QUANT) QTD_PERDA,
    (CASE
    WHEN BC_PRODUTO LIKE 'PIM%' THEN 'MACHARIA'
    WHEN BC_PRODUTO LIKE 'PIC%' THEN 'MOLDAGEM'
    WHEN BC_PRODUTO LIKE 'PIU%' THEN 'USINAGEM'
    WHEN BC_PRODUTO LIKE 'PIH%' THEN 'FUNDICAO' END) DEPTO,
    BC_DATA DT_PROD,
    BC_OPERADO USUARIO,
    BC_RECURSO RECURSO,
    H1_DESCRI,
    BC_HTURNO
    FROM SBC010, SH1010
    WHERE
    BC_FILIAL='11' AND
    BC_DATA='20150123' AND
    SBC010.D_E_L_E_T_<>'*' AND
    BC_HTURNO BETWEEN '001' AND '002' AND
    H1_FILIAL=' ' AND
    H1_CODIGO=BC_RECURSO AND
    SH1010.D_E_L_E_T_<>'*'
    GROUP BY BC_PRODUTO, BC_DATA, BC_OPERADO, BC_RECURSO, H1_DESCRI, BC_HTURNO