APPS.AMV_ITEM_PUB dependencies on AMV_C_CHL_ITEM_MATCH

Line 511: DELETE FROM amv_c_chl_item_match

507: x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
508: x_return_status := FND_API.G_RET_STS_ERROR;
509: END IF;
510: -- Remove item from all channels.
511: DELETE FROM amv_c_chl_item_match
512: WHERE item_id = p_item_id
513: AND table_name_code = G_USED_BY_ITEM;
514: -- Remove item's access.
515: DELETE FROM amv_u_access

Line 626: FROM amv_c_chl_item_match

622: l_application_id NUMBER := p_item_obj.application_id;
623:
624: CURSOR GetChannelMatch_csr IS
625: SELECT channel_id
626: FROM amv_c_chl_item_match
627: WHERE item_id = p_item_obj.item_id
628: AND available_due_to_type = AMV_UTILITY_PVT.G_PUSH;
629: --
630: BEGIN

Line 3501: FROM jtf_amv_items_vl item, amv_c_chl_item_match match,

3497: CURSOR Get_Message_csr IS
3498: SELECT
3499: item.item_id,
3500: item.item_name
3501: FROM jtf_amv_items_vl item, amv_c_chl_item_match match,
3502: amv_u_my_channels mych
3503: WHERE item.item_type = 'MESSAGE_ITEM'
3504: AND item.item_id = match.item_id
3505: AND match.table_name_code = 'ITEM'

Line 3516: FROM jtf_amv_items_vl item, amv_c_chl_item_match match,

3512: UNION
3513: SELECT
3514: item.item_id,
3515: item.item_name
3516: FROM jtf_amv_items_vl item, amv_c_chl_item_match match,
3517: amv_u_my_channels mych, jtf_rs_group_members mem,
3518: jtf_rs_groups_vl g
3519: WHERE item.item_type = 'MESSAGE_ITEM'
3520: AND item.item_id = match.item_id

Line 3661: FROM jtf_amv_items_vl item, amv_c_chl_item_match match,

3657: item.content_type_id,
3658: item.owner_id,
3659: item.default_approver_id,
3660: item.item_destination_type
3661: FROM jtf_amv_items_vl item, amv_c_chl_item_match match,
3662: amv_u_my_channels mych
3663: WHERE item.item_type = 'MESSAGE_ITEM'
3664: AND item.item_id = match.item_id
3665: AND match.table_name_code = 'ITEM'

Line 3698: FROM jtf_amv_items_vl item, amv_c_chl_item_match match,

3694: item.content_type_id,
3695: item.owner_id,
3696: item.default_approver_id,
3697: item.item_destination_type
3698: FROM jtf_amv_items_vl item, amv_c_chl_item_match match,
3699: amv_u_my_channels mych, jtf_rs_group_members mem,
3700: jtf_rs_groups_vl g
3701: WHERE item.item_type = 'MESSAGE_ITEM'
3702: AND item.item_id = match.item_id

Line 3876: , amv_c_chl_item_match m

3872: CURSOR GetChannels_csr IS
3873: select c.channel_id
3874: , c.channel_name
3875: from amv_c_channels_vl c
3876: , amv_c_chl_item_match m
3877: where m.item_id = p_item_id
3878: and m.channel_id = c.channel_id
3879: and c.channel_type = amv_utility_pvt.g_content
3880: and c.access_level_type = amv_utility_pvt.g_public