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.BIX_UWQ_TEMP_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 86: from jtf_rs_group_members grp, jtf_rs_resource_extns res

82: BEGIN
83:
84: select grp.group_id
85: into v_default_group_id
86: from jtf_rs_group_members grp, jtf_rs_resource_extns res
87: where res.resource_id = grp.resource_id
88: and res.user_id = fnd_profile.value('USER_ID')
89: and grp.last_update_date = (select max(grp2.last_update_date)
90: from jtf_rs_group_members grp2, jtf_rs_resource_extns res2

Line 90: from jtf_rs_group_members grp2, jtf_rs_resource_extns res2

86: from jtf_rs_group_members grp, jtf_rs_resource_extns res
87: where res.resource_id = grp.resource_id
88: and res.user_id = fnd_profile.value('USER_ID')
89: and grp.last_update_date = (select max(grp2.last_update_date)
90: from jtf_rs_group_members grp2, jtf_rs_resource_extns res2
91: where res2.resource_id = grp2.resource_id
92: and res2.user_id = fnd_profile.value('USER_ID')
93: );
94: EXCEPTION

Line 145: FROM jtf_rs_group_members grp, jtf_rs_resource_extns res

141:
142: CURSOR c_child_agents(p_group_id INTEGER)
143: IS
144: SELECT DISTINCT res.resource_id RID, res.source_name RNAME
145: FROM jtf_rs_group_members grp, jtf_rs_resource_extns res
146: WHERE grp.group_id = p_group_id
147: AND grp.resource_id = res.resource_id;
148:
149: BEGIN

Line 185: from jtf_rs_group_members grp, jtf_rs_resource_extns res

181: BEGIN
182:
183: select grp.group_id
184: into v_default_group_id
185: from jtf_rs_group_members grp, jtf_rs_resource_extns res
186: where res.resource_id = grp.resource_id
187: and res.user_id = fnd_profile.value('USER_ID')
188: and grp.last_update_date = (select max(grp2.last_update_date)
189: from jtf_rs_group_members grp2, jtf_rs_resource_extns res2

Line 189: from jtf_rs_group_members grp2, jtf_rs_resource_extns res2

185: from jtf_rs_group_members grp, jtf_rs_resource_extns res
186: where res.resource_id = grp.resource_id
187: and res.user_id = fnd_profile.value('USER_ID')
188: and grp.last_update_date = (select max(grp2.last_update_date)
189: from jtf_rs_group_members grp2, jtf_rs_resource_extns res2
190: where res.resource_id = grp.resource_id
191: and res.user_id = fnd_profile.value('USER_ID')
192: );
193: EXCEPTION

Line 301: FROM bix_dm_uwq_agent_sum summ, jtf_rs_resource_extns res

297: SELECT 'BIX_UWQ_LOGINS_RPT', res.source_name, '',
298: DAY6_LOGIN, DAY5_LOGIN, DAY4_LOGIN, DAY3_LOGIN, DAY2_LOGIN, DAY1_LOGIN,
299: DAY_LOGIN, PRIOR_WEEK_LOGIN, CURRENT_WEEK_LOGIN, PRIOR_MONTH_LOGIN, CURRENT_MONTH_LOGIN,
300: v_session_id
301: FROM bix_dm_uwq_agent_sum summ, jtf_rs_resource_extns res
302: WHERE summ.resource_id = substr(v_context,13)
303: AND summ.resource_id = res.resource_id
304: AND summ.day = v_date;
305:

Line 354: FROM bix_dm_uwq_agent_sum summ, jtf_rs_resource_extns res

350: SELECT 'BIX_UWQ_LOGINS_RPT', '', 'A'||to_char(v_date,'DD-MON-YYYY')||summ.resource_id, res.source_name,
351: DAY6_LOGIN, DAY5_LOGIN, DAY4_LOGIN, DAY3_LOGIN, DAY2_LOGIN, DAY1_LOGIN,
352: DAY_LOGIN, PRIOR_WEEK_LOGIN, CURRENT_WEEK_LOGIN, PRIOR_MONTH_LOGIN, CURRENT_MONTH_LOGIN,
353: v_session_id
354: FROM bix_dm_uwq_agent_sum summ, jtf_rs_resource_extns res
355: WHERE summ.resource_id IN
356: (
357: SELECT DISTINCT res.resource_id
358: FROM jtf_rs_group_members grp, jtf_rs_resource_extns res

Line 358: FROM jtf_rs_group_members grp, jtf_rs_resource_extns res

354: FROM bix_dm_uwq_agent_sum summ, jtf_rs_resource_extns res
355: WHERE summ.resource_id IN
356: (
357: SELECT DISTINCT res.resource_id
358: FROM jtf_rs_group_members grp, jtf_rs_resource_extns res
359: WHERE grp.group_id = substr(v_context,13)
360: AND grp.resource_id = res.resource_id
361: )
362: AND summ.resource_id = res.resource_id

Line 418: FROM bix_dm_uwq_agent_sum summ, jtf_rs_resource_extns res

414: SELECT 'BIX_UWQ_LOGINS_RPT', '', 'A'||to_char(v_date,'DD-MON-YYYY')||summ.resource_id, res.source_name,
415: DAY6_LOGIN, DAY5_LOGIN, DAY4_LOGIN, DAY3_LOGIN, DAY2_LOGIN, DAY1_LOGIN,
416: DAY_LOGIN, PRIOR_WEEK_LOGIN, CURRENT_WEEK_LOGIN, PRIOR_MONTH_LOGIN, CURRENT_MONTH_LOGIN,
417: v_session_id
418: FROM bix_dm_uwq_agent_sum summ, jtf_rs_resource_extns res
419: WHERE summ.resource_id IN
420: (
421: SELECT DISTINCT res.resource_id
422: FROM jtf_rs_group_members grp, jtf_rs_resource_extns res

Line 422: FROM jtf_rs_group_members grp, jtf_rs_resource_extns res

418: FROM bix_dm_uwq_agent_sum summ, jtf_rs_resource_extns res
419: WHERE summ.resource_id IN
420: (
421: SELECT DISTINCT res.resource_id
422: FROM jtf_rs_group_members grp, jtf_rs_resource_extns res
423: WHERE grp.group_id = v_default_group_id
424: AND grp.resource_id = res.resource_id
425: )
426: AND summ.resource_id = res.resource_id

Line 487: FROM bix_dm_uwq_agent_sum summ, jtf_rs_resource_extns res

483: bix_util_pkg.get_hrmi_frmt( decode(CURRENT_WEEK_LOGIN,0,0,round(CURRENT_WEEK_DURATION/CURRENT_WEEK_LOGIN)) ),
484: bix_util_pkg.get_hrmi_frmt( decode(PRIOR_MONTH_LOGIN,0,0,round(PRIOR_MONTH_DURATION/PRIOR_MONTH_LOGIN)) ),
485: bix_util_pkg.get_hrmi_frmt( decode(CURRENT_MONTH_LOGIN,0,0,round(CURRENT_MONTH_DURATION/CURRENT_MONTH_LOGIN)) ),
486: v_session_id
487: FROM bix_dm_uwq_agent_sum summ, jtf_rs_resource_extns res
488: WHERE summ.resource_id = substr(v_context,13)
489: AND summ.resource_id = res.resource_id
490: AND summ.day = v_date;
491:

Line 568: FROM bix_dm_uwq_agent_sum summ, jtf_rs_resource_extns res

564: bix_util_pkg.get_hrmi_frmt( decode(CURRENT_WEEK_LOGIN,0,0,round(CURRENT_WEEK_DURATION/CURRENT_WEEK_LOGIN)) ),
565: bix_util_pkg.get_hrmi_frmt( decode(PRIOR_MONTH_LOGIN,0,0,round(PRIOR_MONTH_DURATION/PRIOR_MONTH_LOGIN)) ),
566: bix_util_pkg.get_hrmi_frmt( decode(CURRENT_MONTH_LOGIN,0,0,round(CURRENT_MONTH_DURATION/CURRENT_MONTH_LOGIN)) ),
567: v_session_id
568: FROM bix_dm_uwq_agent_sum summ, jtf_rs_resource_extns res
569: WHERE summ.resource_id IN
570: (
571: SELECT DISTINCT res.resource_id
572: FROM jtf_rs_group_members grp, jtf_rs_resource_extns res

Line 572: FROM jtf_rs_group_members grp, jtf_rs_resource_extns res

568: FROM bix_dm_uwq_agent_sum summ, jtf_rs_resource_extns res
569: WHERE summ.resource_id IN
570: (
571: SELECT DISTINCT res.resource_id
572: FROM jtf_rs_group_members grp, jtf_rs_resource_extns res
573: WHERE grp.group_id = substr(v_context,13)
574: AND grp.resource_id = res.resource_id
575: )
576: AND summ.resource_id = res.resource_id

Line 659: FROM bix_dm_uwq_agent_sum summ, jtf_rs_resource_extns res

655: bix_util_pkg.get_hrmi_frmt( decode(CURRENT_WEEK_LOGIN,0,0,round(CURRENT_WEEK_DURATION/CURRENT_WEEK_LOGIN)) ),
656: bix_util_pkg.get_hrmi_frmt( decode(PRIOR_MONTH_LOGIN,0,0,round(PRIOR_MONTH_DURATION/PRIOR_MONTH_LOGIN)) ),
657: bix_util_pkg.get_hrmi_frmt( decode(CURRENT_MONTH_LOGIN,0,0,round(CURRENT_MONTH_DURATION/CURRENT_MONTH_LOGIN)) ),
658: v_session_id
659: FROM bix_dm_uwq_agent_sum summ, jtf_rs_resource_extns res
660: WHERE summ.resource_id IN
661: (
662: SELECT DISTINCT res.resource_id
663: FROM jtf_rs_group_members grp, jtf_rs_resource_extns res

Line 663: FROM jtf_rs_group_members grp, jtf_rs_resource_extns res

659: FROM bix_dm_uwq_agent_sum summ, jtf_rs_resource_extns res
660: WHERE summ.resource_id IN
661: (
662: SELECT DISTINCT res.resource_id
663: FROM jtf_rs_group_members grp, jtf_rs_resource_extns res
664: WHERE grp.group_id = v_default_group_id
665: AND grp.resource_id = res.resource_id
666: )
667: AND summ.resource_id = res.resource_id