Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /* Relatorio Registro de Atendimento */
- SELECT
- ed.dmda_num_inscr || '/' || ed.dmda_ano AS "Número Demanda",
- bs.sta_titulo AS "Status",
- bp.pes_nome AS "Candidato",
- b.pes_nome AS "Funcionário",
- to_char(a.dmdara_dthra, 'DD/MM/YYYY HH24:MI:SS') AS "Data/Hora",
- a.dmdara_qm_atendeu AS "Contato",
- CASE
- WHEN a.dmdara_vaga_oferecida = '0' THEN 'NÃO'
- WHEN a.dmdara_vaga_oferecida = '1' THEN 'SIM'
- ELSE 'N/D'
- END AS "Vaga Oferecida?",
- a.dmdara_obs AS "Observação"
- FROM edu_demanda_reg_atend a
- INNER JOIN edu_demanda ed
- ON ed.dmda_cod = a.dmdara_dmdacod
- INNER JOIN edu_demanda_status eds
- ON eds.dmdast_dmdacod = ed.dmda_cod
- AND eds.dmdast_ativo = 1
- INNER JOIN bas_status bs
- ON bs.sta_numero = eds.dmdast_status
- AND bs.sta_tipo = 'DEMANDA_STATUS'
- INNER JOIN bas_pessoa b
- ON b.pes_cod = a.dmdara_pescod
- INNER JOIN bas_pessoa bp
- ON bp.pes_cod = ed.dmda_pescod
- WHERE
- 1 = 1
- AND ed.dmda_num_inscr = :NUMERO_DEMANDA
- AND ed.dmda_ano = :ANO
- ORDER BY
- a.dmdara_dthra;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement