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

Line 270: from fnd_user usr

266: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
267: and wjsi.created_by_name is not null
268: and wjsi.created_by is null
269: and not exists (select 1
270: from fnd_user usr
271: where usr.user_name = wjsi.created_by_name)
272: returning wjsi.interface_id bulk collect into l_interfaceTbl;
273:
274: if ( sql%rowcount > 0 ) then

Line 300: from fnd_user usr

296: end if;
297:
298: update wip_job_schedule_interface wjsi
299: set wjsi.created_by = (select usr.user_id
300: from fnd_user usr
301: where usr.user_name = wjsi.created_by_name),
302: wjsi.last_update_date = sysdate
303: where wjsi.group_id = p_groupID
304: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 317: from fnd_user usr

313: where wjsi.group_id = p_groupID
314: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION
315: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
316: and not exists (select 1
317: from fnd_user usr
318: where usr.user_id = wjsi.created_by
319: and sysdate between usr.start_date and nvl(end_date, sysdate))
320: returning wjsi.interface_id bulk collect into l_interfaceTbl;
321:

Line 341: from fnd_user usr

337: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
338: and wjsi.last_updated_by_name is not null
339: and wjsi.last_updated_by is null
340: and not exists (select 1
341: from fnd_user usr
342: where usr.user_name = wjsi.last_updated_by_name)
343: returning wjsi.interface_id bulk collect into l_interfaceTbl;
344:
345: if ( sql%rowcount > 0 ) then

Line 370: from fnd_user usr

366: end if;
367:
368: update wip_job_schedule_interface wjsi
369: set wjsi.last_updated_by = (select usr.user_id
370: from fnd_user usr
371: where usr.user_name = wjsi.last_updated_by_name),
372: wjsi.last_update_date = sysdate
373: where wjsi.group_id = p_groupID
374: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION

Line 388: from fnd_user usr

384: where wjsi.group_id = p_groupID
385: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION
386: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
387: and not exists (select 1
388: from fnd_user usr
389: where usr.user_id = wjsi.last_updated_by
390: and sysdate between usr.start_date and nvl(end_date, sysdate))
391: returning wjsi.interface_id bulk collect into l_interfaceTbl;
392: