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.BIM_KPI_FACT dependencies on BIM_R_CAMP_DAILY_FACTS

Line 338: bim_r_camp_daily_facts a

334: 0 orders_pre_period,
335: 0 aleads_cur_period,
336: 0 aleads_pre_period
337: FROM
338: bim_r_camp_daily_facts a
339: WHERE
340: a.budget_approved > 0
341: GROUP BY a.campaign_id,
342: a.transaction_create_date,

Line 401: bim_r_camp_daily_facts a

397: 0 orders_pre_period,
398: 0 aleads_cur_period,
399: 0 aleads_pre_period
400: FROM
401: bim_r_camp_daily_facts a
402: WHERE
403: a.budget_approved > 0
404: GROUP BY a.campaign_id,
405: a.transaction_create_date,

Line 464: bim_r_camp_daily_facts a

460: 0 orders_pre_period,
461: 0 aleads_cur_period,
462: 0 aleads_pre_period
463: FROM
464: bim_r_camp_daily_facts a
465: WHERE
466: a.budget_approved > 0
467: GROUP BY a.campaign_id,
468: a.transaction_create_date,

Line 527: bim_r_camp_daily_facts a

523: 0 orders_pre_period,
524: 0 aleads_cur_period,
525: 0 aleads_pre_period
526: FROM
527: bim_r_camp_daily_facts a
528: WHERE
529: a.budget_approved > 0
530: GROUP BY a.campaign_id,
531: a.transaction_create_date,

Line 590: bim_r_camp_daily_facts a

586: 0 orders_pre_period,
587: 0 aleads_cur_period,
588: 0 aleads_pre_period
589: FROM
590: bim_r_camp_daily_facts a
591: WHERE
592: a.budget_approved > 0
593: GROUP BY a.campaign_id,
594: a.transaction_create_date,

Line 653: bim_r_camp_daily_facts a

649: 0 orders_pre_period,
650: 0 aleads_cur_period,
651: 0 aleads_pre_period
652: FROM
653: bim_r_camp_daily_facts a
654: WHERE
655: a.budget_approved > 0
656: GROUP BY a.campaign_id,
657: a.transaction_create_date,

Line 716: bim_r_camp_daily_facts a

712: 0 orders_pre_period,
713: 0 aleads_cur_period,
714: 0 aleads_pre_period
715: FROM
716: bim_r_camp_daily_facts a
717: WHERE
718: a.budget_approved > 0
719: GROUP BY a.campaign_id,
720: a.transaction_create_date,

Line 779: bim_r_camp_daily_facts a

775: 0 orders_pre_period,
776: 0 aleads_cur_period,
777: 0 aleads_pre_period
778: FROM
779: bim_r_camp_daily_facts a
780: WHERE
781: a.budget_approved > 0
782: GROUP BY a.campaign_id,
783: a.transaction_create_date,

Line 842: bim_r_camp_daily_facts a

838: 0 orders_pre_period,
839: 0 aleads_cur_period,
840: 0 aleads_pre_period
841: FROM
842: bim_r_camp_daily_facts a
843: WHERE
844: a.budget_approved > 0
845: GROUP BY a.campaign_id,
846: a.transaction_create_date,

Line 905: bim_r_camp_daily_facts a

901: 0 orders_pre_period,
902: 0 aleads_cur_period,
903: 0 aleads_pre_period
904: FROM
905: bim_r_camp_daily_facts a
906: WHERE
907: a.budget_approved > 0
908: GROUP BY a.campaign_id,
909: a.transaction_create_date,

Line 946: bim_r_camp_daily_facts a

942: 0 orders_pre_period,
943: sum(leads_hot) aleads_cur_period,
944: 0 aleads_pre_period
945: FROM
946: bim_r_camp_daily_facts a
947: WHERE
948: a.transaction_create_date between l_cur_year_start_date and l_cur_year_end_date
949: GROUP BY a.campaign_id,
950: a.start_date,

