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 JTF_LOC_HIERARCHIES_B

Line 1359: ,jtf_loc_hierarchies_b b

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
1363: GROUP BY decode(a.event_header_id,-999,a.event_offer_id, a.event_header_id),

Line 1425: ,jtf_loc_hierarchies_b b

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
1429: GROUP BY decode(a.event_header_id,-999,a.event_offer_id, a.event_header_id),

Line 1491: ,jtf_loc_hierarchies_b b

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
1495: GROUP BY decode(a.event_header_id,-999,a.event_offer_id, a.event_header_id),

Line 1557: ,jtf_loc_hierarchies_b b

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
1561: GROUP BY decode(a.event_header_id,-999,a.event_offer_id, a.event_header_id),

Line 1623: ,jtf_loc_hierarchies_b b

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
1627: GROUP BY decode(a.event_header_id,-999,a.event_offer_id, a.event_header_id),

Line 1689: ,jtf_loc_hierarchies_b b

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
1693: GROUP BY decode(a.event_header_id,-999,a.event_offer_id, a.event_header_id),

Line 1755: ,jtf_loc_hierarchies_b b

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
1759: GROUP BY decode(a.event_header_id,-999,a.event_offer_id, a.event_header_id),

Line 1821: ,jtf_loc_hierarchies_b b

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
1825: GROUP BY decode(a.event_header_id,-999,a.event_offer_id, a.event_header_id),

Line 1887: ,jtf_loc_hierarchies_b b

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
1891: GROUP BY decode(a.event_header_id,-999,a.event_offer_id, a.event_header_id),

Line 1953: ,jtf_loc_hierarchies_b b

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
1957: GROUP BY decode(a.event_header_id,-999,a.event_offer_id, a.event_header_id),

Line 1997: ,jtf_loc_hierarchies_b b

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
2001: GROUP BY decode(a.event_header_id,-999,a.event_offer_id, a.event_header_id),

Line 2039: ,jtf_loc_hierarchies_b b

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
2043: GROUP BY decode(a.event_header_id,-999,a.event_offer_id, a.event_header_id),

Line 2081: ,jtf_loc_hierarchies_b b

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
2085: GROUP BY decode(a.event_header_id,-999,a.event_offer_id, a.event_header_id),

Line 2123: ,jtf_loc_hierarchies_b b

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
2127: GROUP BY decode(a.event_header_id,-999,a.event_offer_id, a.event_header_id),

Line 2165: ,jtf_loc_hierarchies_b b

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
2169: GROUP BY decode(a.event_header_id,-999,a.event_offer_id, a.event_header_id),

Line 2207: ,jtf_loc_hierarchies_b b

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
2211: GROUP BY decode(a.event_header_id,-999,a.event_offer_id, a.event_header_id),

Line 2249: ,jtf_loc_hierarchies_b b

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
2253: GROUP BY decode(a.event_header_id,-999,a.event_offer_id, a.event_header_id),

Line 2291: ,jtf_loc_hierarchies_b b

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
2295: GROUP BY decode(a.event_header_id,-999,a.event_offer_id, a.event_header_id),

Line 2333: ,jtf_loc_hierarchies_b b

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
2337: GROUP BY decode(a.event_header_id,-999,a.event_offer_id, a.event_header_id),

Line 2375: ,jtf_loc_hierarchies_b b

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
2379: GROUP BY decode(a.event_header_id,-999,a.event_offer_id, a.event_header_id),