APPS.IEM_RULES_ENGINE_PUB dependencies on JTF_AMV_ITEMS_VL

Line 915: jtf_amv_items_vl ib

911:
912:
913: select count(ib.item_id) into x_total
914: from amv_c_chl_item_match cim,
915: jtf_amv_items_vl ib
916: where cim.channel_category_id = p_cat_id
917: and cim.channel_id is null
918: and cim.approval_status_type ='APPROVED'
919: and cim.table_name_code ='ITEM'

Line 930: FROM jtf_amv_items_vl i,jtf_amv_attachments_v a

926: Select count(*) into x_total
927: from
928: (
929: SELECT i.item_id,i.item_name,i.description,i.item_type,i.last_update_date
930: FROM jtf_amv_items_vl i,jtf_amv_attachments_v a
931: WHERE i.item_id = a.attachment_used_by_id (+)
932: AND i.item_id IN
933: (
934: select ib.item_id

Line 936: jtf_amv_items_vl ib

932: AND i.item_id IN
933: (
934: select ib.item_id
935: from amv_c_chl_item_match cim,
936: jtf_amv_items_vl ib
937: where cim.channel_category_id = p_cat_id
938: and cim.channel_id is null
939: and cim.approval_status_type ='APPROVED'
940: and cim.table_name_code ='ITEM'

Line 972: jtf_amv_items_vl ib

968: if l_value is not null then
969:
970: select count(ib.item_id) into l_total
971: from amv_c_chl_item_match cim,
972: jtf_amv_items_vl ib
973: where cim.channel_category_id = l_value
974: and cim.channel_id is null
975: and cim.approval_status_type ='APPROVED'
976: and cim.table_name_code ='ITEM'