Constant Field Values

Contents

• br.com.*
• systextil.dao.*

br.com.*

br.com.intersys.systextil.function.BaixaOrdemEstagio

Modifier and Type	Constant Field	Value
public static final String	BAIXA	"B"
public static final String	ESTORNO	"E"

br.com.intersys.systextil.function.BuscaAtributosRemessa

Modifier and Type	Constant Field	Value
public static final int	NOT_FOUND	-35

br.com.intersys.systextil.function.BuscaIGV

Modifier and Type	Constant Field	Value
public static final int	versao_systextil5_f	1

br.com.intersys.systextil.function.ChecaData

Modifier and Type	Constant Field	Value
public static final int	ERROR_CODE	-99

br.com.intersys.systextil.function.DestinoCorte

Modifier and Type	Constant Field	Value
public static final int	TIPO_REGISTRO	341

br.com.intersys.systextil.function.EncontraConta

Modifier and Type	Constant Field	Value
public static final int	ERROR_CODE	-99

br.com.intersys.systextil.function.GetCorOrdemDeCorte

Modifier and Type	Constant Field	Value
public static final int	A_PLANEJAR	0
public static final int	CORTE_FINALIZADO	3
public static final int	CORTE_INICIADO	2
public static final int	NAO_RELACIONADO_AO_CORTE	9
public static final int	PLANEJADA	1

br.com.intersys.systextil.function.InserirHist200

Modifier and Type	Constant Field	Value
public final int	versao_systextil5_f	1

br.com.intersys.systextil.function.creditopedido.ProcessadorDeSituacaoAnalise

Modifier and Type	Constant Field	Value
public static final int	INATIVA	1
public static final int	ISENTO	1

br.com.intersys.systextil.function.creditopedido.SituacaoAnalise

Modifier and Type	Constant Field	Value
protected final int	ISENTO	1

br.com.intersys.systextil.function.pcpb.geral.TipoDeProdutoGlobal

Modifier and Type	Constant Field	Value
public static final int	TIPO_ORDEM_ACABAMENTO	4
public static final int	TIPO_ORDEM_TECELAGEM	3
public static final int	TIPO_ORDEM_TINGIMENTO	2
public static final int	TIPO_ORDEM_URDIMENTO	1

br.com.intersys.systextil.function.pcpb.geral.ValidacoesBlocoK

Modifier and Type	Constant Field	Value
public static final String	BENEFICIAMENTO	"BENEFICIAMENTO"
public static final String	ORDEM_BASE	"ordem_base"
public static final String	ORDEM_ORIGINAL	"ordem_original"
public static final String	ORDEM_REPROCESSO	"ordem_reprocesso"
public static final String	TECELAGEM	"TECELAGEM"

systextil.dao.*

systextil.dao.AssinaturaBloqueio

Modifier and Type	Constant Field	Value
public static final int	CODIGO_PROCESSO_PEDIDO	1

systextil.dao.AtributosDeTingimento

Modifier and Type	Constant Field	Value
public static final String	BASE_FIND_QUERY	"select * from basi_450 "

systextil.dao.CadastrosGenericos

Modifier and Type	Constant Field	Value
public static final String	exists	"select 1 from hdoc_001 "

systextil.dao.Calendario

Modifier and Type	Constant Field	Value
public static final String	ANTERIOR	"<"
public static final String	ANTERIOR_OU_IGUAL	"<="
public static final String	DIA_UTIL	"dia_util"
public static final String	DIA_UTIL_FINAN	"dia_util_finan"
public static final String	IGUAL	"="
public static final String	POSTERIOR	">"
public static final String	POSTERIOR_OU_IGUAL	">="

systextil.dao.CentroDeCustoMaquina

Modifier and Type	Constant Field	Value
public static final int	DIA_SEMANA_POR_DATA	0

systextil.dao.CGProdutoGlobal

Modifier and Type	Constant Field	Value
public static final String	EXISTS	"select 1 from hdoc_001 "

systextil.dao.CodigoContabil

Modifier and Type	Constant Field	Value
public static final int	TIPO_COFINS	11
public static final int	TIPO_CREDITO	3
public static final int	TIPO_DEBITO	1
public static final int	TIPO_ICMS	6
public static final int	TIPO_IPI	8
public static final int	TIPO_PIS	10

