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

Line 1950: || ' , FND_USER d'

1946: || ' , nvl(d.user_name,to_char(c.last_updated_by)) "Updated
By"'
1947: || ' from fnd_profile_options a'
1948: || ' , FND_PROFILE_OPTIONS_TL b'
1949: || ' , FND_PROFILE_OPTION_VALUES c'
1950: || ' , FND_USER d'
1951: || ' , FND_USER e'
1952: || ' , FND_RESPONSIBILITY_TL g'
1953: || ' , FND_APPLICATION h'
1954: || ' where a.application_id = nvl(' || nvl(p_application_id,'null')

Line 1951: || ' , FND_USER e'

1947: || ' from fnd_profile_options a'
1948: || ' , FND_PROFILE_OPTIONS_TL b'
1949: || ' , FND_PROFILE_OPTION_VALUES c'
1950: || ' , FND_USER d'
1951: || ' , FND_USER e'
1952: || ' , FND_RESPONSIBILITY_TL g'
1953: || ' , FND_APPLICATION h'
1954: || ' where a.application_id = nvl(' || nvl(p_application_id,'null')
1955: || ' , a.application_id)'

Line 2050: l_user_name fnd_user.user_name%type;

2046: procedure Set_Client_html(p_user_name varchar2, p_resp_id number,
2047: p_app_id number, p_sec_grp_id number) is
2048: l_cursor integer;
2049: l_num_rows integer;
2050: l_user_name fnd_user.user_name%type;
2051: l_user_id number;
2052: l_app_id number;
2053: l_counter integer;
2054: l_appl_vers fnd_product_groups.release_name%type;

Line 2064: from fnd_user where user_name = l_user_name;

2060: begin
2061: l_user_name := upper(p_user_name);
2062: begin
2063: select user_id into l_user_id
2064: from fnd_user where user_name = l_user_name;
2065: exception
2066: when others then
2067: raise inv_user;
2068: end;

Line 2072: 'from fnd_user_responsibility rg '||

2068: end;
2069: l_appl_vers := get_db_apps_version; -- sets g_appl_version
2070: if g_appl_version = '11.0' or g_appl_version = '10.7' then
2071: sqltxt := 'select rg.application_id '||
2072: 'from fnd_user_responsibility rg '||
2073: 'where rg.responsibility_id = '||to_char(p_resp_id)||' '||
2074: 'and rg.user_id = '||to_char(l_user_id);
2075: elsif g_appl_version = '11.5' then
2076: sqltxt := 'select rg.responsibility_application_id '||

Line 2077: 'from fnd_user_resp_groups rg '||

2073: 'where rg.responsibility_id = '||to_char(p_resp_id)||' '||
2074: 'and rg.user_id = '||to_char(l_user_id);
2075: elsif g_appl_version = '11.5' then
2076: sqltxt := 'select rg.responsibility_application_id '||
2077: 'from fnd_user_resp_groups rg '||
2078: 'where rg.responsibility_id = '||to_char(p_resp_id)||' '||
2079: 'and rg.user_id = '||to_char(l_user_id);
2080: end if;
2081: begin

Line 4056: fnd_user u

4052: fnd_profile_options o,
4053: fnd_profile_options_tl ot,
4054: fnd_application_tl a,
4055: fnd_responsibility_tl r,
4056: fnd_user u
4057: where o.application_id = nvl(p_application_id, o.application_id)
4058: and o.profile_option_name = nvl(p_short_name, o.profile_option_name)
4059: and v.LEVEL_VALUE =
4060: decode(level_id, 10004, u.user_id, 10003, r.responsibility_id,

Line 4098: fnd_user u

4094: fnd_profile_options o,
4095: fnd_profile_options_tl ot,
4096: fnd_application_tl a,
4097: fnd_responsibility_tl r,
4098: fnd_user u
4099: where o.application_id = nvl(p_application_id, o.application_id)
4100: and o.profile_option_name = nvl(p_short_name, o.profile_option_name)
4101: and v.LEVEL_VALUE =
4102: decode(level_id, 10004, u.user_id, 10003, r.responsibility_id,

Line 4213: l_user_name fnd_user.user_name%type;

4209: procedure Set_Client_text(p_user_name varchar2, p_resp_id number,
4210: p_app_id number, p_sec_grp_id number) is
4211: l_cursor integer;
4212: l_num_rows integer;
4213: l_user_name fnd_user.user_name%type;
4214: l_user_id number;
4215: l_app_id number;
4216: l_counter integer;
4217: l_appl_vers fnd_product_groups.release_name%type;

Line 4227: from fnd_user where user_name = l_user_name;

4223: begin
4224: l_user_name := upper(p_user_name);
4225: begin
4226: select user_id into l_user_id
4227: from fnd_user where user_name = l_user_name;
4228: exception
4229: when others then
4230: raise inv_user;
4231: end;

Line 4235: 'from fnd_user_responsibility rg '||

4231: end;
4232: l_appl_vers := get_db_apps_version; -- sets g_appl_version
4233: if g_appl_version = '11.0' or g_appl_version = '10.7' then
4234: sqltxt := 'select rg.application_id '||
4235: 'from fnd_user_responsibility rg '||
4236: 'where rg.responsibility_id = '||to_char(p_resp_id)||' '||
4237: 'and rg.user_id = '||to_char(l_user_id);
4238: elsif g_appl_version = '11.5' then
4239: sqltxt := 'select rg.responsibility_application_id '||

Line 4240: 'from fnd_user_resp_groups rg '||

4236: 'where rg.responsibility_id = '||to_char(p_resp_id)||' '||
4237: 'and rg.user_id = '||to_char(l_user_id);
4238: elsif g_appl_version = '11.5' then
4239: sqltxt := 'select rg.responsibility_application_id '||
4240: 'from fnd_user_resp_groups rg '||
4241: 'where rg.responsibility_id = '||to_char(p_resp_id)||' '||
4242: 'and rg.user_id = '||to_char(l_user_id);
4243: end if;
4244: begin