[Servico][Accestage][Embratel][Portal] add Mask – Máscara

Add imagem da solução

pop

e a

lista

ackage br.com.embratel.conciliacao;

import br.com.embratel.conciliacao.util.FormatUtil;

import javax.faces.component.UIComponent;
import javax.faces.context.FacesContext;
import javax.faces.convert.Converter;

/**
 * Converter para utilizar mascara no telefone
 * @author Cássio Alexandre de Sousa
 */
public class ConverterFone implements Converter {
    public ConverterFone() {
        super();
    }
    
    /**
     * Retorna o objejeto sem mascara
     * @param facesContext
     * @param uIComponent
     * @param string
     * @return
     */
    public Object getAsObject(FacesContext facesContext,
                              UIComponent uIComponent, String string) {
        if(string != null){
            return FormatUtil.recuperarNumerosTelefone(string);
        }
        return "";
    }
    
    /**
     * Adiciona mascara no objeto
     * @param facesContext
     * @param uIComponent
     * @param object
     * @return
     */
    public String getAsString(FacesContext facesContext,
                              UIComponent uIComponent, Object object) {
        if(object != null){
            String fone = String.valueOf(object);          
            if(!fone.equals("") && fone.length() > 7){
                return fone.substring(fone.length() - 4 ).concat("-").concat(fone.substring(0, 4));
            }
        }
        return "";
    }
}


package br.com.embratel.conciliacao.mb;

import br.com.embratel.conciliacao.util.ADFUtils;

import br.com.embratel.conciliacao.util.FormatUtil;

import java.util.Calendar;

import java.util.Date;

import oracle.adf.model.BindingContext;

import oracle.adf.model.binding.DCIteratorBinding;
import oracle.adf.share.ADFContext;
import oracle.adf.view.rich.component.rich.input.RichInputDate;
import oracle.adf.view.rich.component.rich.output.RichOutputFormatted;
import oracle.adf.view.rich.event.DialogEvent;
import oracle.adf.view.rich.event.PopupCanceledEvent;

import oracle.binding.BindingContainer;
import oracle.binding.OperationBinding;

import oracle.adf.view.rich.event.PopupFetchEvent;

public class CadastraBancoBean {   
    private static final String GET_USER_EXPRESSION =
        "#{securityContext.userName}";
    
    public CadastraBancoBean() {
    }

    public void editPopupFetchListener(PopupFetchEvent popupFetchEvent) {        
        if (popupFetchEvent.getLaunchSourceClientId().contains("cbInsert")) {            
            BindingContainer bindings = getBindings(); 
            OperationBinding operationBinding = bindings.getOperationBinding("CreateInsert");            
            operationBinding.execute();
        }
    }
    
    public void editDialogListener(DialogEvent dialogEvent) {       
        if (dialogEvent.getOutcome().name().equals("ok")) {           
            BindingContainer bindings = getBindings();
            
            String nome = String.valueOf(ADFUtils.getExpressionValue(GET_USER_EXPRESSION));
            
            ADFUtils.setBoundAttributeValue("NmeLogin", nome);
           
            OperationBinding operationBinding = bindings.getOperationBinding("Commit");
            operationBinding.execute();   
        } else if (dialogEvent.getOutcome().name().equals("cancel")) {
            BindingContainer bindings = getBindings();
            OperationBinding operationBinding = bindings.getOperationBinding("Rollback");
            operationBinding.execute();
        }
    }

    public void editPopupCancelListener(PopupCanceledEvent popupCanceledEvent) {
        BindingContainer bindings = getBindings();
        OperationBinding operationBinding = bindings.getOperationBinding("Rollback");
        operationBinding.execute();
    }
    
    public BindingContainer getBindings() {        
        return BindingContext.getCurrent().getCurrentBindingsEntry();
    }


    public void deleteDialogListener(DialogEvent dialogEvent) {
       
        if (dialogEvent.getOutcome().name().equals("yes")) { 
            BindingContainer bindings = getBindings();
            OperationBinding operationBinding = bindings.getOperationBinding("Delete");            
            operationBinding.execute(); 
            OperationBinding operationBindingCommit = bindings.getOperationBinding("Commit");            
            operationBindingCommit.execute();
        } else if (dialogEvent.getOutcome().name().equals("no")) {
            BindingContainer bindings = getBindings();
            OperationBinding operationBinding = bindings.getOperationBinding("Rollback");
            operationBinding.execute();
        }
    }
}


Obtendo a chave para google Maps para android

