Subversion Repositories DevTools

/* BOM History */

SELECT TO_CHAR( nt.DATE_TIME_STAMP,'DD-MON-YYYY HH24:MI:SS' ) AS DATE_TIME_STAMP,

	   nt.TRAIL_ACTION,

	   usr.FULL_NAME,

	   usr.USER_EMAIL

  FROM NODE_TRAIL nt,

  	   USERS usr

 WHERE nt.USER_ID = usr.USER_ID

   AND nt.NODE_ID = :NODE_ID	

 ORDER BY nt.DATE_TIME_STAMP DESC