# Exemplo 2 - Query do CBS

**<span style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">select</span>**

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">top 100</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cenario.ID\_CENARIO</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;"> </span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cbs\_cst</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cbs\_class\_trib</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cbs\_aliq</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cbs\_vlr\_aliq\_efetiva</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cbs\_displeg</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cbs\_obs</span>

<span style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cbs.base\_calculo</span>

<span style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cbs\_red\_aliq</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cbs\_inf\_adic</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cred\_cbs\_ind\_cred</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cred\_cbs\_cst\_entr</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cred\_cbs\_perc\_cred</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cred\_cbs\_vig\_de</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cred\_cbs\_vig\_ate</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cred\_cbs\_obs</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cbs\_tribreg\_CSTReg</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cbs\_tribreg\_cClassTribReg</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cbs\_tribreg\_pCBS</span>

<span style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cbs\_tribreg\_baseCalculoReg</span>

<span style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">cbs\_tribreg\_pRedAliq</span>

<span style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">credpresu\_cbs\_cCredPres</span>

<span style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">credpresu\_cbs\_pCredPres</span>

<span style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">credpresu\_cbs\_vigenciaDe</span>

<span style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">credpresu\_cbs\_vigenciaAte</span>

<span style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">credpresu\_cbs\_observacoes</span>

**From**

<span style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">TBL\_CENARIO\_MATERIAL\_REFORMA CM (NOLOCK)</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">LEFT JOIN TBL\_MATERIAL M (NOLOCK) ON CM.MAT\_CODI = M.MAT\_CODI</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">INNER JOIN TBL\_CENARIO C (NOLOCK) ON CM.CENARIO\_CODI = C.CENARIO\_CODI</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">LEFT JOIN TBL\_IMP\_CBS I3 (NOLOCK) ON CM.CMA\_CODI = I3.CMA\_CODI</span>

<span lang="EN-US" style="background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">LEFT JOIN TBL\_CBS CBS (NOLOCK) ON I3.IMP\_CODI = CBS.IMP\_CODI</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;"> </span>

**<span lang="EN-US" style="mso-ansi-language: EN-US;">where </span>**

<span lang="EN-US" style="mso-ansi-language: EN-US;">material.COD\_PROD='X62002003405'</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">cenario.UF\_ORIGEM='SP' AND</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">cenario.UF\_DESTINO='SP' AND</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">cenario.ORIGEM='3' AND</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">cenario.DESTINACAO='3' AND</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">material.MAT\_STATUS='P' AND</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">material.MAT\_ATIVO=1 AND</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">cen\_mat.cma\_ativ=1 AND</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">IBSUF.imp\_ativ='1' AND</span>

<span lang="EN-US" style="mso-ansi-language: EN-US;">IBSUF.imp\_status='A'</span>