Subversion Repositories DevTools

Rev

Rev 64 | Blame | Compare with Previous | Last modification | View Log | RSS feed

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