APPS.BIX_UWQ_TEMP_PKG dependencies on BIX_DM_UWQ_AGENT_SUM

Line 162: from bix_dm_uwq_agent_sum;

158: commit;
159:
160: select max(day)-1
161: into v_max_date
162: from bix_dm_uwq_agent_sum;
163:
164: --
165: --Select the user who is logged in and the user's default group
166: --

Line 222: FROM bix_dm_uwq_agent_sum summ

218: DAY_LOGIN,
219: 'A'||to_char(v_max_date,'DD-MON-YYYY')||rec_child_agents.RID,
220: bix_util_pkg.get_hrmi_frmt( decode(DAY_LOGIN,0,0,round(DAY_DURATION/DAY_LOGIN)) ),
221: v_session_id
222: FROM bix_dm_uwq_agent_sum summ
223: WHERE summ.resource_id = rec_child_agents.RID
224: AND summ.DAY = trunc(v_max_date);
225:
226:

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 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 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 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