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 914: from amv_c_chl_item_match cim,

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

Line 935: from amv_c_chl_item_match cim,

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

Line 971: from amv_c_chl_item_match cim,

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