Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- String sql = "SELECT "+
- "'C' AS tpEvento, EMPRESA AS empresa, NR_PROTOCOLO AS nrProtocolo, ID_PRESTADOR AS idPrestador, ID_LOCALIDADE AS idLocalidade, ID_EVENTO AS idEvento, "+
- "VL_TOTAL_APRESENTADO, VL_TOTAL_LIQUIDO, 'teste' AS con_condicaoparacobranca, 5 as con_tipo, '5' AS con_valor, 5 AS con_iddoobjeto, ID_USUARIO, CONTROLE, DT_EVENTO, ID_TABELA_REF, "+
- "'teste' AS PRODECIMENTO, '2015-06-01' AS con_datavalidadeinicial, '2016-06-01' AS con_datavalidadefinal, 5 AS sgp_id_grupo_proc, 1 AS QUANTIDADE, NR_GUIA " +
- "FROM SA_PROTOCOLO_CONSULTA " +
- "WHERE " +
- "NR_CONTRATO = '11529' AND " +
- "DT_EVENTO > '2015-07-06' AND " +
- "COPARTICIPACAO = 2 "+
- "UNION ALL " +
- "SELECT " +
- "'S' AS tpEvento, EMPRESA AS empresa, NR_PROTOCOLO AS nrProtocolo, ID_PRESTADOR AS idPrestador, ID_LOCALIDADE AS idLocalidade, ID_EVENTO AS idEvento, "+
- "VL_TOTAL_APRESENTADO, VL_TOTAL_LIQUIDO, 'teste' AS con_condicaoparacobranca, 5 as con_tipo, '5' AS con_valor, 5 AS con_iddoobjeto, ID_USUARIO, CONTROLE, DT_EVENTO, ID_TABELA_REF, "+
- "'teste' AS PRODECIMENTO, '2015-06-01' AS con_datavalidadeinicial, '2016-06-01' AS con_datavalidadefinal, 5 AS sgp_id_grupo_proc, 1 AS QUANTIDADE, NR_GUIA "+
- "FROM SA_PROTOCOLO_SADT "+
- "WHERE " +
- "NR_CONTRATO = '11529' AND "+
- "DT_EVENTO > '2015-07-06' AND "+
- "COPARTICIPACAO = 2 "+
- "UNION ALL " +
- "SELECT " +
- "'M' AS tpEvento, EMPRESA AS empresa, NR_PROTOCOLO AS nrProtocolo, ID_PRESTADOR AS idPrestador, ID_LOCALIDADE AS idLocalidade, ID_EVENTO AS idEvento, "+
- "VL_TOTAL_APRESENTADO, VL_TOTAL_LIQUIDO, 'teste' AS con_condicaoparacobranca, 5 as con_tipo, '5' AS con_valor, 5 AS con_iddoobjeto, ID_USUARIO, CONTROLE, DT_EVENTO, ID_TABELA_REF, "+
- "'teste' AS PRODECIMENTO, '2015-06-01' AS con_datavalidadeinicial, '2016-06-01' AS con_datavalidadefinal, 5 AS sgp_id_grupo_proc, 1 AS QUANTIDADE, NR_GUIA "+
- "FROM SA_PROTOCOLO_GAM " +
- "WHERE " +
- "NR_CONTRATO = '11529' AND "+
- "DT_EVENTO > '2015-07-06' AND "+
- "COPARTICIPACAO = 2 " +
- "UNION ALL " +
- "SELECT "+
- "'H' AS tpEvento, EMPRESA AS empresa, NR_PROTOCOLO AS nrProtocolo, ID_PRESTADOR AS idPrestador, ID_LOCALIDADE AS idLocalidade, ID_EVENTO AS idEvento, "+
- "VL_TOTAL_APRESENTADO, VL_TOTAL_LIQUIDO, 'teste' AS con_condicaoparacobranca, 5 as con_tipo, '5' AS con_valor, 5 AS con_iddoobjeto, ID_USUARIO, CONTROLE, DT_EVENTO, 5 AS ID_TABELA_REF, "+
- "'teste' AS PRODECIMENTO, '2015-06-01' AS con_datavalidadeinicial, '2016-06-01' AS con_datavalidadefinal, 5 AS sgp_id_grupo_proc, 1 AS QUANTIDADE, NR_GUIA "+
- "FROM SA_PROTOCOLO_GIH "+
- "WHERE " +
- "NR_CONTRATO = '11529' AND "+
- "DT_EVENTO > '2015-07-06' AND "+
- "COPARTICIPACAO = 2";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement