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_EMAIL_PROC_PVT dependencies on AMV_C_CHL_ITEM_MATCH

Line 172: from amv_c_chl_item_match cim,jtf_amv_items_vl ib

168: --Fix for bug 14202765
169: l_notes_flag VARCHAR2(1) := 'Y';
170:
171: cursor c_item is select ib.item_id,ib.item_name,ib.last_update_date
172: from amv_c_chl_item_match cim,jtf_amv_items_vl ib
173: where cim.channel_category_id = l_cm_cat_id
174: and cim.channel_id is null
175: and cim.approval_status_type ='APPROVED'
176: and cim.table_name_code ='ITEM'

Line 4942: from amv_c_chl_item_match cim,jtf_amv_items_vl ib

4938: ABORT_REPROCESSING EXCEPTION;
4939: l_logmessage varchar2(1000);
4940: l_level varchar2(20);
4941: cursor c_item is select ib.item_id,ib.item_name,ib.last_update_date
4942: from amv_c_chl_item_match cim,jtf_amv_items_vl ib
4943: where cim.channel_category_id = l_cm_cat_id
4944: and cim.channel_id is null
4945: and cim.approval_status_type ='APPROVED'
4946: and cim.table_name_code ='ITEM'