systextil.dao.CondicaoDePagamento

Modifier and Type	Constant Field	Value
public static final int	SITUACAO_INATIVA	2

systextil.dao.ContaCorrente

Modifier and Type	Constant Field	Value
public static final String	CREDITO	"C"
public static final String	DEBITO	"D"

systextil.dao.CoresPadronagens

Modifier and Type	Constant Field	Value
public static final int	TIPO_COMBINACAO_DE_CORES	2
public static final int	TIPO_COR_LISA	1
public static final int	TIPO_DESENHO	2
public static final int	TIPO_ESTAMPA	2

systextil.dao.Deposito

Modifier and Type	Constant Field	Value
public static final int	TIPO_PRONTA_ENTREGA	1

systextil.dao.DestinosOrdemPlanejamento

Modifier and Type	Constant Field	Value
public static final int	CONFECCAO	1

systextil.dao.DivisaoProducao

Modifier and Type	Constant Field	Value
public static final String	BASE_EXISTS_QUERY	"select 1 from basi_180 "
public static final String	BASE_FIND_QUERY	"select basi_180.* from basi_180 "

systextil.dao.Duplicata

Modifier and Type	Constant Field	Value
public static final String	SELECT_ALL_FROM_FATU_070	"SELECT fatu_070.codigo_empresa, fatu_070.cli_dup_cgc_cli9, fatu_070.cli_dup_cgc_cli4, fatu_070.cli_dup_cgc_cli2, fatu_070.tipo_titulo, fatu_070.num_duplicata, fatu_070.seq_duplicatas, fatu_070.data_venc_duplic, fatu_070.valor_duplicata, fatu_070.situacao_duplic, fatu_070.cod_canc_duplic, fatu_070.data_canc_duplic, fatu_070.perc_juro_duplic, fatu_070.perc_desc_duplic, fatu_070.portador_duplic, fatu_070.serie_nota_fisc, fatu_070.num_nota_fiscal, fatu_070.numero_bordero, fatu_070.quantidade, fatu_070.tecido_peca, fatu_070.percentual_comis, fatu_070.valor_comis, fatu_070.base_calc_comis, fatu_070.pedido_venda, fatu_070.nr_titulo_banco, fatu_070.cod_rep_cliente, fatu_070.posicao_duplic, fatu_070.port_anterior, fatu_070.vencto_anterior, fatu_070.duplic_emitida, fatu_070.nr_solicitacao, fatu_070.data_emissao, fatu_070.numero_titulo, fatu_070.data_transf_tit, fatu_070.numero_sequencia, fatu_070.valor_remessa, fatu_070.cod_historico, fatu_070.compl_historico, fatu_070.cod_local, fatu_070.previsao, fatu_070.moeda_titulo, fatu_070.valor_moeda, fatu_070.data_prorrogacao, fatu_070.conta_corrente, fatu_070.numero_remessa, fatu_070.perc_comis_crec, fatu_070.duplic_impressa, fatu_070.cod_transacao, fatu_070.codigo_contabil, fatu_070.tit_renegociado, fatu_070.seq_end_cobranca, fatu_070.num_contabil, fatu_070.comissao_lancada, fatu_070.referente_nf, fatu_070.tipo_tit_origem, fatu_070.num_dup_origem, fatu_070.seq_dup_origem, fatu_070.cli9resptit, fatu_070.cli4resptit, fatu_070.cli2resptit, fatu_070.origem_pedido, fatu_070.cgc9_endosso, fatu_070.cgc4_endosso, fatu_070.cgc2_endosso, fatu_070.controle_cheque, fatu_070.tipo_comissao, fatu_070.codigo_administr, fatu_070.comissao_administr, fatu_070.perc_comis_crec_adm, fatu_070.tit_baixar, fatu_070.posicao_ant, fatu_070.mensagem_boleto, fatu_070.atraso_pela_renegociacao, fatu_070.data_ult_movim_pagto, fatu_070.data_ult_movim_credito, fatu_070.saldo_duplicata, fatu_070.cod_forma_pagto, fatu_070.nr_cupom, fatu_070.nr_mtv_prorrogacao, fatu_070.nr_remessa_inadimplencia, fatu_070.nr_solicitacao_inadimplencia, fatu_070.situacao_inadimplencia, fatu_070.valor_desp_cobr, fatu_070.cond_pagto_vendor, fatu_070.executa_trigger, fatu_070.valor_desconto_aux, fatu_070.valor_juros_aux, fatu_070.valor_saldo_aux, fatu_070.nr_identificacao, fatu_070.cod_carteira, fatu_070.motivo_bxa_serasa_pefin, fatu_070.cd_centro_custo, fatu_070.nr_adiantamento, fatu_070.flag_alteracao_boleto, fatu_070.tipopix, fatu_070.chavepix, fatu_070.bolepix, fatu_070.nr_identificacao_fnd, fatu_070.observacao from fatu_070 "

