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

Line 10093: ||' from fnd_user fu'

10089: v_sql_stmt := 61;
10090: lv_sql_stmt :=
10091: 'UPDATE msc_st_groups msg'
10092: ||' SET contact_user_id = (select user_id '
10093: ||' from fnd_user fu'
10094: ||' where UPPER(fu.user_name) = UPPER(msg.contact_user_name)) '
10095: ||' WHERE contact_user_name IS NOT NULL'
10096: ||' AND batch_id = :lv_batch_id'
10097: ||' AND sr_instance_code = :v_instance_code'

Line 10824: ||' from fnd_user fu'

10820: v_sql_stmt := 78;
10821: lv_sql_stmt :=
10822: 'UPDATE msc_st_group_companies msg'
10823: ||' SET contact_user_id = (select user_id '
10824: ||' from fnd_user fu'
10825: ||' where UPPER(fu.user_name) =UPPER( msg.contact_user_name)) '
10826: ||' WHERE batch_id = :lv_batch_id'
10827: ||' AND sr_instance_code = :v_instance_code'
10828: ||' AND process_flag = '||G_IN_PROCESS;

Line 12259: ||' FROM fnd_user fu'

12255: 'UPDATE msc_st_planners msp'
12256: ||' SET process_flag = '||G_ERROR_FLG||','
12257: ||' error_text = '||''''||lv_message_text||''''
12258: ||' WHERE NOT EXISTS(SELECT 1 '
12259: ||' FROM fnd_user fu'
12260: ||' where fu.user_name =UPPER(msp.user_name))'
12261: ||' AND batch_id = :lv_batch_id'
12262: ||' AND sr_instance_code = :v_instance_code'
12263: ||' AND process_flag = '||G_IN_PROCESS;

Line 12348: ||' from fnd_user fu'

12344: v_sql_stmt := 07;
12345: lv_sql_stmt :=
12346: 'UPDATE msc_st_planners msp'
12347: ||' SET employee_id = (select employee_id '
12348: ||' from fnd_user fu'
12349: ||' where fu.user_name = UPPER(msp.user_name)) '
12350: ||' WHERE batch_id = :lv_batch_id'
12351: ||' AND sr_instance_code = :v_instance_code'
12352: ||' AND process_flag = '||G_IN_PROCESS;

Line 12480: UPDATE FND_USER y

12476: ROLLBACK;
12477: END;
12478: END LOOP;
12479:
12480: UPDATE FND_USER y
12481: SET EMAIL_ADDRESS = (select ELECTRONIC_MAIL_ADDRESS
12482: from msc_st_planners z
12483: WHERE UPPER(z.USER_NAME) = y.USER_NAME
12484: AND z.process_flag = G_VALID

Line 35168: WHERE ( mscu.user_name IS NULL OR NOT EXISTS(select '1' from fnd_user fu where fu.user_name =UPPER(mscu.user_name)))

35164:
35165: UPDATE msc_st_company_users mscu
35166: SET mscu.process_flag = G_ERROR_FLG,
35167: mscu.error_text = lv_message_text
35168: WHERE ( mscu.user_name IS NULL OR NOT EXISTS(select '1' from fnd_user fu where fu.user_name =UPPER(mscu.user_name)))
35169: AND mscu.process_flag = G_IN_PROCESS
35170: AND mscu.batch_id = lv_batch_id
35171: AND mscu.sr_instance_code = v_instance_code;
35172: