VIEW: CTXSYS.DRV$WAITING

Source

View Text - Preformatted

select "WTG_CID","WTG_ROWID","WTG_PID" from dr$waiting
 where wtg_cid = SYS_CONTEXT('DR$APPCTX','IDXID')
with check option

View Text - HTML Formatted

SELECT "WTG_CID"
, "WTG_ROWID"
, "WTG_PID"
FROM DR$WAITING
WHERE WTG_CID = SYS_CONTEXT('DR$APPCTX'
, 'IDXID') WITH CHECK OPTION