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 10219: ||' from fnd_user fu'

10215: v_sql_stmt := 61;
10216: lv_sql_stmt :=
10217: 'UPDATE msc_st_groups msg'
10218: ||' SET contact_user_id = (select user_id '
10219: ||' from fnd_user fu'
10220: ||' where UPPER(fu.user_name) = UPPER(msg.contact_user_name)) '
10221: ||' WHERE contact_user_name IS NOT NULL'
10222: ||' AND batch_id = :lv_batch_id'
10223: ||' AND sr_instance_code = :v_instance_code'

Line 10950: ||' from fnd_user fu'

10946: v_sql_stmt := 78;
10947: lv_sql_stmt :=
10948: 'UPDATE msc_st_group_companies msg'
10949: ||' SET contact_user_id = (select user_id '
10950: ||' from fnd_user fu'
10951: ||' where UPPER(fu.user_name) =UPPER( msg.contact_user_name)) '
10952: ||' WHERE batch_id = :lv_batch_id'
10953: ||' AND sr_instance_code = :v_instance_code'
10954: ||' AND process_flag = '||G_IN_PROCESS;

Line 15746: ||' FROM fnd_user fu'

15742: 'UPDATE msc_st_planners msp'
15743: ||' SET process_flag = '||G_ERROR_FLG||','
15744: ||' error_text = '||''''||lv_message_text||''''
15745: ||' WHERE NOT EXISTS(SELECT 1 '
15746: ||' FROM fnd_user fu'
15747: ||' where fu.user_name =UPPER(msp.user_name))'
15748: ||' AND batch_id = :lv_batch_id'
15749: ||' AND sr_instance_code = :v_instance_code'
15750: ||' AND process_flag = '||G_IN_PROCESS;

Line 15835: ||' from fnd_user fu'

15831: v_sql_stmt := 07;
15832: lv_sql_stmt :=
15833: 'UPDATE msc_st_planners msp'
15834: ||' SET employee_id = (select employee_id '
15835: ||' from fnd_user fu'
15836: ||' where fu.user_name = UPPER(msp.user_name)) '
15837: ||' WHERE batch_id = :lv_batch_id'
15838: ||' AND sr_instance_code = :v_instance_code'
15839: ||' AND process_flag = '||G_IN_PROCESS;

Line 15967: UPDATE FND_USER y

15963: ROLLBACK;
15964: END;
15965: END LOOP;
15966:
15967: UPDATE FND_USER y
15968: SET EMAIL_ADDRESS = (select ELECTRONIC_MAIL_ADDRESS
15969: from msc_st_planners z
15970: WHERE UPPER(z.USER_NAME) = y.USER_NAME
15971: AND z.process_flag = G_VALID

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

39948:
39949: UPDATE msc_st_company_users mscu
39950: SET mscu.process_flag = G_ERROR_FLG,
39951: mscu.error_text = lv_message_text
39952: WHERE ( mscu.user_name IS NULL OR NOT EXISTS(select '1' from fnd_user fu where fu.user_name =UPPER(mscu.user_name)))
39953: AND mscu.process_flag = G_IN_PROCESS
39954: AND mscu.batch_id = lv_batch_id
39955: AND mscu.sr_instance_code = v_instance_code;
39956: