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