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_MATCH_PVT dependencies on AMV_C_KEYWORDS

Line 1022: 'And exists (select 1 from amv_c_keywords ck, ' ||

1018: 'and ca.author = ia.author) ';
1019: END IF;
1020: IF (l_match_on_keyword_flag = FND_API.G_TRUE) THEN
1021: l_where_clause := l_where_clause ||
1022: 'And exists (select 1 from amv_c_keywords ck, ' ||
1023: ' jtf_amv_item_keywords ik ' ||
1024: 'where ck.channel_id = chan.channel_id ' ||
1025: 'and ik.item_id = item.item_id ' ||
1026: 'and ck.keyword = ik.keyword) ';

Line 1305: From amv_c_keywords c, jtf_amv_item_keywords i

1301: And i.author = c.author;
1302: --
1303: CURSOR Check_Keyword_Match_csr IS
1304: Select c.object_version_number
1305: From amv_c_keywords c, jtf_amv_item_keywords i
1306: Where c.channel_id = p_channel_id
1307: And i.item_id = p_item_id
1308: And i.keyword = c.keyword;
1309: --

Line 1543: 'And exists (select 1 from amv_c_keywords ck, ' ||

1539: 'and ca.author = ia.author) ';
1540: END IF;
1541: IF (p_match_on_keyword_flag = FND_API.G_TRUE) THEN
1542: l_where_clause := l_where_clause ||
1543: 'And exists (select 1 from amv_c_keywords ck, ' ||
1544: ' jtf_amv_item_keywords ik ' ||
1545: 'where ck.channel_id = chan.channel_id ' ||
1546: 'and ik.item_id = item.item_id ' ||
1547: 'and ck.keyword = ik.keyword) ';