DBA Data[Home] [Help]

APPS.AMV_MYCHANNEL_PVT dependencies on AMV_C_CHL_ITEM_MATCH

Line 2033: from amv_c_chl_item_match cim

2029: CURSOR Get_CategoryItems_csr IS
2030: select ib.item_id
2031: , ib.item_name
2032: , cim.channel_id
2033: from amv_c_chl_item_match cim
2034: , jtf_amv_items_vl ib
2035: where cim.channel_id in (select subscribing_to_id
2036: from amv_u_my_channels
2037: where user_or_group_id in (select group_id

Line 2058: from amv_c_chl_item_match cim

2054: order by ib.effective_start_date desc;
2055:
2056: CURSOR Get_ItemsTotal_csr IS
2057: select count(cim.item_id)
2058: from amv_c_chl_item_match cim
2059: , jtf_amv_items_vl ib
2060: where cim.channel_id in (select subscribing_to_id
2061: from amv_u_my_channels
2062: where user_or_group_id in (select group_id