Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT tf.cod_tipofdv, t.str_nombre AS str_nombre_tipo, i.cod_instfdv_pk, i.str_nombre AS str_nombre, x.cod_tipofdvatrib, tf.str_nombre AS atributo,
- (CASE
- WHEN tf.str_listacerrada = 'S' THEN (SELECT lcd.str_codigo FROM listacerradadet lcd WHERE lcd.cod_listacerradadet_pk = x.ldc_valor)
- WHEN tf.str_listacerrada = 'N' AND x.cod_instfdv_ref IS NOT NULL THEN (SELECT v.str_nombre FROM instfdv v WHERE v.cod_instfdv_pk = x.cod_instfdv_ref)
- WHEN tf.str_listacerrada = 'N' AND x.cod_instfdv_ref IS NULL THEN x.str_valor
- ELSE NULL
- END) AS valor, i.cod_depende_de AS depende_de, s.str_nombre AS supervisor
- FROM instfdv i
- JOIN instfdvatrib x ON x.cod_instfdv = i.cod_instfdv_pk
- JOIN tipofdvatrib tf ON tf.cod_tipofdvatrib_pk = x.cod_tipofdvatrib
- JOIN tipofdv t ON t.cod_tipofdv_pk = tf.cod_tipofdv
- JOIN periodoprocesos pp ON pp.cod_perproc_pk = 37990
- JOIN procesos p ON p.cod_proceso_pk = pp.cod_proceso
- JOIN gruporeglas gr ON gr.cod_gruporegla_pk = p.cod_gruporegla
- JOIN gruporegla_fdv fdv ON fdv.cod_gruporegla = gr.cod_gruporegla_pk
- JOIN listacerradadet lcd ON lcd.cod_listacerradadet_pk = fdv.cod_fdv AND lcd.cod_tipofdv = tf.cod_tipofdv
- LEFT JOIN instfdv s ON s.cod_instfdv_pk = i.cod_depende_de
- WHERE i.fecha_desde <= pp.fec_desde
- AND COALESCE(i.fecha_hasta, CURRENT_DATE) >= pp.fec_desde
- ORDER BY i.str_nombre ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement