Consulta com criteria

private static final long serialVersionUID = 8312548265314059367L;

	@Id
	@TableGenerator(name = "ID_ORDEM_VENDA_PK", pkColumnName = "NM_SEQUENCE", pkColumnValue = "ORDEM_VENDA", valueColumnName = "NR_CURRENT_KEY", table = "SEQUENCE_BLOCK", allocationSize = 0)
	@GeneratedValue(strategy = GenerationType.TABLE, generator = "ID_ORDEM_VENDA_PK")
	@Column(name = "ID_ORDEM_VENDA_PK")
	private BigDecimal id;

	@ManyToOne
	@JoinColumn(name = "ID_HOLDING_FK")
	@Fetch(FetchMode.JOIN)	
	private HoldingModel holdingExterna;
	
	@ManyToOne
	@JoinColumn(name = "ID_TIPO_CATEGORIA_FK")
	@Fetch(FetchMode.JOIN)	
	private TipoCategoriaModel tipoCategoria;
	
	@ManyToOne
	@JoinColumn(name = "ID_TIPO_REMUNERACAO_FK")
	@Fetch(FetchMode.JOIN)	
	private TipoRemuneracaoModel tipoRemuneracao;
	
	@ManyToOne
	@JoinColumn(name = "ID_PERIODO_REFERENCIA_FK")
	@Fetch(FetchMode.JOIN)	
	private PeriodoReferenciaModel periodoReferencia;

	@ManyToOne
	@JoinColumn(name = "ID_REMESSA_FK")
	@Fetch(FetchMode.JOIN)	
	private RemessaNotaFiscalSapModel remessa;
	
	@ManyToOne
	@JoinColumn(name = "ID_REMESSA_RETORNO_FK")
	@Fetch(FetchMode.JOIN)	
	private RemessaNotaFiscalSapModel remessaRetorno;

	@ManyToOne
	@JoinColumn(name = "ID_REMESSA_RETORNO_NF_FK")
	@Fetch(FetchMode.JOIN)	
	private RemessaNotaFiscalSapModel remessaRetornoNF;
	
	@Column(name = "SG_UF_EXTERNA")
	private String sgUfExterna;
	
	@Column(name = "SG_UF_INTERNA")
	private String sgUfInterna;
	
	@Column(name = "CD_CLIENTE_SAP")
	private BigDecimal cdClienteSAP;
	
	@Column(name = "CD_MATERIAL_SAP")
	private BigDecimal cdMaterialSAP;
	
	@Column(name = "DC_NUMERO_PEDIDO")
	private String dcNumeroPedido;
	
	@Column(name = "VL_BRUTO")
	private BigDecimal vlBruto;
	
	@Column(name = "DT_CRIACAO")
	private Date dtCriacao;
	
	@Column(name = "NU_ORDEM_VENDA")
	private BigDecimal nuOrdemVenda;
	
	@Column(name = "VL_IMPOSTO")
	private BigDecimal vlImposto;
	
	@Column(name = "DC_ERRO")
	private String dcErro;
	
	@Column(name = "CD_SITUACAO_ORDEM_VENDA")
	private Integer cdSituacaoOrdemVenda;
	
	@Column(name = "DT_CRIACAO_NF")
	private Date dtCriacaoNF;
	
	@Column(name = "VL_LIQUIDO_NF")
	private BigDecimal vlLiquidoNF;
	
	@Column(name = "VL_IMPOSTO_NF")
	private BigDecimal vlImpostoNF;
	
	@Column(name = "VL_CONTESTADO_NF")
	private BigDecimal vlContestadoNF;
	
	@Column(name = "DC_TEXTO_NF")
	private String dcTextoNF;
	
	@Column(name = "FL_ITEM_PAI_NF")
	private String flItemPaiNF;
	
	@Column(name = "DC_DOCTO_FATURAMENTO_NF")
	private String dcDoctoFaturamentoNF;
	
	@Column(name = "DC_DOCTO_NF")
	private String dcDoctoNF;

@Id
	@TableGenerator(name = "ID_ORDEM_VENDA_CONTESTADA_PK", pkColumnName = "NM_SEQUENCE", pkColumnValue = "ORDEM_VENDA_CONTESTADA", valueColumnName = "NR_CURRENT_KEY", table = "SEQUENCE_BLOCK", allocationSize = 0)
	@GeneratedValue(strategy = GenerationType.TABLE, generator = "ID_ORDEM_VENDA_CONTESTADA_PK")
	@Column(name = "ID_ORDEM_VENDA_CONTESTADA_PK")
	private BigDecimal id;

	@ManyToOne
	@JoinColumn(name = "ID_HOLDING_FK")
	@Fetch(FetchMode.JOIN)	
	private HoldingModel holdingExterna;
	
	@ManyToOne
	@JoinColumn(name = "ID_PERIODO_REFERENCIA_FK")
	@Fetch(FetchMode.JOIN)	
	private PeriodoReferenciaModel periodoReferencia;
	
	@ManyToOne
	@JoinColumn(name = "ID_TIPO_CATEGORIA_FK")
	@Fetch(FetchMode.JOIN)	
	private TipoCategoriaModel tipoCategoria;
	
	@ManyToOne
	@JoinColumn(name = "ID_TIPO_REMUNERACAO_FK")
	@Fetch(FetchMode.JOIN)	
	private TipoRemuneracaoModel tipoRemuneracao;

	@ManyToOne
	@JoinColumn(name = "ID_REMESSA_FK")
	@Fetch(FetchMode.JOIN)	
	private RemessaNotaFiscalSapModel remessa;
	
	@ManyToOne
	@JoinColumn(name = "ID_REMESSA_RETORNO_FK")
	@Fetch(FetchMode.JOIN)	
	private RemessaNotaFiscalSapModel remessaRetorno;

	@Column(name = "SG_UF_EXTERNA")
	private String sgUfExterna;
	
	@Column(name = "SG_UF_INTERNA")
	private String sgUfInterna;
	
	@Column(name = "CD_MATERIAL_SAP")
	private BigDecimal cdMaterialSAP;
	
	@Column(name = "NU_ORDEM_VENDA")
	private BigDecimal nuOrdemVenda;
	
	@Column(name = "VL_BRUTO_CONTESTADO")
	private BigDecimal vlBrutoContestado;
	
	@Column(name = "VL_BRUTO_CONTESTADO_SAP")
	private BigDecimal vlBrutoContestadoSAP;
	
	@Column(name = "CD_SITUACAO_ORDEM_VENDA")
	private Integer cdSituacaoOrdemVenda;
	
	@Column(name = "DT_CRIACAO")
	private Date dtCriacao;
	
	@Column(name = "NU_NOTA_FISCAL")
	private BigDecimal nuNotaFiscal;
	
	@Column(name = "DC_DOCTO_COMPENSACAO")
	private String dcDoctoCompensacao;
	
	@Column(name = "DC_DOCTO_CONTABIL")
	private String dcDoctoContabil;
	
	@Column(name = "DC_DOCTO_FATURA")
	private String dcDoctoFatura;
	
	@Column(name = "DC_ERRO")
	private String dcErro;