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_EVEN_DAILY_FACTS

Line 1358: bim_r_even_daily_facts a

1354: 0 orders_pre_period,
1355: 0 aleads_cur_period,
1356: 0 aleads_pre_period
1357: FROM
1358: bim_r_even_daily_facts a
1359: ,jtf_loc_hierarchies_b b
1360: WHERE
1361: a.budget_approved > 0
1362: AND b.location_hierarchy_id = a.country

Line 1424: bim_r_even_daily_facts a

1420: 0 orders_pre_period,
1421: 0 aleads_cur_period,
1422: 0 aleads_pre_period
1423: FROM
1424: bim_r_even_daily_facts a
1425: ,jtf_loc_hierarchies_b b
1426: WHERE
1427: a.budget_approved > 0
1428: AND b.location_hierarchy_id = a.country

Line 1490: bim_r_even_daily_facts a

1486: 0 orders_pre_period,
1487: 0 aleads_cur_period,
1488: 0 aleads_pre_period
1489: FROM
1490: bim_r_even_daily_facts a
1491: ,jtf_loc_hierarchies_b b
1492: WHERE
1493: a.budget_approved > 0
1494: AND b.location_hierarchy_id = a.country

Line 1556: bim_r_even_daily_facts a

1552: 0 orders_pre_period,
1553: 0 aleads_cur_period,
1554: 0 aleads_pre_period
1555: FROM
1556: bim_r_even_daily_facts a
1557: ,jtf_loc_hierarchies_b b
1558: WHERE
1559: a.budget_approved > 0
1560: AND b.location_hierarchy_id = a.country

Line 1622: bim_r_even_daily_facts a

1618: 0 orders_pre_period,
1619: 0 aleads_cur_period,
1620: 0 aleads_pre_period
1621: FROM
1622: bim_r_even_daily_facts a
1623: ,jtf_loc_hierarchies_b b
1624: WHERE
1625: a.budget_approved > 0
1626: AND b.location_hierarchy_id = a.country

Line 1688: bim_r_even_daily_facts a

1684: 0 orders_pre_period,
1685: 0 aleads_cur_period,
1686: 0 aleads_pre_period
1687: FROM
1688: bim_r_even_daily_facts a
1689: ,jtf_loc_hierarchies_b b
1690: WHERE
1691: a.budget_approved > 0
1692: AND b.location_hierarchy_id = a.country

Line 1754: bim_r_even_daily_facts a

1750: 0 orders_pre_period,
1751: 0 aleads_cur_period,
1752: 0 aleads_pre_period
1753: FROM
1754: bim_r_even_daily_facts a
1755: ,jtf_loc_hierarchies_b b
1756: WHERE
1757: a.budget_approved > 0
1758: AND b.location_hierarchy_id = a.country

Line 1820: bim_r_even_daily_facts a

1816: 0 orders_pre_period,
1817: 0 aleads_cur_period,
1818: 0 aleads_pre_period
1819: FROM
1820: bim_r_even_daily_facts a
1821: ,jtf_loc_hierarchies_b b
1822: WHERE
1823: a.budget_approved > 0
1824: AND b.location_hierarchy_id = a.country

Line 1886: bim_r_even_daily_facts a

1882: 0 orders_pre_period,
1883: 0 aleads_cur_period,
1884: 0 aleads_pre_period
1885: FROM
1886: bim_r_even_daily_facts a
1887: ,jtf_loc_hierarchies_b b
1888: WHERE
1889: a.budget_approved > 0
1890: AND b.location_hierarchy_id = a.country

Line 1952: bim_r_even_daily_facts a

1948: 0 orders_pre_period,
1949: 0 aleads_cur_period,
1950: 0 aleads_pre_period
1951: FROM
1952: bim_r_even_daily_facts a
1953: ,jtf_loc_hierarchies_b b
1954: WHERE
1955: a.budget_approved > 0
1956: AND b.location_hierarchy_id = a.country

Line 1996: bim_r_even_daily_facts a

1992: 0 orders_pre_period,
1993: sum(leads_hot) aleads_cur_period,
1994: 0 aleads_pre_period
1995: FROM
1996: bim_r_even_daily_facts a
1997: ,jtf_loc_hierarchies_b b
1998: WHERE
1999: a.transaction_create_date between l_cur_year_start_date and l_cur_year_end_date
2000: AND b.location_hierarchy_id = a.country

