Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT C.NOME AS CLIENTE, C2.NOME AS GESTOR
- FROM CLIENTE C INNER JOIN COLABORADOR C2
- ON C.COD_GESTOR = C2.COD_COLABORADOR
- WHERE (SELECT COUNT(*)
- FROM PEDIDO_ASSISTENCIA P INNER JOIN LICENCA L
- ON (P.COD_MODULO = L.COD_MODULO)
- WHERE (P.COD_CLIENTE = C.COD_CLIENTE AND (EXTRACT(YEAR FROM L.DATA_LICENCA)>=(EXTRACT(YEAR FROM SYSDATE)-2)) AND P.COD_TIPO_ASSISTENCIA = 1)) > 0
- AND
- (SELECT COUNT(*)
- FROM PEDIDO_ASSISTENCIA P INNER JOIN LICENCA L
- ON (P.COD_MODULO = L.COD_MODULO)
- WHERE (P.COD_CLIENTE = C.COD_CLIENTE AND (EXTRACT(YEAR FROM L.DATA_LICENCA)>=(EXTRACT(YEAR FROM SYSDATE)-2)) AND P.COD_TIPO_ASSISTENCIA = 2)) > 0
- AND
- (SELECT COUNT(*)
- FROM PEDIDO_ASSISTENCIA P INNER JOIN LICENCA L
- ON (P.COD_MODULO = L.COD_MODULO)
- WHERE (P.COD_CLIENTE = C.COD_CLIENTE AND (EXTRACT(YEAR FROM L.DATA_LICENCA)>=(EXTRACT(YEAR FROM SYSDATE)-2)) AND P.COD_TIPO_ASSISTENCIA = 3)) > 0
- AND
- (SELECT COUNT(*)
- FROM PEDIDO_ASSISTENCIA P INNER JOIN LICENCA L
- ON (P.COD_MODULO = L.COD_MODULO)
- WHERE (P.COD_CLIENTE = C.COD_CLIENTE AND (EXTRACT(YEAR FROM L.DATA_LICENCA)>=(EXTRACT(YEAR FROM L.DATA_LICENCA)-2)) AND P.COD_TIPO_ASSISTENCIA = 4)) > 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement