APPS.IEM_RULES_ENGINE_PUB dependencies on JTF_AMV_ITEMS_VL

Line 926: jtf_amv_items_vl ib

922:
923:
924: select count(ib.item_id) into x_total
925: from amv_c_chl_item_match cim,
926: jtf_amv_items_vl ib
927: where cim.channel_category_id = p_cat_id
928: and cim.channel_id is null
929: and cim.approval_status_type ='APPROVED'
930: and cim.table_name_code ='ITEM'

Line 941: FROM jtf_amv_items_vl i,jtf_amv_attachments_v a

937: Select count(*) into x_total
938: from
939: (
940: SELECT i.item_id,i.item_name,i.description,i.item_type,i.last_update_date
941: FROM jtf_amv_items_vl i,jtf_amv_attachments_v a
942: WHERE i.item_id = a.attachment_used_by_id (+)
943: AND i.item_id IN
944: (
945: select ib.item_id

Line 947: jtf_amv_items_vl ib

943: AND i.item_id IN
944: (
945: select ib.item_id
946: from amv_c_chl_item_match cim,
947: jtf_amv_items_vl ib
948: where cim.channel_category_id = p_cat_id
949: and cim.channel_id is null
950: and cim.approval_status_type ='APPROVED'
951: and cim.table_name_code ='ITEM'

Line 983: jtf_amv_items_vl ib

979: if l_value is not null then
980:
981: select count(ib.item_id) into l_total
982: from amv_c_chl_item_match cim,
983: jtf_amv_items_vl ib
984: where cim.channel_category_id = l_value
985: and cim.channel_id is null
986: and cim.approval_status_type ='APPROVED'
987: and cim.table_name_code ='ITEM'