systextil.dao.Embalagens

Modifier and Type	Constant Field	Value
public static final String	BASE_FIND_QUERY	"select fatu_100.* from fatu_100 "

systextil.dao.EstoqueMovimentacao

Modifier and Type	Constant Field	Value
public static final String	TIPO_ENTRADA	"E"
public static final String	TIPO_SAIDA	"S"

systextil.dao.HistoricoContabil

Modifier and Type	Constant Field	Value
public static final int	ATUALIZA_COMISSAO	1
public static final int	NAO_ATUALIZA_COMISSAO	2
public static final int	SINAL_TITULO_ESTORNO	2
public static final int	SINAL_TITULO_NEUTRO	0
public static final int	SINAL_TITULO_PAGAMENTO	1

systextil.dao.IntePedidoVenda

Modifier and Type	Constant Field	Value
public static final String	SELECT	"select ana_comercial_concessao_desc, ana_comercial_prazo, ana_comercial_comissao, ana_comercial_obs, cod_funcionario, valor_frete_pedido, numero_controle, tipo_registro, obs1, obs2, obs3, obs4, obs5, obs6, obs7, sit_importacao, loja, data_importacao, cod_repre, codigo_empresa, data_emis_venda, data_digit_venda, perc_comis_venda, perc_desc_duplic, seq_end_entrega, seq_end_cobranca, cod_via_transp, trans_pv_forne9, trans_pv_forne4, trans_pv_forne2, cod_banco, data_arquivo, frete_venda, numero_semana, novo_pedido_venda, desconto_item1, desconto_item2, desconto_item3, tipo_comissao, classificacao_pedido, codigo_deposito, obs1_nf, obs2_nf, obs3_nf, obs4_nf, obs5_nf, obs1_prod, obs2_prod, obs3_prod, obs4_prod, obs5_prod, tipo_pedido, tipo_prod_pedido, exigencia_requisito_ambiental, especificar_requisito, origem_pedido, executa_trigger, criterio_pedido, administrador, pedido_cotacao, id_pedido_forca_vendas, criterio_qualidade, desconto_extra, prazo_extra, cond_pgto_extra, cod_local, cod_catalogo, aceita_antecipacao, permite_parcial, cod_preposto, codigo_registro, pedido_venda, tecido_peca, data_entrega, cliente9, cliente4, cliente2, pedido_cliente, colecao_tabela, mes_tabela, sequencia_tabela, codigo_moeda, cond_pgto_venda, desconto1, desconto2, desconto3, trans_re_forne9, trans_re_forne4, trans_re_forne2, nat_oper, nat_est_oper, obs_lista_conteudo_1, obs_lista_conteudo_2, obs_lista_conteudo_3, perc_comissao_fatu_repres, perc_comissao_fatu_adm, pedido_origem, nome_preposto, data_base_fatur, pronta_entrega, servico_postagem, observacao, nr_autorizacao_opera, cod_forma_pagto from inte_100 "

systextil.dao.LancamentoContabil

Modifier and Type	Constant Field	Value
public static final String	CREDITO	"C"
public static final String	DEBITO	"D"

systextil.dao.Mensagem

Modifier and Type	Constant Field	Value
public static final String	INFORMAR	"S"
public static final String	NAO_INFORMAR	"N"

systextil.dao.NaturezaDeOperacao

Modifier and Type	Constant Field	Value
public static final int	NATUREZA_ATIVA	0

systextil.dao.NotaFiscal

Modifier and Type	Constant Field	Value
public static final String	TIPO_ENTRADA	"E"
public static final String	TIPO_SAIDA	"S"

systextil.dao.NotaFiscalDeEntradaItem

Modifier and Type	Constant Field	Value
public static final String	EXISTS_CAPA_NOTA	"select 1 from obrf_015 where capa_ent_nrdoc=? and capa_ent_serie=? and capa_ent_forcli9=? and capa_ent_forcli4=? and capa_ent_forcli2=? "
public static final String	FROM_CAPA_NOTA	"select * from obrf_015 where capa_ent_nrdoc=? and capa_ent_serie=? and capa_ent_forcli9=? and capa_ent_forcli4=? and capa_ent_forcli2=? "

systextil.dao.NotaFiscalDeSaida

Modifier and Type	Constant Field	Value
public static final int	ORIGEM_FATURAMENTO	1
public static final int	ORIGEM_LOJA	3
public static final int	ORIGEM_OBRIGACAO_FISCAL	2
public static final int	SITUACAO_CALCULADA	0
public static final int	SITUACAO_CALCULADA_DUPLICATA	6
public static final int	SITUACAO_CANCELADA	2
public static final int	SITUACAO_EMITIDA	1
public static final int	SITUACAO_ENTRADA_CONFIRMADA	4
public static final int	SITUACAO_PROBLEMA_ESTOQUE	3
public static final int	SITUACAO_PROCESSO_INCOMPLETO	5

systextil.dao.NotaFiscalDeSaidaItem

Modifier and Type	Constant Field	Value
public static final String	TABELA_ORIGEM	"FATU_060"

systextil.dao.NotaFiscalSerie

Modifier and Type	Constant Field	Value
public static final int	SITUACAO_ATIVA	0
public static final int	SITUACAO_INATIVA	1
public static final int	TIPO_NF_ENTRADA	1

systextil.dao.ObservacoesRolo

Modifier and Type	Constant Field	Value
public static final String	BASE_EXISTS_QUERY	"select 1 from pcpt_022 "
public static final String	BASE_FIND_QUERY	"select pcpt_022.* from pcpt_022 "
public static final String	WHERE_PK	"where pcpt_022.codigo_rolo = ? and pcpt_022.usuario = ? and pcpt_022.data = ? and pcpt_022.hora = ?"

systextil.dao.OrcamentoItem

Modifier and Type	Constant Field	Value
public static final String	TIPO_TROCA	"T"
public static final String	TIPO_VENDA	"V"

systextil.dao.OrdemAgrupadaConfeccao

Modifier and Type	Constant Field	Value
public static final int	NAO_CANCELADA	0
public static final String	SEM_OBSERVACAO	""

systextil.dao.OrdemDeCorte

Modifier and Type	Constant Field	Value
public static final String	BASE_EXISTS_QUERY	"select 1 from pcpc_020 "
public static final String	BASE_FIND_QUERY	"select pcpc_020.* from pcpc_020 "

systextil.dao.OrdemServicoItemAReceber

Modifier and Type	Constant Field	Value
public static final int	SITUACAO_ABERTO	1
public static final int	SITUACAO_BAIXA_PARCIAL	3
public static final int	SITUACAO_EM_PROCESSO	2

systextil.dao.ParametrosDeEmpresa

Modifier and Type	Constant Field	Value
protected static final String	FATU_500	"FATU_500"
protected static final String	FATU_501	"FATU_501"
protected static final String	FATU_502	"FATU_502"
protected static final String	FATU_503	"FATU_503"
protected static final String	FATU_504	"FATU_504"

systextil.dao.ParametrosGenericos

Modifier and Type	Constant Field	Value
public static final String	BASE_EXISTS_QUERY	"select 1 from hdoc_001"
public static final String	BASE_FIND_QUERY	"select hdoc_001.* from hdoc_001 "
public static final String	WHERE_PK	"where hdoc_001.tipo=? and hdoc_001.codigo=? and hdoc_001.codigo2=?"

systextil.dao.PeriodoProducao

Modifier and Type	Constant Field	Value
public static final int	ABERTO	0
public static final int	AREA_CONFECCAO	1
public static final int	CONFIRMADO	2
public static final int	FECHADO	3
public static final int	PLANEJADO	1

systextil.dao.PermissaoUsuario

Modifier and Type	Constant Field	Value
public static final String	SIM	"S"

systextil.dao.ProdutoComponente

Modifier and Type	Constant Field	Value
public static final int	COMPRADO	1
public static final int	FABRICADO	2

systextil.dao.ProdutoEmpresaDeposito

Modifier and Type	Constant Field	Value
public static final int	APLICACAO_INDUSTRIALIZACAO	2
public static final int	APLICACAO_MATERIA_PRIMA	3
public static final int	APLICACAO_USO_E_CONSUMO	1
public static final int	ORIGEM_COMPRADO	1
public static final int	ORIGEM_CONFORME_REFERENCIA	0
public static final int	ORIGEM_FABRICADO	2

systextil.dao.ProdutoEmpresaMesCusto

Modifier and Type	Constant Field	Value
public static final String	CUSTO_CONTRATIPO	"CC"
public static final String	CUSTO_INFORMADO	"CI"
public static final String	CUSTO_PADRAO	"CP"

systextil.dao.ProdutoEstoqueCiclicoDAO

Modifier and Type	Constant Field	Value
public static final String	SQL_POR_PRODUTO_COM_DEPOSITO	"select ESTQ_040.CDITEM_NIVEL99, ESTQ_040.CDITEM_GRUPO, ESTQ_040.CDITEM_SUBGRUPO, ESTQ_040.CDITEM_ITEM, ESTQ_040.DEPOSITO, ESTQ_040.LOTE_ACOMP, ESTQ_040.QTDE_ESTOQUE_ATU from ESTQ_040 inner join BASI_030 ON (BASI_030.NIVEL_ESTRUTURA = ESTQ_040.CDITEM_NIVEL99 and BASI_030.REFERENCIA = CDITEM_GRUPO) inner join BASI_205 ON (BASI_205.TIPO_VOLUME = 0 and BASI_205.LOCAL_DEPOSITO = ? and ESTQ_040.DEPOSITO = BASI_205.CODIGO_DEPOSITO) and ESTQ_040.CDITEM_NIVEL99 = ? and (ESTQ_040.DEPOSITO = ? ) and (ESTQ_040.CDITEM_GRUPO = ? or ? = \'XXXXXX\') and (ESTQ_040.CDITEM_SUBGRUPO = ? or ? = \'XXXX\') and (ESTQ_040.CDITEM_ITEM = ? or ? = \'XXXXXXX\') order by DBMS_RANDOM.VALUE() "
public static final String	SQL_POR_PRODUTO_SEM_DEPOSITO	"select ESTQ_040.CDITEM_NIVEL99, ESTQ_040.CDITEM_GRUPO, ESTQ_040.CDITEM_SUBGRUPO, ESTQ_040.CDITEM_ITEM, ESTQ_040.DEPOSITO, ESTQ_040.LOTE_ACOMP, 0 AS QTDE_ESTOQUE_ATU from ESTQ_040 inner join BASI_030 ON (BASI_030.NIVEL_ESTRUTURA = ESTQ_040.CDITEM_NIVEL99 and BASI_030.REFERENCIA = CDITEM_GRUPO) inner join BASI_205 ON (BASI_205.TIPO_VOLUME = 0 and BASI_205.LOCAL_DEPOSITO = ? and ESTQ_040.DEPOSITO = BASI_205.CODIGO_DEPOSITO) and ESTQ_040.CDITEM_NIVEL99 = ? and (ESTQ_040.CDITEM_GRUPO = ? or ? = \'XXXXXX\') and (ESTQ_040.CDITEM_SUBGRUPO = ? or ? = \'XXXX\') and (ESTQ_040.CDITEM_ITEM = ? or ? = \'XXXXXXX\') order by DBMS_RANDOM.VALUE() "
public static final String	SQL_PRODUTOS_IMG_RETRO	" select estq_049.nivel, estq_049.grupo, estq_049.subgrupo, estq_049.item from estq_049 where estq_049.data_imagem >= to_char(sysdate -?) and estq_049.data_imagem <> to_char(sysdate) and estq_049.cod_deposito = ? and estq_049.nivel = ? group by estq_049.nivel, estq_049.grupo, estq_049.subgrupo, estq_049.item "
public static final String	SQL_PRODUTOS_IMG_RETRO_DIA	" select estq_049.nivel, estq_049.grupo, estq_049.subgrupo, estq_049.item from estq_049 where estq_049.data_imagem > to_char(sysdate -?) and estq_049.cod_deposito = ? and estq_049.nivel = ? group by estq_049.nivel, estq_049.grupo, estq_049.subgrupo, estq_049.item "
public static final String	SQL_PRODUTOS_POR_ESTOQUE	"select ESTQ_040.CDITEM_NIVEL99, ESTQ_040.CDITEM_GRUPO, ESTQ_040.CDITEM_SUBGRUPO, ESTQ_040.CDITEM_ITEM, ESTQ_040.DEPOSITO, ESTQ_040.LOTE_ACOMP, ESTQ_040.QTDE_ESTOQUE_ATU, BASI_030.CONTA_ESTOQUE || \' - \' || BASI_150.DESCR_CT_ESTOQUE CONTA_ESTOQUE from ESTQ_040 inner join BASI_030 ON (BASI_030.NIVEL_ESTRUTURA = ESTQ_040.CDITEM_NIVEL99 and BASI_030.REFERENCIA = CDITEM_GRUPO) inner join BASI_150 ON (BASI_150.CONTA_ESTOQUE = BASI_030.CONTA_ESTOQUE) inner join BASI_205 ON (BASI_205.TIPO_VOLUME = 0 and BASI_205.LOCAL_DEPOSITO = ? and ESTQ_040.DEPOSITO = BASI_205.CODIGO_DEPOSITO) and (BASI_030.CONTA_ESTOQUE in (%s)) and ESTQ_040.CDITEM_NIVEL99 = ? and (ESTQ_040.DEPOSITO = ? or ? = 0) %s order by DBMS_RANDOM.VALUE()"
public static final String	SQL_PRODUTOS_POR_MOVIMENTO	"select ESTQ_040.CDITEM_NIVEL99, ESTQ_040.CDITEM_GRUPO, ESTQ_040.CDITEM_SUBGRUPO, ESTQ_040.CDITEM_ITEM, ESTQ_040.DEPOSITO, ESTQ_040.LOTE_ACOMP, ESTQ_040.QTDE_ESTOQUE_ATU from ESTQ_040 inner join BASI_030 ON (BASI_030.NIVEL_ESTRUTURA = ESTQ_040.CDITEM_NIVEL99 and BASI_030.REFERENCIA = CDITEM_GRUPO) inner join BASI_205 ON (BASI_205.TIPO_VOLUME = 0 and BASI_205.LOCAL_DEPOSITO = ? and ESTQ_040.DEPOSITO = BASI_205.CODIGO_DEPOSITO) and ESTQ_040.CDITEM_NIVEL99 = ? and (ESTQ_040.DEPOSITO = ? or ? = 0) %s order by DBMS_RANDOM.VALUE()"
public static final String	SQL_PRODUTOS_POR_UM	"select ESTQ_040.CDITEM_NIVEL99, ESTQ_040.CDITEM_GRUPO, ESTQ_040.CDITEM_SUBGRUPO, ESTQ_040.CDITEM_ITEM, ESTQ_040.DEPOSITO, ESTQ_040.LOTE_ACOMP, ESTQ_040.QTDE_ESTOQUE_ATU, BASI_030.UNIDADE_MEDIDA from ESTQ_040 inner join BASI_030 ON (BASI_030.NIVEL_ESTRUTURA = ESTQ_040.CDITEM_NIVEL99 and BASI_030.REFERENCIA = CDITEM_GRUPO) inner join BASI_205 ON (BASI_205.TIPO_VOLUME = 0 and BASI_205.LOCAL_DEPOSITO = ? and ESTQ_040.DEPOSITO = BASI_205.CODIGO_DEPOSITO) and (BASI_030.UNIDADE_MEDIDA in (?)) and ESTQ_040.CDITEM_NIVEL99 = ? and (ESTQ_040.DEPOSITO = ? or ? = 0) %s order by DBMS_RANDOM.VALUE() "
public static final String	SQL_QTDE_REFERENCIAS	" select count(*) QTDE_REFERENCIAS from rcnb_060 where rcnb_060.tipo_registro = ? and rcnb_060.subgru_estrutura = ? and rcnb_060.nr_solicitacao = ? "
public static final String	SQL_REFERENCIAS	" select RCNB_060.GRUPO_ESTRUTURA_STR, RCNB_060.SUBGRU_ESTRUTURA_STR, RCNB_060.DESCRICAO from rcnb_060 where rcnb_060.tipo_registro = ? and rcnb_060.subgru_estrutura = ? and rcnb_060.nr_solicitacao = ? "

