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_GROUPS_VL

Line 246: FROM bix_dm_uwq_group_sum summ, jtf_rs_groups_vl vl

242: DAY_LOGIN,
243: 'G'||to_char(v_max_date,'DD-MON-YYYY')||rec_child_groups.GID,
244: bix_util_pkg.get_hrmi_frmt( decode(DAY_LOGIN,0,0,round(DAY_DURATION/DAY_LOGIN)) ),
245: v_session_id
246: FROM bix_dm_uwq_group_sum summ, jtf_rs_groups_vl vl
247: WHERE summ.group_id = rec_child_groups.GID
248: AND summ.group_id = vl.group_id
249: AND summ.day = trunc(v_max_date);
250:

Line 319: FROM bix_dm_uwq_group_sum summ, jtf_rs_groups_vl vl

315: SELECT 'BIX_UWQ_LOGINS_RPT', vl.group_name, '',
316: DAY6_LOGIN, DAY5_LOGIN, DAY4_LOGIN, DAY3_LOGIN, DAY2_LOGIN, DAY1_LOGIN,
317: DAY_LOGIN, PRIOR_WEEK_LOGIN, CURRENT_WEEK_LOGIN, PRIOR_MONTH_LOGIN, CURRENT_MONTH_LOGIN,
318: v_session_id
319: FROM bix_dm_uwq_group_sum summ, jtf_rs_groups_vl vl
320: WHERE summ.group_id = substr(v_context,13)
321: AND summ.group_id = vl.group_id
322: AND summ.day = v_date;
323:

Line 334: FROM bix_dm_uwq_group_sum summ, jtf_rs_groups_vl vl

