APPS.AMV_MATCH_PVT dependencies on AMV_C_ITEM_TYPES

Line 1044: 'And exists (select 1 from amv_c_item_types ci ' ||

1040: 'and cc.content_type_id = item.content_type_id) ';
1041: END IF;
1042: IF (l_match_on_item_type_flag = FND_API.G_TRUE) THEN
1043: l_where_clause := l_where_clause ||
1044: 'And exists (select 1 from amv_c_item_types ci ' ||
1045: 'where ci.channel_id = chan.channel_id ' ||
1046: 'and ci.item_type = item.item_type) ';
1047: END IF;
1048: l_sql_statement := l_sql_statement || l_where_clause;

Line 1292: From amv_c_item_types

1288: And content_type_id = p_content_type_id;
1289: --
1290: CURSOR Check_ItemType_Match_csr(p_item_type IN VARCHAR2) IS
1291: Select object_version_number
1292: From amv_c_item_types
1293: Where channel_id = p_channel_id
1294: And item_type = l_item_type;
1295: --
1296: CURSOR Check_Author_Match_csr IS

Line 1565: 'And exists (select 1 from amv_c_item_types ci ' ||

1561: 'and cc.content_type_id = item.content_type_id) ';
1562: END IF;
1563: IF (p_match_on_item_type_flag = FND_API.G_TRUE) THEN
1564: l_where_clause := l_where_clause ||
1565: 'And exists (select 1 from amv_c_item_types ci ' ||
1566: 'where ci.channel_id = chan.channel_id ' ||
1567: 'and ci.item_type = item.item_type) ';
1568: END IF;
1569: l_sql_statement := l_sql_statement || l_where_clause;