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