330: SELECT 'BIX_UWQ_LOGINS_RPT', '', 'G'||to_char(v_date,'DD-MON-YYYY')||summ.group_id, vl.group_name,
331: DAY6_LOGIN, DAY5_LOGIN, DAY4_LOGIN, DAY3_LOGIN, DAY2_LOGIN, DAY1_LOGIN,
332: DAY_LOGIN, PRIOR_WEEK_LOGIN, CURRENT_WEEK_LOGIN, PRIOR_MONTH_LOGIN, CURRENT_MONTH_LOGIN,
333: v_session_id
334: FROM bix_dm_uwq_group_sum summ, jtf_rs_groups_vl vl
335: WHERE summ.group_id IN
336: (select denorm.group_id GID
337: from jtf_rs_groups_denorm denorm
338: where denorm.parent_group_id = substr(v_context,13)

Line 383: FROM bix_dm_uwq_group_sum summ, jtf_rs_groups_vl vl

379: SELECT 'BIX_UWQ_LOGINS_RPT', vl.group_name, '',
380: DAY6_LOGIN, DAY5_LOGIN, DAY4_LOGIN, DAY3_LOGIN, DAY2_LOGIN, DAY1_LOGIN,
381: DAY_LOGIN, PRIOR_WEEK_LOGIN, CURRENT_WEEK_LOGIN, PRIOR_MONTH_LOGIN, CURRENT_MONTH_LOGIN,
382: v_session_id
383: FROM bix_dm_uwq_group_sum summ, jtf_rs_groups_vl vl
384: WHERE summ.group_id = v_default_group_id
385: AND summ.group_id = vl.group_id
386: AND summ.day = v_date;
387:

Line 398: FROM bix_dm_uwq_group_sum summ, jtf_rs_groups_vl vl

394: SELECT 'BIX_UWQ_LOGINS_RPT', '', 'G'||to_char(v_date,'DD-MON-YYYY')||summ.group_id, vl.group_name,
395: DAY6_LOGIN, DAY5_LOGIN, DAY4_LOGIN, DAY3_LOGIN, DAY2_LOGIN, DAY1_LOGIN,
396: DAY_LOGIN, PRIOR_WEEK_LOGIN, CURRENT_WEEK_LOGIN, PRIOR_MONTH_LOGIN, CURRENT_MONTH_LOGIN,
397: v_session_id
398: FROM bix_dm_uwq_group_sum summ, jtf_rs_groups_vl vl
399: WHERE summ.group_id IN
400: (select denorm.group_id GID
401: from jtf_rs_groups_denorm denorm
402: where denorm.parent_group_id = v_default_group_id

Line 515: FROM bix_dm_uwq_group_sum summ, jtf_rs_groups_vl vl

511: bix_util_pkg.get_hrmi_frmt( decode(CURRENT_WEEK_LOGIN,0,0,round(CURRENT_WEEK_DURATION/CURRENT_WEEK_LOGIN)) ),
512: bix_util_pkg.get_hrmi_frmt( decode(PRIOR_MONTH_LOGIN,0,0,round(PRIOR_MONTH_DURATION/PRIOR_MONTH_LOGIN)) ),
513: bix_util_pkg.get_hrmi_frmt( decode(CURRENT_MONTH_LOGIN,0,0,round(CURRENT_MONTH_DURATION/CURRENT_MONTH_LOGIN)) ),
514: v_session_id
515: FROM bix_dm_uwq_group_sum summ, jtf_rs_groups_vl vl
516: WHERE summ.group_id = substr(v_context,13)
517: AND summ.group_id = vl.group_id
518: AND summ.day = v_date;
519:

Line 539: FROM bix_dm_uwq_group_sum summ, jtf_rs_groups_vl vl

535: bix_util_pkg.get_hrmi_frmt( decode(CURRENT_WEEK_LOGIN,0,0,round(CURRENT_WEEK_DURATION/CURRENT_WEEK_LOGIN)) ),
536: bix_util_pkg.get_hrmi_frmt( decode(PRIOR_MONTH_LOGIN,0,0,round(PRIOR_MONTH_DURATION/PRIOR_MONTH_LOGIN)) ),
537: bix_util_pkg.get_hrmi_frmt( decode(CURRENT_MONTH_LOGIN,0,0,round(CURRENT_MONTH_DURATION/CURRENT_MONTH_LOGIN)) ),
538: v_session_id
539: FROM bix_dm_uwq_group_sum summ, jtf_rs_groups_vl vl
540: WHERE summ.group_id IN
541: (select denorm.group_id GID
542: from jtf_rs_groups_denorm denorm
543: where denorm.parent_group_id = substr(v_context,13)

Line 606: FROM bix_dm_uwq_group_sum summ, jtf_rs_groups_vl vl

602: bix_util_pkg.get_hrmi_frmt( decode(CURRENT_WEEK_LOGIN,0,0,round(CURRENT_WEEK_DURATION/CURRENT_WEEK_LOGIN)) ),
603: bix_util_pkg.get_hrmi_frmt( decode(PRIOR_MONTH_LOGIN,0,0,round(PRIOR_MONTH_DURATION/PRIOR_MONTH_LOGIN)) ),
604: bix_util_pkg.get_hrmi_frmt( decode(CURRENT_MONTH_LOGIN,0,0,round(CURRENT_MONTH_DURATION/CURRENT_MONTH_LOGIN)) ),
605: v_session_id
606: FROM bix_dm_uwq_group_sum summ, jtf_rs_groups_vl vl
607: WHERE summ.group_id = v_default_group_id
608: AND summ.group_id = vl.group_id
609: AND summ.day = v_date;
610:

Line 630: FROM bix_dm_uwq_group_sum summ, jtf_rs_groups_vl vl

626: bix_util_pkg.get_hrmi_frmt( decode(CURRENT_WEEK_LOGIN,0,0,round(CURRENT_WEEK_DURATION/CURRENT_WEEK_LOGIN)) ),
627: bix_util_pkg.get_hrmi_frmt( decode(PRIOR_MONTH_LOGIN,0,0,round(PRIOR_MONTH_DURATION/PRIOR_MONTH_LOGIN)) ),
628: bix_util_pkg.get_hrmi_frmt( decode(CURRENT_MONTH_LOGIN,0,0,round(CURRENT_MONTH_DURATION/CURRENT_MONTH_LOGIN)) ),
629: v_session_id
630: FROM bix_dm_uwq_group_sum summ, jtf_rs_groups_vl vl
631: WHERE summ.group_id IN
632: (select denorm.group_id GID
633: from jtf_rs_groups_denorm denorm
634: where denorm.parent_group_id = v_default_group_id