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 269: from fnd_user usr

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

Line 299: from fnd_user usr

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

Line 316: from fnd_user usr

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

Line 340: from fnd_user usr

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

Line 369: from fnd_user usr

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

Line 387: from fnd_user usr

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