---Get Application User Login Session Details Oracle R12
SELECT
SUBSTR(d.user_name,1,50) User_Name
, a.pid Process_ID
, b.sid Session_ID
, b.serial#
, to_char(c.start_time,'DD-MON-RRRR HH:MI:SS AM') start_time
, to_char(c.end_time,'DD-MON-RRRR HH:MI:SS AM') end_time
FROM
v$process a
, v$session b
, fnd_logins c
, fnd_user d
WHERE a.pid = c.pid
AND d.user_name = UPPER (:p_user_name)
AND d.user_id = c.user_id
AND a.addr = b.paddr ;