APPS.WIP_EAMMTLPROC_PRIV dependencies on MTL_SERIAL_NUMBERS

Line 335: from mtl_serial_numbers msn

331: and transaction_source_type_id = 5
332: and rebuild_item_id is not null
333: and rebuild_serial_number is not null
334: and not exists(select 1 --subquery verifies rebuild sn is predefined or (issued out/in stores and in the asset's genealogy)
335: from mtl_serial_numbers msn
336: where mti.rebuild_item_id = msn.inventory_item_id
337: and mti.rebuild_serial_number = msn.serial_number
338: and ( msn.current_status = 1 --defined not used
339: or ( msn.current_status in (3,4) --issued out or in stores

Line 342: csi_item_instances cii, mtl_serial_numbers msn_parent

338: and ( msn.current_status = 1 --defined not used
339: or ( msn.current_status in (3,4) --issued out or in stores
340: and exists(select 1
341: from wip_discrete_jobs wdj, mtl_object_genealogy mog,
342: csi_item_instances cii, mtl_serial_numbers msn_parent
343: where wdj.maintenance_object_id = cii.instance_id
344: and wdj.maintenance_object_type = 3
345: and wdj.wip_entity_id = mti.transaction_source_id
346: and cii.inventory_item_id = msn_parent.inventory_item_id

Line 423: from mtl_serial_numbers_temp

419: --we have already checked the serial_control_code so a serial number must be in MSNT
420: if(p_compRec.lotControlCode = wip_constants.no_lot) then
421: select fm_serial_number
422: bulk collect into l_serialNumTbl
423: from mtl_serial_numbers_temp
424: where transaction_temp_id = p_compRec.txnTmpID;
425: else
426: select fm_serial_number
427: bulk collect into l_serialNumTbl

Line 428: from mtl_serial_numbers_temp

424: where transaction_temp_id = p_compRec.txnTmpID;
425: else
426: select fm_serial_number
427: bulk collect into l_serialNumTbl
428: from mtl_serial_numbers_temp
429: where transaction_temp_id = (select serial_transaction_temp_id
430: from mtl_transaction_lots_temp
431: where transaction_temp_id = p_compRec.txnTmpID);
432: end if;

Line 439: from wip_discrete_jobs wdj, csi_item_instances cii, mtl_serial_numbers msn

435:
436: select wdj.maintenance_object_id, wdj.maintenance_object_type,
437: wdj.maintenance_object_source, msn.gen_object_id
438: into l_maintObjID, l_maintObjType, l_maintObjSrc, l_maintGenObjID
439: from wip_discrete_jobs wdj, csi_item_instances cii, mtl_serial_numbers msn
440: where wdj.wip_entity_id = p_compRec.wipEntityID
441: and wdj.maintenance_object_type = 3
442: and wdj.maintenance_object_id = cii.instance_id
443: and msn.serial_number (+) = cii.serial_number --Modified outer join for bug 6892336