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 MTL_SERIAL_NUMBERS

Line 273: from mtl_serial_numbers

269: and wjdi.load_type = wip_job_details.wip_serial
270: and wjdi.substitution_type = p_substitution_type
271: and wjdi.wip_entity_id = we.wip_entity_id
272: and not exists(select 1
273: from mtl_serial_numbers
274: where serial_number = wjdi.serial_number_new
275: and inventory_item_id = we.primary_item_id
276: and current_organization_id = wjdi.organization_id);
277:

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