Subversion Repositories DevTools

/* BOM History */
SELECT TO_CHAR( bt.DATE_TIME_STAMP,'DD-MON-YYYY HH24:MI:SS' ) AS DATE_TIME_STAMP,
           bt.TRAIL_ACTION,
           bt.TRAIL_COMMENTS,
           usr.FULL_NAME,
           usr.USER_EMAIL
  FROM BOM_TRAIL bt,
           USERS usr
 WHERE bt.USER_ID = usr.USER_ID
   AND bt.BOM_ID = :BOM_ID      
 ORDER BY bt.DATE_TIME_STAMP DESC