A classe MapView é biblioteca externa de mapa que é mto útil que permite facilmente integrar seu aplicativo com Google Maps. Ele permite downloading, rederinzação, bem como a variedade de opção de exibição e controle. Ele proporsiona uma funcionalidade em torno do API Google Maps que permite que seu aplicativo faça um requisição e manipule os dados do Google Maps atrvés dos métodos da Classe, e que permite que trabalhe com o dados do Mapas como faria com outros tipos de Views.

Porque MapView dá-lhe acesso aos dados do Google Maps, você precisa-se registrar com o Serviço Google Maps e concordar com os termos de serviços antes que voce receba do MapView os dados do Google Maps. Isto se aplica se vocÇe estiver desenvolvendo seu aplicativo no emulador ou se prparando seu aplicação para implantação para o dispositivo.

Registrando para a chave para API Maps , veja como é simples, gratuito , e siga dois passo:

1. Registre o MD5 fingerprint o certificado que você usará no seu assintatura no seu applicação. O registro do serviço Maps então a chave do API MAP permite que você associe com seu certificação aplicação.

2. Adicionando uma referencia para a chave API Maps,se declarado no XML ou instanciado diretamente do codigo. Você pode usar alguns Chave ke para mto MapView em mtas Aplicações android, desde que a aplicação seja assinado com certificação, cujo vc retistrado com o serviço digital.

keytool -list -keystore ~/.android/debug.keystore

chika@comp173:~$ keytool -list  -keystore ~/.android/debug.keystore Enter keystore password:

*****************  WARNING WARNING WARNING  *****************
* The integrity of the information stored in your keystore  *
* has NOT been verified!  In order to verify its integrity, *
* you must provide your keystore password.                  *
*****************  WARNING WARNING WARNING  *****************

Keystore type: JKS
Keystore provider: SUN

Your keystore contains 1 entry

androiddebugkey, Sep 13, 2012, PrivateKeyEntry,
Certificate fingerprint (MD5): 6A:3B:07:21:70:BC:D3:DC:3E:B8:4F:25:83:18:61:29

https://developers.google.com/android/maps-api-signup?hl=pt-BR

Segue os passos abaixos:

Informações sobre Google Maps API
https://developers.google.com/maps/?hl=pt-BR

OBS: Tive problemas com versão do Ubuntu, na língua br. Depois de formatar o meu pc eu add, a versão inglês. Não ocorreu erro.

[ADF]Table barra de rolagem

Recente mente tive problema de barra de rolagem, na horizontal. Tabela tinha vários colunas, maior que atela, o mesmo acontecia com as linhas.

Problema: Qdo eu fazia consulta , e tinha linhas superior que a tela. O scroll (barra de rolagem), não aparecia. Pq a barra de rolagem estava exatamente na última linha, ou seja a barra acompanhava a última linha.

Solução foi colocar scroll:

  styleClass="AFStretchWidth"
  inlineStyle="overflow:auto;"

O Projeto, de uma olhada

