APPS.AMV_SEARCH_PVT dependencies on JTF_AMV_ITEMS_VL

Line 1361: -- ' , jtf_amv_items_vl b ';

1357:
1358: --Commented for new SQL
1359: -- l_from := ' FROM '|| p_table_name ||' a ' ||
1360:
1361: -- ' , jtf_amv_items_vl b ';
1362:
1363:
1364: --ss
1365:

Line 2298: x_sql_statement(p_index) := ' from jtf_amv_items_vl b ';

2294: x_sql_statement(p_index) := ', (score(1) + score(2))/2';
2295:
2296: p_index := p_index + 1;
2297:
2298: x_sql_statement(p_index) := ' from jtf_amv_items_vl b ';
2299:
2300: p_index := p_index + 1;
2301:
2302: IF p_include_chns = FND_API.G_TRUE THEN

Line 2738: x_sql_statement(p_index) := ' from jtf_amv_items_vl b ';

2734: x_sql_statement(p_index) := ', score(1)';
2735:
2736: p_index := p_index + 1;
2737:
2738: x_sql_statement(p_index) := ' from jtf_amv_items_vl b ';
2739:
2740: p_index := p_index + 1;
2741:
2742: x_sql_statement(p_index) := ' , jtf_amv_attachments a ';

Line 3126: x_sql_statement(p_index) := ' from jtf_amv_items_vl b ';

3122: x_sql_statement(p_index) := ', score(1)';
3123:
3124: p_index := p_index + 1;
3125:
3126: x_sql_statement(p_index) := ' from jtf_amv_items_vl b ';
3127:
3128: p_index := p_index + 1;
3129:
3130: IF p_include_chns = FND_API.G_TRUE THEN

Line 3488: x_sql_statement(p_index) := ' from jtf_amv_items_vl b ';

3484: x_sql_statement(p_index) := ', score(1)';
3485:
3486: p_index := p_index + 1;
3487:
3488: x_sql_statement(p_index) := ' from jtf_amv_items_vl b ';
3489:
3490: p_index := p_index + 1;
3491:
3492: IF p_include_chns = FND_API.G_TRUE THEN

Line 4550: from jtf_amv_items_vl itm, amv_temp_ids tmp

4546: select itm.item_id, itm.last_update_date, itm.item_name,
4547:
4548: itm.description, max(tmp.score)
4549:
4550: from jtf_amv_items_vl itm, amv_temp_ids tmp
4551:
4552: where itm.item_id = tmp.id
4553:
4554: group by itm.item_id, itm.last_update_date, itm.item_name, itm.description