APPS.EAM_ASSETNUMBER_PUB dependencies on CSI_ITEM_INSTANCES

Line 264: SELECT count(*) INTO l_count FROM csi_item_instances

260: -- Bug # 4770445 : Need to check if p_eam_linear_id is null or not
261:
262: IF (p_eam_linear_id IS NOT NULL) THEN
263: -- Check if eam_linear_id already exists in MSN
264: SELECT count(*) INTO l_count FROM csi_item_instances
265: WHERE linear_location_id = p_eam_linear_id AND ROWNUM = 1;
266:
267: IF (l_count > 0) THEN
268: FND_MESSAGE.SET_NAME('EAM', 'EAM_LINEAR_ID_EXISTS_IN_MSN');

Line 548: from csi_item_instances

544:
545: if (p_instance_id is not null) then
546: select last_vld_organization_id,inventory_item_id,serial_number
547: into l_organization_id,l_inventory_item_id,l_serial_number
548: from csi_item_instances
549: where instance_id = p_instance_id;
550: elsif (p_instance_number is not null) then
551: select last_vld_organization_id,inventory_item_id,serial_number
552: into l_organization_id,l_inventory_item_id,l_serial_number

Line 553: from csi_item_instances

549: where instance_id = p_instance_id;
550: elsif (p_instance_number is not null) then
551: select last_vld_organization_id,inventory_item_id,serial_number
552: into l_organization_id,l_inventory_item_id,l_serial_number
553: from csi_item_instances
554: where instance_number = p_instance_number;
555: end if;
556:
557: if (p_inventory_item_id is not null AND p_serial_number is not null) then

Line 560: from csi_item_instances

556:
557: if (p_inventory_item_id is not null AND p_serial_number is not null) then
558: select instance_id,last_vld_organization_id
559: into l_instance_id,l_organization_id
560: from csi_item_instances
561: where serial_number = p_serial_number
562: and inventory_item_id = p_inventory_item_id;
563: end if;
564:

Line 630: SELECT count(*) INTO l_count FROM csi_item_instances

626:
627: -- Bug # 4770445 : Need to check if p_eam_linear_id is null or not
628: IF (p_eam_linear_id IS NOT NULL AND p_eam_linear_id <> fnd_api.g_miss_num) THEN
629: -- Check if eam_linear_id already exists in MSN
630: SELECT count(*) INTO l_count FROM csi_item_instances
631: WHERE linear_location_id = p_eam_linear_id
632: AND instance_id <> l_instance_id AND ROWNUM = 1;
633:
634: IF (l_count > 0) THEN

Line 843: FROM csi_item_instances cii, mtl_parameters mp

839:
840: BEGIN
841: SELECT cii.instance_id, nvl(cii.maintainable_flag, 'Y'), nvl(cii.network_asset_flag, 'N'), mp.maint_organization_id
842: INTO l_instance_id, l_old_maint_flag, l_old_network_asset_flag, l_org
843: FROM csi_item_instances cii, mtl_parameters mp
844: WHERE cii.serial_number = p_serial_number
845: AND cii.inventory_item_id = p_inventory_item_id
846: AND cii.last_vld_organization_id = p_current_organization_id
847: AND cii.last_vld_organization_id = mp.organization_id;