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.IEM_CLIENT_PUB dependencies on IEU_SH_SESSIONS

Line 1318: SELECT session_id from IEU_SH_SESSIONS

1314: l_rt_media_item_id_ib number;
1315: l_type VARCHAR2(2);
1316:
1317: CURSOR sel_csr IS
1318: SELECT session_id from IEU_SH_SESSIONS
1319: WHERE BEGIN_DATE_TIME = (SELECT MAX(BEGIN_DATE_TIME)
1320: FROM IEU_SH_SESSIONS
1321: WHERE RESOURCE_ID = l_resource_id
1322: AND ACTIVE_FLAG = 'T'

Line 1320: FROM IEU_SH_SESSIONS

1316:
1317: CURSOR sel_csr IS
1318: SELECT session_id from IEU_SH_SESSIONS
1319: WHERE BEGIN_DATE_TIME = (SELECT MAX(BEGIN_DATE_TIME)
1320: FROM IEU_SH_SESSIONS
1321: WHERE RESOURCE_ID = l_resource_id
1322: AND ACTIVE_FLAG = 'T'
1323: AND APPLICATION_ID = 680);
1324: BEGIN

Line 2027: SELECT session_id from IEU_SH_SESSIONS

2023: l_tran_lead_id number;
2024: l_tran_to_acct_id number;
2025:
2026: CURSOR sel_csr IS
2027: SELECT session_id from IEU_SH_SESSIONS
2028: WHERE BEGIN_DATE_TIME = (SELECT MAX(BEGIN_DATE_TIME)
2029: FROM IEU_SH_SESSIONS
2030: WHERE RESOURCE_ID = l_resource_id
2031: AND ACTIVE_FLAG = 'T'

Line 2029: FROM IEU_SH_SESSIONS

2025:
2026: CURSOR sel_csr IS
2027: SELECT session_id from IEU_SH_SESSIONS
2028: WHERE BEGIN_DATE_TIME = (SELECT MAX(BEGIN_DATE_TIME)
2029: FROM IEU_SH_SESSIONS
2030: WHERE RESOURCE_ID = l_resource_id
2031: AND ACTIVE_FLAG = 'T'
2032: AND APPLICATION_ID = 680);
2033: