Subversion Repositories DevTools

Rev

Rev 15 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
15 rsolanki 1 
/* BOM History */
2 
SELECT TO_CHAR( ot.DATE_TIME_STAMP,'DD-MON-YYYY HH24:MI:SS' ) AS DATE_TIME_STAMP,
3 
	   ot.TRAIL_ACTION,
4 
	   usr.FULL_NAME,
5 
	   usr.USER_EMAIL
6 
  FROM OS_TRAIL ot,
7 
  	   USERS usr
8 
 WHERE ot.USER_ID = usr.USER_ID
9 
   AND ot.OS_ID = :OS_ID
10 
 ORDER BY ot.DATE_TIME_STAMP DESC
11