eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEM_RULES_ENGINE_PUB dependencies on AMV_C_CHL_ITEM_MATCH

Line 925: from amv_c_chl_item_match cim,

921: if l_value is not null then
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'

Line 946: from amv_c_chl_item_match cim,

942: WHERE i.item_id = a.attachment_used_by_id (+)
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'

Line 982: from amv_c_chl_item_match cim,

978:
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'