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_EMAILS_SUMMARY_PKG dependencies on FII_TIME_DAY

Line 522: TYPE week_id_tab IS TABLE OF fii_time_day.week_id%TYPE;

518: TYPE two_done_rsln_tab IS TABLE OF bix_email_details_f.two_rsln_in_period%TYPE;
519: TYPE three_done_rsln_tab IS TABLE OF bix_email_details_f.three_rsln_in_period%TYPE;
520: TYPE four_done_rsln_tab IS TABLE OF bix_email_details_f.four_rsln_in_period%TYPE;
521: TYPE intr_thread_tab IS TABLE OF bix_email_details_f.interaction_threads_in_period%TYPE;
522: TYPE week_id_tab IS TABLE OF fii_time_day.week_id%TYPE;
523: TYPE ent_period_id_tab IS TABLE OF fii_time_day.ent_period_id%TYPE;
524: TYPE ent_qtr_id_tab IS TABLE OF fii_time_day.ent_qtr_id%TYPE;
525: TYPE ent_year_id_tab IS TABLE OF fii_time_day.ent_year_id%TYPE;
526: TYPE week_start_date_tab IS TABLE OF fii_time_day.week_start_date%TYPE;

Line 523: TYPE ent_period_id_tab IS TABLE OF fii_time_day.ent_period_id%TYPE;

519: TYPE three_done_rsln_tab IS TABLE OF bix_email_details_f.three_rsln_in_period%TYPE;
520: TYPE four_done_rsln_tab IS TABLE OF bix_email_details_f.four_rsln_in_period%TYPE;
521: TYPE intr_thread_tab IS TABLE OF bix_email_details_f.interaction_threads_in_period%TYPE;
522: TYPE week_id_tab IS TABLE OF fii_time_day.week_id%TYPE;
523: TYPE ent_period_id_tab IS TABLE OF fii_time_day.ent_period_id%TYPE;
524: TYPE ent_qtr_id_tab IS TABLE OF fii_time_day.ent_qtr_id%TYPE;
525: TYPE ent_year_id_tab IS TABLE OF fii_time_day.ent_year_id%TYPE;
526: TYPE week_start_date_tab IS TABLE OF fii_time_day.week_start_date%TYPE;
527: TYPE ent_period_start_date_tab IS TABLE OF fii_time_day.ent_period_start_date%TYPE;

Line 524: TYPE ent_qtr_id_tab IS TABLE OF fii_time_day.ent_qtr_id%TYPE;

520: TYPE four_done_rsln_tab IS TABLE OF bix_email_details_f.four_rsln_in_period%TYPE;
521: TYPE intr_thread_tab IS TABLE OF bix_email_details_f.interaction_threads_in_period%TYPE;
522: TYPE week_id_tab IS TABLE OF fii_time_day.week_id%TYPE;
523: TYPE ent_period_id_tab IS TABLE OF fii_time_day.ent_period_id%TYPE;
524: TYPE ent_qtr_id_tab IS TABLE OF fii_time_day.ent_qtr_id%TYPE;
525: TYPE ent_year_id_tab IS TABLE OF fii_time_day.ent_year_id%TYPE;
526: TYPE week_start_date_tab IS TABLE OF fii_time_day.week_start_date%TYPE;
527: TYPE ent_period_start_date_tab IS TABLE OF fii_time_day.ent_period_start_date%TYPE;
528: TYPE ent_qtr_start_date_tab IS TABLE OF fii_time_day.ent_qtr_start_date%TYPE;

Line 525: TYPE ent_year_id_tab IS TABLE OF fii_time_day.ent_year_id%TYPE;

521: TYPE intr_thread_tab IS TABLE OF bix_email_details_f.interaction_threads_in_period%TYPE;
522: TYPE week_id_tab IS TABLE OF fii_time_day.week_id%TYPE;
523: TYPE ent_period_id_tab IS TABLE OF fii_time_day.ent_period_id%TYPE;
524: TYPE ent_qtr_id_tab IS TABLE OF fii_time_day.ent_qtr_id%TYPE;
525: TYPE ent_year_id_tab IS TABLE OF fii_time_day.ent_year_id%TYPE;
526: TYPE week_start_date_tab IS TABLE OF fii_time_day.week_start_date%TYPE;
527: TYPE ent_period_start_date_tab IS TABLE OF fii_time_day.ent_period_start_date%TYPE;
528: TYPE ent_qtr_start_date_tab IS TABLE OF fii_time_day.ent_qtr_start_date%TYPE;
529: TYPE ent_year_start_date_tab IS TABLE OF fii_time_day.ent_year_start_date%TYPE;

Line 526: TYPE week_start_date_tab IS TABLE OF fii_time_day.week_start_date%TYPE;

522: TYPE week_id_tab IS TABLE OF fii_time_day.week_id%TYPE;
523: TYPE ent_period_id_tab IS TABLE OF fii_time_day.ent_period_id%TYPE;
524: TYPE ent_qtr_id_tab IS TABLE OF fii_time_day.ent_qtr_id%TYPE;
525: TYPE ent_year_id_tab IS TABLE OF fii_time_day.ent_year_id%TYPE;
526: TYPE week_start_date_tab IS TABLE OF fii_time_day.week_start_date%TYPE;
527: TYPE ent_period_start_date_tab IS TABLE OF fii_time_day.ent_period_start_date%TYPE;
528: TYPE ent_qtr_start_date_tab IS TABLE OF fii_time_day.ent_qtr_start_date%TYPE;
529: TYPE ent_year_start_date_tab IS TABLE OF fii_time_day.ent_year_start_date%TYPE;
530: TYPE curr_depth_tab IS TABLE OF bix_email_details_f.one_rsln_in_period%TYPE;