systextil.dao.RegistroDeParadas

Modifier and Type	Constant Field	Value
public static final String	SQL_PK	"select * from efic_090 where data_parada <= ? and maquina_maq_sub_grupo_mq = ? and maquina_maq_sub_sbgr_maq = ? and maquina_nr_maq = ? and parada_cd_area = ? and parada_cd_parad = ? and turno = ? and equipe = ? and hora_inicio = ? and operador_parada = ?"
public static final String	SQL_PK_SEM_HR	"select * from efic_090 where data_parada \t<= ? and maquina_maq_sub_grupo_mq = ? and maquina_maq_sub_sbgr_maq = ? and maquina_nr_maq \t= ? and parada_cd_area \t= ? and parada_cd_parad \t= ? and turno \t= ? and equipe \t= ? and operador_parada = ?"

systextil.dao.RoloDeTecido

Modifier and Type	Constant Field	Value
public static final int	BENEFICIAMENTO	2
public static final int	EM_ESTOQUE	1
public static final int	EM_PRODUCAO	0
public static final int	EM_TRANSPORTE	4
public static final int	FATURADO_FORA_DE_ESTOQUE	2
public static final int	TECELAGEM	4

systextil.dao.SimulacaoFichaDeCustos

Modifier and Type	Constant Field	Value
public static final String	BASE_EXISTS_QUERY	"select 1 from rcnb_850 "
public static final String	BASE_FIND_QUERY	"select rcnb_850.* from rcnb_850 "
public static final String	WHERE_PK	"where rcnb_850.codigo_empresa = ? and rcnb_850.mes = ? and rcnb_850.ano = ? and rcnb_850.nivel_estrutura = ? and rcnb_850.grupo_estrutura = ? and rcnb_850.subgru_estrutura = ? and rcnb_850.item_estrutura = ?and rcnb_850.nr_versao = ? "

