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

Line 159: --MAIL should get fnd username i.s.o resource_number

155: t_err_string varchar2(2000);
156: t_not_id number;
157: t_request_id number;
158:
159: --MAIL should get fnd username i.s.o resource_number
160: cursor c_user
161: ( b_res_num varchar2
162: )
163: is

Line 164: select fnd.USER_NAME

160: cursor c_user
161: ( b_res_num varchar2
162: )
163: is
164: select fnd.USER_NAME
165: from FND_USER fnd
166: , JTF_RS_RESOURCE_EXTNS jtf
167: where jtf.USER_ID = fnd.USER_ID
168: and jtf.RESOURCE_NUMBER = b_res_num;

Line 165: from FND_USER fnd

161: ( b_res_num varchar2
162: )
163: is
164: select fnd.USER_NAME
165: from FND_USER fnd
166: , JTF_RS_RESOURCE_EXTNS jtf
167: where jtf.USER_ID = fnd.USER_ID
168: and jtf.RESOURCE_NUMBER = b_res_num;
169:

Line 167: where jtf.USER_ID = fnd.USER_ID

163: is
164: select fnd.USER_NAME
165: from FND_USER fnd
166: , JTF_RS_RESOURCE_EXTNS jtf
167: where jtf.USER_ID = fnd.USER_ID
168: and jtf.RESOURCE_NUMBER = b_res_num;
169:
170: r_user c_user%ROWTYPE;
171: t_user varchar2(100);