Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @DE_ORGAO VARCHAR(2048) = 'FNDE'
- DECLARE @DE_STATUS VARCHAR(32) = '--TODOS--'
- DECLARE @NU_STATUS INTEGER = (
- CASE
- WHEN @DE_STATUS = 'Ativo' THEN
- 1
- WHEN @DE_STATUS = 'Inativo' THEN
- 0
- WHEN @DE_STATUS = 'Invisivel' THEN
- 2
- ELSE
- 99
- END)
- DECLARE @NU_NIVEL INTEGER = 99
- SELECT
- [TB041].[DE_SIGLA_ORGAO]
- ,[TB041].[DE_ORGAO]
- ,TB041.NU_NIVEL
- ,[DC001].[DE_SECAO_ARVORE_COMPLETA] AS [DE_SECAO_ARVORE]
- ,TB057.DE_DADO_SOLICITACAO
- ,dbo.fnNormalizaHTML(dbo.DecoficaHtml(TB057.DE_ORIENTACAO_OPERADOR)) AS DE_ORIENTACAO_OPERADOR
- FROM [dbo].[TB056_DADO_SOLICITACAO] AS TB056
- INNER JOIN
- [dbo].[TB057_DADO_SOLICITACAO_INTERNACIONALIZA] AS TB057
- ON
- [TB057].[ID_DADO_SOLICITACAO] = [TB056].[ID_DADO_SOLICITACAO]
- INNER JOIN
- [dtc].[TB001_SECAO_ARVORE] AS DC001
- ON
- [DC001].[ID_SECAO] = TB056.ID_SECAO
- INNER JOIN
- [dbo].[TB041_ORGAO] AS TB041
- ON
- [TB041].[ID_ORGAO] = [TB056].[ID_ORGAO]
- WHERE [dbo].[fnValidaOrgao]([TB041].[DE_SIGLA_ORGAO], @DE_ORGAO) = 1
- AND
- (@NU_NIVEL = 99
- OR
- (@NU_NIVEL <> 99
- AND
- @NU_NIVEL = TB041.NU_NIVEL
- )
- )
- ORDER BY
- [TB041].[DE_ORGAO]
- ,[TB041].[DE_SIGLA_ORGAO]
- ,[NU_NIVEL]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement