How can find Locked Object in Oracle Apps R12 ? or How can find Locked object name and Oracle User name in Oracle Apps R12? Query 1 - SELECT b.owner , b.object_name , a.oracle_username , a.os_user_name FROM v$locked_object a , all_objects b WHERE a.object_id = b.object_id Query 2 - SELECT c.owner , c.object_name , c.object_type , b.SID , b.serial# , b.status , b.osuser , b.machine FROM v$locked_object a , v$session b , dba_objects c WHERE b.SID = a.session_id AND a.object_id = c.object_id; Query 3 - SELECT a.session_id , a.oracle_username , a.os_user_name , b.owner "OBJECT OWNER" , b.object_name , b.object_type , a.locked_mode FROM ( SELECT object_id , session_id , oracle_username , os_user_name , locked_mode FROM v$locked_object ) a , ( SELECT object_id , owner , object_na