APPS.AMV_MATCH_PVT dependencies on AMV_I_ITEM_PERSPECTIVES

Line 541: From amv_i_item_perspectives

537: Where item_id = p_item_id;
538: --
539: CURSOR Check_empty_persp_csr IS
540: Select 1
541: From amv_i_item_perspectives
542: Where item_id = p_item_id;
543: --
544: BEGIN
545: SAVEPOINT Match_ItemWithChannels_Pvt;

Line 1031: 'amv_i_item_perspectives ip ' ||

1027: END IF;
1028: IF (l_match_on_perspective_flag = FND_API.G_TRUE) THEN
1029: l_where_clause := l_where_clause ||
1030: 'And exists (select 1 from amv_c_chl_perspectives cp, ' ||
1031: 'amv_i_item_perspectives ip ' ||
1032: 'where cp.channel_id = chan.channel_id ' ||
1033: 'and ip.item_id = item.item_id ' ||
1034: 'and cp.perspective_id = ip.perspective_id) ';
1035: END IF;

Line 1312: From amv_c_chl_perspectives c, amv_i_item_perspectives i

1308: And i.keyword = c.keyword;
1309: --
1310: CURSOR Check_Perspective_Match_csr IS
1311: Select c.object_version_number
1312: From amv_c_chl_perspectives c, amv_i_item_perspectives i
1313: Where c.channel_id = p_channel_id
1314: And i.item_id = p_item_id
1315: And i.perspective_id = c.perspective_id;
1316: --

Line 1552: 'amv_i_item_perspectives ip ' ||

1548: END IF;
1549: IF (p_match_on_perspective_flag = FND_API.G_TRUE) THEN
1550: l_where_clause := l_where_clause ||
1551: 'And exists (select 1 from amv_c_chl_perspectives cp, ' ||
1552: 'amv_i_item_perspectives ip ' ||
1553: 'where cp.channel_id = chan.channel_id ' ||
1554: 'and ip.item_id = item.item_id ' ||
1555: 'and cp.perspective_id = ip.perspective_id) ';
1556: END IF;