select distinct a.process
from v$session a, v$locked_object b, dba_objects c
where b.object_id = c.object_id
and a.sid = b.session_id
and OBJECT_NAME=upper('&TABLE_NAME');
DEV> SELECT * FROM v$session where sid=2144;
no rows selected
DEV> SELECT * FROM dba_ddl_locks where name like 'XX_WIP_SHORTAGE_REP_PKG%';
no rows selected
