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.AS_OPP_SALES_CREDIT_PVT dependencies on FND_USER

Line 214: -- FROM jtf_rs_resource_extns a, fnd_user b, jtf_rs_group_members c

210: CURSOR c_group_id(c_SALESFORCE_ID NUMBER) IS
211: -- SELECT decode(count(*), 1, to_char(max(c.group_id)), decode(fnd_profile.value_specific('ASF_DEFAULT_GROUP_ROLE', max(a.user_id)),'XXXXX',null,fnd_profile.value_specific('ASF_DEFAULT_GROUP_ROLE',max(a.user_id))))
212: -- SELECT decode(count(*), 1, to_char(max(c.group_id)))
213: -- SELECT to_char(max(c.group_id))
214: -- FROM jtf_rs_resource_extns a, fnd_user b, jtf_rs_group_members c
215: -- WHERE a.user_id = b.user_id
216: -- AND a.resource_id = c.resource_id
217: -- AND a.resource_id = c_SALESFORCE_ID;
218: -- fix the bug 2549218

Line 220: FROM jtf_rs_resource_extns a, fnd_user b, jtf_rs_group_members c, JTF_RS_ROLE_RELATIONS d , JTF_RS_ROLES_B e

216: -- AND a.resource_id = c.resource_id
217: -- AND a.resource_id = c_SALESFORCE_ID;
218: -- fix the bug 2549218
219: SELECT to_char(max(c.group_id))
220: FROM jtf_rs_resource_extns a, fnd_user b, jtf_rs_group_members c, JTF_RS_ROLE_RELATIONS d , JTF_RS_ROLES_B e
221: WHERE a.user_id = b.user_id
222: AND a.resource_id = c.resource_id
223: AND e.ROLE_TYPE_CODE in ('SALES','TELESALES','FIELDSALES','PRM')
224: AND c.GROUP_MEMBER_ID = d.ROLE_RESOURCE_ID