systextil.dao.SimulacaoFichaDeCustosMateriaPrima

Modifier and Type	Constant Field	Value
public static final String	BASE_EXISTS_QUERY	"select 1 from rcnb_851 "
public static final String	BASE_FIND_QUERY	"select rcnb_851.* from rcnb_851 "
public static final String	WHERE_PK	"where rcnb_851.codigo_empresa = ? and rcnb_851.mes = ? and rcnb_851.ano = ? and rcnb_851.nivel_estrutura = ? and rcnb_851.grupo_estrutura = ? and rcnb_851.subgru_estrutura = ? and rcnb_851.item_estrutura = ? and rcnb_851.seq_estrutura = ? and and rcnb_851.nivel_explosao = ? and rcnb_851.nivel_componente = ? and rcnb_851.grupo_componente = ? and rcnb_851.subgru_componente = ? and rcnb_851.item_componente = ? and rcnb_851.nr_versao = ?"

systextil.dao.SolicitacaoProcesso

Modifier and Type	Constant Field	Value
public static final int	PASSO_FINALIZADO	2

systextil.dao.SolicitacaoProcessoPassos

Modifier and Type	Constant Field	Value
public static final int	PASSO_EM_ABERTO	1
public static final int	PASSO_FINALIZADO	2

systextil.dao.Tamanho

Modifier and Type	Constant Field	Value
public static final int	TECIDO_NORMAL	1
public static final int	TECIDO_TUBULAR	2

systextil.dao.ValoresClasseDeValor

Modifier and Type	Constant Field	Value
public static final String	BASE_EXISTS_QUERY	"select 1 from rcnb_800 "
public static final String	BASE_FIND_QUERY	"select rcnb_800.* from rcnb_800 "
public static final String	WHERE_PK	"where rcnb_800.mes_classe = ? and rcnb_800.ano_classe = ? and rcnb_800.seq_classe = ? and rcnb_800.classe_valor = ?"

systextil.dao.Volume

Modifier and Type	Constant Field	Value
public static final int	CAIXA_FECHADA	3
public static final int	CONFERIR_PESO	8