Line 2038: bim_r_even_daily_facts a

2034: sum(booked_orders) orders_pre_period,
2035: 0 aleads_cur_period,
2036: sum(leads_hot) aleads_pre_period
2037: FROM
2038: bim_r_even_daily_facts a
2039: ,jtf_loc_hierarchies_b b
2040: WHERE
2041: a.transaction_create_date between l_pre_year_start_date and l_pre_year_end_date
2042: AND b.location_hierarchy_id = a.country

Line 2080: bim_r_even_daily_facts a

2076: 0 orders_pre_period,
2077: sum(leads_hot) aleads_cur_period,
2078: 0 aleads_pre_period
2079: FROM
2080: bim_r_even_daily_facts a
2081: ,jtf_loc_hierarchies_b b
2082: WHERE
2083: a.transaction_create_date between l_cur_qtr_start_date and l_cur_qtr_end_date
2084: AND b.location_hierarchy_id = a.country

Line 2122: bim_r_even_daily_facts a

2118: sum(booked_orders) orders_pre_period,
2119: 0 aleads_cur_period,
2120: sum(leads_hot) aleads_pre_period
2121: FROM
2122: bim_r_even_daily_facts a
2123: ,jtf_loc_hierarchies_b b
2124: WHERE
2125: a.transaction_create_date between l_pre_qtr_start_date and l_pre_qtr_end_date
2126: AND b.location_hierarchy_id = a.country

Line 2164: bim_r_even_daily_facts a

2160: 0 orders_pre_period,
2161: sum(leads_hot) aleads_cur_period,
2162: 0 aleads_pre_period
2163: FROM
2164: bim_r_even_daily_facts a
2165: ,jtf_loc_hierarchies_b b
2166: WHERE
2167: a.transaction_create_date between l_cur_month_start_date and l_cur_month_end_date
2168: AND b.location_hierarchy_id = a.country

Line 2206: bim_r_even_daily_facts a

2202: sum(booked_orders) orders_pre_period,
2203: 0 aleads_cur_period,
2204: sum(leads_hot) aleads_pre_period
2205: FROM
2206: bim_r_even_daily_facts a
2207: ,jtf_loc_hierarchies_b b
2208: WHERE
2209: a.transaction_create_date between l_pre_month_start_date and l_pre_month_end_date
2210: AND b.location_hierarchy_id = a.country

Line 2248: bim_r_even_daily_facts a

2244: 0 orders_pre_period,
2245: sum(leads_hot) aleads_cur_period,
2246: 0 aleads_pre_period
2247: FROM
2248: bim_r_even_daily_facts a
2249: ,jtf_loc_hierarchies_b b
2250: WHERE
2251: a.transaction_create_date between l_cur_week_start_date and l_cur_week_end_date
2252: AND b.location_hierarchy_id = a.country

Line 2290: bim_r_even_daily_facts a

2286: sum(booked_orders) orders_pre_period,
2287: 0 aleads_cur_period,
2288: sum(leads_hot) aleads_pre_period
2289: FROM
2290: bim_r_even_daily_facts a
2291: ,jtf_loc_hierarchies_b b
2292: WHERE
2293: a.transaction_create_date between l_pre_week_start_date and l_pre_week_end_date
2294: AND b.location_hierarchy_id = a.country

Line 2332: bim_r_even_daily_facts a

2328: 0 orders_pre_period,
2329: sum(leads_hot) aleads_cur_period,
2330: 0 aleads_pre_period
2331: FROM
2332: bim_r_even_daily_facts a
2333: ,jtf_loc_hierarchies_b b
2334: WHERE
2335: trunc(a.transaction_create_date) = trunc(l_date)
2336: AND b.location_hierarchy_id = a.country

Line 2374: bim_r_even_daily_facts a

2370: sum(booked_orders) orders_pre_period,
2371: 0 aleads_cur_period,
2372: sum(leads_hot) aleads_pre_period
2373: FROM
2374: bim_r_even_daily_facts a
2375: ,jtf_loc_hierarchies_b b
2376: WHERE
2377: trunc(a.transaction_create_date) = trunc(l_date - 1)
2378: AND b.location_hierarchy_id = a.country