Advertisement
gkpoll

Untitled

May 2nd, 2019
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.34 KB | None | 0 0
  1.  
  2.   SELECT gft.gep_id_origen
  3.        FROM usr_sat_gft.gft_eventos_postergados gft
  4.        WHERE gft.gep_estado='ERROR'
  5.        AND gft.gep_id_origen
  6.        IN (  SELECT pdoc.ped_cod_documento
  7.              FROM usr_sat_pesef.ped_documento pdoc
  8.              WHERE pdoc.ped_pea_cod_area=3)
  9.              ORDER BY gft.gep_fecha_ejecucion DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement