APPS.AMV_MATCH_PVT dependencies on JTF_AMV_ITEM_KEYWORDS

Line 536: From jtf_amv_item_keywords

532: Where item_id = p_item_id;
533: --
534: CURSOR Check_empty_keyword_csr IS
535: Select 1
536: From jtf_amv_item_keywords
537: Where item_id = p_item_id;
538: --
539: CURSOR Check_empty_persp_csr IS
540: Select 1

Line 1023: ' jtf_amv_item_keywords ik ' ||

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) ';
1027: END IF;

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 1544: ' jtf_amv_item_keywords ik ' ||

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) ';
1548: END IF;