APPS.AMV_SEARCH_PVT dependencies on AMV_C_CHANNELS_VL

Line 995: l_from := l_from || ' , amv_c_channels_vl b ';

991: l_select := ' SELECT a.channel_id, a.channel_id, 50 ';
992:
993: l_from := ' FROM '|| p_table_name ||' a ';
994:
995: l_from := l_from || ' , amv_c_channels_vl b ';
996:
997: IF p_include_chns = FND_API.G_TRUE THEN
998:
999: l_from := l_from || ' , amv_temp_numbers id ';

Line 1931: x_sql_statement(p_index) := ' from amv_c_channels_vl b ';

1927: x_sql_statement(p_index) := ', b.channel_id, (score(1) + score(2))/2 ';
1928:
1929: p_index := p_index + 1;
1930:
1931: x_sql_statement(p_index) := ' from amv_c_channels_vl b ';
1932:
1933: p_index := p_index + 1;
1934:
1935: IF p_include_chns = FND_API.G_TRUE THEN

Line 3734: from amv_c_channels_vl b

3730: CURSOR get_pub_channels IS
3731:
3732: select b.channel_id
3733:
3734: from amv_c_channels_vl b
3735:
3736: where b.channel_type = G_CONTENT
3737:
3738: and b.access_level_type = G_PUBLIC

Line 3746: from amv_c_channels_vl b

3742: UNION ALL
3743:
3744: select b.channel_id
3745:
3746: from amv_c_channels_vl b
3747:
3748: where b.channel_type = G_PRIVATE
3749:
3750: and b.owner_user_id = p_user_id

Line 3756: from amv_c_channels_vl b

3752: UNION ALL
3753:
3754: select b.channel_id
3755:
3756: from amv_c_channels_vl b
3757:
3758: , amv_u_access au
3759:
3760: , jtf_rs_group_members_vl jgm

Line 4320: from amv_c_channels_vl chn

4316: , tmp.number_value
4317:
4318: , max(tmp.score)
4319:
4320: from amv_c_channels_vl chn
4321:
4322: , amv_temp_ids tmp
4323:
4324: where chn.channel_id = tmp.id

Line 4348: from amv_c_channels_vl

4344: select channel_category_id
4345:
4346: , channel_name
4347:
4348: from amv_c_channels_vl
4349:
4350: where channel_id = l_id;
4351:
4352:

Line 4602: from amv_c_channels_vl

4598: select channel_id
4599:
4600: , channel_name
4601:
4602: from amv_c_channels_vl
4603:
4604: where channel_id = l_id;
4605:
4606: