APPS.EAM_ASSETNUMBER_PUB dependencies on MTL_PARAMETERS

Line 170: -- Validate the serial uniqueness specified in the MTL Parameters

166: add_error('EAM_ASSET_NUMBER_EXISTS');
167: RAISE FND_API.G_EXC_ERROR;
168: end if;
169:
170: -- Validate the serial uniqueness specified in the MTL Parameters
171: eam_asset_number_pvt.serial_check(
172: p_api_version => 1.0,
173: x_return_status => l_return_status,
174: x_msg_count => errCount,

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;

Line 1115: from mtl_parameters

1111: end if;
1112:
1113: if (not (p_current_organization_id = l_prod_organization_id)) then
1114: select count(*) into l_count
1115: from mtl_parameters
1116: where organization_id=l_prod_organization_id
1117: and maint_organization_id=p_current_organization_id;
1118:
1119: if (l_count=0) then