Subversion Repositories DevTools

Rev

Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed 

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