eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_BIS_LOCKS_PUB dependencies on V$SESSION

Line 1539: FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u

1535: )IS
1536: PRAGMA AUTONOMOUS_TRANSACTION;
1537: CURSOR c_conflict_session IS
1538: SELECT c.program_id, u.user_name, s.machine, s.terminal
1539: FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u
1540: WHERE c.session_id = s.audsid
1541: AND c.program_id IN (-100, -101, -200, -201, -700, -800, -802)
1542: AND c.session_id <> USERENV('SESSIONID')
1543: AND c.user_id = u.user_id (+);

Line 1561: FROM V$SESSION VS);

1557: --Delete all orphan the sessions
1558: DELETE BSC_CURRENT_SESSIONS
1559: WHERE SESSION_ID NOT IN
1560: (SELECT VS.AUDSID
1561: FROM V$SESSION VS);
1562:
1563: --Delete all the session not being reused by FND
1564: DELETE BSC_CURRENT_SESSIONS
1565: WHERE ICX_SESSION_ID IN (

Line 1610: FROM V$SESSION VS

1606: --Delete all the Killed Sessions
1607: DELETE BSC_CURRENT_SESSIONS
1608: WHERE SESSION_ID IN (
1609: SELECT VS.AUDSID
1610: FROM V$SESSION VS
1611: WHERE VS.STATUS = 'KILLED');
1612: --INSERT INTO test_debug_log VALUES ('0','in autonomus',SYSDATE);
1613: COMMIT;
1614: FOR cd IN c_conflict_session LOOP