SELECT C.CON_IN_CODIGO,
(SELECT MAX(FA.PFA_DT_INICIAL)
FROM GLO_PROCESSO_FLUXO_ANDA FA
INNER JOIN GLO_PROCESSO_FLUXO FL
ON FA.PFLU_IN_CODIGO = FL.PFLU_IN_CODIGO
AND FL.PFLU_CHAVE_PK = C.CON_IN_CODIGO
AND FL.PFLU_NOMETABELA = 'RH_FORM_CONTRATACAO') DATA_MOV
FROM RH_FORM_CONTRATACAO C
WHERE UPPER(c.CON_ST_STATUS) NOT IN('FINALIZADO','CANCELADO')
and (SELECT MAX(FA.PFA_DT_INICIAL)
FROM GLO_PROCESSO_FLUXO_ANDA FA
INNER JOIN GLO_PROCESSO_FLUXO FL
ON FA.PFLU_IN_CODIGO = FL.PFLU_IN_CODIGO
AND FL.PFLU_CHAVE_PK = C.CON_IN_CODIGO
AND FL.PFLU_NOMETABELA = 'RH_FORM_CONTRATACAO') < ADD_MONTHS(SYSDATE,-2);
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter