[Home] [Help]
262: and transaction_source_type_id = 5
263: and rebuild_item_id is not null
264: and rebuild_activity_id is not null
265: and not exists (select 1
266: from mtl_eam_asset_activities meaa, csi_item_instances cii, eam_org_maint_defaults eomd
267: where mti.rebuild_activity_id = meaa.asset_activity_id
268: and meaa.activity_association_id = eomd.object_id
269: and eomd.object_type = 60
270: and eomd.organization_id = mti.organization_id
339: and ( msn.current_status = 1 --defined not used
340: or ( msn.current_status in (3,4) --issued out or in stores
341: and exists(select 1
342: from wip_discrete_jobs wdj, mtl_object_genealogy mog,
343: csi_item_instances cii, mtl_serial_numbers msn_parent
344: where wdj.maintenance_object_id = cii.instance_id
345: and wdj.maintenance_object_type = 3
346: and wdj.wip_entity_id = mti.transaction_source_id
347: and cii.inventory_item_id = msn_parent.inventory_item_id
457:
458: select wdj.maintenance_object_id, wdj.maintenance_object_type,
459: wdj.maintenance_object_source, msn.gen_object_id
460: into l_maintObjID, l_maintObjType, l_maintObjSrc, l_maintGenObjID
461: from wip_discrete_jobs wdj, csi_item_instances cii, mtl_serial_numbers msn
462: where wdj.wip_entity_id = p_compRec.wipEntityID
463: and wdj.maintenance_object_type = 3
464: and wdj.maintenance_object_id = cii.instance_id
465: and msn.serial_number (+) = cii.serial_number --Modified outer join for bug 6892336