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 JTF_AMV_ITEMS_VL

Line 146: from amv_c_chl_item_match cim,jtf_amv_items_vl ib

142: l_intent_flg number(15,0);
143: l_rule_id number;
144: l_acct_type iem_mstemail_accounts.account_type%type;
145: cursor c_item is select ib.item_id,ib.item_name,ib.last_update_date
146: from amv_c_chl_item_match cim,jtf_amv_items_vl ib
147: where cim.channel_category_id = l_cm_cat_id
148: and cim.channel_id is null
149: and cim.approval_status_type ='APPROVED'
150: and cim.table_name_code ='ITEM'

Line 3847: from amv_c_chl_item_match cim,jtf_amv_items_vl ib

3843: ABORT_REPROCESSING EXCEPTION;
3844: l_logmessage varchar2(1000);
3845: l_level varchar2(20);
3846: cursor c_item is select ib.item_id,ib.item_name,ib.last_update_date
3847: from amv_c_chl_item_match cim,jtf_amv_items_vl ib
3848: where cim.channel_category_id = l_cm_cat_id
3849: and cim.channel_id is null
3850: and cim.approval_status_type ='APPROVED'
3851: and cim.table_name_code ='ITEM'