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.AMV_SEARCH_PVT dependencies on AMV_TEMP_NUMBERS

Line 35: -- 27-Jul-2005 MKETTLE Removed Schema prefix for trunc of AMV_TEMP_NUMBERS

31: -- 6/07/04 Sharma Fixed bug 2719461
32: -- SQL in procedure Build_Items_File_Sql, Build_Items_Text_Sql
33: -- Build_Items_URL_Sql modified to get correct score
34: --
35: -- 27-Jul-2005 MKETTLE Removed Schema prefix for trunc of AMV_TEMP_NUMBERS
36: --
37:
38:
39:

Line 999: l_from := l_from || ' , amv_temp_numbers id ';

995: l_from := l_from || ' , amv_c_channels_vl b ';
996:
997: IF p_include_chns = FND_API.G_TRUE THEN
998:
999: l_from := l_from || ' , amv_temp_numbers id ';
1000:
1001: END IF;
1002:
1003: l_where := ' WHERE a.channel_id = b.channel_id';

Line 1376: --l_from := l_from || ' , amv_temp_numbers id ';

1372:
1373: --Commented for new SQL
1374: --l_from := l_from || ' , amv_c_chl_item_match cim ';
1375:
1376: --l_from := l_from || ' , amv_temp_numbers id ';
1377:
1378:
1379: --ss
1380:

Line 1383: l_mainFrom := l_mainFrom || ' , amv_temp_numbers id ';

1379: --ss
1380:
1381: l_mainFrom := ' FROM amv_c_chl_item_match cim ';
1382:
1383: l_mainFrom := l_mainFrom || ' , amv_temp_numbers id ';
1384: --ss
1385:
1386: END IF;
1387:

Line 1937: x_sql_statement(p_index) := ' , amv_temp_numbers id ';

1933: p_index := p_index + 1;
1934:
1935: IF p_include_chns = FND_API.G_TRUE THEN
1936:
1937: x_sql_statement(p_index) := ' , amv_temp_numbers id ';
1938:
1939: p_index := p_index + 1;
1940:
1941: END IF;

Line 2197: from amv_temp_numbers;

2193: CURSOR category_id_list IS
2194:
2195: select number_value
2196:
2197: from amv_temp_numbers;
2198:
2199:
2200:
2201: l_category_counter number :=1;

Line 2308: x_sql_statement(p_index) := ' , amv_temp_numbers id ';

2304: x_sql_statement(p_index) := ' , amv_c_chl_item_match cim ';
2305:
2306: p_index := p_index + 1;
2307:
2308: x_sql_statement(p_index) := ' , amv_temp_numbers id ';
2309:
2310: p_index := p_index + 1;
2311:
2312: END IF;

Line 2636: from amv_temp_numbers;

2632: CURSOR category_id_list IS
2633:
2634: select number_value
2635:
2636: from amv_temp_numbers;
2637:
2638:
2639:
2640: l_category_counter number :=1;

Line 2760: --x_sql_statement(p_index) := ' , amv_temp_numbers id ';

2756:
2757:
2758: --commented to fix bug 2719461, this clause is added in where condition as sub query
2759:
2760: --x_sql_statement(p_index) := ' , amv_temp_numbers id ';
2761:
2762: --p_index := p_index + 1;
2763:
2764: END IF;

Line 3022: from amv_temp_numbers;

3018: CURSOR category_id_list IS
3019:
3020: select number_value
3021:
3022: from amv_temp_numbers;
3023:
3024:
3025:
3026: l_category_counter number :=1;

Line 3138: --x_sql_statement(p_index) := ' , amv_temp_numbers id ';

3134: p_index := p_index + 1;
3135:
3136: --commented 2 lines to fix 2719461, the lines are added as subquery in join condition in where clause
3137:
3138: --x_sql_statement(p_index) := ' , amv_temp_numbers id ';
3139:
3140: --p_index := p_index + 1;
3141:
3142: END IF;

Line 3384: from amv_temp_numbers;

3380: CURSOR category_id_list IS
3381:
3382: select number_value
3383:
3384: from amv_temp_numbers;
3385:
3386:
3387:
3388: l_category_counter number :=1;

Line 3500: --x_sql_statement(p_index) := ' , amv_temp_numbers id ';

3496: p_index := p_index + 1;
3497:
3498: --commented to fix bug 2719461, this is added as subquery to where clase in the join
3499:
3500: --x_sql_statement(p_index) := ' , amv_temp_numbers id ';
3501:
3502: --p_index := p_index + 1;
3503:
3504: END IF;

Line 4078: l_stmt varchar2(200) :='INSERT INTO amv_temp_numbers (number_value) VALUES (:id)';

4074: x_status OUT NOCOPY VARCHAR2)
4075:
4076: IS
4077:
4078: l_stmt varchar2(200) :='INSERT INTO amv_temp_numbers (number_value) VALUES (:id)';
4079:
4080: -- Added for Schmema swap changes
4081: l_status varchar2(30);
4082: l_schema varchar2(30);

Line 4100: --EXECUTE IMMEDIATE 'TRUNCATE TABLE amv.amv_temp_numbers';

4096:
4097: -- amv_temp_ids must also be empty after TRUNCATE
4098:
4099: l_return_status := FND_INSTALLATION.get_app_info('AMV',l_status,l_industry,l_schema);
4100: --EXECUTE IMMEDIATE 'TRUNCATE TABLE amv.amv_temp_numbers';
4101:
4102: EXECUTE IMMEDIATE 'TRUNCATE TABLE amv_temp_numbers';
4103:
4104:

Line 4102: EXECUTE IMMEDIATE 'TRUNCATE TABLE amv_temp_numbers';

4098:
4099: l_return_status := FND_INSTALLATION.get_app_info('AMV',l_status,l_industry,l_schema);
4100: --EXECUTE IMMEDIATE 'TRUNCATE TABLE amv.amv_temp_numbers';
4101:
4102: EXECUTE IMMEDIATE 'TRUNCATE TABLE amv_temp_numbers';
4103:
4104:
4105:
4106: -- build ids insert statement

Line 4110: --DBMS_OUTPUT.PUT_LINE('insert into amv_temp_numbers (number_value) values (' || p_id_array(i) ||');');

4106: -- build ids insert statement
4107:
4108: FOR i in 1..p_id_array.count LOOP
4109:
4110: --DBMS_OUTPUT.PUT_LINE('insert into amv_temp_numbers (number_value) values (' || p_id_array(i) ||');');
4111:
4112: EXECUTE IMMEDIATE l_stmt USING p_id_array(i);
4113:
4114: END LOOP;

Line 4192: -- temporary table for session, including amv_temp_numbers

4188: -- clear the temporary global table
4189:
4190: --This is commented OUT NOCOPY because truncation empties all
4191:
4192: -- temporary table for session, including amv_temp_numbers
4193:
4194: -- which causes search result to be empty.
4195:
4196: --EXECUTE IMMEDIATE 'TRUNCATE TABLE amv.amv_temp_ids';