<?xml version='1.0' encoding='UTF-8'?>
<jsp:root xmlns:jsp="http://java.sun.com/JSP/Page" version="2.1"
          xmlns:f="http://java.sun.com/jsf/core"
          xmlns:af="http://xmlns.oracle.com/adf/faces/rich">
  <jsp:directive.page contentType="text/html;charset=UTF-8"/>
  <f:view locale="pt-BR">
    <af:document id="d1" title="Embratel - Portal">
      <af:form id="f1">
        <af:pageTemplate value="#{bindings.pageTemplateBinding.templateModel}" id="pt1">
          <f:facet name="content">
            <af:group id="g1">
              <af:panelGroupLayout id="pgl2"
                                   binding="#{MovimentoBancoBean.pglMaster}"
                                   partialTriggers="t1:gl1 cb21" visible="true">
                <af:panelAccordion id="pa1" styleClass="AFStretchWidth"
                                   dimensionsFrom="children"
                                   discloseMany="true">
                  <af:showDetailItem text="Pesquisar - Movimento Banco"
                                     id="sdi1" disclosed="true">
                    <af:panelFormLayout id="pfl1">
                      <af:selectOneChoice label="Banco:" id="soc1"
                                          value="#{bindings.banco1.inputValue}"
                                          unselectedLabel="Todos">
                        <af:forEach items="#{bindings.BancoView1.rangeSet}"
                                    var="bc">
                          <af:selectItem label="#{bc.CodBanco} - #{bc.NmeBanco}"
                                         value="#{bc.CodBanco}" id="si2"/>
                        </af:forEach>
                      </af:selectOneChoice>
                      <af:selectOneChoice label="Companhia:" id="soc2"
                                          value="#{bindings.companhia1.inputValue}"
                                          unselectedLabel="Todos">
                        <af:forEach items="#{bindings.CompanhiaView1.rangeSet}"
                                    var="bc">
                          <af:selectItem label="#{bc.NmeCia}"
                                         value="#{bc.CodCia}" id="si3"/>
                        </af:forEach>
                      </af:selectOneChoice>
                      <af:selectOneChoice label="Status:" id="soc3"
                                          value="#{bindings.status1.inputValue}"
                                          unselectedLabel="Todos">
                        <af:forEach items="#{bindings.StatusConciliadoView1.rangeSet}"
                                    var="bc">
                          <af:selectItem label="#{bc.DscStaConciliado}"
                                         value="#{bc.StaConciliado}" id="si1"/>
                        </af:forEach>
                      </af:selectOneChoice>
                      <af:inputText label="Convênio:" id="it1"
                                    value="#{bindings.convenio1.inputValue}"/>
                      <af:inputDate id="id1"
                                    value="#{bindings.dtaInicial1.inputValue}"
                                    label="Data Inicial:" showRequired="true"
                                    binding="#{MovimentoBancoBean.dtaInicio}"/>
                      <af:inputDate id="id2"
                                    value="#{bindings.dtaFinal1.inputValue}"
                                    label="Data Final:" showRequired="true"
                                    binding="#{MovimentoBancoBean.dtaFim}"/>
                      <af:panelGroupLayout id="pgl4" layout="horizontal">
                        <af:commandButton disabled="#{!bindings.ExecuteWithParams.enabled}"
                                          id="cb2" text="Pesquisar"
                                          actionListener="#{MovimentoBancoBean.pesquisar}"/>
                      </af:panelGroupLayout>
                    </af:panelFormLayout>
                  </af:showDetailItem>
                  <af:showDetailItem text="Resultado" id="sdi2" disclosed="true"
                                     rendered="#{not empty bindings.dtaInicial1.inputValue and not empty bindings.dtaFinal1.inputValue}">
                    <af:table value="#{bindings.VMovimentoBancoView1.collectionModel}"
                              var="row"
                              rows="#{bindings.VMovimentoBancoView1.rangeSize}"
                              emptyText="#{bindings.VMovimentoBancoView1.viewable ? 'Não há dados para exibir.' : 'Access Denied.'}"
                              fetchSize="#{bindings.VMovimentoBancoView1.rangeSize}"
                              rowBandingInterval="0"
                              selectedRowKeys="#{bindings.VMovimentoBancoView1.collectionModel.selectedRow}"
                              selectionListener="#{bindings.VMovimentoBancoView1.collectionModel.makeCurrent}"
                              rowSelection="single" id="t1"
                              partialTriggers="::cb2  ::cb21"
                              styleClass="AFStretchWidth"
                              inlineStyle="overflow:auto;"
                              autoHeightRows="#{bindings.VMovimentoBancoView1.rangeSize}">
                      <af:column sortProperty="CodBanco" sortable="true"
                                 headerText="#{bindings.VMovimentoBancoView1.hints.CodBanco.label}"
                                 id="c18" align="center">
                        <af:outputText value="#{row.CodBanco}" id="ot12" shortDesc="#{row.NmeBanco}"/>
                      </af:column>
                      <af:column sortProperty="CodCia" sortable="true"
                                 headerText="#{bindings.VMovimentoBancoView1.hints.CodCia.label}"
                                 id="c12" align="center">
                        <af:outputText value="#{row.CodCia}" id="ot5" shortDesc="#{row.NmeCia}"/>
                      </af:column>
                      <af:column sortProperty="DtaPagto" sortable="true"
                                 headerText="#{bindings.VMovimentoBancoView1.hints.DtaPagto.label}"
                                 id="c1" align="center">
                        <af:outputText value="#{row.DtaPagto}" id="ot1">
                          <af:convertDateTime pattern="#{bindings.VMovimentoBancoView1.hints.DtaPagto.format}"/>
                        </af:outputText>
                      </af:column>
                      <af:column sortProperty="VlrBruto" sortable="true"
                                 headerText="#{bindings.VMovimentoBancoView1.hints.VlrBruto.label}"
                                 id="c10" align="center">
                        <af:outputText value="#{row.VlrBruto}" id="ot21"
                                       inlineStyle="float:right">
                          <af:convertNumber groupingUsed="false"
                                            pattern="#{bindings.VMovimentoBancoView1.hints.VlrBruto.format}"/>
                        </af:outputText>
                      </af:column>
                      <af:column sortProperty="VlrTarifa" sortable="true"
                                 headerText="#{bindings.VMovimentoBancoView1.hints.VlrTarifa.label}"
                                 id="c6" align="center">
                        <af:outputText value="#{row.VlrTarifa}" id="ot6"
                                       inlineStyle="float:right">
                          <af:convertNumber groupingUsed="false"
                                            pattern="#{bindings.VMovimentoBancoView1.hints.VlrTarifa.format}"/>
                        </af:outputText>
                      </af:column>
                      <af:column sortProperty="VlrTarifaEsperada"
                                 sortable="true"
                                 headerText="#{bindings.VMovimentoBancoView1.hints.VlrTarifaEsperada.label}"
                                 id="c15" align="center">
                        <af:outputText value="#{row.VlrTarifaEsperada}"
                                       id="ot25" inlineStyle="float:right">
                          <af:convertNumber groupingUsed="false"
                                            pattern="#{bindings.VMovimentoBancoView1.hints.VlrTarifaEsperada.format}"/>
                        </af:outputText>
                      </af:column>
                      <af:column sortProperty="QtdMov" sortable="true"
                                 headerText="#{bindings.VMovimentoBancoView1.hints.QtdMov.label}"
                                 id="c14" align="center">
                        <af:outputText value="#{row.QtdMov}" id="ot22">
                          <af:convertNumber groupingUsed="false"
                                            pattern="#{bindings.VMovimentoBancoView1.hints.QtdMov.format}"/>
                        </af:outputText>
                      </af:column>
                      <af:column sortProperty="VlrTarifaPadrao" sortable="true"
                                 headerText="#{bindings.VMovimentoBancoView1.hints.VlrTarifaPadrao.label}"
                                 id="c3" align="center">
                        <af:outputText value="#{row.VlrTarifaPadrao}" id="ot19"
                                       inlineStyle="float:right">
                          <af:convertNumber groupingUsed="false"
                                            pattern="#{bindings.VMovimentoBancoView1.hints.VlrTarifaPadrao.format}"/>
                        </af:outputText>
                      </af:column>
                      <af:column sortProperty="DscStaConciliado" sortable="true"
                                 headerText="#{bindings.VMovimentoBancoView1.hints.DscStaConciliado.label}"
                                 id="c9" align="center">
                        <af:commandLink id="gl1"
                                        partialSubmit="true"
                                        visible="#{row.StaConciliado != 'N' and row.StaConciliado != 'D'}"
                                        actionListener="#{MovimentoBancoBean.buscaCodGrupo}"
                                        action="#{MovimentoBancoBean.resumoConciliacao}"
                                        text="#{row.DscStaConciliado}">
                          <af:clientAttribute name="codGrupoConc"
                                              value="#{row.CodGrupoContabilConc}"/>
                        </af:commandLink>
                        <af:outputText value="#{row.DscStaConciliado}" id="ot17"
                                       visible="#{row.StaConciliado == 'N' or row.StaConciliado == 'D'}"/>
                      </af:column>
                      <af:column sortProperty="TpoArrec" sortable="true"
                                 headerText="#{bindings.VMovimentoBancoView1.hints.TpoArrec.label}"
                                 id="c25" align="center">
                        <af:outputText value="#{row.TpoArrec}" id="ot7"/>
                      </af:column>
                      <af:column sortProperty="CodConvenio" sortable="true"
                                 headerText="#{bindings.VMovimentoBancoView1.hints.CodConvenio.label}"
                                 id="c24" align="center">
                        <af:outputText value="#{row.CodConvenio}" id="ot8" shortDesc="#{row.FilePath}/#{row.FileName}"/>
                      </af:column>
                      <af:column sortProperty="CodModalidade" sortable="true"
                                 headerText="#{bindings.VMovimentoBancoView1.hints.CodModalidade.label}"
                                 id="c7" align="center">
                        <af:outputText value="#{row.CodModalidade}" id="ot10"/>
                      </af:column>
                      <af:column sortProperty="DtaArquivo" sortable="true"
                                 headerText="#{bindings.VMovimentoBancoView1.hints.DtaArquivo.label}"
                                 id="c16" align="center">
                        <af:outputText value="#{row.DtaArquivo}" id="ot2">
                          <af:convertDateTime pattern="#{bindings.VMovimentoBancoView1.hints.DtaArquivo.format}"/>
                        </af:outputText>
                      </af:column>
                      <af:column sortProperty="CodBancoAnt" sortable="true"
                                 headerText="#{bindings.VMovimentoBancoView1.hints.CodBancoAnt.label}"
                                 id="c8" align="center">
                        <af:outputText value="#{row.CodBancoAnt}" id="ot24"/>
                      </af:column>
                      <af:column sortProperty="CodGrupoContabilConc"
                                 sortable="true"
                                 headerText="#{bindings.VMovimentoBancoView1.hints.CodGrupoContabilConc.label}"
                                 id="c19" align="center">
                        <af:outputText value="#{row.CodGrupoContabilConc}"
                                       id="ot9"/>
                      </af:column>
                      <af:column sortProperty="VlrGrupoConciliacao"
                                 sortable="true"
                                 headerText="#{bindings.VMovimentoBancoView1.hints.VlrGrupoConciliacao.label}"
                                 id="c2" align="center">
                        <af:outputText value="#{row.VlrGrupoConciliacao}"
                                       id="ot16" inlineStyle="float:right">
                          <af:convertNumber groupingUsed="false"
                                            pattern="#{bindings.VMovimentoBancoView1.hints.VlrGrupoConciliacao.format}"/>
                        </af:outputText>
                      </af:column>
                      <af:column sortProperty="DesStepConciliacao"
                                 sortable="true"
                                 headerText="#{bindings.VMovimentoBancoView1.hints.DesStepConciliacao.label}"
                                 id="c13" align="center">
                        <af:outputText value="#{row.DesStepConciliacao}"
                                       id="ot13"/>
                      </af:column>
                      <af:column sortProperty="NmeUsuario" sortable="true"
                                 headerText="#{bindings.VMovimentoBancoView1.hints.NmeUsuario.label}"
                                 id="c17" align="center">
                        <af:outputText value="#{row.NmeUsuario}" id="ot3"/>
                      </af:column>
                    </af:table>
                    <f:facet name="toolbar">
                      <af:toolbar id="t2">
                       <af:commandButton text="Exportar" id="cb1"
                                        iconPosition="trailing"
                                        inlineStyle="text-align:left;"
                                        partialSubmit="true">
                           <af:fileDownloadActionListener filename="ASConciliacao_MovimentoBanco.xls"
                                                       method="#{MovimentoBancoBean.exportarTabela}"/>
                      
                      
                      
                       <!-- <af:commandButton text="Exportar"
                                          iconPosition="trailing"
                                          partialTriggers="cb1 t1"
                                          disabled="#{bindings.VMovimentoBancoView1Iterator.estimatedRowCount eq 0}"
                                          id="cb1">
                          <af:exportCollectionActionListener exportedId="t1"
                                                             type="excelHTML"
                                                             filename="ASConciliacao_MovimentoBanco.xls"
                                                             title="Exportar"/>-->
                        </af:commandButton>
                      </af:toolbar>
                    </f:facet>
                  </af:showDetailItem>
                </af:panelAccordion>
              </af:panelGroupLayout>
              <af:panelGroupLayout id="pgl1"
                                   binding="#{MovimentoBancoBean.pglDetail}"
                                   visible="false" partialTriggers="t1:gl1 cb21">
                <af:panelAccordion id="pa11" styleClass="AFStretchWidth"
                                   dimensionsFrom="children"
                                   discloseMany="true">
                  <af:showDetailItem text="Resultado - Movimento Banco"
                                     id="sdi11" disclosed="true">
                    <af:table value="#{bindings.VRetornoSintView1.collectionModel}"
                              var="row"
                              rows="#{bindings.VRetornoSintView1.rangeSize}"
                              emptyText="#{bindings.VRetornoSintView1.viewable ? 'Não há registros para exibir.' : 'Access Denied.'}"
                              fetchSize="#{bindings.VRetornoSintView1.rangeSize}"
                              rowBandingInterval="0" id="t21"
                              styleClass="AFStretchWidth"
                              inlineStyle="height:auto;" autoHeightRows="15">
                      <af:column sortProperty="CodBanco" sortable="false"
                                 headerText="#{bindings.VRetornoSintView1.hints.CodBanco.label}"
                                 id="c84" align="center">
                        <af:outputText value="#{row.CodBanco}" id="ot65"
                                       noWrap="false"
                                       shortDesc="#{row.NmeBanco}"/>
                      </af:column>
                      <af:column sortProperty="CodCia" sortable="false"
                                 headerText="#{bindings.VRetornoSintView1.hints.CodCia.label}"
                                 id="c88" align="center">
                        <af:outputText value="#{row.CodCia}" id="ot36"
                                       noWrap="false"
                                       shortDesc="#{row.NmeCia}"/>
                      </af:column>
                      <af:column sortProperty="DtaPagto" sortable="false"
                                 headerText="#{bindings.VRetornoSintView1.hints.DtaPagto.label}"
                                 id="c86" align="center">
                        <af:outputText value="#{row.DtaPagto}" id="ot70">
                          <af:convertDateTime pattern="#{bindings.VRetornoSintView1.hints.DtaPagto.format}"/>
                        </af:outputText>
                      </af:column>
                      <af:column sortProperty="VlrBruto" sortable="false"
                                 headerText="#{bindings.VRetornoSintView1.hints.VlrBruto.label}"
                                 id="c62" align="center">
                        <af:outputText value="#{row.VlrBruto}" id="ot48"
                                       inlineStyle="float:right"/>
                      </af:column>
                      <af:column sortProperty="VlrTarifa" sortable="false"
                                 headerText="#{bindings.VRetornoSintView1.hints.VlrTarifa.label}"
                                 id="c81" align="center">
                        <af:outputText value="#{row.VlrTarifa}" id="ot73"
                                       inlineStyle="float:right"/>
                      </af:column>
                      <af:column sortProperty="VlrTarifaEsperada"
                                 sortable="false"
                                 headerText="#{bindings.VRetornoSintView1.hints.VlrTarifaEsperada.label}"
                                 id="c82" align="center">
                        <af:outputText value="#{row.VlrTarifaEsperada}"
                                       id="ot83" inlineStyle="float:right"/>
                      </af:column>
                      <af:column sortProperty="QtdMov" sortable="false"
                                 headerText="#{bindings.VRetornoSintView1.hints.QtdMov.label}"
                                 id="c69" align="center">
                        <af:outputText value="#{row.QtdMov}" id="ot67"
                                       inlineStyle="float:right"/>
                      </af:column>
                      <af:column sortProperty="VlrTarifaPadrao" sortable="false"
                                 headerText="#{bindings.VRetornoSintView1.hints.VlrTarifaPadrao.label}"
                                 id="c73" align="center">
                        <af:outputText value="#{row.VlrTarifaPadrao}" id="ot71"
                                       inlineStyle="float:right"/>
                      </af:column>
                      <af:column sortProperty="TpoArrec" sortable="false"
                                 headerText="#{bindings.VRetornoSintView1.hints.TpoArrec.label}"
                                 id="c58" align="center">
                        <af:outputText value="#{row.TpoArrec}" id="ot89"/>
                      </af:column>
                      <af:column sortProperty="CodConvenio" sortable="false"
                                 headerText="#{bindings.VRetornoSintView1.hints.CodConvenio.label}"
                                 id="c59" align="right">
                        <af:outputText value="#{row.CodConvenio}" id="ot85"
                                       noWrap="false"
                                       shortDesc="#{row.FilePath}/#{row.FileName}"/>
                      </af:column>
                      <af:column sortProperty="CodModalidade" sortable="false"
                                 headerText="#{bindings.VRetornoSintView1.hints.CodModalidade.label}"
                                 id="c74" align="center">
                        <af:outputText value="#{row.CodModalidade}" id="ot81"/>
                      </af:column>
                      <af:column sortProperty="DtaArquivo" sortable="false"
                                 headerText="#{bindings.VRetornoSintView1.hints.DtaArquivo.label}"
                                 id="c90" align="center">
                        <af:outputText value="#{row.DtaArquivo}" id="ot74">
                          <af:convertDateTime pattern="#{bindings.VRetornoSintView1.hints.DtaArquivo.format}"/>
                        </af:outputText>
                      </af:column>
                      <af:column sortProperty="CodBancoAnt" sortable="false"
                                 headerText="#{bindings.VRetornoSintView1.hints.CodBancoAnt.label}"
                                 id="c60" align="center">
                        <af:outputText value="#{row.CodBancoAnt}" id="ot33"
                                       noWrap="false"
                                       shortDesc="#{row.NmeBancoAnt}"/>
                      </af:column>
                    </af:table>
                    <f:facet name="toolbar">
                      <af:toolbar id="t4">
                        <af:commandButton text="Desfazer" id="cb21"
                                          action="#{MovimentoBancoBean.atualizarConciliacao}"
                                          rendered="#{bindings.StaConciliado == 'M' and MovimentoBancoBean.usuarioRule}"
                                          partialSubmit="true"
                                          partialTriggers="t1:gl1" 
                                          actionListener="#{bindings.updateAll.execute}"/>
                        <af:commandButton text="Voltar" id="cb3"
                                          action="#{MovimentoBancoBean.voltarTelaPrincipal}"/>
                      </af:toolbar>
                    </f:facet>
                  </af:showDetailItem>
                  <af:showDetailItem text="Resultado - Movimento Contabil"
                                     id="sdi21" disclosed="true">
                    <af:table value="#{bindings.VContabilView1.collectionModel}"
                              var="row"
                              rows="#{bindings.VContabilView1.rangeSize}"
                              emptyText="#{bindings.VContabilView1.viewable ? 'Não há registros para exibir.' : 'Access Denied.'}"
                              fetchSize="#{bindings.VContabilView1.rangeSize}"
                              rowBandingInterval="0" id="t11"
                              styleClass="AFStretchWidth"
                              inlineStyle="height:auto;" autoHeightRows="15">
                      <af:column sortProperty="CodBanco" sortable="false"
                                 headerText="#{bindings.VContabilView1.hints.CodBanco.label}"
                                 id="c11" align="center">
                        <af:outputText value="#{row.CodBanco}" id="ot52"
                                       noWrap="false"
                                       shortDesc="#{row.NmeBanco}"/>
                      </af:column>
                      <af:column sortProperty="CodCia" sortable="false"
                                 headerText="#{bindings.VContabilView1.hints.CodCia.label}"
                                 id="c40" align="center">
                        <af:outputText value="#{row.CodCia}" id="ot11"
                                       noWrap="false"
                                       shortDesc="#{row.NmeCia}"/>
                      </af:column>
                      <af:column sortProperty="DtaContabil" sortable="false"
                                 headerText="#{bindings.VContabilView1.hints.DtaContabil.label}"
                                 id="c22" align="center">
                        <af:outputText value="#{row.DtaContabil}" id="ot14">
                          <af:convertDateTime pattern="#{bindings.VContabilView1.hints.DtaContabil.format}"/>
                        </af:outputText>
                      </af:column>
                      <af:column sortProperty="VlrContabil" sortable="false"
                                 headerText="#{bindings.VContabilView1.hints.VlrContabil.label}"
                                 id="c20" align="center">
                        <af:outputText value="#{row.VlrContabil}" id="ot4"
                                       inlineStyle="float:right"/>
                      </af:column>
                      <af:column sortProperty="DscHistorico" sortable="false"
                                 headerText="#{bindings.VContabilView1.hints.DscHistorico.label}"
                                 id="c23" align="center">
                        <af:outputText value="#{row.DscHistorico}" id="ot30"/>
                      </af:column>
                      <af:column sortProperty="DesStepConciliacao"
                                 sortable="false"
                                 headerText="#{bindings.VContabilView1.hints.DesStepConciliacao.label}"
                                 id="c39" align="center">
                        <af:outputText value="#{row.DesStepConciliacao}"
                                       id="ot23"/>
                      </af:column>
                      <af:column sortProperty="NumDocumento" sortable="false"
                                 headerText="#{bindings.VContabilView1.hints.NumDocumento.label}"
                                 id="c21" align="center">
                        <af:outputText value="#{row.NumDocumento}" id="ot26"/>
                      </af:column>
                      <af:column sortProperty="CodUnidNegocio" sortable="false"
                                 headerText="#{bindings.VContabilView1.hints.CodUnidNegocio.label}"
                                 id="c27" align="center">
                        <af:outputText value="#{row.CodUnidNegocio}" id="ot40"/>
                      </af:column>
                      <af:column sortProperty="CodDetMod" sortable="false"
                                 headerText="#{bindings.VContabilView1.hints.CodDetMod.label}"
                                 id="c53" align="center">
                        <af:outputText value="#{row.CodDetMod}" id="ot55">
                          <af:convertNumber groupingUsed="false"
                                            pattern="#{bindings.VContabilView1.hints.CodDetMod.format}"/>
                        </af:outputText>
                      </af:column>
                    </af:table>
                  </af:showDetailItem>
                  <af:showDetailItem id="sdi3" disclosed="true">
                    <af:table value="#{bindings.VTtGrpConcView1.collectionModel}"
                              var="row"
                              rows="#{bindings.VTtGrpConcView1.rangeSize}"
                              emptyText="#{bindings.VTtGrpConcView1.viewable ? 'Não há registros para exibir.' : 'Access Denied.'}"
                              fetchSize="#{bindings.VTtGrpConcView1.rangeSize}"
                              rowBandingInterval="0" id="t3"
                              styleClass="AFStretchWidth"
                              inlineStyle="height:auto;"
                              autoHeightRows="#{bindings.VTtGrpConcView1.rangeSize}">
                      <af:column sortProperty="CodGrupoContabilConc"
                                 sortable="false"
                                 headerText="#{bindings.VTtGrpConcView1.hints.CodGrupoContabilConc.label}"
                                 id="c5" align="center">
                        <af:outputText value="#{row.CodGrupoContabilConc}"
                                       id="ot15"/>
                      </af:column>
                      <af:column sortProperty="VlrGrupoConciliacao"
                                 sortable="false"
                                 headerText="#{bindings.VTtGrpConcView1.hints.VlrGrupoConciliacao.label}"
                                 id="c4" align="center">
                        <af:outputText value="#{row.VlrGrupoConciliacao}"
                                       id="ot18" inlineStyle="float:right"/>
                      </af:column>
                      <af:column sortProperty="DesStepConciliacao"
                                 sortable="false"
                                 headerText="#{bindings.VTtGrpConcView1.hints.DesStepConciliacao.label}"
                                 id="c26" align="center">
                        <af:outputText value="#{row.DesStepConciliacao}"
                                       id="ot20"/>
                      </af:column>
                    </af:table>
                  </af:showDetailItem>
                </af:panelAccordion>
              </af:panelGroupLayout>
            </af:group>
          </f:facet>
        </af:pageTemplate>
      </af:form>
    </af:document>
  </f:view>
