Query to find Locked Object in Oracle Apps R12

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_name

              , object_type

        FROM   dba_objects ) b

WHERE  a.object_id = b.object_id;

“A GUIDE FOR ORACLE E-BUSINESS SUITE” – A complete Solution and Learning platform For Oracle Apps R12/11i, Training, India Localization, Technical, P2P, O2C, Drop-shipment, AR/AP Cycle, Implementation, Bug or error in Oracle Apps R12/11i, Up-gradation, Support, Alert, Personalization, Discoverer management, OracleApps R12/11i Module, Finance, SCM, MRP, ASCP, WIP, BOM, FA, AP, AR, OM, INV, AOL, MOAC, TCA structure, Project Accounting, CM, Functional,Oracle DBA, ERP, Techno-functional, OAF, Oracle Apps Interview Question and Error in Oracle apps R12/11i. For More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide.