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_LOCKS_PUB dependencies on V$SESSION

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

1603: l_session_id NUMBER;
1604:
1605: CURSOR c_conflict_session(c_program_id NUMBER) IS
1606: SELECT c.program_id, u.user_name, s.machine, s.terminal
1607: FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u
1608: WHERE c.session_id = s.audsid
1609: AND ((c_program_id = -100 AND c.program_id IN (-300, -400, -500, -700, -800, -802))
1610: OR (c_program_id = -101 AND c.program_id IN (-300, -400, -500, -700, -800, -802))
1611: OR (c_program_id = -200 AND c.program_id IN (-300, -400, -500, -700, -800, -802))

Line 1643: -- FROM V$SESSION VS);

1639: --Delete all orphan the sessions
1640: --DELETE BSC_CURRENT_SESSIONS
1641: --WHERE SESSION_ID NOT IN
1642: -- (SELECT VS.AUDSID
1643: -- FROM V$SESSION VS);
1644: --
1645: --Delete all the session not being reused by FND
1646: --DELETE BSC_CURRENT_SESSIONS
1647: --WHERE ICX_SESSION_ID IN (

Line 1666: -- FROM v$session s, v$session_wait w

1662: -- DELETE BSC_CURRENT_SESSIONS
1663: -- WHERE PROGRAM_ID = -600
1664: -- AND SESSION_ID IN (
1665: -- SELECT s.audsid
1666: -- FROM v$session s, v$session_wait w
1667: -- WHERE s.sid = w.sid
1668: -- AND w.seconds_in_wait > 1200);
1669: -- END IF;
1670: --END IF;

Line 1676: -- FROM V$SESSION VS

1672: --Delete all the Killed Sessions
1673: --DELETE BSC_CURRENT_SESSIONS
1674: --WHERE SESSION_ID IN (
1675: -- SELECT VS.AUDSID
1676: -- FROM V$SESSION VS
1677: -- WHERE VS.STATUS = 'KILLED');
1678: --COMMIT;
1679:
1680: FOR cd IN c_conflict_session(p_program_id) LOOP