APPS.EAM_ITEM_ACTIVITIES_PUB dependencies on CSI_ITEM_INSTANCES

Line 100: FROM csi_item_instances cii

96: BEGIN
97: IF (p_maintenance_object_type = 3) THEN
98: IF ( p_asset_number IS NOT NULL ) THEN
99: SELECT count(*) INTO l_count_rec
100: FROM csi_item_instances cii
101: WHERE cii.serial_number = p_asset_number
102: AND cii.instance_id = p_maintenance_object_id
103: AND cii.inventory_item_id = p_asset_group_id;
104: END IF;

Line 212: from csi_item_instances cii

208: END IF ;
209:
210: if p_eam_item_type = 3 then
211: select count(cii.instance_id) into l_count
212: from csi_item_instances cii
213: where cii.instance_id=p_object_id;
214: elsif p_eam_item_type = 2 then
215: select count(msi.inventory_item_id) into l_count
216: from mtl_system_items msi, mtl_parameters mp

Line 285: from csi_item_instances cii

281:
282: if nvl(p_tmpl_flag, 'N') = 'N'
283: then
284: select count(cii.inventory_item_id) into l_count
285: from csi_item_instances cii
286: where cii.serial_number = p_serial_number;
287:
288: if (l_count = 0) then
289: fnd_message.set_name('EAM', 'EAM_EZWO_ASSET_BAD');