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.EAM_ASSETNUMBER_PUB dependencies on CSI_ITEM_INSTANCES

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

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

Line 568: from csi_item_instances

564:
565: if (p_instance_id is not null) then
566: select last_vld_organization_id,inventory_item_id,serial_number
567: into l_organization_id,l_inventory_item_id,l_serial_number
568: from csi_item_instances
569: where instance_id = p_instance_id;
570: elsif (p_instance_number is not null) then
571: select last_vld_organization_id,inventory_item_id,serial_number
572: into l_organization_id,l_inventory_item_id,l_serial_number

Line 573: from csi_item_instances

569: where instance_id = p_instance_id;
570: elsif (p_instance_number is not null) then
571: select last_vld_organization_id,inventory_item_id,serial_number
572: into l_organization_id,l_inventory_item_id,l_serial_number
573: from csi_item_instances
574: where instance_number = p_instance_number;
575: end if;
576:
577: if (p_inventory_item_id is not null AND p_serial_number is not null) then

Line 580: from csi_item_instances

576:
577: if (p_inventory_item_id is not null AND p_serial_number is not null) then
578: select instance_id,last_vld_organization_id
579: into l_instance_id,l_organization_id
580: from csi_item_instances
581: where serial_number = p_serial_number
582: and inventory_item_id = p_inventory_item_id;
583: end if;
584:

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

646:
647: -- Bug # 4770445 : Need to check if p_eam_linear_id is null or not
648: IF (p_eam_linear_id IS NOT NULL AND p_eam_linear_id <> fnd_api.g_miss_num) THEN
649: -- Check if eam_linear_id already exists in MSN
650: SELECT count(*) INTO l_count FROM csi_item_instances
651: WHERE linear_location_id = p_eam_linear_id
652: AND instance_id <> l_instance_id AND ROWNUM = 1;
653:
654: IF (l_count > 0) THEN

Line 875: FROM csi_item_instances cii, mtl_parameters mp

871:
872: BEGIN
873: SELECT cii.instance_id, nvl(cii.maintainable_flag, 'Y'), nvl(cii.network_asset_flag, 'N'), mp.maint_organization_id
874: INTO l_instance_id, l_old_maint_flag, l_old_network_asset_flag, l_org
875: FROM csi_item_instances cii, mtl_parameters mp
876: WHERE cii.serial_number = p_serial_number
877: AND cii.inventory_item_id = p_inventory_item_id
878: AND cii.last_vld_organization_id = p_current_organization_id
879: AND cii.last_vld_organization_id = mp.organization_id;