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_SERIAL_ASSOC_VALIDATIONS dependencies on WIP_ENTITIES

Line 261: wip_entities we

257: we.primary_item_id,
258: wjdi.serial_number_new,
259: wjdi.rowid
260: from wip_job_dtls_interface wjdi,
261: wip_entities we
262: where wjdi.group_id = p_group_id
263: and wjdi.process_phase = wip_constants.ml_validation
264: and wjdi.process_status in (wip_constants.running,
265: wip_constants.pending,

Line 388: from mtl_serial_numbers msn, wip_entities we

384: and wjdi.organization_id = p_organization_id
385: and wjdi.load_type = wip_job_details.wip_serial
386: and wjdi.substitution_type = p_substitution_type
387: and not exists(select 1
388: from mtl_serial_numbers msn, wip_entities we
389: where msn.serial_number = wjdi.serial_number_new
390: and msn.current_organization_id = wjdi.organization_id
391: and msn.wip_entity_id is null
392: and msn.group_mark_id is null

Line 427: from mtl_serial_numbers msn, wip_entities we

423: and organization_id = p_organization_id
424: and wjdi.load_type = wip_job_details.wip_serial
425: and wjdi.substitution_type = p_substitution_type
426: and not exists(select 1
427: from mtl_serial_numbers msn, wip_entities we
428: where msn.serial_number = wjdi.serial_number_new
429: and msn.current_organization_id = wjdi.organization_id
430: and msn.wip_entity_id is null
431: and msn.group_mark_id is null

Line 458: from mtl_serial_numbers msn, wip_entities we

454: and wjdi.organization_id = p_organization_id
455: and wjdi.load_type = wip_job_details.wip_serial
456: and wjdi.substitution_type = p_substitution_type
457: and not exists(select 1
458: from mtl_serial_numbers msn, wip_entities we
459: where msn.serial_number = wjdi.serial_number_old
460: and msn.current_organization_id = wjdi.organization_id
461: and msn.wip_entity_id = p_wip_entity_id
462: and msn.group_mark_id = p_wip_entity_id

Line 498: from mtl_serial_numbers msn, wip_entities we

494: and organization_id = p_organization_id
495: and wjdi.load_type = wip_job_details.wip_serial
496: and wjdi.substitution_type = p_substitution_type
497: and not exists(select 1
498: from mtl_serial_numbers msn, wip_entities we
499: where msn.serial_number = wjdi.serial_number_old
500: and msn.current_organization_id = wjdi.organization_id
501: and msn.wip_entity_id = p_wip_entity_id
502: and msn.group_mark_id = p_wip_entity_id