Line 527: TYPE ent_period_start_date_tab IS TABLE OF fii_time_day.ent_period_start_date%TYPE;

523: TYPE ent_period_id_tab IS TABLE OF fii_time_day.ent_period_id%TYPE;
524: TYPE ent_qtr_id_tab IS TABLE OF fii_time_day.ent_qtr_id%TYPE;
525: TYPE ent_year_id_tab IS TABLE OF fii_time_day.ent_year_id%TYPE;
526: TYPE week_start_date_tab IS TABLE OF fii_time_day.week_start_date%TYPE;
527: TYPE ent_period_start_date_tab IS TABLE OF fii_time_day.ent_period_start_date%TYPE;
528: TYPE ent_qtr_start_date_tab IS TABLE OF fii_time_day.ent_qtr_start_date%TYPE;
529: TYPE ent_year_start_date_tab IS TABLE OF fii_time_day.ent_year_start_date%TYPE;
530: TYPE curr_depth_tab IS TABLE OF bix_email_details_f.one_rsln_in_period%TYPE;
531:

Line 528: TYPE ent_qtr_start_date_tab IS TABLE OF fii_time_day.ent_qtr_start_date%TYPE;

524: TYPE ent_qtr_id_tab IS TABLE OF fii_time_day.ent_qtr_id%TYPE;
525: TYPE ent_year_id_tab IS TABLE OF fii_time_day.ent_year_id%TYPE;
526: TYPE week_start_date_tab IS TABLE OF fii_time_day.week_start_date%TYPE;
527: TYPE ent_period_start_date_tab IS TABLE OF fii_time_day.ent_period_start_date%TYPE;
528: TYPE ent_qtr_start_date_tab IS TABLE OF fii_time_day.ent_qtr_start_date%TYPE;
529: TYPE ent_year_start_date_tab IS TABLE OF fii_time_day.ent_year_start_date%TYPE;
530: TYPE curr_depth_tab IS TABLE OF bix_email_details_f.one_rsln_in_period%TYPE;
531:
532: l_root_interaction_id root_interaction_id_tab;

Line 529: TYPE ent_year_start_date_tab IS TABLE OF fii_time_day.ent_year_start_date%TYPE;

525: TYPE ent_year_id_tab IS TABLE OF fii_time_day.ent_year_id%TYPE;
526: TYPE week_start_date_tab IS TABLE OF fii_time_day.week_start_date%TYPE;
527: TYPE ent_period_start_date_tab IS TABLE OF fii_time_day.ent_period_start_date%TYPE;
528: TYPE ent_qtr_start_date_tab IS TABLE OF fii_time_day.ent_qtr_start_date%TYPE;
529: TYPE ent_year_start_date_tab IS TABLE OF fii_time_day.ent_year_start_date%TYPE;
530: TYPE curr_depth_tab IS TABLE OF bix_email_details_f.one_rsln_in_period%TYPE;
531:
532: l_root_interaction_id root_interaction_id_tab;
533: l_agent_id agent_id_tab;

Line 681: fii_time_day

677: l_ent_qtr_start_date(i),
678: l_ent_year_id(i),
679: l_ent_year_start_date(i)
680: FROM
681: fii_time_day
682: WHERE report_date = trunc(l_start_date_time(i));
683:
684:
685: IF (l_curr_depth(i) = 1) THEN l_one_done_rsln(i) :=1;

Line 3428: fii_time_day ftd,

3424: accumulated_emails_week_plus,
3425: 0 EMAILS_REROUTED_IN_PERIOD,
3426: 0 LEADS_CREATED_IN_PERIOD
3427: FROM
3428: fii_time_day ftd,
3429: (
3430: /* Query 7 -Part I*/SELECT
3431: media_id MEDIA_ID,
3432: nvl(email_account_id, -1) EMAIL_ACCOUNT_ID,

Line 3915: fii_time_day ftd,

3911: accumulated_emails_week_plus,
3912: 0 EMAILS_REROUTED_IN_PERIOD,
3913: 0 LEADS_CREATED_IN_PERIOD
3914: FROM
3915: fii_time_day ftd,
3916: --
3917: --Currently in QUEUE or in QUEUE until collect end date
3918: --
3919: (

Line 4577: fii_time_day ftd

4573: ftd.ent_year_id
4574: order by to_date(to_char(bead.period_start_date, 'dd/mm/yyyy ') ||
4575: lpad(bead.period_start_time, 5, '0'), 'dd/mm/yyyy hh24:mi') desc) year_acc_emails_week_plus
4576: FROM bix_email_details_f bead,
4577: fii_time_day ftd
4578: WHERE bead.time_id = ftd.report_date_julian
4579: AND bead.period_type_id = 1
4580: --AND bead.period_start_date >= p_min_date --DOES NOT PERFORM INDEX SCAN IF USING PERIOD_START_DATE
4581: AND bead.time_id >= to_number( to_char(p_min_date,'J'))

Line 5212: fii_time_day ftd

5208: ftd.ent_year_id
5209: order by to_date(to_char(bead.period_start_date, 'dd/mm/yyyy ') ||
5210: lpad(bead.period_start_time, 5, '0'), 'dd/mm/yyyy hh24:mi') desc) year_acc_emails_week_plus
5211: FROM bix_email_details_stg bead,
5212: fii_time_day ftd
5213: WHERE bead.time_id = ftd.report_date_julian
5214: AND bead.period_type_id = 1
5215: --AND bead.request_id = g_request_id
5216: ) inv2