Skip to content

Instantly share code, notes, and snippets.

@elvisgs

elvisgs/extracao_gestao.sql

Created April 11, 2018 01:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save elvisgs/f2e5204f92ed615f17ac50155ee349f8 to your computer and use it in GitHub Desktop.
Save elvisgs/f2e5204f92ed615f17ac50155ee349f8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
extracao_gestao.sql
SELECT distinct prod.*
FROM est_nf_ent nfe
JOIN est_nf_ent_it it ON nfe.CD_EMP = it.CD_EMP AND nfe.CD_FILIAL = it.CD_FILIAL and nfe.CD_NF = it.CD_NF
JOIN est_prod prod ON it.CD_EMP = prod.CD_EMP AND it.CD_PROD = prod.CD_PROD
WHERE nfe.DT_ENT BETWEEN '${data_inicial}' AND '${data_final}'
UNION
SELECT distinct prod.*
FROM est_nf_sai nfs
JOIN est_nf_sai_it it ON nfs.CD_EMP = it.CD_EMP AND nfs.CD_FILIAL = it.CD_FILIAL and nfs.CD_NF = it.CD_NF
JOIN est_prod prod ON it.CD_EMP = prod.CD_EMP AND it.CD_PROD = prod.CD_PROD
WHERE nfs.DT_EMI_NF BETWEEN '${data_inicial}' AND '${data_final}'
SELECT distinct cd_barra.*
FROM est_nf_ent nfe
JOIN est_nf_ent_it it ON nfe.CD_EMP = it.CD_EMP AND nfe.CD_FILIAL = it.CD_FILIAL and nfe.CD_NF = it.CD_NF
JOIN est_prod prod ON it.CD_EMP = prod.CD_EMP AND it.CD_PROD = prod.CD_PROD
JOIN est_prod_cd_barra cd_barra ON prod.CD_EMP = cd_barra.CD_EMP AND prod.CD_PROD = cd_barra.CD_PROD
WHERE nfe.DT_ENT BETWEEN '${data_inicial}' AND '${data_final}'
UNION
SELECT distinct cd_barra.*
FROM est_nf_sai nfs
JOIN est_nf_sai_it it ON nfs.CD_EMP = it.CD_EMP AND nfs.CD_FILIAL = it.CD_FILIAL and nfs.CD_NF = it.CD_NF
JOIN est_prod prod ON it.CD_EMP = prod.CD_EMP AND it.CD_PROD = prod.CD_PROD
JOIN est_prod_cd_barra cd_barra ON prod.CD_EMP = cd_barra.CD_EMP AND prod.CD_PROD = cd_barra.CD_PROD
WHERE nfs.DT_EMI_NF BETWEEN '${data_inicial}' AND '${data_final}'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment