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.IEX_CASE_OWNER_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 81: FROM hz_customer_profiles hp, jtf_rs_resource_extns rs,ar_collectors ac

77: --Begin bug#5246309 schekuri 29-Jun-2006
78: --Changed the query to get the resource from hz_customer_profiles
79: CURSOR c_party_resource(p_party_id NUMBER) IS
80: SELECT ac.resource_id,0
81: FROM hz_customer_profiles hp, jtf_rs_resource_extns rs,ar_collectors ac
82: WHERE hp.party_id = p_party_id
83: and rs.resource_id = ac.resource_id
84: and hp.collector_id = ac.collector_id
85: and hp.cust_account_id=-1

Line 97: FROM as_rpt_managers_v m, as_accesses acc, jtf_rs_resource_extns rs

93: group by ac.resource_id;
94:
95: /*CURSOR c_party_resource(p_party_id NUMBER) IS
96: SELECT DISTINCT rs.resource_id, 0
97: FROM as_rpt_managers_v m, as_accesses acc, jtf_rs_resource_extns rs
98: WHERE m.person_id = acc.person_id
99: AND m.manager_person_id = rs.source_id
100: AND acc.customer_id = p_party_id
101: AND rs.start_date_active <= sysdate