APPS.AMV_CHANNEL_PVT dependencies on JTF_AMV_ITEMS_VL

Line 5436: , jtf_amv_items_vl ib

5432: --
5433: CURSOR C_PendingItmCount IS
5434: select count(cim.item_id)
5435: from amv_c_chl_item_match cim
5436: , jtf_amv_items_vl ib
5437: where cim.channel_id = p_channel_id
5438: and cim.approval_status_type = p_item_status
5439: and cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE
5440: and cim.available_for_channel_date <= sysdate

Line 5446: , jtf_amv_items_vl ib

5442:
5443: CURSOR Get_PendingItems IS
5444: select ib.item_id
5445: from amv_c_chl_item_match cim
5446: , jtf_amv_items_vl ib
5447: where cim.channel_id = p_channel_id
5448: and cim.approval_status_type = p_item_status
5449: and cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE
5450: and cim.item_id = ib.item_id

Line 5456: , jtf_amv_items_vl ib

5452:
5453: CURSOR C_TotalItmCount IS
5454: select count(cim.item_id)
5455: from amv_c_chl_item_match cim
5456: , jtf_amv_items_vl ib
5457: where cim.channel_id = p_channel_id
5458: and cim.approval_status_type = p_item_status
5459: and cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE
5460: and cim.available_for_channel_date <= sysdate

Line 5468: , jtf_amv_items_vl ib

5464:
5465: CURSOR Get_Items IS
5466: select ib.item_id
5467: from amv_c_chl_item_match cim
5468: , jtf_amv_items_vl ib
5469: where cim.channel_id = p_channel_id
5470: and cim.approval_status_type = p_item_status
5471: and cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE
5472: and cim.available_for_channel_date <= sysdate