</jsp:root>

[SQL]Union !!!!

select t.COD_MODALIDADE, 
       t.COD_TARIFA, 
       t.DTA_ATUALIZACAO, 
       t.DTA_CRIACAO, 
       t.DTA_FIM, 
       t.DTA_INI, 
       t.ID_CONVENIO, 
       t.NME_LOGIN, 
       t.VLR_TARIFA, 
       null DSC_MODALIDADE, 
       null COD_MODALIDADE1, 
       null COD_MODALIDADE2,
       null TPO_ARREC,
       'A'
  from tarifa t, modalidade_tarifa m
 where t.id_convenio = :idConvenioExecParam
   and t.cod_modalidade = m.cod_modalidade
   and trunc(sysdate) BETWEEN T.DTA_INI AND T.DTA_FIM
   and decode(:dtaInicialExecParam, null, 1, 2) = decode(:dtaInicialExecParam, null, 1, 3)
union
select t.COD_MODALIDADE, 
       t.COD_TARIFA, 
       t.DTA_ATUALIZACAO, 
       t.DTA_CRIACAO, 
       t.DTA_FIM, 
       t.DTA_INI, 
       t.ID_CONVENIO, 
       t.NME_LOGIN, 
       t.VLR_TARIFA, 
       null DSC_MODALIDADE, 
       null COD_MODALIDADE1, 
       null COD_MODALIDADE2,
       null TPO_ARREC,
       'B'
  from tarifa t, modalidade_tarifa m
 where t.id_convenio = :idConvenioExecParam
   and t.cod_modalidade = m.cod_modalidade
   and t.dta_ini < trunc(sysdate)
   and t.dta_fim is null
   and decode(:dtaInicialExecParam, null, 1, 2) = decode(:dtaInicialExecParam, null, 1, 3)
union
SELECT Tarifa.COD_MODALIDADE, 
       Tarifa.COD_TARIFA, 
       Tarifa.DTA_ATUALIZACAO, 
       Tarifa.DTA_CRIACAO, 
       Tarifa.DTA_FIM, 
       Tarifa.DTA_INI, 
       Tarifa.ID_CONVENIO, 
       Tarifa.NME_LOGIN, 
       Tarifa.VLR_TARIFA, 
       ModalidadeTarifa.DSC_MODALIDADE, 
       ModalidadeTarifa.COD_MODALIDADE AS COD_MODALIDADE1, 
       ModalidadeTarifa.COD_MODALIDADE AS COD_MODALIDADE2,
       ModalidadeTarifa.TPO_ARREC,
       'C'
FROM TARIFA Tarifa, MODALIDADE_TARIFA ModalidadeTarifa
WHERE Tarifa.cod_modalidade = ModalidadeTarifa.cod_modalidade
and (:idConvenioExecParam is null or Tarifa.id_convenio = :idConvenioExecParam)
and ( ( :dtaInicialExecParam is null and Tarifa.dta_ini >= trunc(sysdate) ) or Tarifa.dta_ini >= :dtaInicialExecParam   )
and (   :dtaFinalExecParam is null or (Tarifa.dta_fim <= :dtaFinalExecParam or Tarifa.dta_fim is null)   )
ORDER BY DSC_MODALIDADE,dta_ini,dta_fim;