SELECT LPAD(' ', 32, ' ') AS LOGINSNAP
, TRIM(U.SENHASNAP) AS SENHASNAP
, TRIM(U.SERVIDORSMTP) AS SERVIDORSMTP
, TRIM(U.EMAIL) AS EMAIL
, TRIM(U.PORTAENVIO) AS PORTAENVIO
, TRIM(U.PORTAPOP3) AS PORTAPOP3
, LPAD(TRIM(U.EMPRESAGRUPO),15,0) AS NOMEUSUARIO
, NVL(U.UTILIZARSSL_ENVIO,'N') AS UTILIZARSSL_ENVIO
, U.UTILIZA_EMAIL_PADRAO_CONTROLE
, U.SERVIDORPOP3
, ' ' AS AUTENTICACAO_USUARIO
, ' ' AS AUTENTICACAO_SENHA
, 'S' AS SERV_SAIDA_UTILIZA_SERV_ENTR
FROM CTR_PARAMETROS U
1º Empresa
Tela/Select da
empresa
Annotations:
SELECT LPAD(' ', 32, ' ') AS LOGINSNAP,
CODIGOEMPRESA ,
EMPRESAGRUPO AS NOMEUSUARIO,
EMAIL ,
SENHASNAP AS SENHASNAP,
SERVIDORSMTP AS SERVIDORSMTP,
SERVIDORPOP3 ,
PORTAENVIO AS PORTAENVIO,
PORTAPOP3 AS PORTAPOP3,
(SELECT NVL(U.UTILIZARSSL_ENVIO,'N')
FROM CTR_PARAMETROS U ) AS UTILIZARSSL_ENVIO,
' ' AS AUTENTICACAO_USUARIO,
' ' AS AUTENTICACAO_SENHA,
'S' AS SERV_SAIDA_UTILIZA_SERV_ENTR,
UTILIZA_EMAIL_PADRAO_CONTROLE
FROM CTR_EMAIL_POR_EMPRESA
--WHERE CODIGOEMPRESA = :CODIGOEMPRESA