Line 985: bim_r_camp_daily_facts a

981: sum(orders_booked) orders_pre_period,
982: 0 aleads_cur_period,
983: sum(leads_hot) aleads_pre_period
984: FROM
985: bim_r_camp_daily_facts a
986: WHERE
987: a.transaction_create_date between l_pre_year_start_date and l_pre_year_end_date
988: GROUP BY a.campaign_id,
989: a.start_date,

Line 1024: bim_r_camp_daily_facts a

1020: 0 orders_pre_period,
1021: sum(leads_hot) aleads_cur_period,
1022: 0 aleads_pre_period
1023: FROM
1024: bim_r_camp_daily_facts a
1025: WHERE
1026: a.transaction_create_date between l_cur_qtr_start_date and l_cur_qtr_end_date
1027: GROUP BY a.campaign_id,
1028: a.start_date,

Line 1063: bim_r_camp_daily_facts a

1059: sum(orders_booked) orders_pre_period,
1060: 0 aleads_cur_period,
1061: sum(leads_hot) aleads_pre_period
1062: FROM
1063: bim_r_camp_daily_facts a
1064: WHERE
1065: a.transaction_create_date between l_pre_qtr_start_date and l_pre_qtr_end_date
1066: GROUP BY a.campaign_id,
1067: a.start_date,

Line 1102: bim_r_camp_daily_facts a

1098: 0 orders_pre_period,
1099: sum(leads_hot) aleads_cur_period,
1100: 0 aleads_pre_period
1101: FROM
1102: bim_r_camp_daily_facts a
1103: WHERE
1104: a.transaction_create_date between l_cur_month_start_date and l_cur_month_end_date
1105: GROUP BY a.campaign_id,
1106: a.start_date,

Line 1141: bim_r_camp_daily_facts a

1137: sum(orders_booked) orders_pre_period,
1138: 0 aleads_cur_period,
1139: sum(leads_hot) aleads_pre_period
1140: FROM
1141: bim_r_camp_daily_facts a
1142: WHERE
1143: a.transaction_create_date between l_pre_month_start_date and l_pre_month_end_date
1144: GROUP BY a.campaign_id,
1145: a.start_date,

Line 1180: bim_r_camp_daily_facts a

1176: 0 orders_pre_period,
1177: sum(leads_hot) aleads_cur_period,
1178: 0 aleads_pre_period
1179: FROM
1180: bim_r_camp_daily_facts a
1181: WHERE
1182: a.transaction_create_date between l_cur_week_start_date and l_cur_week_end_date
1183: GROUP BY a.campaign_id,
1184: a.start_date,

Line 1219: bim_r_camp_daily_facts a

1215: sum(orders_booked) orders_pre_period,
1216: 0 aleads_cur_period,
1217: sum(leads_hot) aleads_pre_period
1218: FROM
1219: bim_r_camp_daily_facts a
1220: WHERE
1221: a.transaction_create_date between l_pre_week_start_date and l_pre_week_end_date
1222: GROUP BY a.campaign_id,
1223: a.start_date,

Line 1258: bim_r_camp_daily_facts a

1254: 0 orders_pre_period,
1255: sum(leads_hot) aleads_cur_period,
1256: 0 aleads_pre_period
1257: FROM
1258: bim_r_camp_daily_facts a
1259: WHERE
1260: a.transaction_create_date = trunc(l_date)
1261: GROUP BY a.campaign_id,
1262: a.start_date,

Line 1297: bim_r_camp_daily_facts a

1293: sum(orders_booked) orders_pre_period,
1294: 0 aleads_cur_period,
1295: sum(leads_hot) aleads_pre_period
1296: FROM
1297: bim_r_camp_daily_facts a
1298: WHERE
1299: a.transaction_create_date = trunc(l_date) - 1
1300: GROUP BY a.campaign_id,
1301: a.start_date,