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.AMV_MYCHANNEL_PVT dependencies on JTF_AMV_ITEMS_VL

Line 2034: , jtf_amv_items_vl ib

2030: select ib.item_id
2031: , ib.item_name
2032: , cim.channel_id
2033: from amv_c_chl_item_match cim
2034: , jtf_amv_items_vl ib
2035: where cim.channel_id in (select subscribing_to_id
2036: from amv_u_my_channels
2037: where user_or_group_id in (select group_id
2038: from jtf_rs_group_members

Line 2059: , jtf_amv_items_vl ib

2055:
2056: CURSOR Get_ItemsTotal_csr IS
2057: select count(cim.item_id)
2058: from amv_c_chl_item_match cim
2059: , jtf_amv_items_vl ib
2060: where cim.channel_id in (select subscribing_to_id
2061: from amv_u_my_channels
2062: where user_or_group_id in (select group_id
2063: from jtf_rs_group_members

Line 2296: from jtf_amv_items_vl

2292: select item_id
2293: , item_name
2294: , description
2295: , item_type
2296: from jtf_amv_items_vl
2297: where owner_id = p_user_id
2298: and application_id = p_application_id
2299: and nvl( expiration_date, sysdate ) >= sysdate
2300: and nvl(effective_start_date, sysdate) <= sysdate

Line 2305: from jtf_amv_items_vl

2301: order by item_name;
2302:
2303: CURSOR Get_ItemsTotal_csr IS
2304: select count(item_id)
2305: from jtf_amv_items_vl
2306: where owner_id = p_user_id
2307: and nvl( expiration_date, sysdate ) >= sysdate
2308: and nvl(effective_start_date, sysdate) <= sysdate
2309: and application_id = p_application_id;